Saving data to sheets

[Shane_Byron]

I have created an application to select a location and scan a barcode then that data needs to be sent to sheets . I have put together everything but no matter what i try the data dose is not sent to sheets.

[SteveJG]

You might try the ideas in the section on Spreadsheets in

Foreground GPS Location Service experiments and Tutorial by SteveJG

Foreground GPS Location Service experiments and Tutorial by SteveJG Use the Android GPS receiver using a Foreground service, capture locations and a make a Track. Three examples use the CloudDB, a fourth example uses a Google Spreadsheet to store the data.Create a List of location coordinates and display a Track on a Map. When the Foreground (KAS) service is activated: the app will continue to post to the database when and after the device screen closes. The…

[ABG]

You are trying to send data to sheets too soon, before it has arrived in the After Scan event.

Move the GoToURL block to the AfterScan block, with the result.

[Shane_Byron]

Like so?

[Taifun]

and next time instead of taking a picture of your blocks:
To get an image of your blocks, right click in the Blocks Editor and select "Download Blocks as Image". You might want to use an image editor to crop etc. if required. Then post it here in the community.

Taifun

[Shane_Byron]

Is this correct then?

[Shane_Byron]

I watched a YT video on how to create a form, edit the link and incert it into the go url join. I dont know if this could be the issue

[TIMAI2]

See this guide:

METRIC RAT AI2 - Use AI2 to directly submit Google Form Data

[ABG]

Try it

[Shane_Byron]

Nothing has worked so far. I am stumped.

[Taifun]

Further arguments are added using an &
Earlier you did it correct

Taifun

[Shane_Byron]

Im not too sure I understand your reply

[ABG]

I just remembered, I did a sample app that can scan Marathon runner bar codes and log their times to Google Sheets:

Logging Marathon Runner Checkpoints in Google Sheets

This sample is intended to show how to use Google Sheets aggregation functions like MAXIFS to summarize multirow log data into single line summaries. This sample uses the New York City Marathon as a base, though it probably can't scale to the 53,000 runners. It is based on three sheets: Checkpoints, a list of locations each runner must cross on his route Mileposts, a detail list of runner checkpoint timestamps Runners, a master list of runners, with identifying bar codes and stats Checkpoin…

[Taifun]

@Shane_Byron

Im not too sure I understand

Replace that ? by a &
Taifun

[Shane_Byron]

done, and still nothing

[TIMAI2]

show this full url

Did you read my guide ?

[Taifun]

Use Do it and show us the result

Use the companion app and Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools

FAQ Section: Debugging

Introductory Testing techniques, including Do It - MIT Sample Connect -> Companion sequence - @ABG How to Read and Understand a Runtime Error Message - @ABG Common Runtime Errors - @TimAI2 Advanced Do It' to view procedure results, event arguments and local variables How to run Logcat How to use Do It in a loop Screen1.ErrorOccured message numbers SteveJG monster list of things you should not do How to show raw responseContent from your app when debugging - TimAI2 Video of copying Do…

Taifun

---

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

[Shane_Byron]

[Shane_Byron]

I tried both "do it" and "doit"

[Shane_Byron]

if I right click, do it is not available