when users select the particular choice field value , how can i show the message such that it already exists in the table

(0) Share

Report

Posted on by Community Member Microsoft Employee

i have used the duplicate detection rule and also used alternate keys features to check if country is already present when users creates new record, but this both features will work only after users click on save button.

since there are more than 30 column to be filled and selecting country is the first column, it will be waste of time for users to fill all the 30 records then show the error message that country is already present,

So wanted to check if there is any way , where when users select the country , it should that this country is already present and users don't have to click on save button to notice this

basically i want country column should be unique column, but i want app to detect before clicking on save button ,

All responses (1)

Answers (0)

Suggested answer

antc 2,909 on at

Like (0)

Report

RE: when users select the particular choice field value , how can i show the message such that it already exists in the table

You could write javascript OnChange of the country field then set a Notification or an alert box to the user.

You could even do a redirect to the existing record.

Plenty of details if you google to achieve this by doing a RetrieveMultiple using the country provided as a filter.