Suddenly Unable to Edit Row - Possible Validation Error

In one of my apps, i am suddenly unable to edit an existing row in a certain table. This happened before when Appsheet was going through some UI changes, and at that time, I reverted back to the old UI and it worked fine. Fast forward to today, and I am getting this when trying to edit an existing row:

patient_form_error.png

The Date field has a Valid_If statement that historically worked fine to make sure that only one entry per date can exist, but now i cannot edit a date if the numbers were entered incorrectly without manually editing the spreadsheet. The Valid_If statement is:

NOT(
IN([_THISROW].[Date],
Daily Totals[Date]
)
)


I have no idea how to get out of this one and would like some help, please and thank you.

0 10 259
10 REPLIES 10
Top Labels in this Space