Forum Discussion

AlinMihalcea1's avatar
AlinMihalcea1
Qrew Assistant Captain
8 years ago

Webhook bug?

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?
  • 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.
  • AlinMihalcea1's avatar
    AlinMihalcea1
    Qrew Assistant Captain
    Exactly what you said. My formula was pulling information through a reference from a related table.
  • AlinMihalcea1's avatar
    AlinMihalcea1
    Qrew Assistant Captain
    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's avatar
    MCFNeil
    Qrew Captain
    What if you use a webhook on the source table, that changes a checkbox on the table in question....