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
Yes, but please post your formula which is unique. We need to make it null (empty) if that checkbox is checked.
- Here is what I came up with for the unique field...
List("-",ToText([Quickbase User Name]),ToText([Overtime Volunteer Date]))
The field that has the check box is "Remove from List - I figured it out using an IF formula....
If([Remove from List]=false,List("-",ToText([Quickbase User Name]),ToText([Overtime Volunteer Date])),"")
Thanks again for the help and tips! - Well done and greetings from 30,000 feet somewhere over the middle of the USA enroute to Seattle.
