Question: Choice Component (allow selecting multiple)

Ask for Help
1

My user’s submit ideas to the ideas table and tag their ideas with multiple “tags” from the tags table using the choice component with the “allow selecting multiple” option. I’m looking for a way to allow my users to continue choosing from the existing “tags” but add the ability for them to add custom tags to that table without having to add the custom tag THEN select it. Is there a way that submitting a new tag to the tags table would also automatically add it to the comma separated list created by the choice component?

@Robert_Petitto?

2

How are you letting them submit ideas? If it’s a native form then that’s a no go because we don’t have access to the value yet. If it’s a custom form then there might be a way.

  • Add a “User ID” column to your tags table.
  • When users submit a new tag, write their User ID to the tags table.
  • Create a relation - lookup combo from the Users table to the Tags table to retrieve the last tag added.
  • Use a single value column to retrieve the value from the custom form column where you’re letting the users write the choices to.
  • Split that SV column by comma, then add the “retrieved last tag” as a new element of the array, finally join the elements of the new array by commas.
  • When users submit the tag, set a wait condition, and then write the "join list’ above back to the custom form column where you’re letting the users write the choices to.
3

Thinking there’s some sort of variation of this:

Glide: Append ANY CHOICE LIST after completing a form AUTOMATICALLY

1 Like
4

I have a concept App that does this. Have a look below - if it’s what you are looking for I can provide instructions for setting it up.

1 Like
5

Hi @Darren_Murphy ,

Do you still have those instructions? I’m trying to filter a list of policies based on user-selected tags. I need to show policies that contain the tags the user chooses.

Right now Im doing:

  1. User Selection: A Choice component lets a user select multiple tags. This writes the selected tag names as a comma-separated string to a user-specific column in my Users table called usc_SelectedTagList.

  2. Policy Tag List: In my Policies table, I have a Joined List column named Policy Tag List. This creates a single, comma-separated string of all tag names for each policy (e.g., “perks, benefits, insurance”).

  3. The Filter Logic: In the Policies table, I have an If-Then-Else column called Is a Match. The logic is:

    • If… Policy Tag List includes User Profile → usc_SelectedTagList

    • Then… true

But this method is causing two issues:

  1. If a user has no tags selected, the filter incorrectly shows all policies as a match.

  2. The filter only works if the user selects tags in the exact same order as they appear in the policy’s tag list. For example, if a policy has “perks, benefits”, it doesn’t match a user’s selection of “benefits, perks”.

Should I be doing this differently? Or is there a way to fix this?

6

I’ll let @Darren_Murphy give instructions for his setup, but right off the bat I think you are just comparing string to string. You should be using a Split Text column to convert those text strings into arrays. That should hopefully get you a little bit closer.

1 Like
7

Yeah, it’s odd. I’ve tried it where both are split text, joined list, and as a template and it can never really seem to detect a specific group of tags regardless of order.

8

It’s been quite a while since I made this one, so I had to go back and look to see how I set it up. What I did is as follows:

  • Convert the selected tags to an array with a split text column
  • Do the same with each items tags
  • Use a remove elements column to remove the selected tags array from the item tags array
  • Do a rollup->count on the resultant array
  • If the count is zero, then the item matches all selections
  • If the count is less than the total number of tags, but greater than zero, then you have a partial match

If you want a copy of the template, you can get it below:

2 Likes