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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhen 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
------------------------------
Terri Wells
------------------------------
- MarkShnier__YouOK, 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
------------------------------The field that's getting populated is not on the form. Does that matter?
------------------------------
Terri Wells
------------------------------- MarkShnier__YouProbably does mater. Why not put it on the form, in read only mode if you like.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------