Silent Submission of Google Forms

If you tuned in about half an hour ago, you’d have seen how we’re triggering channel creation in Slack based on a custom post type getting published. One of the other tricks we wanted to happen as a result of that was the creation of a Google Folder. There are a variety of ways to play this but some of the easier ones would require some options we have blocked on our VCU accounts. I could have gone around that via a personal account and then subsequent sharing but it seemed like it’d be more fun to do it this way. I knew I could trigger script events based on form submissions and that I could use the data in the form as variables as well. I also knew I could fill out form variables via URL parameters. What I didn’t know was whether I could submit a Google Form without actually hitting submit. Turns out you can. Take your normal form URL. https://docs.google.com/a/vcu.edu/forms/d/e/1FAIpQLScK2wgma6Oicv_ZY9i-6tg_w9RfEKKkgiAFJDw15jJnmr5ofQ/viewform?entry.1431785794 You can get one of the pre-filled URL patterns like so . . . Which gives you a URL like this. You can see my pre-filled response ‘fish tank’ at the end of the url. https://docs.google.com/forms/d/e/1FAIpQLScK2wgma6Oicv_ZY9i-6tg_w9RfEKKkgiAFJDw15jJnmr5ofQ/viewform?usp=pp_url&entry.1431785794=fish+tank Now to make it auto submit ‘fish tank’ you have to change one piece and add an element at the […]

18

Gravity Forms – Regular URL for File Upload

I do a fair amount of Gravity Forms to posts. Many times those posts have files, mainly images, associated with them that I’d like to have embedded in the post. Gravity Forms did some changes a while back to prevent people from guessing where files are (which is good) but the secure URL change also made my embed patterns break. Throwing the little line above in a plugin makes things work again (although at the risk of people guessing where other files may reside).

Lynda Domain URL Tip

WordPress Essential Training Lynda.com is new to VCU. It’s good stuff and I wanted to use it more with students but the vanilla links lead you to the non-VCU authentication page which equals confusion and despair. Luckily, there is a simple solution. Just append ?org=vcu1 to the end of the URL and it’ll prompt the user for authentication and all the good things will happen. So this . . . https://www.lynda.com/WordPress-tutorials/WordPress-Essential-Training/372542-2.html becomes this . . . https://www.lynda.com/WordPress-tutorials/WordPress-Essential-Training/372542-2.html?org=vcu Just a little tip to make life more pleasant. 1 or whatever your org is – I spent some time trying vcu.edu and failing

Pre-Filling Forms via URL

I have to figure out a rather unpleasant and boring thing. I am, however, learning some fairly odd and interesting tricks as a result. This is one that might be useful to someone. Google Forms You can pre-fill Google form entries with a URL. That might be useful if you had 720 students in groups of 6 reviewing one another but didn’t want to build a form with 720 student names or build a 120 forms with 6 student names. I don’t think I’m going to end up using this for this purpose1 but maybe it’ll prove useful to someone else and it’s dead simple. Step one – Build your form. Step two – Go to Responses in the Form Editor view and select “Get pre-filled URL”. You then fill out the form the way you want and it creates the URL. In this case, I’m filling out a multiple choice question and a free form text entry. https://docs.google.com/forms/d/1P5_6vTv53MEKCEjd87xecI483goNqDg1-nPlFH84Mz0/viewform?entry.1615031756=Bob+Smith&entry.1012634392=I,+for+one,+have+always+admired+the+number+two. Now, you might wonder what would happen if in the URL you set a multiple choice answer to something not available as an option- like ‘Freddy Kruger’ for the first field in the form. I wondered that. It just comes up blank in the spreadsheet.2 Sadly, as I mucked around I couldn’t come up with a decent way to hide the […]