Jump to content
  • 0

Is there a way that people can only add a certain field only one time per ID field




I have a dropdown that lists book 1, book 2, book 3 etc...

The store ID can only add the books one time. So store 1 can have book 1 with all book 1's information and book 2 with all book 2's information etc... but they cannot have book 1, book1, and book 2. Store 2 can also have book 1 with all book 1's information. So being unique in the table does not work since it can be used multiple times. 

Is there any solution for this. Currently us the user can add any of the options. 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi @nanglin,

If I understand it correctly, you have a table of 'records' where each row displays an entry of what book is added into what store?


Records Table

| ID  |    Store    | Book
|        |                    |
|ID1 | Store 2 | Book 2 ...
|ID2 | Store 1 | Book 3 ...
|ID3 | Store 2 | Book 3 ...

If this is the case, we can use the method that is mentioned here 

-create a formula field in the records table
-concatenate the Store ID with the Book ID (convert both into text if they're in number format as to avoid arithmetic addition instead of concatenation) 
-make the Formula field in the table unique. In that way, if another entry is submitted to the 'records' table with the same concatenated value, the submission form will display an error instead of inputting the data into the table.
*You can change the error message in the Localization Tab of the Caspio Bridge and using it on the specific datapage

Hope this is the solution you're looking for. Good Luck!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...