Hi community 👋
I'm trying to create a gifting system where it would prevent users from creating new records if a record, with the same values from two of the fields, already exists.
A use case here is: The company is giving gifts to lead personnel working on projects. And since some of these people have worked on a couple of projects before, they shouldn't receive the same gift as in previous times.
I tried setting up the primary field to require entries to be unique and also set up the automation to populate the primary field with Name_Gift but this doesn't prevent records from being created.
It would be ideal if the primary field would be autogenerated as Name_Gift and at the same time have an option to select Require entries to be unique, but unfortunately, this is not possible.
If anyone sees any workaround I'd be happy to hear.
Thanks,
Dino