Duplicate Record Checker
Hello, I have a form with two fields named "Year" and "Quarter". The Quarter field is a dropdown with options such as "Q1", "Q2", etc. The Year field is a numeric field where users enter a year (i.e...
Forum Discussion
If your users will always use the form to enter data and save records, a simple approach is to have a formula field to join {using list()} these two fields and make this field unique, resulting in something: "Q1-2025". You'll also want to have the fields Quarter and Year required so this formula field will always have a value.
The standard/built-in error message will display when the user attempts to save the record.
If this ends up being too restrictive on this table, you can always add another field to the formula to capture uniqueness, except Record ID.