Forum Discussion

TerriWells's avatar
TerriWells
Qrew Trainee
6 years ago

Calculate & Auto Fill a Date Field

Hi Everyone,

I have a form that when a particular date field is populated, I would like to add 15 days to that date and auto fill  another date field.  I created at Date formula with the following formula:

[Proposal Approval to Alight]+Days(15)

I'm not getting any syntax errors with formula, but field remain unpopulated.

Any help would be greatly appreciated.

------------------------------
Terri Wells
------------------------------
Forms
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    When you say you want to auto fill a field, do you just mean that you want to display a formula field on a form?   Or did you want the value of the formula field populated into a data entry field?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • TerriWells's avatar
      TerriWells
      Qrew Trainee
      6 years ago
      I just want the value of the formula field populated into a data entry field.  I created a field that I'm using for reporting purposes, and what's driving the population of the field, is the entry of a data on a form.

      ------------------------------
      Terri Wells
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        OK, so you will need to have a Dynamic Form Rule.  In order for the rule to work, that formula  field will need to be on the form, even if it's in a hidden section.

        The form rule would look like.

        When multiple conditions are true
        ALL of the following
        [my data entry field] is blank
        [my formula field is not blank]

        Change the value of the [my data entry field] to the value in the field [my formula field].

        then uncheck the checkbox at the bottom of he form so that the rule fires all the time.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------