Labs user application

Questions about Thunkable
1

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.

2

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:

  1. 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.

  2. 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.

  3. 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.

3

image
image751×384 23 KB

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.

4

I understand. What have you tried and what is your question?

5

i can get all datas from google sheet in a list. but i cant filter datas by barcode. i need this filter blocks.

6

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!

7

In bar code place uniqe value for each computer. Place same values in sheet. When user scan barcode, compare value from barcode with values in sheets and assign user to computer.

8

Thank you so much, you made my day.

.

To develop your application, you can use Google Sheets API to pull student data and display it based on the barcode input. You’ll need a backend (like Python or Node.js) to query the Google Sheet and return results. The frontend can include a simple form to input the barcode and show the corresponding student list. Narrative essays can be challenging, especially when you’re asked to tell a personal story in a meaningful way. I turned to Academized Academized for help with my narrative essay, and the service was fantastic. The essay was well-written, emotionally engaging, and easy to read. The writer was able to make my story come to life, and I received positive feedback from my professor. I’ll definitely use this service again for future writing assignments.

2 Likes