Hi negaresh8609x6rsup, welcome to Thunkable!
Be sure to check out How to ask Great Questions v2.0, the Community Guidelines, and our Getting Started Guide to make the best of your Thunkable Community experience!
This is a good first attempt and I can certainly see what you are trying to do. Here are a few general recommendations.
- I would recommend using app variables instead of stored variables.
- As you are using blocks, I would encourage learning what the block does and what it returns. The way to do that is to set a label to a block to see what it gives you. For example, you have a “get value” purple data source block. I would encourage you to connect that with a label to see exactly what the block does. And if you look at the docs for information on the block, you will see that “row id” will be a number, not what column you are searching for.
- Debugging and figuring out what is wrong is a skill that is painful to develop. It goes into what I said earlier, but if you come into a situation where it isn’t working as you expected, I would recommend going through each block and asking yourself if you know what the block does. This does not mean not to ask questions here, but rather to try to place blocks with intention.
- Lastly, for now, I would recommend trying to make one thing work at a time. Instead of creating three searches, I would start with one and try to make that work first. Then use that one to create the others.
For your project specifically, I would do that following:
- Create a button, list, and text input
- When you click a button, use this block to set the list. Instead of column 1, it should be your name column. Test to make sure it works
- Then add blocks such that when you type in a text input, the list is only set if the text input’s text = “name”.
Start out with this and see if you can get this working. Once it does, try to expand to include the other columns. It won’t get you to exactly what you want most likely, but it should give you the fundamentals to hopefully figure out how the blocks work and the logic to start to put it together