Solved: Conditional Dropdown behaviour - Page 2

AlexM · 02-19-2021 07:23 AM

Hello,

I am a bit confused about my app’s behavior.

I have 4 tables:
Clients

Client Sites

Client Rates

Bookings

The expected outcome is that, when creating a new Booking, the [Rate] dropdown will only have the [Client Rates] for the client that owns the selected [Client Site]

[Rate] from Bookings table has the following ValidIf condition:

SELECT(Client Rates[ID],[_THISROW].[Client Site].[Client]=[Client])

What actually happens is that when I select the dropdown, the list is empty.
I click New on the dropdown to add a rate but then I click Cancel.

Selecting the [Rate] again, the dropdown will have the correct values.

EXTRA: If, after selecting the Rate, I change the Client Site and then save, it allows me to do it even if the rate should be invalid.

Tried to upload a screen recording but the format is not allowed.

Steve

That’s very odd. I’d call it a bug. Consider reporting it to support@appsheet.com.

As for the Valid if expression, try this:

FILTER(
  "Client Rates",
  IN(
    [Client],
    SELECT(
      Client Sites[Client],
      ([ID] = [_THISROW].[Client Site])
    )
  )
)

View solution in original post