This is a ticketing system, I'm trying to hide or filter the invalid entry (Ticket ID) if the user already filled in the survey form, and show the Ticket ID if hasn't been filled.
Any suggestions or solutions?
The expression will need to remove the existing row from the evaluation when a record is being edited.
It could be something like below
ISBLANK(
FILTER(
"Survey",
([_THIS] = [Ticket ID])
)
- LIST([_THISROW])
)
List expressions - AppSheet Help
Point to note is that such expressions could fail in multi user environments in edge cases.
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |