Skip to main content
Question

Use QB Action to Edit Record in another application

  • January 5, 2018
  • 0 replies
  • 38 views
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?
      This topic has been closed for replies.

      • JessicaFeauto2
      • Author
      • Registered
      • January 6, 2018
      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);
      Terms & ConditionsAccessibility statement