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:
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.
User | Count |
---|---|
15 | |
11 | |
10 | |
8 | |
3 |