Forum Discussion

Qrew Trainee

3 years ago

How do we make formula field editable in the quickbase?

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 Ka...

Formulas and functions

Tables and fields

MarkShnier__You

Qrew Legend

A formula field is not editable. If you need to override it, then have an data entry field and then you have the formula use the override if not empty

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

MrunaliKadam

Qrew Trainee

3 years ago

Thank you Mark!

Not sure How can I use or write formula to override if not empty? Please advise.

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

MarkShnier__You
Qrew Legend
3 years ago
What field type is this?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- MrunaliKadam
  Qrew Trainee
  3 years ago
  This is a date/time field.
  
  ------------------------------
  Mrunali Kadam
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    IF(not IsNull(ToDate([my date / time field Override]),
    [my date / time field Override], existing formula goes here)
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------