Rich Text Button - Not saving record edits
Hello, I'm trying to set up a rich text button that checks a box and records the user who checked it. However, from the user standpoint, I'd like them to be able to work on other things in the re...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTo try to get this debugged, what happens if you make a URL formula field that just does this
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord" &
"&rid=" & [Record ID#]
& "&apptoken=##########################"
& "&_fid_2058=" & URLEncode(UserToName(User()))
& "&_fid_2057=true"
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord" &
"&rid=" & [Record ID#]
& "&apptoken=##########################"
& "&_fid_2058=" & URLEncode(UserToName(User()))
& "&_fid_2057=true"
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I had a similar thing happen to me - I was expecting to see the 'Saving Record' flash on screen (due to the 'auto save child' checkbox), and it wasn't doing that. Turns out, when I was testing it I wasn't changing any information on the record, so in that case it doesn't save.
Maybe it's not that, but I believe the auto save should happen BEFORE the the execution of the button, so it seems impossible for it not to save? I'm curious to see what you discover...
------------------------------
Mike Tamoush
------------------------------- Formula - Rich Text buttons do not activate the native 'autosave' functionality, but can be coded to initiate the 'save' script. Unfortunately, this is an 'unsupported' security exploit that is being closed in the coming months.
Formula - Url buttons do activate the native 'autosave' functionality, but they ignore other core functions like Dynamic Form Rules in the process.
At the moment, if you do not care about your data entry obeying field/form/table rules, use Formula - URL buttons. If you do care, you can leverage the security exploit by manually coding the save script functions into your rich text buttons - but again, that exploit is being closed in the coming months.
I do have super-high hopes that there will be a new feature/fieldtype added that will function as a customizable save button before they close the exploit.
------------------------------
Brad Lemke
------------------------------- Oh, thank you Brad. That's a helpful rule of thumb to keep in mind for future buttons.
------------------------------
Liz Chartrand
------------------------------
Hi Mark,
The Formula-URL worked just as I needed it saved the work on the record, fired the tasks on the field, and refreshed/reopened the record in edit view.
Thank you
------------------------------
Liz Chartrand
------------------------------
