How I could do next? is it possible?

[Cristian Ruiz]

Hi!

We need to cover a internal proccess in our school and with google form is not possible. 

We need to create a new form with data from a spreadsheet. We have discovered Form Ranger Add-on and now we know to import a field from a spreadsheet into google form. This is ok. But we need something more.

We have a spreadsheet with 700 students but we need to show this data with filters to the final user. For example, a parent has to fill this form and we dont know that they have to see our 700 students. The best would be that first of all import "course" field, and then, with an automatic filter, show only students in this course.

Would be it possible with form ranger?

Thank you!!

[Joseph Schmidt]

How about a custom URL for each parent that only shows their child?  You can modify the prefilled option and use FormMule to share the link.  The link would open the form and fill in the student's name.  That way, you don't need a list of students.  You wouldn't need a list of students.  

=HYPERLINK("https://docs.google.com/forms/d/e/1form_urleQ/viewform?usp=pp_url&entry.776236766="&text(today(),"yyyy-mm-dd")&"&entry.421985528="&substitute(SUBSTITUTE(AB4," ","+"),",","%2C")&"&entry.1018455166="&B4&"&entry.1787786125="&C4&"&entry.920687010="&D4&"&entry.828160006="&E4&"&entry.220503251="&F4&"&entry.762216168="&G4&"&entry.1611885239="&H4&"&entry.866254840="&I4&"&entry.1773985176="&J4&"&entry.495287452=0&entry.1403088856=0&entry.1810542154=0&entry.1898174097=0&entry.259339819=0&entry.755324326=0&entry.755482142=0&entry.1019197049=0&entry.421083387=0&entry.2144745685=0&entry.2062286903=0&entry.1249626037=0&entry.709077598=0&entry.994794199=0&entry.549501795=0","add for current") 

The above fills in multiple fields.  The substitution is so that blanks and commas are represented correctly.

On the form you get a prefilled link and then modify it to pull data from the spreadsheet.

Let me know if you need more data.

FormRanger updates the form before it is opened by the user.  I don't know of a tool that updates questions based on answers to other questions.  That would be super powerful.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

De acuerdo con la L.O. 3/2018 de 5 de diciembre de Protección de Datos Personales y Garantía de los Derechos Digitales, le informamos que los datos personales contenidos en este correo y/o archivos adjuntos serán tratados por la INSTITUCIÓN HISPANO BRITÁNICA DE ENSEÑANZA, S.C.L. y por la FUNDACIÓN JUAN DE LANUZA (en adelante conjuntamente denominadas como COLEGIO JUAN DE LANUZA), como responsables del tratamiento, con la finalidad de atender su solicitud. En cualquier momento podrá solicitar más información sobre el tratamiento de sus datos, así como ejercer los derechos de acceso, rectificación, supresión, portabilidad y limitación u oposición a su tratamiento enviando un correo a lo...@juandelanuza.org. Puede ampliar esta información en www.juandelanuza.org

--
You received this message because you are subscribed to the Google Groups "NV Form Ranger Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-form-ranger-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-form-ranger-add-on/99fc5c3b-89bf-430e-a635-6f046b0cd2d9n%40googlegroups.com.