Save and Redirect Button
I know this has been posted before, but I just can't get it to work.
I want users to be able to enter comments into a multi-line text field, and then click a button that will both save their comments/edits and redirect them to a different table in the same app.
If I create a Formula - URL button, this works fine. Saves and redirects as expected.
If I create a Formula - Rich Text field, where the button is stylized, it redirects but does not save the edits. I've fiddled around with it quite a bit and tried to follow many of the suggestions in the forum, but can't get any of them to work. Either they don't save the edits or they simply don't do anything when you click the button.
I'm not sure why one works and the other does not. I have the "save child records" or whatever checkbox checked off in Advanced Table Settings. My reasoning for creating the rich text field is that I want the button to be large so users will be inclined to click on that rather than the native Save & Close button on top.
Here's my existing rich text:
I've seen on the forum all kinds of onclick commands and such to embed in the rich text button but none of them actually save the edits. So either I'm entering them wrong or there's something else going on. Any help is much appreciated.
I want users to be able to enter comments into a multi-line text field, and then click a button that will both save their comments/edits and redirect them to a different table in the same app.
If I create a Formula - URL button, this works fine. Saves and redirects as expected.
If I create a Formula - Rich Text field, where the button is stylized, it redirects but does not save the edits. I've fiddled around with it quite a bit and tried to follow many of the suggestions in the forum, but can't get any of them to work. Either they don't save the edits or they simply don't do anything when you click the button.
I'm not sure why one works and the other does not. I have the "save child records" or whatever checkbox checked off in Advanced Table Settings. My reasoning for creating the rich text field is that I want the button to be large so users will be inclined to click on that rather than the native Save & Close button on top.
Here's my existing rich text:
"<a style=\"background:#6bbd57; border-radius: 5px; padding:8px 16px; text-decoration:none; color:#ffffff; display:inline-block; font-size:14px; font-weight:bold; text-align:center; white-space:nowrap;\" href=\""&URLEncode(URLRoot()&"db/"&[_DBID_SUPERVISORS]&"?a=dr&dfid=10&key="&[Supervisor])&"\">Save and Return</a>"I've seen on the forum all kinds of onclick commands and such to embed in the rich text button but none of them actually save the edits. So either I'm entering them wrong or there's something else going on. Any help is much appreciated.
