Hi
The reason we are not using lookup fields is that we are trying to see how long a record is in a status. So, we want a new child record each time the status is changed on the parent, having multiple entries in the child.
Below I applied the field info to the formula you provided above, which doesnt work. Any suggestions would be great as I am very new to QuickBase.
Parent Fields
� [Record ID#] - fid 3
� [Current Status] - fid 41
Child Fields
� [Record ID#] - fid 3
� [Status] - fid 16
var text $URLONE=
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken="chusaq6stbw3jcg2den4fa2vq=" & [Record ID#] & "&_fid_41="&URLEncode("Sales Feedback");
var text URLTWO = URLRoot() & "db/" & [_DBID_STATUS_LOG]
& "?act=API_AddRecord"
& "&_fid_3=" & [Record ID#] // populate the field [related parent] with the record ID# of the parent you are sitting on
& "&_fid_16=" & urlencode([Current Status])
& "&apptoken="chusaq6stbw3jcg2den4fa2vq";
var text URLTHREE = urlroot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))