First off, Happy Holidays to everyone here. I have been diligent in cleaning up my code to make a well-functioning app. I wanted to have an idea of not "who," but where and when a particular downloaded app was being used. With help, I added a random number generator from 999,999 to 9,999,999 and this becomes the User_ID number. I modified an available script to what I think should allow me to send data to my Google Sheets.
I am not sure what I am doing, as this is new territory for me. I am mostly copying and pasting and crossing my fingers.
Given that I get an error code, I know I am improperly "mixing and matching" but I do not know where. Can someone help me eliminate my error and, perhaps, lead me to a successful Sheets download?
Even though the chances are low, you run the risk of a collision of two random numbers being the same. You might consider a random password generator or this extension for your user ID
Have you looked at the responseContent ? When sending data using a prefilled form, the response is usually an html file not data.
Just an observation, but it is unlikely that the Location sensor will get a fix immediately on Screen Initialise, unless you are using a fused provider (wifi/data/gps)
Are you trying to retrieve data that already exists, or set new data ?
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|
Following is the block I am trying to insert Pura Vida's code into.
