Good evening friends!
Please help: how can you implement GoogleTables search?
For example, there is a column: ID
In the application, a person enters the desired ID, and the program looks for the required ID in GoogleTables, after which it displays data from the second column (for example, an email address)?
I’m trying to make a diagram, but something doesn’t work - I can’t figure out where I’m going wrong
It sounds like you’re trying to do a VLOOKUP. This video might be helpful:
But also, your repeat while loop has the condition true which means it will either never run or will run forever. When you use a repeat while block, you need to have a condition that can evaluate to true OR false such as something with an operator (____ = ____ or ____ > ____).
I forgot one thing that will enhance performance for large data tables.
In the arrow, which is just after displaying the label or doing whatever you want from the loop. You need to break out of the loop because you already found what you want and there is no need to continue searching.