Button action of form to check if field is unique

Hi! I have a custom form that writes to a temp table with user-specific columns, then sends the data to a specific table. I’d like to know if this is possible in Glide:

  1. User enters stock trade info on form page
  2. App checks to see if stock symbol is unique among all users
  3. If yes, add trade info to Trade table and add a new row to another table with a specific value (incrementing numbers)
  4. If not unique, just add info to Trade table

Thanks!

That sounds very similar to what I did in the post below, but instead of using a form to write a new record to the temp table and then transferring that info to another table, just use the temp table with user specific columns to accept the inputs, then let it check if there is a match through a single relation. If the relation is empty, then add a new row to the table. If the relation is not empty, then update the existing row through the relation.

3 Likes