Creating a calculated date field but needs to be editable

Question

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.&nbsp; Is there a way to go about doing this?&nbsp; Any help would be greatly appreciated.Thank you.------------------------------John Sanchez------------------------------

markshnier__you · Answer

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 · Answer

Thank you very much Mark.&nbsp; I will try that and see how it goes.&nbsp; Much appreciated.------------------------------John Sanchez------------------------------

Forum Discussion

Creating a calculated date field but needs to be editable

Related Content

Using Grid Edit to Edit Multiple Records at Once

Calculation/Performance Limits Inquiry

Calculating 1.5 pay

Edit Multiple Records at Once with Grid Edit

Child Table - Grid Edit Issues