Discussions

Expand all | Collapse all

Use QB Action to Edit Record in another application

  • 1.  Use QB Action to Edit Record in another application

    Posted 01-05-2018 18:24
    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?


  • 2.  RE: Use QB Action to Edit Record in another application

    Posted 01-05-2018 19:02
    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);