I have been struggling with this for over an hour and it’s time to get some help! I want to display a list/map of locations and allow users to filter them by at least one tag I would like users to be able to add a place and associate the place with one or more tags from a predefined list. I start…

[image] Mauronic: I can provide more info and screen shots if this does not make sense. Hey @Mauronic ! Can you plz?

Sure! I created a test project and was able to solve some problems. View places and filter by tags - for example parks with restrooms Edit a place to delete a tag (albeit cumbersome) However, adding a tag to a place currently allows duplicates. Do you know how I could address that? Here’s a samp…

If it’s just a predefined list of tags, would it be easier to create a column for each tag in the places sheet and create a checkbox component for each tag column? Then when editing the Place, it would be easy to add or remove tags by simply checking or unchecking the box. Or is your list of tags …

I don’t expect the tags to change too much for the first couple of months. However, I do want people to be able to filter places on the map by tags. Right now I am filtering based on the tag lookup. If I used the checkbox approach, is there a way to create a lookup column like this from that data? …

You could create an array column in the sheet with sequentially named columns (Tag 1, Tag 2, Tag 3, etc.), but with checkboxes, you would lose the ability to differentiate which column is which. Maybe you could still create the array column like I mentioned above, but create multiple choice compone…

You could create an array column in the sheet with sequentially named columns (Tag 1, Tag 2, Tag 3, etc.), but with checkboxes, you would lose the ability to differentiate which column is which. OK, interesting Jeff. I haven’t encountered the array column feature before. I set this up in a new te…

[image] Jeff_Hager: This would also allow you to set up filters on each choice component based on selected values in the other choice components, so you wouldn’t have duplicates. Have you tried this before? After more experimentation this I have run into several issues on the edit screen: F…

[image] Mauronic: When I tried to filter the Tag1 choice component options based on the array Tag it did not work. [image] Mauronic: I added a text component to display the tag above each choice component but it does not update when you choose a different value from the choice component …

Thanks for taking the time to explain the options Jeff. Because my tag list will be small for a couple of months, I am going to start with using one boolean column for each tag and build out the functionality from there.

Adding and Deleting Tags from a Related Table

Ask for Help

Mauronic September 30, 2020, 11:48pm 4

As far as not allowing duplicates, I think @Robert_Petitto’s example may help, but after experimenting with this for an hour or so I am not sure how I would modify it for this case.

Topic		Replies	Views
Edit record with tags Ask for Help	6	197	August 10, 2023
Request for Input on implementing Tags Ask for Help	38	196	February 6, 2025
Question: Choice Component (allow selecting multiple) Ask for Help	7	276	September 18, 2025
Dynamic filter using TAGs created by user Ask for Help	11	1051	October 13, 2022
How to Fill Join Table Using One Click (Submit) (Many-to-Many Join Table)? Ask for Help	6	70	May 27, 2025

Adding and Deleting Tags from a Related Table

Related topics