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
