Forum Discussion
There are three issues. BUt before I exp0lain I'm assuming that you want to land the user on the record in edit mode as you called the button Save & Continue....
The first is that you are confusing
?a=er
with
?a=API_EditRecord
The former will put a record into manual edit mode for the user to do data entry (and it does not support populating fields) and the latter, will actually instantly edit the record.
The second issue will be that the %%rid%% does not like to be URLEncoded, so we need to contrive to keep it out of the URLEncode's parentheses.
The last is that when you run an API, you need to land the user somewhere or else the success or failure of the API call will be spewed onto the screen. So I'm making the assumption that you want to land the user on the record in Edit mode.
Note also for this technique to work, the user or a form rule needs to edit the record so it's dirty, thus forcing the save and you need to have the table's Advanced settings set to
"Auto save when directed away from the page". All new apps default the setting this way but just in case you're working with a very old app.
Try this
& "?a=API_EditRecord&_fid_18=1&rid=" & $rid;
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------