Coalesce or first non-null

[Richard Sayad]

I tried to use the Default pabbly provided task where I want the first non-null value to be used like the coalesce function in sql. Unfortunately, default fails when the default value supplied by an input parameter is null. How can we simulate the function so that it returns the first not null parameter or just returns null if all of them are empty?

 

[Pabblymember11]

Hey @rsayad

Also, can you tell us are you using the Default Value action step in your workflow.

 

[Richard Sayad]

Hey @rsayad

Also, can you tell us are you using the Default Value action step in your workflow.

View attachment 12390

Yes, I've assigned a nullable field value for default, one example is when I call an api which may or may not find a record to assign for the default value.

 

[Pabblymember11]

Hey @rsayad

Yes, I've assigned a nullable field value for default, one example is when I call an api which may or may not find a record to assign for the default value.

We looked into your concern and seems like it is not possible to pass the null value on the "Default Value" action step's response.