Check a box from a Notification email
We want to check a checkbox using a link disguised as a button in a notification email. Has anyone tried such an endeavor and had success? My brain says it's possible and easy so if you know somet...
Forum Discussion
That is easy to do, I think, but the issue will be permissions and even if the user does have permissions they may not be logged into Quick Base.
You could have a userid with restricted permissions, but enough to check the checkbox and the button could authenticate with a userid and password and then redirect to check the checkbox and then it would need to do something like display the record.
You could have a userid with restricted permissions, but enough to check the checkbox and the button could authenticate with a userid and password and then redirect to check the checkbox and then it would need to do something like display the record.
You can just use a formula URL field then.
The field will be called [Click to Approve]
But then what do you want to happen in terms of the user interface when the button is clicked. Should it display the record?
var text URLONE = URLRoot() & "db/" & dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_7=1";
var text URLTWO = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#]
$URLONE
& "&rdr=" & URLEncode($URLTWO)
The field will be called [Click to Approve]
But then what do you want to happen in terms of the user interface when the button is clicked. Should it display the record?
var text URLONE = URLRoot() & "db/" & dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_7=1";
var text URLTWO = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#]
$URLONE
& "&rdr=" & URLEncode($URLTWO)