Hi All
I have a table that has a virtual column that I want to use to show messages based on the input, however the column seems to hold the last value.
How can I reset it to BLANK so that it starts the form blank.
Thank you
Please post a screenshot demonstrating the unwanted behavior. Please also post a screenshot of the virtual columnโs complete App formula expression.
This is the formula in the column:
IF(ANY(SELECT(BOOKINGS[No Players], ([GNAME] = [_THISROW].[GNAME])))>=ANY(SELECT(BOOKINGS[Max], ([GNAME] = [_THISROW].[GNAME]))),โThis game has already the Max Players allowed. If you continue, you will be waitlisted as per the rules.โ,"")
This is the screen when you enter it. MSG should be blank and only appear if the condition is met.
Thank you
I donโt understand what your App formula expression is doing. Please explain what you want it to do using plain language and no AppSheet terms.
If the [No of Players] of a the selected [GAME] is >= the [Maximum] allowed players for the game, set the text in the field to โhis game has already the Max Players allowed. If you continue, you will be waitlisted as per the rules.โ or โโ if the condition is false.
I hope this explains it better.
IFS(
AND(
ISNOTBLANK([GNAME]),
ISNOTBLANK(
FILTER(
"BOOKINGS",
AND(
([GNAME] = [_THISROW].[GNAME]),
([No Players] >= [Max])
)
)
)
),
โThis game has already the Max Players allowed. If you continue, you will be waitlisted as per the rules.โ
)
Thank you. Worked !!!
User | Count |
---|---|
40 | |
28 | |
22 | |
20 | |
15 |