Barcode and Database

[esad18 (m.esad)]

Hey everybody

I just started Kodular IO and i want to learn something from here.

Firstly i want to create a app about barcode and database. I can add barcode scanner in my application. But i didnt add a database. I have a DB. It has very big list like 4*1000 or more, (it is xls but i can convert everything).
I want to scan a barcode after i need to find this barcode at my db. If scanned barcode is in my db, i want to see this barcode’s line other cell. If its not in db. i want to see “barcode is not found” in my screen. How can i do?

Thanks for your help

DB example

Barcode | Info1 | Info2 | Info3
9876543 | Mick | 2489 | 1254
1234567 | John | 6547 | 7456
xxxxxxxx | xxxx | xxxx | xxxxx
…
…

[Rogerio_Rios (Professional Support)]

@esad18

I just started Kodular IO and i want to learn something from here.

Firstly i want to create a app about barcode and database. I can add barcode scanner in my application. But i didnt add a database. I have a DB. It has very big list like 4*1000 or more, (it is xls but i can convert everything).
I want to scan a barcode after i need to find this barcode at my db. If scanned barcode is in my db, i want to see this barcode’s line other cell. If its not in db. i want to see “barcode is not found” in my screen. How can i do?

Thanks for your help

Welcome.
There are these options:
FireBase (NoSql) and Mysql (SQL) and other relational databases.

Firebase Storage | A Guide for Beginners

Good Job !

And

MySQL. PHP. GET. POST. Insert. Update. Delete. Segur SQL Inject

Hello friends, I have published a basic tutorial on MySQLi and PHP in the App Inventor Community, I think it is better to put a link in this forum so as not to repeat the same thing. The tutorial deals with 3 examples: 1.- MySQLi + PHP + GET 2.- MySQLi + PHP + POST 3.- MySQLi + PHP + Web page In these examples I use the 000webhost server. The forum link is: I have also put it in Spanish: App inventor. App inventor y MySQLi. PHP. GET. POST. Página web. Base de datos [mysqlwebhost9] […

And

https://puravidaapps.com/mysql.php

[aditya_chaturvedi (XyberNeo AKA Aditya)]

Hey !

First of all welcome !

If you have xls that means you might already be a bit more comfortable with xls db, why not go for google sheets as database, it has several advantages to list and is easy to operate too !

You may also like to consider Cloudsheets to connect google sheets with app, a approximately 4 years only service having 19 formatting options in classic version and 16 in tools version. And a decent speed with all time active support team !!

You can search for cloudsheets on the community and find my post

[ PAID API] Cloudsheets Extension

Check the latest version here : [ PAID API] Cloudsheets Extension - #50 by aditya_chaturvedi Hi developers, Am here to introduce Cloudsheets - A dedicated service to link your google spreadsheet with app. The extension is free to use but need an API that can be generated from our website : https://www.cloudsheets.xyberneo.com A special mention to @help_cttricks for being by my side in the whole development process and helping me with solutions Advantages of using google spreadsheet as your …

Keep koding

[Rogerio_Rios (Professional Support)]

Free

Which Server should I Use?

Mysql. It is an established database. With lots of research material. It works with SQL language, which is a language with a lot of research material. So you have stability, robustness and research material. Free. Imagine who bought it? ORACLE. The giant ORACLE. Who use Mysql :

[Opinion] Free Database?

Use mysql / mariadb with php scripts. My first test I did with the help of @Kleyber_Derick and I used a database of more than 100,000 records. This query in the database was made with Join in 4 tables. The data appears instantly. I also send the parameters to the script and the Scripts I create works with Insert, Select, Update and Delete on the server. And as I already mentioned, Mysql / Mariadb have thousands of research sources. They also use the SQL language (DML and DDL) which is used dir…

DB-Engines Ranking

Why developers like MySQL

[esad18 (m.esad)]

Thanks for your support Aditya Chaturvedi

I didnt find how can i read from google sheets. Im new here
Im using this sometimes google sheets. Can u share with me if u know any topic about it.
Also i will continue coding i hope
Thanks.

[esad18 (m.esad)]

Thanks for your support Rogerio Rios

But can i do without any online database. It mean if i use local DB from storage, how can i do?
My original data is xls(excel table). I need to do like that. Because i need to add or change this db sometimes from excel.

[Rogerio_Rios (Professional Support)]

@esad18

But can i do without any online database.

Sqlite Local.

[aditya_chaturvedi (XyberNeo AKA Aditya)]

Hi, why not speak on dm, am quiet good with this topic.

I have sent you message through personal window

Setting up wont be much pain !!

[Peter (Moderator)]

This is also a free and great way.

🟩 Use gviz to get or query PRIVATE google sheet data

🟩 Use gviz to get and query google sheet data

No need for extensions. It is always best, if something can be done without extensions, to do it that way.

[esad18 (m.esad)]

I will try this way if i dont be happy with google sheets.
Thanks for all Rogerio.

[Rogerio_Rios (Professional Support)]

@esad18

with google sheets

You don’t need extensions to do it that way.
Good luck, without extensions.

[aditya_chaturvedi (XyberNeo AKA Aditya)]

Using it might save some time of a developer and there is someone to back you, always without messing much into the blocks

Depends on user to user, those who are using it might already be knowing this fact, still they used so there might be something about it.

Peace

[Rogerio_Rios (Professional Support)]

I am reporting a way to connect without extensions , without costs and without financial interests.
Hugs.

[aditya_chaturvedi (XyberNeo AKA Aditya)]

Respect that from heart, but maybe just saying that without those bold characters would have also worked ?

Sometimes things can be simplified too !!

Continuing to your thread : Alternates : Use form and csv methods

And if you wish to try with something thats easy to setup with a response time of 3 mins in case of support then you may consider an extension cum service called Cloudsheets

Regards

[Boban (Boban Stojmenovic)]

Can you provide a small xls file so we can try out something for you…

[Jai_sankar_E]

Hi @esad18, please read this post there by you will get an idea about how to read data from googlesheet

How to search and select a name from google sheet - regd

Kodulars, I am having 1300 names in column A (A1 to A1300), And if theuser types his name in the field(text box or spinner or anything) it have to filer and show his name in the app. Is there any option available in kodular? My ultimate aim is the user need to pick his name from googlesheet into the field -Jaisankar

[esad18 (m.esad)]

Thanks for all support also i’m sorry for late message.

I added a excel file here also. I didnt try still with SQL or google spreadsheets etc.
If someone want to help me about it, please share here for other users.

Thanks for all your supports

data.zip (170.7 KB)

[Boban (Boban Stojmenovic)]

@esad18

data.zip (170.7 KB)

Is anyone able to open this file or is something wrong on my end?

[aditya_chaturvedi (XyberNeo AKA Aditya)]

I tried with google sheets app and it failed with error as corrupt xls but with default phone reader its opening well

[Boban (Boban Stojmenovic)]

@aditya_chaturvedi

and it failed with error as corrupt xls

Yes same here, both local (PC) and Google sheets.