How to compare a text field data with a recordType or readonly grid column data.

Hi,

I have an interface where I am loading the data in a read only grid using a recordType and also I have a "ADD" button to provide a new item to add.

Now, when the user is trying to save a text fields data, I would like to compare text fields data with a recordType fields/columns..

Can someone advise on how to compare user enter data in a text field with a recordType or Read only grid column. If user is trying to enter same data, I would like to return a validation message.

Thanks.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    4 months ago

    This is a little vague, but in general, if you want to ensure a user is entering a unique value in a text field (compared to any prior values entered in the DB), then what you can do is query the DB table and filter on the value the user entered (presumably using the "=" operator for a relatively exact match), and show a validation error if there are any maches to the query.

Reply
  • 0
    Certified Lead Developer
    4 months ago

    This is a little vague, but in general, if you want to ensure a user is entering a unique value in a text field (compared to any prior values entered in the DB), then what you can do is query the DB table and filter on the value the user entered (presumably using the "=" operator for a relatively exact match), and show a validation error if there are any maches to the query.

Children