I’ve been developing an app to record wine tasting results, to share amongst my friends (so they can record their tastings of the same wines). Although I’ve been able to figure out most of the key things I want this app to do, I am simply stuck on how to have the Wine Number removed from the subsequent choices, once the user(s) has selected that wine number about which to write their review. eg., lets say there’s 12 wines to be tasted. The taster chooses to start on wine number 4. Once they have completed that tasting, I want number 4 to be no longer available from the choice box in the form (so there are no double ups, and no missed wine numbers). Please bear in mind that I’m very new to this, and I am almost geriatric (over 60 years of age). Any advice/help will be greatly appreciated.
What you need to do is add a Query column to your Wines table.
This column should target the table where the form submissions go, and have two filters applied: one to match the wine, and another to match the signed in user.
You can then use that Query column as a filter on your choice component - only showing those wines where the query column is empty.
4 Likes
Thanks for that, Darren. I will give it a try. Cheers