Using "hidden" fields in dynamic form rules
I have a Request form that I need to validate the date and time for the date the service is requested. I created formula fields to use in the dynamic form rules, but I do not want these fields to be ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThat is certainly strange. I routinely set up a section called Required for form rules and CDD (Conditional Drop Down) and dump fields in there and hide the section with a Form Rule.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- 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,
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
------------------------------- Thank 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
------------------------------
