Forum Discussion

JENNIFERPASCHAL's avatar
JENNIFERPASCHAL
Qrew Trainee
5 years ago

TBD option for date field

Hello,

Looking for a way to have some sort of "TBD" option with a date field. The users would like to know if the field is strictly blank or if is its something that is still being discussed. Is there a way to do this? Or has anyone had a similar ask and found a way to tackle this? Open to ideas!

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    You only option is to have a field to show in view mode and on report which is a text formula field.  You would need a checkbox field for [TBD?]

    Some like

    IF(IsNull([My Date field]) and [TBD]=true, "TBD", ToText([My Date field])

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JENNIFERPASCHAL's avatar
      JENNIFERPASCHAL
      Qrew Trainee
      5 years ago
      Thank you! Do you know if there is a way to force the field to accept a value of 00-00-0000?

      ------------------------------
      Thanks in advance,
      Jennifer Paschal
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        I am pretty sure that neither QuickBase nor Excel will except that as a date.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------