Sheet CONFIGURATION

aliharb · 02-20-2023 04:12 PM

Hello All

I made an AppSheet to simplify my work, I configured data, views, conditional formats, conditions, and actions to fit my requirements and it took a lot of work, effort, and time. That's not the problem. I am delighted by what I got and the result was amazing.

The problem is that my work consists of multiple worksheets with the same design and purpose and needs the same configuration. Still, I didn't find a way to copy the structure from the first sheet to the rest, so every time I got a new search I have to modify a sheet from zero (data structure, format rules, actions, views, conditions) in the same app. Is there a way to copy them, or make a template for future sheets? So that I just generate a sheet with the same settings, deploy it, and fill it through the application.

Note: I tried to clear the data from the sheet linked to the application and copy it, then upload it to the app sheet, but it didn't work.

Thanks in advance.

Regards

dbaum

Copy the app and then in the copy change the data source of each table to reference the new sheet.

aliharb

so I have to make an app for every sheet? Is there any other way? to make them all in the same app?

dbaum

@aliharb wrote:

so I have to make an app for every sheet?

Based on your OP, it sounded like that was your goal.

If instead your goal is to use within a single app all the data currently in identically structured worksheets, the recommendation would be to consolidate the data into a single worksheet. For example, if each worksheet contains data from a different month, then put all the rows instead in a single worksheet that includes a "Month" column to designate the month that applies to each row. Then, within the app you can use slices and other functionality to limit the data in a specific view or available to a specific user according to each row's month or whatever other category.