I have an action that copies a bunch of rows into another table, I would like to know if its possible for this information to be automatically deleted from the original table?
Yes.
2 Likes
Would you be so kind as to tell me how? I realize that I should have worded my post better.
1 Like
It should just be a matter of performing a delete action on the row that initiated the copies. It would be helpful to see the configuration that starts that process.
I wanted to try a few things before responding, but I have not had any luck getting it to work the way I want.
I know that there is a delete action, and I could set that up in a similar way to the action that copies stuff into the target table, but I was hoping there was a way of automating it. Basically I want the action I have created to act more like a cut and paste than a copy paste, since I don’t want the data to be duplicated across 2 tables.
I have tried to use a bot to automatically delete the data in current table but I have not gotten it right.
1 Like
There is no equivalent of “cut and paste”; the best you can hope for is “copy and paste and delete”.
1 Like
Precisely, I am trying a few things to achieve this but do you have any insight to share on how I can accomplish “copy + paste then delete”?
1 Like
It was very simple in the end. All I had to do was create a new group action that executes the copy+paste action then delete action. copy+paste action is hidden and the new action replaces it in the app view.
1 Like
- create Copy paste action
2.create ‘Delete action’ to this “Delete this row.”…
3.create bot for ‘delete action’
1 Like
the bot didnt work for me because I am working with 2 different tables. It was easier to create a group action that executes copy paste and then delete in sequence.
1 Like
Bingo! Well done!