API not honoring show_if

[Scott_Nesbitt]

I have a record that has a single / multiple location selector. I then show or hide the Single Location field and the Multiple-Location field based on the selector, and everything works great.

Both the single and multiple location fields are required, but since AppSheet understands that if they are not shown they are not needed this is not a problem.

However, when I try to use the API to insert a record I get an error:

“Bad Request”,“status”:400,“detail”:“REST API invoke request failed: Error: Row having key ‘xxxx’ in table ‘Clean Start’ in field ‘Multi Locations’ is required’”

It appears as though the API does not understand that Multi Locations is not needed when it is hidden based on another field. Is this a bug?

[Suvrutt_Gurjar]

Please try in those fields’ ( Single /multi locations) Required setting the following expression

CONTEXT('Host")<>“Server”

[Scott_Nesbitt]

There are hundreds of fields that I would have to change, so this workaround is not applicable. I would like to open a bug report, but https://issuetracker.google.com/ does not have an AppSheet option, and https://support.google.com/appsheet does not allow you to create a ticket. What to do?

[Steve]

Good question!