How do we make formula field editable in the quickbase?

Question

I've a formula field which is read only/non-editable on the form.

Can you please advise how can we make it editable? or is there any other workaround?

------------------------------
Mrunali Kadam
------------------------------

markshnier__you · Answer

A formula field is not editable. &nbsp;If you need to override it, then have an data entry field &nbsp;and then you have the formula use the override if not empty------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

mrunalikadam · Answer

Thank you Mark!&nbsp;Not sure How can I use or write formula to override if not empty? Please advise.------------------------------Mrunali Kadam------------------------------

markshnier__you · Answer

What field type is this?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

mrunalikadam · Answer

This is a date/time field.------------------------------Mrunali Kadam------------------------------

markshnier__you · Answer

IF(not IsNull(ToDate([my date / time field Override]), [my date / time field Override],&nbsp; existing formula goes here)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

How do we make formula field editable in the quickbase?

6 Replies

Related Content

Conditional edit/read-only on Grid edit

Grid Edit in Quickbase Mobile App?

Formula Help

Embedded Grid Edit Report help

access the QuickBase document outside the QuickBase

Recent Discussions

Extrapolating nuanced data

Date Input

Quickbase Actions

Empower Discussion

%%rid%% has ceased working on mobile - be advised