Help on building a view

I want to have a dashboard view that will basically have two screens.

One is a choice, lets say to choose between View A, View B, View C etc; and the second is the view that is chosen in the first view. Views A, B C are made from different tables.

Is there a way to achieve this?

I thought of using slices but a slice is essentially a โ€˜sliceโ€™ of the same table.

Solved Solved
0 4 155
  • UX
1 ACCEPTED SOLUTION

Please

  1. Create a single row table called say โ€œViewsSelectโ€ with two columns ID (key), ViewName (Enum type ,Text base ) Enum Options: Names of views that you wish to appear selectively in dashboard.
    The table vill be multirow with column for useremail for multiple users- one row to retain selection of each user.

  2. Create a detail view called say โ€œViewSelectโ€ on above table with column โ€œViewNameโ€ as Quickedit

  3. Include โ€œViewSelectโ€ view and ALL views that you wish to be selected through Enum in a dashboard view

  4. For each of those views except โ€œViewSelectโ€ view , the show_if will be
    ANY(ViewsSelect[ViewName])= โ€œView Nameโ€
    e.g. For a view called โ€œOrdersโ€ the Show_if will be ANY(ViewsSelect[ViewName])= โ€œOrdersโ€

The expression will change for multi user environment. You will need to bring in user email in teh expression.

View solution in original post

4 REPLIES 4

Like this?

Dashboard

Exactly this.

Please

  1. Create a single row table called say โ€œViewsSelectโ€ with two columns ID (key), ViewName (Enum type ,Text base ) Enum Options: Names of views that you wish to appear selectively in dashboard.
    The table vill be multirow with column for useremail for multiple users- one row to retain selection of each user.

  2. Create a detail view called say โ€œViewSelectโ€ on above table with column โ€œViewNameโ€ as Quickedit

  3. Include โ€œViewSelectโ€ view and ALL views that you wish to be selected through Enum in a dashboard view

  4. For each of those views except โ€œViewSelectโ€ view , the show_if will be
    ANY(ViewsSelect[ViewName])= โ€œView Nameโ€
    e.g. For a view called โ€œOrdersโ€ the Show_if will be ANY(ViewsSelect[ViewName])= โ€œOrdersโ€

The expression will change for multi user environment. You will need to bring in user email in teh expression.

Got it.

Top Labels in this Space