This is for use cases where you would like a message displayed on the form based on the input into a field in the form. Ex. If you want to tell a Form Completer that their entry into a field (City) is out of range or otherwise needs to be changed. Doing this will let you provide a custom message that will appear on the form after it has been submitted. See display example below.
If you have multiple fields on a form where this is the case, you will just recreate this solution for each field.
This solution works great in conjunction with the Embedding Update/ Edit Record Links feature which you can read more about HERE.
Follow the Steps below to implement this solution.
1.) In your Target Table, create a NEW Rich Text field.
2.) In the Formula Box, apply the sample formula below.
3.) Replace the highlighted parts below with the content that pertains to your scenario.
If(([City]="Denver"),"Do not use Denver, Click Edit to pick a new City"," ")
4.) Then place the new field in the desired location on your FE Form and Save.
This solution will not prevent an End User from submitting a form with an incorrect city, but the message will appear when the form is in Print view, so they are aware that information was entered incorrectly.
By applying the Embedded Update/ Edit Record Link, the End User can edit the record as soon as they see the error message and change their selection to a valid option.
Related Articles:
- Embedding Links/ URLs in Forms
- Using the Edit & Print Links
- Adding a New Field to an Existing Template
- Formula Fields