I am trying to create a button that will move a project from one table to another. I have set up the button currently so that it will add a row to a different table and fill in certain values but I am not sure how to then remove the row from its current table. Essentially I need a formula that will add a the row to a different table and then delete the row.
Here is the link to my doc: Coda | A new doc for teams.
One the Work Block Detail page I’d like to be able to click “Send to Backlog” and have that project show on the “Project Backlog” Page. I have a feeling i could have accomplished this better by just creating different views of the same table and filtering, but as it stands I have two tables.