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
