Creating sub menu

I have been trying to create a simple homescreen with sub menus and actions but it gets more and more confusing.
Should be going easier but hell no. I have read all the threads i found and watched videos but still not working.
for the last hour I checked the sample app in here: 

https://www.appsheet.com/templates/This-app-demonstrates-how-to-use-actions-to-navigate-to-different...

This makes no sense for me. I have one big database (1 sheet only) and I have created slices for several views.
I want to make a gallery type homescreen to go to those views.

starting from main view: Homescreen, there are 2 icons "Inventory" and "Completed products". Clicking on "inventory" should open a table type view with a list of other views that I have made with the slices.
Clicking on "completed products" should open a view i have already created where all products are listed.

Not sure if its clear enough?

Solved Solved
0 4 759
2 ACCEPTED SOLUTIONS

Aurelien
Google Developer Expert
Google Developer Expert

Creating such custom menu may require a little trick ๐Ÿ™‚

Here is one I made in my portfolio:

PF_CustomMenu

View solution in original post

The slices are like databases.

The important notion is the view, which based on a slice or a table.

The table on which is based the menu view, should have a Link column.

Aurelien_0-1678281116837.png

This is a virtual column.

Aurelien_3-1678281253393.png

The slice is a "copy" of the table, with "Read Only" permission.

Here is the action that will make the user to jump to another view in the app.

Aurelien_2-1678281204771.png

Each record in my table contains the target internal view name. 

Aurelien_1-1678281170060.png

The user see this view: any click on the record will triger the action, hence the action will make the user to jump to internal view names.

This require to create views, and reuse these view names in your CustomMenu table.

 

View solution in original post

4 REPLIES 4

Aurelien
Google Developer Expert
Google Developer Expert

Creating such custom menu may require a little trick ๐Ÿ™‚

Here is one I made in my portfolio:

PF_CustomMenu

After some hours I can't find or understand "the trick".

I basically copied the actions and everything. I dont understand the connection between the action and the slices that should pop up after clicking on it on the main screen. 

The slices are like databases.

The important notion is the view, which based on a slice or a table.

The table on which is based the menu view, should have a Link column.

Aurelien_0-1678281116837.png

This is a virtual column.

Aurelien_3-1678281253393.png

The slice is a "copy" of the table, with "Read Only" permission.

Here is the action that will make the user to jump to another view in the app.

Aurelien_2-1678281204771.png

Each record in my table contains the target internal view name. 

Aurelien_1-1678281170060.png

The user see this view: any click on the record will triger the action, hence the action will make the user to jump to internal view names.

This require to create views, and reuse these view names in your CustomMenu table.

 

Yeah, what could I do without you?
It works now, I actually understood all of this, the only problem was the virtual column. I had a physical column in my table.

I am pretty hopeless at this.

Thank you a lot, again!

Top Labels in this Space