Display a personally crafted (not chosen among a set) recommendation after a Typeform.

Refresh: after that post I was able to display a webpage through JSON data sent via a doget() on google apps script upon webpage loading. Now I stil have to ensure that the content loaded on the webpage is the respondent’s recommendation only.

Thanks Grace!

@mathio  seems to be the right person to help me. I found another conversation that seem to be related to my question:

That could probably help me but as i’m a beginner in coding I need more detailed explanations on the different steps:

• creating a hidden field with the ‘response Id’ to be sure I find that ‘response Id’ in my google sheets
• passing that ‘response Id’ to a url where the personal recommendation will be displayed or, if the respondent can remain on the same page, passing that ‘response Id’ to the doget()/dopost() function of my script in Google apps script.

Thanks!

Stef

Thanks @mathio for your quick reply!

1. The link to google sheets is OK and I have the Token column. it’s perfect if I can use it as a unique identifier.

2. The page where the Typeform is embedded is: https://www.ridingmatch.com/questionnaire

(the page where the recommendations would be displayed if that solution is chosen: https://www.ridingmatch.com/recos)

I’m aware I have to use the callback function but not sure where exactly on the Typeform page and if I need to erase other lines when I insert the code showed on Vanilla.

3. Google apps script uses a form of JS with custom google functions. Below is the code I tried with email as identifier but it doesn’t work for me as a respondent may fill several forms so the Token seems to be what I need.

So my problem now is to catch the Token after submission and for example add it to the redirect page URL to identify the form. If I can do that I’ll find a way to extract it from the URL with my script to display the proper recommendation. I’m interested in the other option you mentioned (without redirect page) but I would need more step-by-step guidance.

Thanks for your help!

Stef

var sbi SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/myspreadsheetexample')

var sheet = sbi.getSheetByName('sheet where I store the recommendations data');

var …

var …

var …

//all the variables to state in which columns the recommendations data is stored 

function doGet(e) {

  // Get the unique identifier from the URL parameters

  var identifier = e.parameter.id;//I tried that with email as identifier but it doesn’t work for me as a respondent may fill several forms. So the token is a good solution.

  // Check if the identifier is valid (you need to implement this function)

  if (isValidIdentifier(identifier)) {

    var lastRespRow = isValidIdentifier(identifier);//row where the recommendation of the respondent we are looking for is stored

    // Get the data from the respondent row we’re interested in

    var submitAt = sheet.getRange(lastRespRow, submitAtColumn).getValue();

    var typefToken = sheet.getRange(lastRespRow, typefTokenColumn).getValue();

       var recipientEmail = sheet.getRange(lastRespRow, recipientColumn).getValue();

    var firstName = sheet.getRange(lastRespRow, firstNameColumn).getValue();

    var … //all the variables to get the data from the row of the identifier

    // Display the recommendation

    if (flagValue !== "") {

      //Create the HTML table:

      var emailTemplate = HtmlService.createTemplateFromFile('emailtemplate');//create a HTML file from the data (I had done that to send recommendations by email, I kept it that way)

      // Compose the message to display

      var message = emailTemplate.evaluate().getContent();

      var jsonResponse = {

        title: 'Email Template Page',

        content: message

      };

      // Convert JSON to string

      var jsonString = JSON.stringify(jsonResponse);

      // Set Content-Type header to application/json

      var output = ContentService.createTextOutput(jsonString).setMimeType(ContentService.MimeType.JSON);

      return output;

    }

  } else {

    // Handle unauthorized access

    return HtmlService.createHtmlOutput('<h1>Unauthorized Access</h1>');

  }

  function isValidIdentifier(identifier) {

//function to look for the row where the identifier is located

         }

  }

 }

Excellent!!! I’m beginning my coding journey and the support from experienced coders like you is so valuable. Thank you so much to have helped me achieved what I had in mind.

Hi @mathio, you helped me a few months ago to catch a form token after submission and use that token to display personalised recommendatrions on a webpage 👍

Now some respondents, after seeing their recommendations, want to go back to the form, change some answers on some questions and get another personalised recommendation (corresponding to a new form token). Is it possible to create a URL link to go back to the form (a URL that includes the token)? I would inlude that URL link at the end of the recommendation for the respondents to go back and change only some answers.

Thanks,

Stef

Thanks @mathio for your reply. I'll have to find another way to do it.