• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Coalesce or first non-null

rsayad

Member
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?
 

Supreme

Well-known member
Staff member
Hey @rsayad

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

1656074193327.png
 

Supreme

Well-known member
Staff member
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.
 
Top