• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Need help with filtering to add or update record in Airtable from ThriveCart transactions

Delilah

Member
I set up a workflow that adds a new record or updates an existing record in Airtable whenever a transaction is processed in ThriveCart for a monthly membership. It seems to be working but it's adding multiple records, 3 blank and 1 filled in with the transaction details, for each new member. I'm not sure where I went wrong.

1724945728503.png


1724945748866.png


1724945776981.png


1724945816780.png


1724945841791.png


1724945856531.png


1724945884016.png


1724945910819.png
1724945939881.png

1724945956261.png


1724945974343.png


1724945992262.png

1724946007779.png

1724946025462.png
 

ArshilAhmad

Moderator
Staff member
Hi @Delilah,

The issue you are describing occurs when a user clicks on 'Save & Send Test Request' multiple times, which, in turn, creates multiple webhooks in the application, causing the workflow to execute that many times.

To fix this, disable the workflow in which you are facing the issue and set up a new workflow from scratch (without cloning).
1724951405510.png




We have also made some changes to this workflow on your behalf, which will help you achieve your desired result. Make sure to set up your new workflow exactly in this manner.
 

Delilah

Member
I have had this running since making these changes and it is working correctly to capture new purchases (thanks!), but it is not updating the Airtable on rebills.
 

Preeti Paryani

Well-known member
Staff member
Hello @Delilah

We have added a minute delay to your workflow please refer to the attached image for more info. Please make a few tests and let us know if it works for you.

1730794230683.png


Also, please elaborate on the use case you are trying to acheive so we can better assist you.
 

Delilah

Member
The goal is to track all subscription sales on Airtable. I want to capture the initial charge, then update the record with the recurring charge each month. It's tracking the initial charge but not updating recurring charges in Airtable.
 

Preeti Paryani

Well-known member
Staff member
Hello @Delilah

In that case, it seems the workflow is not configured correctly. Please refer to the attached.

1730870128631.png


As per my perception, the flow should be like:

  1. Trigger: Product Purchase
  2. Action: Search record by view(To check if the record with the email exists)
  3. Action: Router
    1. Route 1: Action: Create Record: If the user doesn't exist.
    2. Route 2: Action: Update Record: if the user exists.
If the above-mentioned flow fulfills your requirement, kindly set up the workflow in that manner and mapp the details accordingly. If after a new setup, the issue persists please let us know.
 
Top