Discussions

Expand all | Collapse all

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

  • 1.  How to add a N/A checkbox for a Date field

    Posted 08-03-2018 17:17

    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!




  • 2.  RE: How to add a N/A checkbox for a Date field

    Posted 08-14-2018 20:26
    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]))