I have a Schedule table and buttons for start and complete to change the status of the items. The buttons are used in different contexts and so having it go to a specific report is not friendly for work flow. Is there a way to have it just edit the record and stay put without going to record or to a certain report?
-
338 Points
Posted 1 year ago
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
-
75,144 Points
-
338 Points
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
-
75,144 Points
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.
-
162 Points
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'});"
-
338 Points
Oh that's cool! thanks
-
338 Points
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
-
75,144 Points
