Hi, I am trying to find a solution to populate items in a choice component from the split text items. See the image below, [image] So, if a user enters a pincode, using some API calls and parsing JSON responses, I can create a list of locations using split text. I am stuck with being able to sh…

Hola @gvalero Thank you so much, your solution worked like a charm! Gracias

create a vertical list from that split using the if-else column… (I assume you have these locations in some column) how you are getting locations?

Thanks @Uzo for the quick revert. These locations are generated dynamically based on the pincode entered in a text field. Can you guide me on the method to create a vertical list using if-else column?

Do you have a list of locations somewhere? how do you assign Pincode to the location?

No, they are generated dynamically using an API call, [image] In the screen above, I am collecting the pincode from the user in a text filed and store it in a user column. Next, I use google maps API to generate a list of locations around that pincode. I use a template column to clean up the list…

then you cant convert to vertical… unless is a fixed number of locations that you wanna show… then you can create that many columns and pick the corresponding text

True, I guessed the same since the count of locations will be different for different pincodes.

you can do that in google sheets, in glide you would have to create rows and use a content generator… is possible

Interesting, I am curious to learn more. Can you explain in detail?

is similar to creating a row number in a glide table, you can try this method [image] How do I create an auto-incrementing row number with Glide Tables? Community Resources This is a question that comes up a lot, so creating this topic to use as a reference. Typically, th…

Thanks, will try and find a solution around it

Choice items from split text items

Ask for Help

Robert_Petitto May 4, 2022, 5:31pm 12

Ya, you have to create a working table that transposes your API results. This method will give you some ideas:

Topic		Replies	Views
Parsing text into multiple choice values for a Choice form component Ask for Help choice , multiple-rows	9	310	March 6, 2024
Choice Component using split list or array Ask for Help	9	2431	March 12, 2022
Use comma-separated values as source for Choice? Ask for Help choice	10	695	February 15, 2024
Array values as a choice for user Ask for Help	8	118	October 28, 2024
Need data from split to be used in choice Ask for Help	4	51	April 16, 2025

Choice items from split text items

Related topics