Hi Mike, I tried "Get URL" too.
It may not be possible to submit/post the data in the URL (launch url "https://docs.google.com/forms/d/e/1FAIpQLScoYoEfrcewj4IEG0FnfjBnfeVVSLva5tWv-dVexoP95trNNA/formResponse <https://docs.google.com/forms/d/e/1FAIpQLScoYoEfrcewj4IEG0FnfjBnfeVVSLva5tWv-dVexoP95trNNA/formResponse>?"& tStudentName & tDate & tSecondsSince & tCardName & tTargetObject) without getting the Google Form response. I was thinking of possible using this strategy in an HTML5 stack with student Chromebooks. Too bad, that would have been an easy way to store light weight stack data without a lot of effort :( Thank you! > On Aug 26, 2017, at 2:21 PM, Mike Bonner via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Try > get url "https://docs.google.com/forms/d/e/1FAIpQLScoYoEfrcewj4IEG0FnfjBn > feVVSLva5tWv-dVexoP95trNNA/formResponse?"& tStudentName & tDate & > tSecondsSince & tCardName & tTargetObject > > On Sat, Aug 26, 2017 at 3:15 PM, JOHN PATTEN via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> Hi All, >> >> I’m using the Google spreadsheet that gets created when you create a >> Google Form to collect data from a stack. >> >> I’ve copied out the specific Google submit form button to send my stack >> data to the Google spreadsheet. >> >> This works fine using “Launch URL” however it opens the browser and give >> me the Google Form Submission Confirmation page. Is there any way to >> submit the URL without actually launching the browser? >> >> I experimenting with tracking my students’ mouse clicks while using a >> learning app I may create, and was looking at a easy way to store that >> data, and utilize Google Forms simple data reports. >> >> Here’s the card script I’m using: >> >> on mouseDown >> >> --put the short name of target >> >> put the millisecs into TCurrentTime >> >> --convert tCurrentTime to milliseconds >> >> put cd fld "lastAction" into tOldTime >> >> put (tCurrentTime - tOldTime)/1000 into tSecondsSince >> >> if tSecondsSince > 60 then >> >> put "entry.133167263=" & tSecondsSince/60 & " minutes" & "&" into >> tSecondsSince >> >> put "entry.1059711654=" & cd fld "studentName" into tStudentName >> >> put "entry.630316753=" & the short date & "&" into tDate >> >> put "entry.768691577=" & the name of current card & "&" into tCardName >> >> put "entry.1264876799=" & the short name of target into tTargetObject >> >> launch url "https://docs.google.com/forms/d/e/ >> 1FAIpQLScoYoEfrcewj4IEG0FnfjBnfeVVSLva5tWv-dVexoP95trNNA/formResponse?"& >> tStudentName & tDate & tSecondsSince & tCardName & tTargetObject >> >> end if >> >> put tSecondsSince && "seconds" && "-" && the short name of target >> >> put "entry.133167263=" & tSecondsSince && "seconds" & "&" into >> tSecondsSince >> >> put "entry.1059711654=" & cd fld "studentName" & "&" into tStudentName >> >> put "entry.630316753=" & the short date & "&" into tDate >> >> put "entry.768691577=" & the name of current card & "&" into tCardName >> >> put "entry.1264876799=" & the short name of target into tTargetObject >> >> launch url "https://docs.google.com/forms/d/e/ >> 1FAIpQLScoYoEfrcewj4IEG0FnfjBnfeVVSLva5tWv-dVexoP95trNNA/formResponse?"& >> tStudentName & tDate & tSecondsSince & tCardName & tTargetObject >> >> put tCurrentTime into cd fld "lastAction" >> end mouseDown >> >> on openCard >> put the millisecs into cd fld “lastAction" >> end openCard >> >> Thank you! >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
