Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
2 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's avatar
MarkShnier__You
Qrew Champion
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's avatar
MrunaliKadam
Qrew Trainee
2 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's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    What field type is this?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MrunaliKadam's avatar
      MrunaliKadam
      Qrew Trainee
      2 years ago
      This is a date/time field.

      ------------------------------
      Mrunali Kadam
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        2 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
        ------------------------------