Forum Discussion

JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
7 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 ta...
JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
7 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);