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

2 Replies

Related Content

Formula URL - Edit then Add

Create Child Record, Save and then Edit button

New Form - Show Create Record button

Button: save the new record and edit the new record

Create a formula duration over 5 years

Recent Discussions

Are all QB notifications "No-Reply" emails

Bulk create child records from selection list

Selecting which fields to display from Formula URL searches

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting

Save & Redirect in a Formula URL Using API_GenAddRecordForm