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 LegendThen there is no reason that the formula field would not work.
I suggest that you put it on the form to confirm that it is working and then take it off the form
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I put the field on the form, but when I create the dynamic rule, under Action > Change the field is not there to be selected.
So, I never got the point of checking the rule, because the isn't there to select.
When I do a preview of the form I see the field, just not in the drop down, under Action > Change >select a field
------------------------------
Terri Wells
------------------------------
So, I never got the point of checking the rule, because the isn't there to select.
When I do a preview of the form I see the field, just not in the drop down, under Action > Change >select a field
------------------------------
Terri Wells
------------------------------
- I found the problem! I have two fields that the names are very similar, and I grabbed the wrong. Problem solved; thing work great when you grab the correct field.
Thank you for your help and patience!
------------------------------
Terri Wells
------------------------------ - MarkShnier__You
Never mind about the form rule. I thought you wanted to populate a different field. If you put the formula field on the form and the components of the formula are populated than the formula will calculate automatically just like excel as long as
[Proposal Approval to Alight]
is populated
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - MarkShnier__YouThe only other possibility is that when you view the formula field setting and save, it has an error.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - The field is on the form and I'm not getting any errors with the formula when I save the field. I've attached a document that shows the field configuration and formula, a copy of a report which I use for testing, and the two fields off the form where the "Proposal Approval to Alight" field is filled in but the "CR Proposal Due Date" is still blank. Hopefully, with this information you"ll be able is see my error.
------------------------------
Terri Wells
------------------------------ - MarkShnier__YouI think that there is come confusion over the duplicate field names. The field name used in the formula is not the same as the field name on your report.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - The field name on the report is just an alternate label text. See below:
------------------------------
Terri Wells
------------------------------