Hello everyone.
I want to develop an application for a school laboratory. There are 20 computers in the laboratory and I created barcodes for them such as “pc-01”, “pc-02”… I recorded each student sitting on these computers in a google sheet (more than one student sitting on a computer). I need help with the application that will display the list of these students on the screen from the database according to the barcode query.
Welcome to Thunkable! What you are asking for involves many separate small steps. It’s not really possible to list them all for you – plus, that would take someone a lot of time.
Here’s what I recommend when starting on an app:
-
Create an algorithm. LLMs like ChatGPT are great at helping with this. The algorithm should be someone detailed so that you have an idea of concrete steps to take next.
-
Start to create the first few steps in Thunkable. If you get stuck, check out the documentation. Much of it has good tutorial videos such as here.
-
If something doesn’t work and you can’t figure it out, post as many details as you can including screenshots and a link to your project and ask a specific question about a specific step in your algorithm.
I have a table like the one in the image. What I want is that when the barcode is scanned in the application (eg: pc-lab-01), the people whose data in the ogrPc column is “pc-lab-01” should appear on the screen.
I understand. What have you tried and what is your question?
i can get all datas from google sheet in a list. but i cant filter datas by barcode. i need this filter blocks.
I’m not sure i understood your question, but when i have to deal with barcodes i always suggest quickchart.io
It can create a barcode/qrcode with the value you want and, once scanned, you can easily identify your value or row in google sheet.
for example if you create a QR Code with value “pc-lab-01” (something like this qr (150×150))
You can then modify or take action based on the different value with an if/else statement.
something like:
if SCANNED_VALUE == pc-lab-01:
action that you need
Still not sure if this will help you, but it was worth a try
Good luck!