Forum Discussion

IrisBonilla's avatar
IrisBonilla
Qrew Cadet
6 years ago

How to add a N/A checkbox for a Date field

Hello!

I have a table with multiple date fields, but a lot of times my users don't have those dates yet, and I would like them to have the N/A option. Is there a way to add a checkbox next to the date field that says "N/A" and if they click it then the input for the field should be N/A.

I don't want this to be a separate field, because I need it to have a N/A input for a monthly report.

Any help would be great!

Thank you!


Tables and fields

1 Reply

Sort By
  • Quick_BaseJunki's avatar
    Quick_BaseJunki
    Qrew Captain
    6 years ago
    Unfortunately Date fields can only accept dates (or be blank).

    However you could create another formula text field that will either populate with your date field or "N/A" if the checkbox you mentioned is checked for use in your monthly report.

    If([Checkbox]=true, "N/A", ToText([Date]))