Use a google form to update existing google spreadsheets -

-

i'm trying build google form fills out cells of existing google spreadsheet responses on google form. need of answers on google form come spreadsheet in drop down style menu.

the existing spreadsheet being used organization have members log information on weekly basis, however, members continue fill out form incorrectly no matter how many times i've corrected them. reason i'm trying make process more automated.

the way current spreadsheet set there multiple sheets different divisions of organization. in each sheet there column dedicated names in division, different name on each row of column. there columns dedicated specific weeks, week 1 information put column d , e, week 2 info in f , g, etc.

ex:

# | name | percent |... week 1 .... |... week 2 .... | ....

1 |.. bob..| 0%..... ..| info 1| info 2 | info 1| info2..|

2 | ..joe..| 99%......| info1..................................

i'd able to:

  1. make first question of form drop down menu selecting division, make rest of questions info based off sheet corresponding division.
  2. second question drop down menu select name. names based off names listed in existing name column of spreadsheet.
  3. a drop down menu select specific week submitting information for.
  4. a fill in box question fill in "info 1"
  5. a fill in box question fill in "info 2"

when submitted form find correct sheet based off (1), find correct row based off (2), find correct column based off (3), copy (4) , (5) corresponding cells.

is possible this? or need create separate form each division? can provide me appreciated. don't have familiarity google scripting, although experienced c++ , have basic working knowledge of scripting in python.

this difficult implement (but not impossible) stock google forms. can't use google apps script manipulate display of form in response user actions can javascript on form you've coded scratch.

google apps script can generate , manipulate form in same way can in form editor, , can triggered when form submitted take action response, can not interact user directly.

to achieve want have few options.

you set multi-page google form logic branches forms behaviour want, use apps script triggered onformsubmit() take care of moving data appropriate locations.

or can skip using stock google forms altogether , instead present form using google apps script published web-app, gives full control on form (html, css & javascript) displayed user, not leverage of google form features. render form doget() , process submission dopost().

a third approach hybrid of two, set several individual google forms, , use apps script published web app display first drop down , direct user appropriate form. have scripts triggered onformsubmit() of each of google forms handle moving data around.

see following:

https://developers.google.com/apps-script/guides/triggers/events#google_forms_events

https://developers.google.com/apps-script/guides/web#deploying_a_script_as_a_web_app https://developers.google.com/apps-script/guides/html/


Comments

Post a Comment

Popular posts from this blog

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs>
Read more

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11
Read more