Does anyone know of a way to mimic moving of data between tables?
I have a customer table that acts as the base for a somewhat large Service management system.
There are many sheets attached to the App using many views and slices.
However, one of the views is a stand alone sheet with a simple UI which is
serving as a Customer LEAD portion of the App.
The issue is that once they become an actual customer I need to copy or move the data to the main list.
I don’t want to pollute the main list with unneeded columns, which is why I have not already put the LEADS columns into the main sheet. I don’t want to de-normaliize my tables.
I’ve looked at the copy and edit action, but from what I see it only works on the current table.
I need it to copy/move the data from one sheet to another.