In the last part of your video, you mention that there is a way to provide an Edit Form URL that goes to a specific Section (page) of the form. Do you have a link to a tutorial that you could share? Thanks!
Do you think there would be a way to have tiered approval paths? For instance, in a school, if a teacher made a request, then their principal approved it, could it then kick up to a superintendent for final approval?
Hi, did you create the second video tutorial for the Edit Form URL that goes to a specific Section (page) of the form? Would love to see that also. This is my first try at creating something like this in google forms and your first tutorial was great and seems like part two make this a really good way to get a request and then respond to it.
Erik, Very good description. I have a question regarding pre-filled URLs. You inferred that you can use pre-filled URLs to start on a second page, but I have not been able to find how to do that. I can pre-fill the first page, but I want to pre-fill the role and have them start on their page. Can you elaborate on how to accomplish that? Thanks!
I've seen several questions regarding multi-tier approvals. That is request -> instructor -> principal. Does anyone have an example of how to make this work that they would be willing to share? Thanks!
Hi Erik My Co due to worry of possible security bleach; had blocked Google Add-ons in Google Form. My question is, is there an alternative to create multi-level approver (5-tiers) by use of Gmail itself, pls. Sorry I am not tech savvy, do apologise if I haven't ask succinctly. Thanking you in advance for your help 🙏 Kind regards, Alice
Hi Erik, In the last part of your video, you mentioned that there is going to be another tutorial for going straight to one specific page of a form. Can you share with the tutorial link?
hi eric, im thinking of a multi approver (parrallel or serial) form where there are several people must give their approval before the requestor receives the email notifcation. most of the examples in the web are 1 approver only. Thanks!
This is great! Is there anyone who could help mi in creating workflow for orders which we are getting over google docs web form? Namely, we are getting orders over form, but I see here that it is possible to make more things, like as soon as we get order and it goes to spreadsheet, we could have automatic email to specified transporter (truck) email and to choosen producer. Is there anyone who could do this?
+Erik Erickson, I love this workflow and have been using it for a while. However, now, when the second person revisits the form to answer their questions, all of the previous users data is erased. Has anyone else noticed this?
I have been facing the same problem. Also I was using Auto-crat and FormMule for thsi workflow and now Google is blocking the file (I can't even open the document).
+OscarG There is a workaround here: productforums.google.com/forum/#!msg/docs/c27fLpODhlo/scJcLARQCgAJ. No word on if Google knows the issue, or when it might be fixed
Love this. Thank you so much for this instructional video. I have used this here in our school district and refer back to this video for reminders often. Now I have another kind of advanced question for you. I would like to auto submit. You have shown a little about proceeding to the next page with a prefilled form link. Well this form needs to proceed to the next page then the only thing on the next page is the submit button. I would like to figure out how to do that. Looks like the &continue=Continue+» doesn't work together with &submit=Submit. The first page of the form has a question with a certain answer, they just need to submit. Any ideas? I'm not very fluent on coding...
I have been using this, and it does fine taking us to the next/submit page, but I was hoping since there are no questions on that page, just a submit button if we could make that automatic. Here is a link I am using: docs.google.com/forms/d/e/1FAIpQLSfC9Zt6lof3D_3fgdwtURVkHHUU2ntNfJGxgHx2_r5VQadzUA/formResponse?entry.1364820515=Mary&entry.1485704272=In&continue=Continue+» This is an example form we are using: docs.google.com/a/usd357.org/forms/d/1BvG2gUOraZ_4nk8FYxglkI5lOTb4fxe129sgLogew_I/edit?usp=sharing
So... this is working if we don't have the collect user name on. :( Just wanted the student to have to scan the in QR Code by the door and not have to do anything else for returning back to class. Not sure there's a way if we are collecting the username.
Erik Erickson thanks for this. The last bit you talk about and show a prefilled link. I am very interested in that. Can you share the formula you used for that?
Erik Erickson thanks. Kind of you. It looks like I'll just manage :) I will work on this over the next week or so. I assume SheetKey! is the sheet you refer to where your vlookup info resides.
Erik Erickson Thanks again for assisting. I have now created a test form and checking it out. I must have done something wrong as my form create a new row for each submitter type. I was hoping the second submitter type would add the new data to the same row but in other columns. I hope this explains my issue.
Erik Erickson Thanks for assisting. Here is my spreadsheet docs.google.com/spreadsheets/d/1MRJEGfMnT2Yl7d_BGMPyey4GIhBXFpgorCtKsm5Ioe0/edit?usp=sharing And here is my form docs.google.com/forms/d/1j8rSPfeojhF86sV0co4GxcafTK7YBoMRemRm7DTM-O0/viewform?usp=send_form
Erik, I am a little late to the game here but was hoping you could elaborate a bit on this for me. I am trying to create a link that gets a user to the second section of a form. I believe this does it but am not sure how to personalize this to my form. Any help is appreciated - thanks!