I have a button that saves a record then executes an API that edits the record and creates a new record. When using the button not logged in as 'Everyone on the Internet' I get an error that 2 users are editing the same record. The theory is that since I made the button that it is making me the editor using the API and 'Everyone on the Internet' the editor of the record.
Logically I would think that 'Everyone on the Internet' saves the record then the API edit action takes place thus not editing at the same time. But my thought is to workaround it by putting the 'Everyone on the Internet' user token eliminate me from the equation. I don't think there is a token or a way for there to be one for security reasons but it never hurts to ask.
I could avoid the whole mess if automations could copy multi-select text from one table to the next but unfortunately on setup the automation wants you to make the selections. I also tried Actions and Webhooks but with both Multi-select text copying is sporadic. The API in a button would work great except that I am trying to do to much because end users see clicking save or an extra checkbox as 'cumbersome' and 'tedious'.
Good news is a table to table copy works great and only has some minor annoying issues but ideally Quick Base will fix the issue with automations.