Forum Discussion

JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
8 years ago

Use QB Action to Edit Record in another application

I want to use an Action to Edit a record in another application.  I have given both applications the appropriate permissions and made a parent-child relationship for the table I want data in to the table I have the data in.  I can create records via Action in the other application.  However, it does not let me edit records in the other app.  Any thoughts?  Can I do this through webhooks?
  • JessicaFeauto2's avatar
    JessicaFeauto2
    Qrew Cadet
    8 years ago
    Nevermind the question, I got it to work using the EditRecord API call.  The trick is using the app token of the app that will be recieving data (not the one sending it).  

    var text URL= "https://xxxxxxx.quickbase.com/db/xxxxxx"; & "?act=API_EditRecord"
    & "&rid=" & URLEncode ([Field in sending App that will match the Record ID in receiving App])
    & "&_fid_193=" & URLEncode ([Field 1])
    & "&_fid_194=" & URLEncode ([Field 2])
    & "&_fid_12=" & URLEncode ([Field 3])
    & "&_fid_17=" & URLEncode ([Field 4])

    & "&apptoken=" & "xxxxx";

    "javascript:" &
    "$.get('" & 
    $URL & 
    "',function(){" &
    "location.reload(true);" &
    "});" 
    & "void(0);