Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
My approach with a native solution and no code pages would be two clicks. i just did that last night for a client
var text URLONE= 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
var text URL =
"javascript:" &
"$.get('" &
$URLONE &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);";
var text Words = "<b><font size=6><font color=red>Click here to reset date and checkboxes";
If([Copy Of Indicator used in Copy Master Detail]<>"",
"<a href=" & $URL & ">" & $Words & "</a>").
when you use the copy master detail, it write Copy Of ... into field. So I use that to detect that the recored has just been duplicated and then ask the user to click to clear the fields.
var text URLONE= 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
var text URL =
"javascript:" &
"$.get('" &
$URLONE &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);";
var text Words = "<b><font size=6><font color=red>Click here to reset date and checkboxes";
If([Copy Of Indicator used in Copy Master Detail]<>"",
"<a href=" & $URL & ">" & $Words & "</a>").
when you use the copy master detail, it write Copy Of ... into field. So I use that to detect that the recored has just been duplicated and then ask the user to click to clear the fields.