Getting Started

 View Only
  • 1.  Using "hidden" fields in dynamic form rules

    Posted 03-03-2022 09:16
    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 displayed on the form. If I don't include them on the form, the dynamic forms rules don't work.  I tried including them, but for edit only and that did not work either.  I tried putting the formula fields in a separate section and used a dynamic form rule to hide the section and that also caused the date test dynamic rules to fail. 

    I have a test form with the fields displayed and the rules work perfectly.  

    How can you configure the form so that the fields are not displayed, but they are available to the dynamic form rules? (without using javascript because that is above my skill set.)

    Thanks in advance for any help!

    ------------------------------
    Julie Meeker
    ------------------------------


  • 2.  RE: Using "hidden" fields in dynamic form rules

    Posted 03-03-2022 09:20
    That 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
    ------------------------------



  • 3.  RE: Using "hidden" fields in dynamic form rules

    Posted 03-03-2022 09:25
      |   view attached
    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
    ------------------------------

    Attachment(s)

    docx
    Hide Test fields.docx   75 KB 1 version


  • 4.  RE: Using "hidden" fields in dynamic form rules

    Posted 03-04-2022 09:10
    Edited by Don Larson 03-04-2022 09:11
    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
    ------------------------------



  • 5.  RE: Using "hidden" fields in dynamic form rules

    Posted 03-04-2022 11:46
    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
    ------------------------------