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.

Hello all, you have been so helpful to this complete beginner so far, so I’m hoping you can carry on the hit rate!

Here’s the background:

We are training company with online courses. When a new user signs up, a Zap sends a new record from Thinkific to Zoho Creator and populates a new user form (form 1) with all their details including their unique user ID, date of birth, email address etc.

When they then purchase a course, a Zap creates a new record (row)  in a separate Zoho form (form 2), using all their previous details from form 1, with the addition of the course name they have signed up for, usually level 1,  and the course enrolment date.

We have 3 different levels of courses, levels 1, 2, and 3.

The user, having finished level 1, may then sign up for level 2, and a new ‘row’ is created via a Zap, in form 2 using all the users details, the course name, level 2, and the course enrollment date.

So now the user has 2 records (rows), one for level 1, and one for level 2.

Here’s a made-up example

 

Here’s where I am now getting stuck.

When a user completes a course, I am trying to set a zap to be triggered by a course completion in Thinkific to populate the course completion date (and eventually the certificate number) in the row specific to the course.

So let’s say the user completes level 1 on 30th may, the Zap needs to enter the course completion date against the correct row using the user ID and the course name (level 1) as the identifier i.e it needs to update a row by adding in the course completion date against the correct user and course.

I’m struggling to understand the steps to update an existing record, and ensure it updates the correct row based on the user ID and course name.

Could someone tell me the step please.

Thanks for you help!

 

 

 

Hi there!

I’ve taken a look at the available Zoho Creator action events, and at the moment, the Update Record action is not supported. Other users have expressed interest in this feature, so I’ve added you to the list of interested users, and you’ll be notified if/when it becomes available.

In the meantime, you can consider storing this information in a spreadsheet app such as Google Sheets or Zapier Tables (https://zapier.com/apps/categories/spreadsheets), where you’ll be able to create, look up and update rows. That way, when the course is completed, you can search for a row with the matching user ID/course level, and update the row accordingly.

Hope this helps!

Hi ​@Coachbase Training 

You would have to use this Zap action: Zoho Creator - API Request

Zoho Creator API: https://www.zoho.com/creator/help/api/v2.1/update-records.html

 

If you need help, there is a directory of Certified Zapier Experts: https://zapier.com/experts

 

 

Hi Troy. Thanks, I’m getting there. I’ve managed to direct the API request to a recognised URL, but I’ve got an error message I don’t understand. 

So to recap: Each individual user has a row created in our course enrolments report whenever they enrol on one or more of our courses. So if a user buys 2 courses, they will have 2 lines, one for course 1, and one for course 2, each containing all the user’s details, their unique ID, and the course they enrolled on.

e.g 

USER NAME. USER ID.   EMAIL                    COURSE NAME           ENROLLMENT DATE.   COMPLETED ON

Joe Blogs.       123456    j.blogs@gmail.com.   Gymnastics level 1             30/03/25                    31/05/25

Joe Blogs.       123456    j.blogs@gmail.com.   Trampoline Level 1             01/06/2025                 

 

Obviously the user is going to complete the 2 courses on different days. The ‘feed’ coming in as the trigger from Thinkific is the course completion date.

So our API request is to locate the correct row in the course enrolments report based on 2 matching criteria - the user ID, and the course name, and then populate the field ‘COMPLETED ON’ with the date coming out of Thinkific.

 

Here’s what we have so far:

 

And this is the error message:

Could you please guide me. I am literally learning from scratch here!

Should the method say ‘get, or ‘patch’?

Should there be another step before the previous one for the zapier action required? I.e, populate the ‘course completed date. Not sure what zapier action to use here.

Thanks again.

​@Coachbase Training 

TIP: Try asking ChatGPT for guidance and help configuring the API request.

  • Share the link to the app API endpoint to reference.
  • Share screenshots with how your Zap step is configured.
  • Share screenshots of any encountered errors from testing.
Terms & ConditionsAccessibility statement