Skip to main content
Question

Auto Fill Date Field Based Off of Another Field

Hello, 

I would have three fields that I would like to work together, [Status], [Scheduled Date] and [Completion Date]. Essentially I want the [Completion Date] field to auto fill with the same date as the [Scheduled Date] field once the [Status] field is equal to "Complete". 

Any thoughts on how to make this work? I'm a little new at QuickBase. 

Thanks!
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • March 15, 2017
      You will need to set a "dynamic form rule" to populate that date, when your status field is changed.  

      If you are an Admin on the account and you open up one of the records
      >
      In the top right you will see "Customize This Form"
      >
      After opening up those settings, click on the "Dynamic Form Rules" tab
      >
      Create a new rule with the needed logic
      >
      Something to the affect of:

      Condition
      If [Status] is equal to "Complete"

      Action:
      Change [Completion Date] to the value in the field [Scheduled Date]

      Andreonna,

      Are you certain the two dates will always match? Is it not possible that [Completion Date] may occur sooner than or later than [Scheduled Date] ?

      Terms & ConditionsAccessibility statement