Setting conditional Constraints

Need help Database
1

I have a constraint that meets my needs in all but one case. This constraint limits the data to a repeating group using the value set in a state. These values are text values and are Studio, 1, 2 or 3 and correspond the the data in the source table.

I use the following menu (composed of a RG) and I use the state (UT Beds) to control the display of data in the RG table below the menu. I set the state to the cell’s display (in the case of Studio being selected) and I truncate Display to 1 character when the index is > 2. This works with the constraint I set for the data to the RG table since it matches properly with the data in the Unit Mix table. Here is the menu and RG table.
image

This works fine when I select Studio, 1 Bed, 2 Bed or 3 Bed but I cannot figure out how to show everything when I select All from the menu.
image

Is there something I can set the state to where the constraint for “Beds =” is ignored? I’ve seen some instances where empty constraints are ignored but this does not appear when I set this data source up.

2

Try changing the rg’s data source via the display action upon clicking all

3

Thanks, I went down that road a couple times trying to find my way but what I decided to do instead is pull the data back from Airtable since when using Airtable, the option to ignore empty constraints was not available, and it’s ignoring this one constraint that I needed.

I have other data in Airtable and elsewhere that I may need to revisit this again, but thank you for a viable suggestion.

1 Like