Best way to copy and paste / duplicate complete rows.
Best way to copy and paste / duplicate complete rows.
I have a set of data which frequently has repeats with individual changes.
I'm tracking operations staff do on different products. Say I have different ingredients to add to different sandwiches. E.g. I have rows for
"Add cheese to hamburger"
"Add lettuce to hamburger"
"Add beef patty to hamburger"
(in this example, the ingredient is a column and the burger type is a column).
Say I now add a chicken burger. I want to be able to copy and paste the first two rows and then use something like the multiple-selection example to change the product from "hamburger" to "chicken burger".
What's the best approach to this?
Answers
Is this something you want the user to do? If so, this example would be a good fit. You could also use a join so the 'hamburger'/'cheeseburger' could be a drop down, like the 'site' field in that example.
If it's something you want to do from the API, then
multiSet()
is the way to go,Colin