Skip to main content
Question

Can webhook capture the field name that's being modified?

Hello,

I am trying to set up a webhook to capture any changes to a record. I don't know which field is going to me modified by the user, therefore, I need the webhook to capture the field name that's being changed. My question is is it achievable with webhook? If it is achievable, how?

Thank you.

------------------------------
Chaohan Li
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    What I have done in the past is to create a child audit trail table and when any edits are made  to the record, trigger a Webhook to copy the old and new values into the child table. Of course in most cases very few of the fields will be changed meaning that the old value and the new values will be the same.

    So then,  say each night,  we would run a pipeline to delete all the records where there was no change to the particular field.  ie, the old and new values were the same. 

    On any reports of the audit trail we would simply filter out where the old value and the new value is the same so from the users' perspective they would not be bothered by that extra clutter awaiting the nightly purge.


    Message Header QUICKBASE-ACTION API_ImportFromCSV

    Webhook #1 called Logger - multi field when added or modified of just logged fields changing

    <qdbapi>
    <usertoken>bxv4tx_bjix_8csgf2bk9smkgc5igppzvgv53r</usertoken>
    <records_csv>
    %RepeatOn%

    "[Last Modified By]","Client Name","[old.Client Name]", "[Client Name]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Site Name","[old.Site Name]", "[Site Name]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Contact Name","[old.Contact Name]", "[Contact Name]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Contract Name","[old.Contract Name]", "[Contract Name]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Contract Type","[old.Contract Type]", "[Contract Type]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Industry","[old.Industry]", "[Industry]", "CO","[Record ID#]","[Record ID#]"

    "[Last Modified By]","Primary Project Manager","[old.Primary Project Manager]", "[Primary Project Manager]", "CO","[Record ID#]","[Record ID#]"

    "[Last Modified By]","Secondary Project Manager","[old.Secondary Project Manager]", "[Secondary Project Manager]", "CO","[Record ID#]","[Record ID#]"

    "[Last Modified By]","Large Contract Approver","[old.Large Contract Approver]", "[Large Contract Approver]", "CO","[Record ID#]","[Record ID#]"

    "[Last Modified By]","Estimator","[old.Senior Estimator]", "[Senior Estimator]", "CO","[Record ID#]","[Record ID#]"

    "[Last Modified By]","Projected Start Date","[old.Projected Start Date (not in use)]", "[Projected Start Date (not in use)]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Projected End Date","[old.Projected End Date (not in use)]", "[Projected End Date (not in use)]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Contact Status","[old.Contract Status]", "[Contract Status]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Award Date","[old.Award Date]", "[Award Date]", "CO","[Record ID#]","[Record ID#]" 

    "[Last Modified By]","Customer PO","[old.Customer PO]", "[Customer PO]", "CO","[Record ID#]","[Record ID#]" 



    %RepeatOff%
    </records_csv>
    <clist>6.7.8.9.10.11.14</clist>
    </qdbapi>

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement