Skip to main content
Best answer

SMS works fine in test, but does not trigger when Zap is on


Forum|alt.badge.img
  • Beginner
  • 14 replies

I have a Zap consisting of a webhook from Airtable that the great @Troy Tessalone  helped me figure out.  Eternal thanks for that one!

Now I have a new issue.  I pull data from Airtable via the webook and send a message containing that data via my text provider, JustCall.

When I test the zap, everything works fine.  When I turn the Zap on, the text never sends.  I’ve been waiting about 3 days now for that text, so I’m certain it’s not a polling problem.

When using zap instead of webhook, I’ll get one with a 15 minute-1 hour delay, so I get polling there.  But the webhook should at least send something, right?

Any thoughts?

Best answer by Troy TessaloneBest answer by Troy Tessalone

@JoFo

TIP: Make sure to include a Timestamp as a query string parameter on the webhook sent from Airtable.

let Timestamp = new Date();

Zaps have some deduplication in place, so passing a timestamp ensures the deduplication won’t prevent the Zap from triggering.

 

Also, make sure you have the correct webhook placed in the Airtable Automation Script step.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Forum|alt.badge.img+14

HI @JoFo 

Check your Zap Runs: https://zapier.com/app/history/

  1. Is the Zap ON?
  2. Did the Zap trigger?
  3. Were there errors on a step?

 

Can you post screenshots of your Zap steps?

Can you post screenshots of your Airtable Automation steps?


Forum|alt.badge.img
  • Author
  • Beginner
  • 14 replies
  • August 5, 2021

Thanks @Troy Tessalone  for stepping in again.  The Zap is on.  The Zap will not trigger.  I just tried again.  There were errors back when I was getting the “undefined” error for not naming my variables in Airtable.  Since then, nothing triggers at all.

Here are some shots of Airtable then Zapier.  As you can see, Airtable runs the automation, but Zap doesn’t see it.  The errors were from days ago before fixing airtable.   Today’s attempt doesn’t show at all.



 


Forum|alt.badge.img
  • Author
  • Beginner
  • 14 replies
  • August 5, 2021

Here are two more screen shots.


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31122 replies
  • Answer
  • August 5, 2021

@JoFo

TIP: Make sure to include a Timestamp as a query string parameter on the webhook sent from Airtable.

let Timestamp = new Date();

Zaps have some deduplication in place, so passing a timestamp ensures the deduplication won’t prevent the Zap from triggering.

 

Also, make sure you have the correct webhook placed in the Airtable Automation Script step.


Forum|alt.badge.img
  • Author
  • Beginner
  • 14 replies
  • August 5, 2021

@Troy Tessalone  You’re a genius.  I’ll delete screen shots now, but that was 100% it.

 

Now I have a new problem on the Airtable side.  Where I was getting all 5 variables sent, now my quote calculation that provides the cost is sending as $0.

I’ll try different line places of the Timestamp.

 

 


Troy Tessalone
Forum|alt.badge.img+14

@JoFo 

Another workaround is to send only the Record ID and a Timestamp, then in the Zap use an Airtable Find Record step (find based on ID) to get the data points to map.

NOTE: You may need to add a Formula field to the Table with a formula of: Record_ID()


Forum|alt.badge.img
  • Author
  • Beginner
  • 14 replies
  • August 5, 2021

That worked!!  I got the instant text.

 

For those seeing this later:

 

Catch Hook on Zapier webhooks with RecordID and Timestamp codes only.
Then Find Record based on RecordID

Then send text with your SMS client.