Unique Record based on date in form.
I am having an employee submit a record on my table. Each record will have the Quickbase user name and it will also have the employee number for them. When creating the record, they have to select a d...
Forum Discussion
No problem.
One employee has many records. Let's assume that the records are called Overtime Requests.
Let's assume that there is a field named Related Employee on the Over Time Request Table.
Create a formula text field named
[Sorry, but you already have an Overtime Request for this Date]
I know that is a long field name, but there is method to my madness.
The formula will be with the formula
List("-", ToText([Related Employee], ToText([Overtime Date]))
Mark the field as being Unique in Field Properties.
Make a duplicate entry and save and observe the result.
One employee has many records. Let's assume that the records are called Overtime Requests.
Let's assume that there is a field named Related Employee on the Over Time Request Table.
Create a formula text field named
[Sorry, but you already have an Overtime Request for this Date]
I know that is a long field name, but there is method to my madness.
The formula will be with the formula
List("-", ToText([Related Employee], ToText([Overtime Date]))
Mark the field as being Unique in Field Properties.
Make a duplicate entry and save and observe the result.
- I have made the changes and I get an error when trying to make the field unique. It says:
