Forum Discussion
QuickBaseCoachD
Qrew Captain
What would you want to trigger copying records?
MuraliGangineni
6 years agoQrew Cadet
I got an issue in that...
As i am looking up the Summary Field of FocusTable into the BaseTable, It is giving me the last updated value of Summary Field instead of current updated value. This is happening when i click on the Formula URL Button with the below formula:
var text URLONE = URLRoot() & "db/" & [_DBID_FOCUS_TABLE] & "?act=API_EditRecord"
& "&rid=1"
& "&_fid_6=" & URLEncode([Article Number]);
& "&apptoken=xxxxxxxx";
var text URLTWO = URLRoot() & "db/" & [_DBID_FOCUSMASTER] & "?act=API_EditRecord"
& "&rid=1"
& "&_fid_7=" & URLEncode([FocusMaster - Summary Field - # of Graphmasters]);
var text URLTHREE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=43";
var text URLFOUR = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=44";
var text URLFIVE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=45";
var text URLSIX = URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & ToText([RECORD ID#]) ;
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
Is there a way to get the current updated value ??
If not,
Is there a way to use Javascript in Formula URL to extract the number of records in the Table using API_DoQueryCount ?
As i am looking up the Summary Field of FocusTable into the BaseTable, It is giving me the last updated value of Summary Field instead of current updated value. This is happening when i click on the Formula URL Button with the below formula:
var text URLONE = URLRoot() & "db/" & [_DBID_FOCUS_TABLE] & "?act=API_EditRecord"
& "&rid=1"
& "&_fid_6=" & URLEncode([Article Number]);
& "&apptoken=xxxxxxxx";
var text URLTWO = URLRoot() & "db/" & [_DBID_FOCUSMASTER] & "?act=API_EditRecord"
& "&rid=1"
& "&_fid_7=" & URLEncode([FocusMaster - Summary Field - # of Graphmasters]);
var text URLTHREE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=43";
var text URLFOUR = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=44";
var text URLFIVE = URLRoot() & "db/" & [_DBID_Table2] & "?act=API_RunImport&ID=45";
var text URLSIX = URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & ToText([RECORD ID#]) ;
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
Is there a way to get the current updated value ??
If not,
Is there a way to use Javascript in Formula URL to extract the number of records in the Table using API_DoQueryCount ?