Retrieve a value for a particular Virtual field if another field is blank

[MarkMayhrai]

Hi,

Hi, I'd like to have a start to code a particular scenario: If a calculated field return NULL, I would like another field to have its value set based on a particular cascaded dropdown. If the calculated field has a value, the the field to set will have a value from another cascaded dropdown. Is this possible?

[NiceDuck]

Since this looks like a submission form, I thin you can set the QB ID field as a Calculated Value.

From there, you can use an SQL conditional statement like this:

Case 
When [@field:customerQBID] = ''
then [@@field:Select_Invoice]
else [@@field:Select_Invoice2]
end

Ofcourse, you will have to change the field name with your actual field names. 

[NiceDuck]

You may want to check this articles:
https://howto.caspio.com/datapages/datapage-components/calculated-values/
https://howto.caspio.com/function-reference/