Solved: Leave date field empty in form - Page 2

Ratatosk · 10-09-2020 02:01 AM

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?

Suvrutt_Gurjar

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.

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.

View solution in original post