App with two “windows”

[Sefote]

Good morning, I created a tool with Google Sheet, saved in Drive, which is made up of 53 columns from A1 to BA12. Each column has 12 rows including the header. In each cell there are formulas. The tool is not in the form of a table but of a range. Is it possible to create an app in the form of a table that is made up of two “windows”, one called Input and the other called Output where in the window called Input there will only be certain columns with the possibility of inserting numeric data and selecting drop-down menus, while in the second “Window” called Output you can see the results? If it is possible, how can I do it? Also, is it possible to insert cells that can be edited and cells that cannot be edited in a column? Thanks for the answers

[Steve]

---

The tool is not in the form of a table but of a range.

---

What does this mean?

---

a table that is made up of two “windows”

---

Sounds like a dashboard view.

---

the window called Input there will only be certain columns with the possibility of inserting numeric data and selecting drop-down menus

---

Sounds like a table view with QuickEdit enabled.

---

in the second “Window” called Output you can see the results?

---

A basic table view.

---

cells that can be edited and cells that cannot be edited in a column

---

Editable_If

[Sefote]

The tool created in Google Sheet is not in the form of a table but of a range. What does this mean? It means that the tool I created in Google Sheet is not formatted as a table. When I wrote Windows I was referring to the AppSheet Views. My intent is to create an app, connected to a single Google Sheet file where the 52 columns reside in a single sheet, in whose cells there are formulas. Each column has 12 rows including the header. I managed to create two Views, one called Input and the other called Output which are connected to each other thanks to the formulas contained in the Google Sheet. Now I have a problem: if in the Input view I want, for example, to insert the column called "Stake" but I do not want it to appear in the view called Output, I cannot achieve this. Is it possible that in the Input view the columns I decide appear and in the Output view other columns appear, even different ones? If I hide a column in Input it also disappears in Output and vice versa

[Steve]

A screenshot of your spreadsheet might help me understand what you're trying to do.  As it is, I'm very confused.

---

Is it possible that in the Input view the columns I decide appear and in the Output view other columns appear, even different ones?

---

Yes, you can choose the columns to display in the view configurations.

[Sefote]

Thanks for the help Steve, I'm out of the office now. I'll post a screenshot tomorrow

[Sefote]

Good morning Steve, I'm attaching a screenshot of part of the tool that I created in a single sheet of a single Google Sheets file that is in Google Drive. In reality it is made up of 52 columns, each of which is made up of 12 lines including the header. Each cell of the tool contains formulas, more or less complex, which I have found that AppSheet manages very well and which relate the various cells of the tool. The app I created contains two Views, one called Input and the other Multipla3 (which would be the Output). In the Input view I would like there to be only the columns with the arrow pointing upwards, while in the view called Multipla3 (i.e. the otupt) I would like there to be only the columns with the arrow pointing downwards. Columns that do not have any arrows must not be present either in the Input view or in the Multiple3 views. Basically I would like to be able to freely choose the columns that should be present or not in the two views. The problem I'm encountering is that, for example, if I select the columns to insert or not show in the Input view, they are automatically inserted or not shown in the Multiple3 view. The same thing if I write formulas, they appear in both views. I ask if it is possible to do something like this or I ask if the solution is to copy the exact same tool into another sheet of the single Google Sheets file, create a link between the cells of interest and proceed with the creation of two distinct tables in AppSheet . Thank you

[Steve · Accepted solution]

My suggestion:

Assuming the worksheet is attached to the app as a table named Sheet.

Create a slice of Sheet named Input. Choose only the columns you want to appear in Slice Columns.

Create a view on the Input slice.

Create a similar slice and view for Output.

[Sefote]

Tank you Steve,I will also try this solution, in addition to just creating a table