The app is saving all values that are in the column repeatedly even using the component that chooses an item randomly.
I need the app to take 9 values that are in a column and save each value to a variable.
How do I not let the variables repeat the values?
Hello,
I’m not familiar with spreadsheet but maybe instead of pick random item, use Select list item
the problem is that the address of the list is going to be random
I tried to do a treatment of the values however it didn’t work out. I did it the wrong way. I believe have a way to treat these values
maybe create a local variable and set it to the list value. Then
set global clienteX to pick random item
then remove it from the list.
What kind of treatment do you mean ?
treatment not to let a repeat value
ex number “9” I can not let it be saved in dua variables
can be saved only in a variable
i forgot to talk about this tabela is in the airtablle
Hold on, let me try to make it
okay ,thanks!!!
Try this one to see. It should select a random item, set the cliente variable to it, then removes it from the list and continue.
I will try to see if there is other way simplier.
Can you explain it a little bit more please?
in the column will have writen text and numbers, I would like to get only the numbers
You can try For each item in list, if not is number(item), then remove list item[list=list;index=index in list(item)].
remove list item list should be get values because you are looping each item from get values list
