Forum Discussion
michaelward
7 years agoQrew Member
What about the following:
var text URLONE=URLRoot() & "db/" & [_DBID_Tasks] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Record ID#])&
"&_fid_60=" & [03 IDD]&
"&_fid_61=" & [03 EDD]&;
var text URLTWO=URLEncode("https://DOMAINNAME.quickbase.com/db/DBID2?a=q&qid=REPORT ID");
$URLONE
& "&NextURL=" & URLEncode($URLTWO)
Getting an invalid formula after the semicolon following &[03 EDD]&
var text URLONE=URLRoot() & "db/" & [_DBID_Tasks] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Record ID#])&
"&_fid_60=" & [03 IDD]&
"&_fid_61=" & [03 EDD]&;
var text URLTWO=URLEncode("https://DOMAINNAME.quickbase.com/db/DBID2?a=q&qid=REPORT ID");
$URLONE
& "&NextURL=" & URLEncode($URLTWO)
Getting an invalid formula after the semicolon following &[03 EDD]&
- QuickBaseCoachD7 years agoQrew CaptainRemove the last & in urlone.
var text URLONE=URLRoot() & "db/" & [_DBID_Tasks] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Record ID#])&
"&_fid_60=" & [03 IDD]&
"&_fid_61=" & [03 EDD]; - michaelward7 years agoQrew MemberOK that works but it doesnt save the new record and when I hit save and close I get a bad URL (We Cant Understand....) error
- QuickBaseCoachD7 years agoQrew CaptainPlease post your actual code.
- michaelward7 years agoQrew Membervar text URLONE=URLRoot() & "db/" & [_DBID_Tasks] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Record ID#])&
"&_fid_60=" & [03 IDD]&
"&_fid_61=" & [03 EDD];
var text URLTWO=URLEncode("https://capitalimpact.quickbase.com/db/bmddpcay2?a=q&qid=162");
$URLONE
& "&NextURL=" & URLEncode($URLTWO) - QuickBaseCoachD7 years agoQrew CaptainI�m not that posted properly. Basically in URLTWO, do not URLEncode.
- QuickBaseCoachD7 years agoQrew Captain
- michaelward7 years agoQrew MemberThat works, so last question is there a way to skip opening the child record and having to hit save and close?
- QuickBaseCoachD7 years agoQrew CaptainIf you change
API_GenAddRecordForm
to
API_AddRecord
Then it will add a record without user interaction. - michaelward7 years agoQrew MemberI made the change to API_AddRecord but now I get an XML error
<qdbapi>
<action>API_AddRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>2401</rid>
<update_id>1518204553919</update_id>
</qdbapi> - michaelward7 years agoQrew MemberIf I hit back on the browser I do see it updated with a child record but it cant seem to get back to the report