Re: Help with formula URL

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))