i need some expert to help!! example: 3 columns, which is: column 1 is area A column 2 is area B column 3 is area C how could i joining them in glide sheet, and i can see them (area A, area B, area C) as a “choice” features?

Make a new column. It should have 3 rows: area a, area b, and area c. Then use that as your choice component’s source.

can you teach me how to setting in glide backend sheet ? because its a complicated situation… i can explain like this: 1- i create a delivery platform for multiple merchants. 2- every merchant they have set their area in glide app. (example merchant A set areaA & areaB) 3- merchant A customer (a…

So each merchant can have multiple areas and you have each area set in separate columns?

@Jeff_Hager yes correct! • merchant can set maximum 12 areas (in coverage) with 12 different delivery fares ; • the most complicated is, merchant are around in the city.

yes! something like i create a form for each merchant, the form is for merchant to setting: to merchant A areaA :ballot_box_with_check: areaB :ballot_box_with_check: areaC :ballot_box_with_check: areaD so merchant A have 3 columns, which is areaA in 1 column, areaB in 1 column, areaC in 1 col…

The easiest would be to add a formula to one of your sheets like this: =UNIQUE({Q2:Q; R2:R; S2:S}) This will give you a list of all unique areas from all columns. To have that list filtered for each merchant may require you to change a couple things. First I would create a template column that w…

you have to add columns in users (merchants) sheet that corresponds to number of areas, so column A,B,C and D. than make kind of check mark (thru/false or 0/1) for each user(merchant) in these columns that will indicate which merchant can use each column, than in choice setting filter set to show on…

@Jeff_Hager let me try to setting! thank you for sharing this… appreciated!

[image] [image] did you means like this ? then how to setting in app backend sheet ?

but i think in Glide, Choice column cant choose the value in Split Text or Relation column ?

Possible to be a "choice"?

Ask for Help

profechef January 10, 2021, 12:20pm 12

If the number of Areas is fixed may be this post could help you

Topic		Replies	Views
Choice Component - multiple selections Ask for Help	65	9059	December 24, 2022
Array Column as options in a choice component? Feature Requests	27	3660	March 30, 2021
Selecting options from X/Y query outputs Ask for Help	17	1847	February 16, 2021
Array Column As A Choice Input Ask for Help	22	1707	June 15, 2022
Help! Populate Choice Component with calculated columns data Ask for Help	8	389	December 30, 2020

Possible to be a "choice"?

Related topics