Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
4 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
MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
4 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
Icon for Qrew Legend rankQrew Legend
4 years ago
What field type is this?

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

    ------------------------------
    Mrunali Kadam
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 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
      ------------------------------
      • MrunaliKadam's avatar
        MrunaliKadam
        Qrew Trainee
        4 years ago
        Great! thank you and have a nice weekend!

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