Develop QR code Scanner Android App using MIT AppInventor |Google Sheet | App Script|

[@CrazyCodersClub]

IMPORTANT..! Hello Everyone, For source Code Please Refer Our new Blog:www.crazycodersclub.com Please find respective Post in the blog, Please do not refer http:www.androidlabs.info (Some technical issue).. Please Cooperate, we are coming back with a lot of new stuff... We extremely regret the inconvenience caused.

[@bryanpaulposada1469]

@Crazy Coders Club Hi can you help me to set the time to GMT+7 Bangkok Time, i'm having a hard time changing the IST. What code should I use? Thanks a lot

[@CrazyCodersClub]

You can change it in settings or automatically it will set to your location...

[@bryanpaulposada1469]

Thank you so much it's already working.

[@bryanpaulposada1469]

Hi sorry for asking again, how about for manual entry using textbox and button as to input the data manually? What is the code for that? Looking forward to your answer. Thanks a lot

[@CrazyCodersClub]

Please look into other videos in the channel , you will come to know...

[@hguhgfdd]

i m very glade to see this & i m trying it

[@Futbollucense]

I followed the steps but the data does not appear in Google sheets. Did you have to use the same video names for the application, spreadsheet and script?

[@raymarreyes2208]

Thanks It was 99% Working :) How to used front camera or camera settings Thank you again Crazy Coders Club you deserved my subs and notification bell :)

[@CrazyCodersClub]

Even I tried it.. didn't get... But you can do it with Android studio ..

[@noraallen5036]

can you tell me how you did it? I tried to do it , it is not adding in my spreadsheet

[@Alhasan-kd3tq]

Excellent👌👌

[@akhtarnadaf2540]

Awesome video. I tried for this & it works...Thank you very much.

[@CrazyCodersClub]

You are welcome

[@ahmedtariqh]

nice bro. but can I enter many columns' data and get them arranged in the sheet directly? or how can I make the separator (;) permanent so whenever it recieves the semicolon it moves to the next cell?!

[@CrazyCodersClub]

You can define data and columns as per your requirement.. either you should change in App Inventor or in app script.. first try to understand the flow and try your things.. if you have any business specific application you can approach [e-mail]

[@beautificationprogram7399]

i have a problem in time format i change already the time zone in our country but it didnt take effect

[@marcougoproietti]

I have used this system for a long time. A few days ago it stopped working. I haven't changed anything. The scanner works, but the data is no longer transmitted to the spreadsheet. I don't understand what could have happened. Can you give me some advice?

[@CrazyCodersClub]

Let me try it in latest config

[@JinaneKarhaniRawda]

@@CrazyCodersClub same problem..suddenly stopped writing in sheet, nothing was changed though

[@Serversote1]

Muchisimas gracias mi amigo, excelente aplicación y muy útil, saludos!

[@CrazyCodersClub]

You are welcome 😊

[@manrajjuneja7865]

Hey . I was making a similar app but I just wanted to add one more feature . I want that if the same QR code is scanned again after some time and the data of the previous scan is still in the spreadsheet, I want it to show an error. Please help

[@coollkubi]

YOU ARE AWESOMEEEEEEEEEEE! DANG YOU SAVE A LIFE HERE APPRECIATE THAT

[@heavengranadil8361]

hello there. i was planning to use it for inventory. how can i add quantity on the script and remove the time stamp?

[@alangkan]

Thank you very very much .... I don't know if there is a way to apply with face recognition rather than QR code ^^

[@CrazyCodersClub]

Need to check.. will try and upload if it works

[@DirectionFilms]

i Have used like this but in third column showing undifined. so please help me to correct // reciving scanned data from client i.e android app var sdata = e.parameter.sdata; var sdata1 = e.parameter.sdata1; var date = new Date() sheet.appendRow([date,sdata,sdata1]); }

[@DirectionFilms]

Sorry i got it i akso missed &in blocks, thank you very much for video

[@CrazyCodersClub]

You are welcome...

[@alexwong9472]

@@DirectionFilms can share how to build the block?

[@interspecies-au]

What if I want the frequency of a barcode, as when I m adding the countif function in sheets, then it stopped getting the data. What change is to be done in app script??

[@JinaneKarhaniRawda]

same thing happened to me - it was scanning & adding like a charm, but when i added conditions to other columns it stopped from adding data to the sheet. any idea?

[@deepaksudhakar1]

The input sheet should not be disturbed. 1. Use "importrange" function in A1 to make a dynamic copy of the sheet. 2. Add other functions as you wish. (This way, the original scan data is not disturbed)

[@kranthivangala]

Can I restrict the application to read particular file data only(only one file data) it should not scan other data

[@CrazyCodersClub]

Yes you can do it as per your logic

[@DirectionFilms]

is there any entry limit to write data in google spreadsheet Using API ex. Write Entries/Second Limit

[@CrazyCodersClub]

You can check with appscript quotas... Google it will get it

[@PakCoyMan]

Good vids mate, i wanna know is that possible to make just 1 qr code for everyone who want to absent and they just need to login in the aps ?

[@CrazyCodersClub]

You can do it

Thanks so much!! Regards from México.

[@CrazyCodersClub]

You are welcome 😊

[@luisirizarry7851]

Can use Excel instead of google sheet?

[@Lily_552h]

Is there an alternative to the "barcode scanner" application? I can't install the app in play store, because my version is too high

[@muhammadamirulsyarief3774]

Hye there! If i want to add device information on the google sheet, which part of the script i need to edit?

[@CrazyCodersClub]

Please mail to [e-mail]

[@itungify]

@@CrazyCodersClub same question 🙋 for me

[@CrazyCodersClub]

As mentioned please mail , I can't discuss here

[@zephird.t.3038]

Thank you I appreciated this presentation. I would like to know if there is a bijection between the QR code and the element it represents. Can't the author of the counterfeit copy the genuine QR code to paste it on his imitated product? Can we secure a QR code? Best Regards

[@CrazyCodersClub]

Hi Zeph, ideally this video is for basic flow. This demo or App doesn't include features that you mentioned. But it can be implemented. One needs to do bit reaserch on that

[@elektronkiller4836]

WHY??? AFTER I SCAN QR CODE FROM QR CODE GENERATOR. THE SCANNER SAID THAT ERROR 1109 : THE SPECIFIC URL IS NOT VALID: YOUR WEB URL

[@CrazyCodersClub]

Once again Try from beginning.. follow steps properly

[@ednaldosouza3691]

good morning I did the same procedures in the video but the message does not arrive in the spreadsheet

[@CrazyCodersClub]

Please retry from beginning with fresh project. Please watch video carefully.

[@mdarefurrahmanchowdhury3362]

Hello, Thankyou, I have tried and it works fine, but the scanner is taking too long to read QR, is there any other scanner that can be used

[@fredericr2399]

Thanks a lot ! I save money with this solution :)

[@tEsT-hu2ht]

Can you copy and paste it

[@tEsT-hu2ht]

Vide description not working

[@tEsT-hu2ht]

Pls help

[@CrazyCodersClub]

Hello everyone, our website (blog)www.androidlabs.info, domain renewal is on progress and there is some technical issues .. so kindly cooperate until further notice.. we Kindly regret for the inconvenience caused. We will update the source code link soon.. please stay updated... Admin

[@CrazyCodersClub]

IMPORTANT..! Hello Everyone, For source Code Please Refer Our new Blog:www.crazycodersclub.com Please find respective Post in the blog, Please do not refer http:www.androidlabs.info (Some technical issue).. Please Cooperate, we are coming back with a lot of new stuff... We extremely regret the inconvenience caused.

[@itungify]

Thanks you it's work. There are 2 value on google sheet column Time Stamp and scanned data. Is there any way to add one column to the right (column that I called "device ID") ? . Device ID means device identification number/code depends on type of smartphone. Please help!

[@CrazyCodersClub]

Yes we can add

[@itungify]

@@CrazyCodersClub how to do that? What script we must add? Please help

[@medelynSumile]

@@CrazyCodersClub i also need this

[@JinaneKarhaniRawda]

Did you get any reply sir? can you share it please?

[@itungify]

@@JinaneKarhaniRawda I do not get the answer

[@aishajaved9678]

Hi there, I wan to create a cash register using a similar system to scan food items, any idea how I could start coding something like this? I have my user interface done I Just need help with the coding. Your videos are very helpful!

[@CrazyCodersClub]

Try to understand the code workflow. Or you can contact us [e-mail]

[@NIRAJKUMAR-fp7ll]

can we create an app with two different QR scanning activity and send both data in on one row of google sheet at a time?

[@CrazyCodersClub]

Yes we can do.

[@NIRAJKUMAR-fp7ll]

​@@CrazyCodersClub​ thanks for reply... what is the way?

[@CrazyCodersClub]

@@NIRAJKUMAR-fp7ll , please mail your requirement to [e-mail]

[@augustob3.14]

Cómo se puede hacer, para que al escanear el código devuelva un dato de la hoja de cálculo?

[@CrazyCodersClub]

Please use English, I don't understand your language

[@LoveWaPeace]

can we use front camera to scan?

[@minadief]

i dunno, but I'm just imagining, are you going to put a qr on your forehead? :D

[@bluefish9765]

hello. i want to add additional columns in sheet. first choose typ, then scan barcode, last quantity. i dont get it with listpicker and textbox. anyone can help ?

[@porraweefongmool3777]

Thank you so much. but i would like to scanned data for thai language please.

[@CrazyCodersClub]

Please email to [e-mail]

[@razibhasan6830]

what is problem there is ERROR 1109: THE SPECIFIED URL IS NOT VAILD: YOUR WEB APP URL complete the scan the app pop up this message .plz anyone help me , plzzzzzzz

[@JinaneKarhaniRawda]

Thank you for the clear steps, but I followed them - but for some reason the data is not added to the sheet, though it has sharing permission also for all.. any help or tip pls?

[@JinaneKarhaniRawda]

It worked , after a fresh start .

[@shafiqfauzan454]

Can i make it countinously scan without press button for many times? I really hope that you can help me?

[@CrazyCodersClub]

We can make, if you need customized app paid assistance please email to [e-mail]

[@EddiePryceGaming]

Is there a way to force the app to use the front camera? Ive got my app working the way i want it to work other than using the front camera over the rear camera

[@CrazyCodersClub]

Unholy1314 , Even I am trying to do... If I get ... I will post...

[@EddiePryceGaming]

Cheers dude, been watching your tutorials and find they have helped a lot with what im trying to do for my work Looks like i will need to program it in Android Studio for now :)

[@CrazyCodersClub]

Thank you...

[@sanikalande3694]

after installing this app ... I got security option so is it harmful for my mobile ..

[@CrazyCodersClub]

Nope.. it is expected.. if you instal apps from external sources

[@sanikalande3694]

@@CrazyCodersClub Thanks.. I made app but after scanning data doesn't enter in my laptop... plzz help why this happen..

[@CrazyCodersClub]

Watch video carefully. Retry with fresh project it would work

[@sanikalande3694]

@@CrazyCodersClub I done this for 4- 5 times .. but it doesn't work ... is any problem with laptop ..

[@ChouxCream-i9r]

Hello AndroidLabs, This solution it work for me. Thank you

[@CrazyCodersClub]

Rawipas Chisamut , pass 3rd parameter from client side... as sx only

[@CrazyCodersClub]

Rawipas Chisamut , refer this video, watch carefully on client side coding, you will come to know on passing parameters..

[@ChouxCream-i9r]

Thank you for reply me :D, After I follow your suggestion, now I can send 3 data to my SSheet but it's save in same column haha Date Coloum1 (Name) C2 C3 12/13/2017 9:56:00 t1sdetails=S1samount=data undefined undefined *sx --> samount (I edited value name from App scripts.)

[@ChouxCream-i9r]

Hello, Do you have any suggestion to pointing this problem for me?

[@CrazyCodersClub]

Rawipas Chisamut , sorry I didn't share link that time, please refer kzbin.info/www/bejne/bZubkGarfqaEgs0

[@full655]

Hello, Why I can't insert sdata into speadsheet?

[@CrazyCodersClub]

Try from beginning... Watch video carefully... Try deploying web app with new version

[@mohammadizwanazmi1160]

how to append a new text input from the app and have it appear in a third column? can you teach me? because i'm already watch your videos and i'm still could not do it..

[@Flaviobrayner]

boa noite! o meu esta dando erro: TypeError: Não é possível chamar o método "appendRow" de null. (linha 29, arquivo "Código") teria como me ajudar good evening! mine is giving error TypeError: Can not call null "appendRow" method. (line 29, file "Code") could help me

[@arcamedeis]

IS it possible to add a text input from the app and have it appear in a third column?

[@CrazyCodersClub]

Bruce Hahlbohm , yes it can be done.. please refer other videos..

[@tEsT-hu2ht]

IT DOESN'T COME TO THE SHEET WHEN I SCANNED

[@悠然-c5m]

may i ask how do i scan multiple data into google sheet?

[@itheakaybeyi7263]

TypeError: undefined "parameter"

[@geovanalima9843]

Parameter erro what i make?

[@CrazyCodersClub]

Retry from beginning.watch video carefully

[@geovanalima9843]

@@CrazyCodersClub i need make a other sheet with a names what i want?

[@manirajpaul4609]

I want to insert data in A5 cell only , how to do it

[@CrazyCodersClub]

Build logic accordingly.

[@manirajpaul4609]

How

[@CrazyCodersClub]

Please research with their documentation. If you need dedicated paid assistance, please email to [e-mail]

[@rosliharun7148]

I have tried and it works... Can someone please help me how to make it auto scan continuesly without button?

[@moeswe4641]

Hello, kindly help me please because I can't search aia file. thanks

[@eddiergonzalezmora2375]

have a question??

[@khaliddanoun3001]

Hello I Can't find the ABCD 2 Demo.aia file can someone help me?

[@solomod5787]

everything works fine but when i scan qr code it say that my webapp url is not valid any solution for it? Edit: Thanx it worked.

[@CrazyCodersClub]

That's great!

[@solomod5787]

@Kishen PATEL -GERMANY- I just had copy the same url as shown in the video but we need to put our url of the google sheet. Try it if u had same problem as mine.

[@CrazyCodersClub]

That's great..!

[@PECKEKO]

no me registra nada en el spreadsheets cuando ya escaneo el qr saludos y espero tu pronta respuesta

[@ricardojosehlima6654]

Hello! I was having this problem and solved it. As you are writing in Spanish I assume that the name of your "Sheet1" of your Spreadsheet file is in Spanish (mine was in Portuguese), so if this is the case, then change the name for "Sheet1" (without spaces) and it will work, it did here. Alternatively, if you want to preserve the name of the your first Sheet or even change it, you can, as long as you change it also in the script.

[@mirefrei]

hello , i make the same as you (changing the part of sheet1 ) and i dont have any result in the spreadsheet , hopefully u can help me , thanks!

[@siddheshgawali7764]

any idea how to append column in google sheet through google app script....im not able to find a command for it

[@siddheshgawali7764]

pls reply asap

[@xrless8445]

it is possible to get the code and use it on an app with zxing api? ty.

[@CrazyCodersClub]

Yes ... I have done seperate video on that ... Please refer in my videos

[@adamcsilinko4542]

Hello, First of all thank you for your videos. I want add the location to the spreadsheet when the QR code was sanned. (latitude, longitude) Can you help me? I would also pay for it. Thanks Br Adam

[@CrazyCodersClub]

Hi Adam , can you please contact through [e-mail] with complete requirements of your app.. I will definitely help you

[@bertojdm5347]

function insert(e,sheet) { var sdata = e.parameter.sdata; var date = new Date() sheet.appendRow([name,sdata]); }

[@varrunasettybm7313]

Superb

[@marykilewe3433]

ou're website doesn't work so i can't download the source code for scan qr code from android and save it to google sheets. Do you mind using github instead or share with google drive? This is kind of urgent

[@CrazyCodersClub]

Mary Kilewe , refer video description , you will find link for drive where source code is stored

[@marykilewe3433]

Android Labs thanks

[@CrazyCodersClub]

Mary Kilewe , welcome...

[@parthrana34]

can you make video that how to read data from google spreadsheet?

[@CrazyCodersClub]

Yes sure... But it is not straight forward.... will surely try ... THANKS for your approach

[@arifakbar5483]

Can you made another Apk with MIT app inventor for add student database link with Sheet. Thanks

[@CrazyCodersClub]

You can try ... It is easy...

[@arifakbar5483]

How the apk share with anothe user and use the same apk but data come on same sheet. Thanks

[@fypdtk836]

@@CrazyCodersClub I GOT UNDEFINED AT SCANNED DATA

[@mendroy]

Thank you so much but how could I change the limit of 2 hours?

[@CrazyCodersClub]

+René Eloy Mendoza Franco , can you please elaborate on this..

[@patccpoon]

from the gs script, I got the e.parameter.sdata is undefined. please help

[@patccpoon]

sorry for typo, i got it. But encounter another problem, can not display Chinese Characters when send data back to google sheet. it's no problem in English.

[@CrazyCodersClub]

+Patrick Poon , don't run the function in Editor, you need to deploy it as web app and pass the parameter sdata , please watch video carefully

[@atlarhat861]

thanks ! it works :)

[@CrazyCodersClub]

na ratna , thank for your feedback, we will upload some new experiments soon, stay tuned...

[@ericrodriguez3502]

ei tt, que no nos enlaza la base de datos, que estamos haciendo mal bro?

[@CrazyCodersClub]

please comment in English

[@fionasoon1]

THANKS. it works but it works only for the condition when "anyone or any anonymous" can assess. When set to only myself. It doesn't work. Is that true? Anyone face the same problem?

[@CrazyCodersClub]

Fiona Soon , yes you need to keep it as anyone even anonymous can access... But don't worry nothing wrong in that ... It is accessed means , script is running with your gmail id... Please go through documentation in google

[@0brayfer0]

Great video. Yo realicé tus pasos y al final obtuve: error 1109 the specified url is not valid: your web app url. Luego agrege un "label" al final para mostrar la url y se solucionó. De todas formas, muchas gracias ;)

[@CrazyCodersClub]

+Cristian Quezada de la Cruz , I will update it .. thanks for reminding..

[@marcelaguerrero3040]

amigo, como estas? me podrias ayudar .. en donde colocaste el "label" .... por que me quede en el mismo error y no he podido avanzar, gracias por tu ayuda.

[@Hugzzzer]

Hi Dude, can we chat on mail I have problem to use this app

[@CrazyCodersClub]

Yes please mail to [e-mail]

[@Hugzzzer]

@@CrazyCodersClub Thanks I send you a mail ^^

[@kathikth]

Hi.. is this is a free permanently?

[@CrazyCodersClub]

Can't assure. Please check Google restrictions.

[@tEsT-hu2ht]

How to download the source cod is not working

[@tEsT-hu2ht]

Pls help

[@tEsT-hu2ht]

I opened it from the notepad but some Rubbish appears not the code pls help me

[@tEsT-hu2ht]

Pls send me the code pls beg you

[@CrazyCodersClub]

Not sure. I will verify and update

[@tEsT-hu2ht]

Can you send me the code not in the description one just copy it and paste in the reply it will be a great help

[@ahmedalassadi5226]

doesn't work .. in addition not all the codes exist and the blog you referred to is talking about android studio not MIT App inventor and the aia file not exist too !!!.. thanks anyway !!..

[@geovanalima9843]

name is undefined?

[@sloannascimento7018]

Funcionou. Obrigado!

[@CrazyCodersClub]

sloan nascimento , thanks

[@Flaviobrayner]

tentei e nao consegui.. voce fez alguma coisa a mais ?

[@geovanalima9843]

suas respostas ficaram undefined?

[@namyagupta2884]

where is the aia file in the description???

[@all4u168]

hello sire please add a listbox selection from the app and make video for me thanks

[@CrazyCodersClub]

Yes.. sure will add it soon

[@all4u168]

Thank brother

[@atlarhat861]

how to show the result longer? bcz thats too fast to dissappear

[@CrazyCodersClub]

na ratna , this is just simple prototype, based on this you can develop your own logic.. This is just an instance.. If you need more clarification just mail us to [e-mail]

[@viralvideos3292]

hi crazy coders thanks for making this video i have one problem facing please comment your no pls

[@jefreyromasanta4835]

is there anyone still active here? I have a question?

[@CrazyCodersClub]

Yes please

[@jefreyromasanta4835]

​@@CrazyCodersClub What exact Timezone am I supposed to use? My country is Philippines.

[@CrazyCodersClub]

Will check and update

[@CrazyCodersClub]

Meanwhile you can Google time zone.. for your country. I suggest using GMT+- YOUR COUNTRY ZONE...

[@jefreyromasanta4835]

@@CrazyCodersClub yeah! I tried it many times, using GMT+8:00, GMT+08:00, GMT+08:00:00 and UTC+8:00, UTC+08:00, UTC+08:00:00, still it responds time that are late 8 hours from the phones time.

[@marykilewe3433]

how do you do this with barcodes?

[@CrazyCodersClub]

Mary Kilewe , try scanning bar code with same app.. It may work...

[@marykilewe3433]

You're website doesn't work so i can't download the source code for scan qr code from android and save it to google sheets. Do you mind using github instead or share with google drive? This is kind of urgent

[@kannaa5634]

Hi Admin, as a first time trying to build an app, ur video has given me the confidence to attempt. I want to start to built am stuck as i am not able to find the .aia file. I downloaded from www.crazycodersclub.com the zip file QrCodeToGsheet-master. inside there is no .aia file. also all the files are not ABCD_2. Hope u can guide me. Thank you

[@CrazyCodersClub]

Kanna A , please refer goo.gl/TjZtBX

[@kannaa5634]

Hi Admin, thank youso much, i will try it.

[@sigitpramagita4818]

work. thanks

[@CrazyCodersClub]

You are welcome Sigit

[@jenshaugstrup-andersen6201]

Something goes wrong extracting the files. Other than that thanks a lot :-)

[@CrazyCodersClub]

Jens Haugstrup-Andersen , any issues??

[@RUANGBERITA7]

terima kasih banyak ya....sangat membantu saya

[@itungify]

Kak Hanif, apakah berhasil?

[@unidadtres4225]

H

[@csptechinspiration]

i am not getting your code file abcd2_demo.aia

[@aleksandrgorbachev88]

Thanks! It works ))

[@CrazyCodersClub]

Aleksandr Gorbachev , you are welcome... Please like and subscribe to get more experiments like this