Grab answer and pass into spreadsheet?
March 27, 2014 12:00 AM
Is there a way to take variables and pass them into a spreadsheet.
For exapmle: I need to take the user's name, and there identification number and store in a centralized location with all users who have taken the course.
I try to embed a SharePoint form but I have no way of validating the information as I don't have access to the form code.
Thanks in advance.
Discussion (3)
Awesome! That works perfectly although some of the technology changed and some revisions were required.
Now, I found out I can't use google docs and must use the company SharePoint site, which I thought would be easy enough.
The information required to complete the process is not as attainable as the google doc through firebug. I've tried every link combination and variable combination (even searched through the code itself) with no success.
Any suggestions/guidance would be GREATLY appreciated.
Here is a snippet of the HTML GET Response code, John Test and CVI-Test are the user inputs.
CVI-Test
| John Test |
@adod 60251 wrote:
I'm following that link but am having a bit of trouble.
[ATTACH=CONFIG]553[/ATTACH]
Where the article says the formkey will be just says application/x-www-form-urlencoded so I just used the URL (not the source at the bottom of the screenshot)
I used everything after entry. for the param name/value. So for example "1781393896"
After submitted the form I get gibberish values something like "asdfa"
Please advise.
Well, the url had those values set for each variable in the URL; here is the URL:
https://docs.google.com/forms/d/1rp3on3UwSgzF1MB6uL5pgaPluDIlIHcUZjwheYMTYu4/formResponse?draftResponse=%5B%2C%2C%224462162974437375457%22%5D%0D%0A&entry.1781393895=adfasd&entry.827158905=fasdf&fbzx=4462162974437375457&fromEmail=false&pageHistory=0
Do you mean this? http://lectora.com/blog/capture-learner-data-google-spreadsheets/
Discussions have been disabled for this post