Webhook behavior expected?

Question

I created a webhook that changes a field in a record, based on if a different field is modified. I chose a webhook because it works instantaneously, and it is such a simple thing I hate using an entire pipeline for one simple thing like this.
Webhook works fine except it does not work in grid edit mode (which is the reason I made the webhook in the first place instead of a dynamic form rule). In grid edit mode, if I change 5 records, the webhook fires correctly for the first record changed, but doesnt fire for the remaining records. I saw the limitations on webhooks were 50/second, so I imagine if I grid edit over 50 that could happen, but does anyone know why i cant even grid edit 2 records and have the webhook fire twice, once for each modification?------------------------------Mike Tamoush------------------------------

miketamoush · Answer

Thanks Jim. So in your formula, in the clist I take it you include the Record ID, and then the field you want to change? How do you set the field you want to update?
For example, if I want to set field 100 to the word 'Test', how does that look?------------------------------Mike Tamoush------------------------------

miketamoush · Answer

Nevermind got it!
For others, the Record ID is there so it knows which field to map to. Each thing after the comma maps to the clist below.

So if I had:
[Record ID#],Complete, [Field A]
then Clist 3.125.165
It will match the the record ID and put the word complete in field 125, and put the value of Field A in field 165.
------------------------------Mike Tamoush------------------------------

markshnier__you · Answer

That should work, so I suggest a ticket to support. A webhook is supposed to trigger at the database level so it should not matter how the edit was done.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

miketamoush · Answer

Customer support is saying webhooks do not support multiple record changes, unless you use API_ImportFromCSV utilizing the %repeaton% command.

??? So webhooks essentially dont work in grid edit I guess..?? Any webhook experts think otherwise or have a workaround (I can just use a pipeline....just wondering if anyone knows how to make it work with a webhook).------------------------------Mike Tamoush------------------------------

miketamoush · Answer

Confirmed. API_Edit Record cannot be used in a webhook for multi record changes. But Kirk Trachy has a video on how to leverage API_importfromcsv

https://www.youtube.com/watch?v=-eY6ZAivCZY
Ill try it and report back!------------------------------Mike Tamoush------------------------------

Forum Discussion

Webhook behavior expected?