I have this situation. I had created two apps based on one sheet. Now, I want to duplicate both apps. I want both the apps to now work on another sheet. But,when I duplicate both apps, it either asks keep the same sheet or copy to another sheet. But, I dont want two sheets. I want a copy of the sheet for both the apps. How do I do this? How do I change the sheet to which an app is pointing?

See this thread [image] Front-end / admin apps duplication : what about the sheet(s)? Report a Bug Dear all, I was not sure where to post this question, which is not a bug in fact. I am currently working on a business template. This template is composed on 2 apps : 1 Front-end app (public) and 1 backend / admin app (password protected, till I upgrade both to pro apps). Both apps point on the same Google sheet, of course. This morning, I am afraid that I won’t be able to achieve what I expect. The reason is that I work on a template that is supposed to be duplicated for buyers. Once my temp…

A sort-of workaround is to create a template app that combines the tabs from both apps into one, then duplicate it twice and hide/show the tabs that you need for each app.

i have the exact same question!

Is there a way to tie two sheets so that any changes on one sheet will be reflected on the other sheet? Some function in Google sheets?

Yeah, that’s the problem with multiple apps using the same sheet. There isn’t a great way to duplicate both apps to a new shared sheet. You should be able to use ImportRange to move data between sheets, but it may introduce extra lag for what you are doing. I use importrange to copy data to another spreadsheet to run through formulas, then use another importrange to copy the results back to the original sheet. It’s not necessarily fast, but works for what I need.

Duplicating an app

Ask for Help

Jaime March 15, 2020, 8:57am 2

See this thread

Topic		Replies	Views
Duplicate Apps Ask for Help	3	447	June 25, 2022
Front-end / admin apps duplication : what about the sheet(s)? Report a Bug	13	1313	November 12, 2020
Change Linked Spreadsheet of App Feature Requests	20	2009	April 16, 2021
Same UI to multiple Google Sheets? Ask for Help	4	806	April 7, 2020
Copy app help? Ask for Help	1	238	March 5, 2020

Duplicating an app

Related topics