Using two spinner variables

[Liezel_Louw]

Hi, I am creating an app that uses two spinners. You enter a location in the first one and then a store in the second, I want the program to then depending on the pair of information inserted open a new screen. So far I can only make the program work using one spinner is it possible to use both at the same time?
Thanks

[NishyanthKumar]

First, send the selections to the next screen:

Once you've done so, you can get the values and do whatever you want with them:

(Please disregard the fact that they are the same screens; I was just too lazy to create another).

[TIMAI2]

See also:

Spinner Setup

The spinner component is an odd thing, and requires some rigour to get control of it. This is how I usually setup a spinner so that all the selections are available every time. I use a button to set the selection and call the spinner dropdown, and "hide" the spinner by setting its height and width to 1 pixel each. If placed inside a centred horizontal arrangement, the spinner should be invisible in all themes. By adding a "Close Menu" selection (it can be called what ever you want) at the fir…

[erGrunfe]

Buongiorno, ho bisigno del vostro aiuto.
Good morning, I need your help.
I have three consecutive "spinners": the result of the first spinner, which draws the choices from the list contained in a "general variable" that I filled in "Blocks" MUST BECOME the item of the "selection" in the second spinner. But the result of the first spinner does not refer to a precise general variable but will choose among several other "general variables", each of which contains other lists. (the ratio between the second and third spinner will be identical).
I tried several times, but failed...
Thanks in advance.

Ho tre "spinner" consecutivi: il risultato del primo spinner, che attinge le scelte da elenco contenuto in una "variabile generale" che ho riempita in "Blocks" DEVE DIVENTARE la voce della "selection" nel secondo spinner. Ma il risultato del primo spinner non rimanda ad una precisa variabile generale ma sceglierà tra diverse altre "variabili generali", ognuna delle quali, contiene altri elenchi. (identico sarà il rapporto tra il secondo ed il terzo spinner).
Ho fatto diverse prove, ma non sono riuscito...
Grazie in anticipo.

[NishyanthKumar]

Sorry, the question isn't exactly clear. As I understood it, you want to change the selection of a Spinner based off of another Spinner's selection?

[erGrunfe]

I'm sorry if I wasn't clear: I'll try to express myself more clearly. My problem is: how to use the choice of "spinner1 selection" in "spinner2 elements".
For example: I create a tinyDB of all usable motorized "means of movement".
In "spinner1 elements" I easily put a "global variable" with: motorcycle, car, plane, helicopter, ship...;
For example, if the result of spinner1 is "car", in "spinner2 elements" I will have to insert, among all the others, the "general variable" which contains all the brands of car manufacturers.
Continuing, for example, the choice in spinner2 elements is "Suzuki" (as Italian I should have written Ferrari... )
the "general variable" of all the models produced by Suzuki must appear in spinner elements: Vitara, S-Cross, Baleno, ...; (these are the names under which they market their machine models in Italy).
I hope I was clearer.
Thank you for your availability, which is very precious to me

[TIMAI2]

See here:

Spinner dependent dropdown list

[image] My Project want to read only data from above but in drop down selection from dependent spinner by using Tiny DB. By using fallowing i can get to spinner 1 data then i have to save that selection to pass on to next screen and at the same time in other google sheet use =INDEX(FILTER(prolocation!D2:D,prolocation!D2:D<>""), COUNTA(FILTER(prolocation!D2:D,prolocation!D2:D<>""))) and get next cell to get rage of data by =unique(filter(productlocation!B2:B,productlocation!A2:A=D2)) to get nex…

[ABG]

Try this sample app ...

Build Your Own DB - Part 1