Unable to get a response with the specified URL when scanning QR code

MIT App Inventor Help
1

Hi, I am making an attendance application for my organization, but after following many youtubers, the data from qr code that I scanned didn't appear in my google sheet. Here are my MIT app blocking

image
image806×360 20.2 KB

and google app script

image
image1037×520 55.2 KB

Is there any mistake I made? or any solution that you can suggest? I assumed that because my email that I used to create a sheet is an organization email, the MIT couldn't send a data to my google sheet due to company's privacy.

Thank you in advance!

2

1 run DO IT on web.Url. do you have a & BEFORE barcode=?
2. why you add ( and ) at return result?
3. will your qr code change for each user? how do you know who scan the qrcode?
4. how to avoid user take a photo of qrcode and scan at home?

3

Have you confirmed with your Google Workspace Admin that you can run google apps scripts against your account ?

4

There are two ways to build an attendance app:

  • schoolroom scans the student, or
  • student scans the schoolroom.

Which approach did you choose?

5

You could also tidy up your script....

function doGet(e) {
var ss = SpreadsheetApp.openById(<SPREADSHEET ID HERE>);
var sh = ss.getSheetByName(<SHEETNAME HERE>);
var d = new Date().toLocaleString().split(", ");
var date = d[0];
var time = d[1];
var barcode = e.parameter.barcode;
sheet.appendRow([date,time.barcode]);
return ContentService.createTextOutput("OK");
}

Your GET url should look like this:

https://script.google.com/a/macros/<LONG ID HERE>/exec?barcode=[BarcodeScanner1.Result]

6

sorry for the late reply.

  1. after i run it, it returns https://script.google.com/a/macros/(id)/exec
  2. i have no idea about that, because i followed from youtube. (MIT App Inventor Barcode Scanning Project - YouTube)
  3. yeah, i already generated qr codes for each person, and the only one device will scan those qr.
  4. i tried using pre-filled google form and i found that problem. so, i decided to let one device have an app i invented instead.
7

I already did it. is the problem related to my company's privacy?

8

i think it's schoolroom scans the student, because i decided to let one device to scan all qr codes.

9

i tried and it went like this

image
image1294×298 18.9 KB

even though i have a sheet called "for app"
image
image836×483 12.1 KB

(i changed row1 to [date, time,barcode] according to your code)
image
here is a result after i used to scan a qr code

10

I have not done this app through google API, but web app. Is it the reason why I cannot successfully made an app?

11

This is starting to look like my NY Marathon sample app. Search this board for Marathon.