Google Docs Student Name
August 13, 2022 12:00 AM
Hello -
I'm noticing that the name field in our survey data is coming over to our results page with %2C%20 between the last name and first name. In the past, this data came over as one would expect: Last, First. Is this a known issue? Just wondering if anyone else has experienced this and if so, how did you solve it, and would you want to share your solution? Oh, P.S. I did see that there is a new GOOGLE form dated June 1, 2022 for test/survey data.
Solution
Hello @janellmadonna. I just created a new course in Lectora Desktop version 21 using the Survey form link from the help file. The test is submitting the Survey results to the Google drive form and spreadsheet. I see the users name being saved as "First LastName" with a space between them. Link to my test sheet below.
Is it possible you have some javascript in your course that is parsing the name or changing the Learner's name variable somehow?
My Google Drive Sheet just created. Every entry in Column B was as I typed it in Lectora Run mode when prompted for the student's name:
https://docs.google.com/spreadsheets/d/18dzcRBgNRWfVTskPYrF3y1kO-luCzbYsVUKGsmc9xNU/edit?usp=sharing
Are you using the form from the Help file? If Google has ubpdated their survey form in might not be compatible with the current Lectora code.
https://public.lectora.com/help/Lectora/21.3/ENG/Lectora_Help/index.html#5011.html?Highlight=Google
Discussion (2)
"%2C%20" is comma space in url-encoded text. For some reason the data from Google is being sent as a URL (or received that way).
I've never used the Google APIs, so I have no actual knowledge to assist you with.
Hello @janellmadonna. I just created a new course in Lectora Desktop version 21 using the Survey form link from the help file. The test is submitting the Survey results to the Google drive form and spreadsheet. I see the users name being saved as "First LastName" with a space between them. Link to my test sheet below.
Is it possible you have some javascript in your course that is parsing the name or changing the Learner's name variable somehow?
My Google Drive Sheet just created. Every entry in Column B was as I typed it in Lectora Run mode when prompted for the student's name:
https://docs.google.com/spreadsheets/d/18dzcRBgNRWfVTskPYrF3y1kO-luCzbYsVUKGsmc9xNU/edit?usp=sharing
Are you using the form from the Help file? If Google has ubpdated their survey form in might not be compatible with the current Lectora code.
https://public.lectora.com/help/Lectora/21.3/ENG/Lectora_Help/index.html#5011.html?Highlight=Google