I will preface this by saying that I am a complete amateur to this but here is what I am trying to do.
I am trying to create a basic sign in application. I would like a user to supply basic information, name, postcode, purpose of visit etc, which are input in standard text fields. Upon signing in, the user is generated with a generated visitor number, or whatever (could be a green elephant picture; it doesn't matter. It just needs to be a unique identifier up to about, say, 50 possibilities).
Forgetting the unique number/picture bit for a second, I am just trying to grapple with how to get the data out of the text fields and into a google sheet.
The user will then need to be able to recall that data on a sign_out card later user their unique number/picture. So I suppose I will need to be able to reverse this and get data from the google sheet back into something like a data grid. This bit needs to be anonymous - we can't have everyones data showing up here.
I have read some many articles on arrays, and Google sheets that it is making my head spin. Nothing is working. Can anyone help please?
Sending field data to a Google sheet
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Sending field data to a Google sheet
In your spreadsheet select File - Share and copy the link from the "Link to Share" box.
Then replace the text edit?usp=sharing by export?format=csv. Now the correct code to use is:
This way you get the all spreadsheet as a CSV.
Unfortunately, you cannot write directly to the spreadsheet. What you can do, however, is create a Google Form and view the responses as a spreadsheet. So just analyze the HTML of your Form and post data to it. For more information read here:
Then replace the text edit?usp=sharing by export?format=csv. Now the correct code to use is:
Code: Select all
put URL "https://docs.google.com/spreadsheets/d/1zeuTNtVKbpdcH0culcNDoTRPadsdssJrkfZLsmbLFPNs/export?format=csv" into mydb
Unfortunately, you cannot write directly to the spreadsheet. What you can do, however, is create a Google Form and view the responses as a spreadsheet. So just analyze the HTML of your Form and post data to it. For more information read here:
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
Re: Sending field data to a Google sheet
Incredibly helpful reply, thank you MaxV. I'll do some reading and report back if I have any issues, or even, if it works!