Barcode and Database

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

[Kevinkun]

Airtable is also a good choice. Try this free extension:
http://www.kevinkun.cn/airtable.html.

[aditya_chaturvedi (XyberNeo AKA Aditya)]

Yes, Indeed
But he hs a data of 1000 + row so that becomes eligible for paid plan, thats the reason i didnt recommend it yet to him

[Kevinkun]

Thanks for your reminder to know the airtable free plan only allow 1200 records per base.
maybe airtable not suitable for this project.

[esad18 (m.esad)]

Hey everybody

I sent again. But i sent like a txt file. It mean .csv .

data.txt (206.6 KB)

Also i want to make the app with local database. I can convert every file to my file.
Or i can use google sheets. Because its free everytime

Thanks for all supports.

[Boban (Boban Stojmenovic)]

Try this one BarcodeDatabase.aia (68.4 KB)

[esad18 (m.esad)]

Thanks Boban.
Its looking very good
But i have a problem. I didnt work. When i select the data.csv i see that

[Boban (Boban Stojmenovic)]

Ahh sorry, try this one BarcodeDatabase.aia (97.3 KB)

[esad18 (m.esad)]

Thanks Boban for all.

Can u try for me that app with this barcode. It is first row barcode. I tried a lot of time but it didnt work.

[Boban (Boban Stojmenovic)]

I don’t have that number…

you want 1234567 but in excel is 1235467

[esad18 (m.esad)]

Yeah sorry i wanted to send 123456