how to pass child table value to parent table in quickbase using API formula
I am attempting to update a status field in the parent table when a user clicks the API button from the child table. I have used the following formula, but I received an error stating 'Missing "rid" parameter.' Additionally, I would like to hide the API button from the child table when the user clicks on it
var text EditUser = URLRoot() & "db/" & [_DBID_ON_HOLD_TASKS] & "?act=API_EditRecord"
& "&rid=" & [Record ID#] & "&_fid_6=" & Now(); // Chlid table
var text AddUser = URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=API_EditRecord"
& "&apptoken=dpvtvtrbuvtrjjd5ydp38bccn9np"
& "&_fid_45=" & URLEncode("Task OnHold"); // Parent table
If(IsNull([On Hold Start Date]),
$AddUser & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INPROGRESS] & "?a=dr&rid=" & [Record ID#]),
$EditUser & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ON_HOLD_TASKS] & "?a=dr&rid=" & [Record ID#]))
------------------------------
manohar vankireddy
------------------------------