Conditonal validation on Lookup fields
When a Lookup Field is configured to be required in the field settings, then the first option gets selected by default in the new item form. Because of this users can save the item without selecting the intended value for the lookup field.
Crowcanyon Forms Manager App can fix this issue by adding a validation for empty value on the fields. Please follow the below steps for this configuration. We will take the example of Category lookup field in Tickets list.
Make Category field not required
Go to list settings of ‘Tickets’ list and click on Category field to open the field settings page. Ensure that it is NOT required to specify a value for Category field.
Configure Crow Canyon validation on Category Field
Go to Crow Canyon Forms Manager Add-in (App) from Application Administration or Site Contents. Select ‘Tickets’ list in the list dropdown.
Under the Column Validation Settings, select the Category column and configure settings as shown in the below picture:
Crow Canyon column validaton supports adding conditions so that validation is performed only in specific cases. For e.g., to validate empty value only when a Ticket is getting closed, add a condition as shown below: