By changing the name you unlock the sheet. This only allows you to create a live copy; doesn’t allow you to pull the original Stripe sheet into other tabs. If you keep the preassigned name, you will not be able to create a live copy and feed the live copy into wherever you want. Depends on use case;
Suppose you want 3 people to be able to view the same order. Admin, Driver, and Customer. With the current Stripe settings not possible unless you unlock the sheet. Once unlocked you can submit the live copy into the respective tab feeders to get A, D and C to have their own unique view of the sheet with any additional information you may want to add to each display, by working on empty columns outside the fields occupied by your array formula.
The problem or limitation as some might call it with Stripe is that it doesn’t allow you to select multiples of the same item unless your prepared to select the item twice (something you need to forewarn your customer about). Then there is the other more crucial one, which follows as a logical consequence. Because you cannot select multiples of the same item, Stripe records the selected items as single rows. Now you can easily get round this with the new Grouping functionality we have by grouping orders by customer name or email, but only if you create a live copy of the Stripe sheet. So I hope you can see the benefits attached to unlocking the sheet.
As for the workaround I’m nearly there. It’s hard but nearly there.
I already have the solution; just unsure about it’s feasibility.