Need assistance with calculated fields on edit page

[MarkMayhrai]

Hi there Support Community,

I'm currently working on an edit page where I have implemented a calculated cascading dropdown displaying a selection of pricing options. However, I'm encountering some issues with three fields that have been set as calculated values.

Specifically, I want these fields to display their related lookup values from the pricing table upon selection from the cascading dropdown. However, when no selection is made, a calculation error is displayed. I would like to have these fields display a value of 0 instead.

Could someone please provide guidance or assistance on how to achieve this functionality?

Thanks in advance!

 

 

 

 

[ParkLoey]

Hi @MarkMayhrai! You try adding an IsNull function to your calculations. If there are no values returned, you replace them with a pre-defined value.

IsNull(value, replace_value)

https://howto.caspio.com/function-reference/#:~:text=Number-,IsNull,-(value%2C replace_value)

I hope this helps!

[CoopperBackpack]

Hi @MarkMayhrai,

I believe the error is related to the formula syntax, particularly the Virtual field. 

Please enclose the  [@cbParamVirtual1] into the single quotes to see if this helps to get rid of the error message.

As ParkLoey replied, then you may use the IsNull() function: IsNull( (your select statement),0 )

[Kronos]

Hi @MarkMayhrai,

You may also want to create a Rule to hide the fields if there's no selection from the user. You can refer to the guides below:

Conditional Forms

Video - Creating Conditional Forms Using Caspio

I hope this helps!