Skip to main content

We are trying to find a way to draft a personalized feedback letter to parents from a survey completed by instructors. Here is the way the Zap is currently working

  1. New record in Airtable
    1. This comes from an Airtable survey form
    2. Instructor’s list student full name and select progress and confidence
  2. Formatting with Zapier
    1. Format split - takes only first name of student
    2. Format replace - take out the word “Student” and replace with the previous output (student’s first name)
  3. Create Document in Google Doc from template
    1. Fill in feedback letter with personalized selections from instructor

The problem is the Format replace step is not working. It does not replace “Student” with the first name and I also tried to use {{first}} as a placeholder instead but this just comes up blank in the Google doc. Example from Google doc below. 

continues to make very good progress.. Student is confident of Math skills. He/She is disciplined and able to stay on task.

 

I am not sure where in the process the format replace step needs to be - I cannot seem to edit the contents of the Google doc once it is created and it does not change the incoming data from Airtable before entering information into the Google doc. 

Airtable survey options

 

Hi @Elsie 

Good question.

Please post detailed screenshots with how your Zap steps are configured in order for us to have proper context, thanks.

 

FEEDBACK

You should be able to do the below in Airtable using Airtable Formula fields.

Formatting with Zapier

  1. Format split - takes only first name of student
  2. Format replace - take out the word “Student” and replace with the previous output (student’s first name)

This actually is not something I had tried and it worked really well! I used airtable to change the formatting and then those outputs are correctly updated in Google Docs. Thank you!!