Hi @Markus_Malessa ,
@Markus_Malessa wrote:
Valid if formula for date field:
NOT(IN([_THISROW].[Date], ThisTableName[Date]))
I believe this expression will not allow the user to edit the same row again , should the user wish to edit the saved row for some other column. This is so because for a saved record, the valid_if will always fail by detecting the date as already present the in the table.
I think one needs to use an approach mentioned in the article below at the end on avoiding duplicates. Again even this approach will at times fail in a multi user environment.
List expressions - AppSheet Help
So the expression in this case can be something like
ISBLANK(
FILTER(
"Table NAme",
([_THIS] = [Date])
)
- LIST([_THISROW])
)
The expression basically ignores the current record's date in the valid_If expression by using [_THISROW] . This allows editing of a saved record also.
LinkedIn
Twitter
