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
IF(not [Remove from List],
List("-",ToText([Quickbase User Name]),ToText([Overtime Volunteer Date]))
)
The effect of this is that if the [Remove from list] is true, then the IF will calculate to the "else ..." portion of the IF. But there is no "else portion so it will calculate to null. That is the one value which can be duplicated when a field is set to be Unique. You can have duplicate nulls.
List("-",ToText([Quickbase User Name]),ToText([Overtime Volunteer Date]))
)
The effect of this is that if the [Remove from list] is true, then the IF will calculate to the "else ..." portion of the IF. But there is no "else portion so it will calculate to null. That is the one value which can be duplicated when a field is set to be Unique. You can have duplicate nulls.