avoid duplication in location table

divya123 · ‎04-03-2017

in location table whenever adding location filed value manually if that location is already existed then it show message that already existed that location & show invalid insert , this is what show if location is already existed in location table(cmn_location).

kindly help me with your suggestion how can i write business rule for that.

Thanks

Divya

Alikutty A · ‎04-03-2017

This is the location form and not the right place. Please follow these steps

1) You should right click the Name field and configure dictionary

2) Then on the form that loads, Again configure form layout from the header and add unique field on this form.

3)

4) Add the unique field on dictionary form and check it as true and Save.

Once you do so, the system wont allow a user to enter multiple locations with same name.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

View solution in original post

divya123 · ‎04-03-2017

Hi Alikutty thank you for your reply, Out of box Unique field is not there. i have to add that field or how it is, kindly help me

Alikutty A · ‎04-03-2017

Yes you need to configure form layout of dictionary (form shown above) and add the field on it. This is OOB and will give you a custom error message.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

divya123 · ‎04-03-2017

out of box it is not visible in available list also,

Alikutty A · ‎04-03-2017

Where are you configuring the list ? Can you show me a screenshot of it?

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

divya123 · ‎04-03-2017