Leave date field empty in form

[Ratatosk]

I have a list of contracts with a “Start Date” column and an “End Date” column in Date format.

When I create a new entry it forces me to pick a date in the Date columns.

I’d like to keep the End Date empty because the contract runs until the customer ends it, but appsheet won’t allow it empty.

I have Format Rules on the end date, so it highlights contracts that is about to end.

Any ideas on how to adress this?

[1minManager]

Sounds like you’ve got a valid_if formula but its set to not be valid if the column is blank

[Ratatosk]

I don’t have a “valid if” formula.

[Suvrutt_Gurjar]

I believe if the date column is not set to “Required” , one can save the form without entering the date.

Or as Simon mentioned.

[Ratatosk]

The field is not set to required.

[Suvrutt_Gurjar]

Could you please share what error message you are getting if you leave it blank and try to save.

[Ratatosk]

Hmm… I tried again now, and it suddenly works… hmmm…

The previous error message was “This entry is invalid”

[Suvrutt_Gurjar]

Good to know it works.

Ratatosk:

The previous error message was “This entry is invalid”

In general that message should get displayed if there is a valid_if constraint on the column.

[Ratatosk]

Yes, I understand.

But I’ve never used valid_if on anything yet.

Thank you for the help anyways.

[Suvrutt_Gurjar · Accepted solution]

No problem , you are welcome.

Another reason for " This entry is invalid” could be if the column type and date entry mismatches. Text entry in number column for example.

Ratatosk:

Ahhh. I get it now possibly. There was an initial value of today()

Okay. But I believe if the initial value is also date and there is no mismatching valid_if constraint , then in general it should not show the error message.

Anyway good to know , you have got it working now.

[Ratatosk]

Thank you Yeah that might be it.

[Ratatosk]

Ahhh. I get it now possibly. There was an initial value of today()