Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

pre-fill google form from google apps script

I have a student registration form, there's student id which is a required field. I have a google apps script function which tells if this student is registered for any class or not. Is there a way to auto-fill the field course registered via calling the google apps script function yes or no.

like image 344
ITHelpGuy Avatar asked Feb 09 '26 21:02

ITHelpGuy


1 Answers

Yes you can create a pre filled response with the forms ID, not that the pre filled fields are showed in the URL

Function formPrefill(formId){
    var form = FormApp.openById(formId);
    try{
    var items = form.getItems();
    var formResponse = form.createResponse();
    // Prefill SessionId
    var formItem = "SOMETHING HERE"
    var response = formItem.createResponse(sessionId);
    formResponse.withItemResponse(response);

    //--------ANOTHER FIELD-------------
    formItem = items[4].asMultipleChoiceItem();
    response = formItem.createResponse('YOUR FIELD NAME');
    formResponse.withItemResponse(response);

    }catch(e){catch an error here}


}

check https://developers.google.com/apps-script/reference/forms/form#createresponse

like image 139
Juan Diego Antezana Avatar answered Feb 15 '26 20:02

Juan Diego Antezana



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!