How can I have fields automatically changed 5 days after the date in another field.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a form and there is a date field called pend on date.  I want to update other fields automatically 5 days after the pend on date if other fields are in a certain status.  How can I accomplish this?  I am attaching the current form rule which doesn't work because no one is going into the record to trigger it.


Photo of cowannbell

cowannbell

  • 1,350 Points 1k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
You will need to make those fields be formula fields and calculate their value based on comparing Today()  - ie the current date to some other field.  So there can be input fields, but then you would need a parallel set of fields with a different name  such as suffixed with (final) to calculate the values.
Photo of cowannbell

cowannbell

  • 1,350 Points 1k badge 2x thumb
I'm a little confused. Are you saying that all of the fields would need a set of formula fields?  If so, how would formula fields look at other fields also and then update the original fields.  Can you give an example?  Thanks.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
The original fields would not be updated.  Suppose that the original fields were renamed to end in the word (input), for example [Pend off date (input)]

Then there would be a field called [Pend off Date (final)] with the formula

If([Pend on date to Today's Date] >= 5, [Pend On Date] + Days(5), [Pend On Date (input)]

You would use that [Pend off Date (final)] field on your various reports.
Photo of cowannbell

cowannbell

  • 1,350 Points 1k badge 2x thumb
So are you saying the new pend off date is what would show on the form in view but the original pend on date would be there for edit?  If so would I have to do the same for the other two fields?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Yes exactly!
Photo of cowannbell

cowannbell

  • 1,350 Points 1k badge 2x thumb
ok. Thank you.