Forum Discussion

ChaohanLi's avatar
ChaohanLi
Qrew Member
3 years ago

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...
ChaohanLi's avatar
ChaohanLi
Qrew Member
3 years ago
Hello Mark,

Thank you for your information.

What I currently have in mind is this:
I currently have a few tables, then I created a child table that would log any changes made to the reports in these tables. In the log child table, I have a field named "Affected Field". Every webhook from each table should capture which field is being modified and through that field name to "Affected Field" in the log table. I am just not sure will webhook be able to do that? I don't think your solution will be a suitable one in this situation.

------------------------------
Chaohan Li
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
In this line here

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

It will record who last modified, then the words "Client Name" which is the field affected, and then its old value and its new value.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • ChaohanLi's avatar
    ChaohanLi
    Qrew Member
    3 years ago
    I understand what you mean Mark, but by doing things your way, I think I would have to make hundreds of fields in the log table, and list every possible fields in the webhook. Is there simpler way, say using API_AddRecord? For example, with xml, 

    <field fid="15">[Record ID#]</field>
    <field fid="16">%dbName%</field>
    <field fid="17">                      </field>
    <field fid="10">                      </field>
    <field fid="11">                      </field>
    <field fid="12">%curuser%</field>

    field 17 is where to through in the field name, field 10 for old value, and field 11 for new value. (Yet don't know which field is going to be modified by the user, so it can be any field, and there are at least 50 fields).

    Thanks for your help.

    ------------------------------
    Chaohan Li
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      Sorry but that is the only way I know.
      I suggest that you use excel or word or some other tool to create the body of the webhook where you can use copy and paste.

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