Formula URL Button Troubleshoot

Question

Good morning,

I am wanting this button to edit a field in the form I am in by changing the status field (field id 59) to "Complete", then I want it to jump over to the related parent and flip a checkbox to unchecked, then i want to jump back to the child table, not the form I was in. Is this possible? I thought i had it correct but the only thing code below did was change the status field to complete and then give me an error message about the table not existing or something like that. Thanks in advance!

var text URLONE = URLRoot() & "db/" & Dbid()& "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_59=" & URLEncode("Complete");
var text URLTWO = URLRoot() & "db/" & [_DBID_INVENTORY_TRACKING] & "?act=API_EditRecord&rid=" & [Related Asset-mission] & "&_fid_163=1";
var text URLTHREE = URLRoot() & "db/" & [_DBID_MAINTENANCE_REPORT] & "?a=dr&rid=" & ([Related Asset-mission]);
$URLONE & "&rdr=" & URLEncode($URLTWO) & URLEncode("&rdr=" & URLEncode($URLTHREE))

MarkShnierYou · Answer

Can you post the error message?Is [Related Asset-mission]  the correct field for the Related Parent Inventory Tracking? Is that the correct reference field for that relationship?  It's a bit suspicious that you were using the same field to identify the record to be edited in both  the inventory tracking table and the Maintenance report table.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Sign up

Login to the community