Change "Error in formula" message

[Roosta]

Hello all,

I have an issue where if someone enters From/To dates incorrectly you get the following message due to the calculated fields I have used to create my own dashboards. I know why I am getting the message and want to replace it with something along the lines of "No records found for your selection please review and resubmit" but I cannot find this error messgae in the localisations and looks like its class is cbFormError which I have also lokked for in the styles gallery hoping to change there. However, I can find it but no way to change the message displayed.

 

This is the displayed message:

 

Displayed correctly:

 

Any assistance would be greatly appreciated cheers, Roosta

 

 

 

[Kurumi]

Hi @Roosta - this is the system error message so it can't be localized. In this case, Error in formula should be avoided. You will need to put logic in your formula to prevent system error. You may check this article for reference: https://howto.caspio.com/troubleshooting/errors-and-messages/#:~:text=Error in formula

[Roosta]

@Meekeee

Thanks for the information figured this out late last night by putting a couple of NULLIF & ISNULL statements into my claculations and just returns  0 now if people try to pick a futur date in the "Date From" field.

 

Cheers, Roosta

[telly]

Hi @Roosta,

You may use a case statement for the criteria if the user pick/chooses future date:

https://howto.caspio.com/function-reference/#:~:text=possible result expressions.-,CASE,END,-Vary