How to handle invalid reference in reference type

[sowmyaj]

Hi All,

How to I catch the invalid reference in reference fields, ex. I have three condition to put in on reference field,        

                                                                              1. I need to populate related information when the value exists in reference table -Good with it.

                                                                                2. Onchange of the field if no value is selected which means the value is null, I need to take some action - Good with it.

Finally comes with the 3rd action which I'm not able to track, 3. If i enter some junk value in reference field and which is not exists in reference table as shown below,

then, I need to alert the user saying that the value doesn't exists. How can I achieve this. Please let me know if anyone is having answer for it.

I referred one of community links "Need to add an alert when there is an Invalid Reference in a Reference field " which says get the value of form for particular field and if I did so, the alert is getting populated twice with null value for third condition.

Thanks,

Sowmya

[Shishir Srivast · Accepted solution]

Hi Sowmya,

Entering wrong value is making the field RED, that it self is an indication that the value is wrong and even when submit the form that system will not save the invalid data. So i think there is no need for a client script for validation since its not accepted.

You can make the field mandatory so that it wouldn't be allowed to submit the form without entering the value.

[sowmyaj]

Hi Srivastava,

Based on my requirement, if user enters wrong value/ he will not be able to search value then, I need to let user to enter value in text field by hiding above reference field and alerting user that he can enter value in text field. So, I need handle above mentioned scenario.

Thanks,

Sowmya

[Shishir Srivast]

Can we try in this way, If user doesn't find the searched value then let them select an option as Other and when user select the Other option then add new text field to get the desired value? will that help?

[sowmyaj]

No. This will not be the feasible solution.

Thanks,

Sowmya