The usual way for me to do this is to create a custom form, then use a query column to check the destination table for all matches with relevant input columns. If there’s a match, I show an error hint, else I allow them to be added.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Solution to Prevent Duplicate Entry | 86 | 8253 | January 17, 2024 | |
| Not urgent - avoid input duplicated code (text) | 8 | 796 | January 17, 2024 | |
| I want a duplicate check, for example, this name already exists. | 4 | 636 | September 13, 2024 | |
| Link expired. Can you re-share the link | 7 | 226 | April 10, 2024 | |
| Data validation to avoid collision | 3 | 293 | November 19, 2023 |