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

Quickbase Resources

Formula URL - Edit then Add

QrewTip: Formula Logic Order

Using Grid Edit to Edit Multiple Records at Once

Getting Familiar with Quickbase Navigation