Forum Discussion
JulieMeeker
Qrew Cadet
What do you mean by Conditional Drop Down? I have attached a print screen of the form elements and rules. I don't even get past the first rule. Basically that rule is to not allow a request for today.
------------------------------
Julie Meeker
------------------------------
------------------------------
Julie Meeker
------------------------------
DonLarson
3 years agoQrew Elite
Julie,
Your form rule
To Date Action is equal to To Date Created
Is not going to work if the Record has not been saved once. The Date Created field in Quickbase is blank until it has been saved. After that it is fixed forever and you cannot change it.
Are you trying to prevent the user from creating a record where the [To Date Action] is today?
If so you can create a formula date field FauxCreateDate = Today() and use that in Form Rule 1 on a Add Form. You do not want that rule on a form where the User is editing an existing record.
------------------------------
Don Larson
------------------------------
Your form rule
To Date Action is equal to To Date Created
Is not going to work if the Record has not been saved once. The Date Created field in Quickbase is blank until it has been saved. After that it is fixed forever and you cannot change it.
Are you trying to prevent the user from creating a record where the [To Date Action] is today?
If so you can create a formula date field FauxCreateDate = Today() and use that in Form Rule 1 on a Add Form. You do not want that rule on a form where the User is editing an existing record.
------------------------------
Don Larson
------------------------------
- JulieMeeker3 years agoQrew CadetThank you! I did realize that the Created date is not filled until the record is saved. I did create a formula field for today. Got it all working!
------------------------------
Julie Meeker
------------------------------
Related Content
- 30 days ago