Webhook bug?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
So I have a webhook using API_ImportFromCSV and the trigger for this is the changing of a formula checkbox field value. Well, my webhook fails to trigger, but if I change the trigger to a regular checkbox it works. 
Also I should state that the endpoint URL is in the same table the webhook resides. 
Anyone else encountered this?
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
  • confused.

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
What does the formula depend on - ie is the record getting edited or is the checkbox changing as a result of lookup or summary fields changing.

Webhooks only fire when the record gets edited not when related records on other tables get edited.
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
Did not know that... Great to know though. 

Thanks again Mark!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
Was that the cause of the problem?
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
Exactly what you said. My formula was pulling information through a reference from a related table.
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
So I've been wrecking my brains on how to get around this problem, but I can't come up with the answer.
Here is my formula:
//[Now] - changes to Now() every 30 minutes using table to table sync
//[Store Start Date] and [Store End Date] come from a related table

var date nowDate =ToDate([Now]);

If([Store End Date]>=($nowDate) and 
    [Store Start Date]<=($nowDate) and 
     Abs([Store End Time]-ToTimeOfDay([Now]))<=Hours(1),
       true,false)
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
What if you use a webhook on the source table, that changes a checkbox on the table in question....