So Close to Google Sheets, but yet . .

Greetings,

I finally found an app that worked for me to upload data from the app to my Google Sheets account. Thank you, Pura Vida . . . several cups of coffee are forthcoming;).

Unfortunately, when I try to insert the operative parts into my app, things go off the rails and the lists cause an error. All I think I am doing is copying and pasting from Pura Vida and changing pointers and data. As one can see (below) the output for Latitude and Longitude (the first 2 columns) is randomly? replaced by a label name F_Local). Only the Local_Information_Label contents show correctly. It DOES display the contents of the Local_Information_Label but that is also when the error arises. I have since moved the Web2 blocks inside the When_Web1.GotText block to delay the output until the labels populate but that does not seem to be working.

If someone could help me correct this dysfunctional code, I would really appreciate it. I am pretty burned out by trying, and failing for one reason or another, multiple attempts at uploading to Sheets over the past week.

Please note that I haven't included variables but the connection to Sheets works so the addresses are correct.

||F_Local|F_Local|2 Miles NNW Palm Desert CA|
||F_Local|F_Local|2 Miles NNW Palm Desert CA|
||F_Local|F_Local|2 Miles NNW Palm Desert CA|

errorA

Following is the block I am trying to insert Pura Vida's code into.

A post was merged into an existing topic: Google Sheets Upload Help Request