Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
no problem. make a formula variable called, (I suggest), URL and then continue the formula box with the javascript refresh syntax.
var text URL =
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_11=Complete";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
Don't worry that you don't understand that javascript stuff. It just executes the formula variable called URL and refreshes whatever page you were on. It's magic.
var text URL =
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_11=Complete";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
Don't worry that you don't understand that javascript stuff. It just executes the formula variable called URL and refreshes whatever page you were on. It's magic.
RyanPflederer2
8 years agoQrew Trainee
And if you don't need to see the change on that page immediately, you can swap out
"location.reload(true);" with the line below to remain on the same page but display a small disappearing popup. It makes it even quicker when trying to update numerous records in a report.
Just replace the bold part with whatever text you need to see in the popup.
"$.jGrowl('Record #" & [Record ID#] & " has been marked Completed', {life: 5000, theme: \n'jGrowl-green'});
"location.reload(true);" with the line below to remain on the same page but display a small disappearing popup. It makes it even quicker when trying to update numerous records in a report.
Just replace the bold part with whatever text you need to see in the popup.
"$.jGrowl('Record #" & [Record ID#] & " has been marked Completed', {life: 5000, theme: \n'jGrowl-green'});