How to add to my url formula button that changes a checkbox to ""true"" but also saves the record?
I have created a formula url button for the user to be able to "Submit this Week's Priorities:"
This works perfectly in the form whether or not it is in Edit mode where the button triggers the change to a checkbox field and then a notification is triggered. It also redirects to that current record which I want. However, if it is in Edit mode and there is a modification to one of the fields, you have to use the native "Save" button first before the action will occur (still works fine). I'm just wondering what I could add to this formula to trigger the record to also save any other edits without having to use the native "Save" button.
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_32=1"
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])This works perfectly in the form whether or not it is in Edit mode where the button triggers the change to a checkbox field and then a notification is triggered. It also redirects to that current record which I want. However, if it is in Edit mode and there is a modification to one of the fields, you have to use the native "Save" button first before the action will occur (still works fine). I'm just wondering what I could add to this formula to trigger the record to also save any other edits without having to use the native "Save" button.
