Use QB Action to Edit Record in another application

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Doesn't Need an Answer
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?
Photo of Jessica

Jessica

  • 414 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of Jessica

Jessica

  • 414 Points 250 badge 2x thumb
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);"
(Edited)