Menu Setup with Seperate Tables

[David2]

Hello Everybody,

I’ve been using Appsheet for a while now and have achieved most things I need to do with it, on one of my business accounts however, I am trying to build a process I am not entierly sure how to go about the best way.

I am looking to add a menu option for All Projects, and once clicked have a table with Leads, Current projects and Completed Projects. Each will be a seperate table (doing this to keep them seperate if ever I need this in the future). In A Sense, sort of like nesting tables.

Within each of the three tables I want the usual capabilities to add, remove, which is easy enough, but I’d like the option to edit a row and have a drop down selector (lead, current project, completed) that allows me to move the row, or data, from one table to another.

So summaries, I need a little help with the menu setup All Projects > Sub Menus ( Leads, Current projects and Completed Projects) > Tables and also need a little help with how to move the data from one table to another.

This might be rather simple, and I have read a few articles and attempted a few tests myself but haven’t yet been able to achieve this the way I’ve hoped.

Any help would be greatly appreciated.

[Kirk_Masden · Accepted solution]

Hi @David2! Welcome to the community!

I regard to moving data, this should help:

New Action: Add a Row to a table Announcements

We just added an initial version of a new action ‘Data: add a new row to another table using values from this row’ Please try it and give us feedback. Documentation, etc coming later this week. The brief version is here: let’s consider an example with Orders and OrderDetails as two related tables in an app. Add an action ‘CreateChildRow’ to the Orders table that will add a row to the OrderDetails table. You can specify expressions to assign to each column of this row. For example: Order = [O…

To move data I think you’ll need to use a group action that first copies a row and then deletes to old one.

[David2]

Hello @Kirk_Masden, I have managed to achieve this, thank you for your answer.