I am trying to write a URL formula that will be put into a Email notification as a button. When someone clicks this button i want it to change a status and date stamp a field. I have figured out the date stamp and status change but i can not figure out the redirect.
I want the formula to make the changes to the record and then redirect the user to the changed record in a view mode.
Here is what i have so far...
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=caaaaaaaaaaaaaaaaaaaa &rid=" & URLEncode ([Record ID#])
& "&_fid_86=" & URLEncode(Now())
& "&rdr=" & URLEncode(URLRoot() & URLEncode ([Record ID#]))
when i run this formula i get a 404 not found error.
Any help would be greatly appreciated!