Reset Virtual Column Value

[SAMiD_Dubai]

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

[Steve]

Please post a screenshot demonstrating the unwanted behavior. Please also post a screenshot of the virtual column’s complete App formula expression.

[SAMiD_Dubai]

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

[Steve]

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.

[SAMiD_Dubai]

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.

[Steve]

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.”
)

[SAMiD_Dubai]

Thank you. Worked !!!