Forum Discussion

JohnSanchez1's avatar
JohnSanchez1
Qrew Member
4 years ago

Creating a calculated date field but needs to be editable

Greetings, I would like to create a calculated date field, but I need to have that field editable if the date needs to be changed.  Is there a way to go about doing this?  Any help would be greatly a...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
The usual way to do this is to have a calculated field which also accepts the input of a separate override field in its calculation.  The override field would only be shown on the form in Edit / Add modes.

IF(not IsNull(Date Override]), [Date Override], ... calculation goes here)


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JohnSanchez1's avatar
JohnSanchez1
Qrew Member
4 years ago
Thank you very much Mark.  I will try that and see how it goes.  Much appreciated.

------------------------------
John Sanchez
------------------------------