Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
You make make a summary of the minimum of the Record ID# of the root cause record. Call it [Record ID# of the Root Cause]
Then change the button to this (not tested)
var text EDIT = URLRoot() & "db/" & [_DBID_ROOT_CAUSE] & "?a=dr&rid=" & [Record ID# of the Root Cause];
IF([Record ID# of the Root Cause]>0, $EDIT, $ADD)
Then change the button to this (not tested)
var text URLONE = URLRoot() & "db/" & [_DBID_ROOT_CAUSE] & "?a=API_GenAddRecordForm&_fid_17=" & URLEncode ([Record ID#]);
var text URLTWO = URLRoot() & "db/" & [_DBID_DAMAGE] & "?a=dr&rid=" & [Related Incident];
var text ADD =
$URLONE
& "&NextURL=" & URLEncode($URLTWO);var text EDIT = URLRoot() & "db/" & [_DBID_ROOT_CAUSE] & "?a=dr&rid=" & [Record ID# of the Root Cause];
IF([Record ID# of the Root Cause]>0, $EDIT, $ADD)