OK, so I am new to Bubble.io and learning. I have created a table where users search on ZIP Code, and then are presented with a list of locations within that ZIP Code. They select one and then that choice gets saved to the database. That all works perfectly.
Here is what a user sees:
My issue:
Users can select more than one location on the table. Only the most recent selection is saved to the database (which is correct), but any previous selections also show.
How do I restrict the table to only one entry? If a user selects a new row, I want to automically deselect other rows. I am trying various things with Workflows and Conditions but nothing works. I am sure this is user error - I am still very new to Bubble.