Skip to main content
Question

Webhook bug?

  • July 7, 2017
  • 0 replies
  • 37 views
Forum|alt.badge.img+6
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?
      This topic has been closed for replies.

      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.
      Forum|alt.badge.img+6
      • AlinMihalcea1
      • Author
      • Registered
      • July 7, 2017
      Did not know that... Great to know though. 

      Thanks again Mark!
      Was that the cause of the problem?
      Forum|alt.badge.img+6
      • AlinMihalcea1
      • Author
      • Registered
      • July 7, 2017
      Exactly what you said. My formula was pulling information through a reference from a related table.
      Forum|alt.badge.img+6
      • AlinMihalcea1
      • Author
      • Registered
      • July 7, 2017
      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)
      • MCFNeil
      • Registered
      • July 12, 2017
      What if you use a webhook on the source table, that changes a checkbox on the table in question....
      Terms & ConditionsAccessibility statement