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 LegendThe 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
------------------------------
[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
------------------------------
I'm trying to create a report that lets the business community know if proposal are late from their vendor. The rule is that they have 15 days to return the proposal. I thought best way to handle this would be to crate a field, and do the calculations there. That way, if I need the information for anything else, it would be available.
The business community doesn't want to see this information on the form, just in reports.
------------------------------
Terri Wells
------------------------------
The business community doesn't want to see this information on the form, just in reports.
------------------------------
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
Then 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
------------------------------ - 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
------------------------------