Forum Discussion

JulieMeeker's avatar
JulieMeeker
Qrew Cadet
3 years ago

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 ...
Form Rules
Tables and fields
JulieMeeker's avatar
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
------------------------------
DonLarson's avatar
DonLarson
Qrew Elite
3 years ago
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
------------------------------
  • JulieMeeker's avatar
    JulieMeeker
    Qrew Cadet
    3 years ago
    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
    ------------------------------