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
The field that's getting populated is not on the form. Does that matter?
------------------------------
Terri Wells
------------------------------
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
------------------------------
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__You
Qrew Legend
The 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
------------------------------- 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
------------------------------- 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
------------------------------
