Auto-Fill an end date?
Hey, guys, I'm pretty new to QuickBase, but I currently have a button that sets the status of a task to "Complete" and redirects to the table view (where you originally clicked the button) I tried ...
Forum Discussion
Insert this into your equation;
"&_fid_9="&URLEncode(Today())
So it will look like this...
var text url=
URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" &
"&rid=" & [Record ID#]&
"&apptoken=cn3eu67ch3m9b76jdmn5b7vzn6d"&
"&_fid_10=Complete"&
"&_fid_9="&URLEncode(Today())
;
"javascript:" &
"$.get('" &
$url &
"',function(){" &
"location.reload();"&
"});
"&_fid_9="&URLEncode(Today())
So it will look like this...
var text url=
URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" &
"&rid=" & [Record ID#]&
"&apptoken=cn3eu67ch3m9b76jdmn5b7vzn6d"&
"&_fid_10=Complete"&
"&_fid_9="&URLEncode(Today())
;
"javascript:" &
"$.get('" &
$url &
"',function(){" &
"location.reload();"&
"});
Thanks for the sloppy formula - I modified my grammar to allow whitespace before the closing semicolon on formula variable declarations. Keep posting formulas (a) with errors, (b) without errors or (c) with sloppy formatting and I will keep patching the grammar.