Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hey,

 

Ok, so i have a Zapier table that receives lesson data from my students, once they complete a lesson it sends them an email with results etc…. There are 8 lessons in total, all in one table, each lesson has 5 columns in total e.g. L1_p1(string), L1_p2(string), L1_p3(string), L1_p4(string) and L1_complete(Boolean). The source of the data is Thinkific, when the user completes the lesson it triggers a Zap to tick ‘L1_complete’.

 

My plan was to use a ‘New or updated’ record trigger to tell a Code action which lesson was completed, then have the code grab the data from the columns for that lesson i.e. L1_complete, is ticked so the code looks for columns titled ‘L1’, which is sent on to MailChimp to be sent to the user. 

 

The mailchimp side of things has been it’s own challenge but it seems the “easiest” way i’ve found is to export my template as HTML, edit that with my zapier tags and paste it back to the create campaign HTML field.

 

Does this seem like the most efficient / reliable way to do this, or are there any other triggers/actions that you would recommend for this workflow? 

 

Any tips are much appreciated.

 

 

​@Captainhoola 

I see no reason why your reasoning is flawed. I am generally happy when I get a zap to achieve what I need it to do no matter how messy that is. If it works I’m happy. 

When I learn more I revisit them.

Shopify for me was such a case. Initially I couldn’t work out how to deal with purchases with multiple items in the cart. The zap has run almost five years, fine except when customers failed to follow instructions. Last month I finally worked out how to do it so rewrote them.

Good is good enough. If it works, better is nice, but only if it’s worth the extra effort.  

You could have the code block write the HTML email including logic and the tags in one go, but not sure it would be any different. 

Hi ​@Captainhoola 

Why not use a more generic and scalable table structure? (screenshot as example)

There would be 1 row per student/lesson.

 

If you wanted to take it a step further you could use Airtable to create a relational data base with these linked tables:

  • Students
    • Linked to a Result
    • Can derive the Lessons from the Results
  • Lessons
    • Linked to a Result
  • Results
    • Linked to a Student
    • Linked to a Lesson

Hi ​@Captainhoola,
 
We just wanted to see how everything is going with your Zap. Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Reply


Terms & Conditions