Tessa
Member
Hello!
I have a form like this:
id | tool1 | tool2 | tool3 | tool 4| ...tool35.... | etc
1 | Yes | No | Yes | No
2 | No | Yes | Yes |Yes
..3...
199...
200...
The issue is, when there is 200+ records of different tool sets of possibilities for a ski or snowboard , and a user is trying to search for a record that fits, it is most frequently missed and they end up creating a duplicate record.
Is it possible that they get an error on submit that the entire record (aside from id) is unique? And tell you which record they need to submit? And possibly select that record?
Or am I dreaming?
Thanks in advance!
I have a form like this:
id | tool1 | tool2 | tool3 | tool 4| ...tool35.... | etc
1 | Yes | No | Yes | No
2 | No | Yes | Yes |Yes
..3...
199...
200...
The issue is, when there is 200+ records of different tool sets of possibilities for a ski or snowboard , and a user is trying to search for a record that fits, it is most frequently missed and they end up creating a duplicate record.
Is it possible that they get an error on submit that the entire record (aside from id) is unique? And tell you which record they need to submit? And possibly select that record?
Or am I dreaming?
Thanks in advance!