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
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__You
Qrew Legend
Qrew LegendOK, 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 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
------------------------------ - I'm sorry Mark, but I'm really confused. I'm a new-be, so please bare with me.
Why would I check to see if my formula field, is not blank? If I've never entered data in the data entry field the formula field will always be blank.
In the dynamic roll, after I select Action > Change, the field is not there to be selected. I did add the field to the form.
How do I hide a field on a form?
------------------------------
Terri Wells
------------------------------- MarkShnier__YouThe formula field would be blank if
[Proposal Approval to Alight]
was blank as its used in the formula.
I am assuming here from your post that you have some reason not to simply use the formula field on the form. Is there is reason you want to use a form rule to populate a data entry field for the value in that formula field?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------