Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
The example I posted was for a formula Rich text field as it makes a hyperlink. The alternative would be to just have a red URL formula button as a formula URL field.
I that case it would be a simpler formula
var text URL= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_50=" // blank out copy of indicator
& "&_fid_15=" & ToText(Today()) // set date to today
& "&_fid_31=0" // uncheck Completed
& "&_fid_40=0"; // uncheck Reviewed
If([Copy Of Indicator used in Copy Master Detail]<>"",
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
)
If it wuz me, I would just do the two click method, get 'er done and move on to the next thing on my long todo list.
I that case it would be a simpler formula
var text URL= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_50=" // blank out copy of indicator
& "&_fid_15=" & ToText(Today()) // set date to today
& "&_fid_31=0" // uncheck Completed
& "&_fid_40=0"; // uncheck Reviewed
If([Copy Of Indicator used in Copy Master Detail]<>"",
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
)
If it wuz me, I would just do the two click method, get 'er done and move on to the next thing on my long todo list.