I am using a submission form and trying to customize it. It's a simple script that displays a warning message and stops submission, if a user makes a certain combination of selections(i.e. selects ABC from a dropdown and XYZ is calculated in the Virtual field. However, the code does not seem to work. Could somebody take a look and let me know what I am doing wrong? The UseCaseType is a dropdown with a lookup table linked to it, and the Virtual Parameter is a Calculated Value SQL script(that does
In addition to this post:
Do note that you may opt to do the validation on DataPage level only. Just create a Virtual Field, set the Form Element of Calculated Value, paste the syntax, and set it as hidden field in the Advanced tab.
[@field:Date2] < [@field:Date1]
THEN CAST( 'a' + 1 as INT)