Dinamically Change Form on what user select as Action

[SignXi2]

Hi,

Let me take anr example to explain more clearly what I'm trying to achieve:

I have a table named  Logs that log every activities in a company. That table has others tables referencing to some  of its column. Basically when something happen in the company , an employee can log it, for example: "somebedy get hired in the company " or setting up a meeting... what I want is just one view with one dropdown menu and depending on what an employee choose in that menu, only informations related to that activity will be shown in a form to fill (a sort of dynamic form based on what is choosed).

if the employee select for example "Set ut a meeting" in the dropdown menu, a form in the same view will appear with for example "the date, the hour, the meeting location, the name of the person to meet". if the employee select another activity for example, send a mail the form will change to: "the message, the receiver email and the object"

Hope you understand now. I try my best to be clear as I can...

Thanks

[Steve]

Conditionally show or hide a column value (Show_If) - AppSheet Help

[MultiTech]

You COULD do things this way... but I would advise you to consider the benefits of moving things to different tables - mainly the ability to setup parent-child references and create the beginning of a relational database for your system.

-----------------------------------------------------------------------------------------

That being said:  if you wish to continue utilizing spreadsheet-software based methodologies (allowing you to stay within your wheelhouse while you experiment with AppSheet):

1. Create your table
   1. Create a dropdown column, which is the place where a person will select what they want to do - this will be an ENUM type
   2. Add in your various "sections" into your app
   3. At the front of each of these sections, add an extra column - Page_1, Page_2, Page_3, etc. - or even name these pages something that make sense to you
      
      
2. Inside the column settings for your enum column
   1. Specify the various "buttons" you wish the user to be able to push
      
      
3. Inside the "Show if" formulas for each of the Page columns in your table.... use something like the following formula, where the value used is specific to the page you're wanting to conditionally show
   
   [Option_Dropdown] = "Value1"

--------------------------------------------------------------------------------------------------------------

With this setup, you'll only have to configure the show formula for the pages; by nature, all the items on a page are either shown or not based on if the page is shown.

I would really urge you to think about how a relational database might help with things.

References... are the heart of every system I build