I have data in a Google Sheet and using Sheety.co to pull data into my Bubble app. The data is a list of items that the app picks and displays one at random. This part is working well.
The next stage is to add a user selected field in another section of the app, the result of which will be used to filter the list of items. The item list will have a number of options in another column in the Google Sheet. The data has a structure similar to this:
Customer name Gender
Customer 1 Male
Customer 2 Male
Customer 3 Female
Customer 4 Male
If the user selects ‘Male’, then only Customer 1, Customer 2, and Customer 4 will be options one of which will be chosen at random.
TIA 