Appsheet Set a view types default configuration

Hello,

I am building an App for a personal collection. My spreadsheet has hundreds of slices and each slice needs possibly multiple views. I was wondering if there was a way to set the Editor to pick default configuration values per view type when creating a new one. 

For example, I mainly use the Deck view and I would like to be able to set the Sort by, Group by, Main Image, Primary Header, Secondary Header, Summary Column, and other settings to the same information. The only thing that changes is the slice reference to a different collection set it belongs to. Doing this manually a few hundred times is tedious, so I was wondering if there was a better way to complete this task or a way to configure the editor to set this up. 

Solved Solved
1 5 1,616
1 ACCEPTED SOLUTION

There is a view function called LINKTOFILTEREDVIEW().   Instead of having hundreds of Slices, and then hundreds of views, to display filtered data, you can instead move the Slice filter criteria into an expression and then provide a user selectable way to view the data.

For example, you can provide Filter Selection Form with your various columns to filter by and provide choices for each that user selects:

  • Column 1 Choice - A, B or C
  • Column 2 Choice - D, E, F, G
  • Column 3 Choice - H, I, J, K, L

On Save of the Filter Selection Form, attach an action that will navigate to the view applying the filter using The LINKTOFILTEREDVIEW() function something like this:

LINKTOFILTEREDVIEW("Filter View Name", 
    AND([Column 1] = [Column 1 Choice],
[Column 2] = [Column 2 Choice]
[Column 3] = [Column 3 Choice]
)
)

This would be a much easier approach to implement (though you have already done much of the hard work creating the Slices),  it will much easier to modify and maintain, and I think will be much more performant than having all those Slices and Views inside of the app.

You can find out more on this function below

LINKTOFILTEREDVIEW()

 

 

View solution in original post

5 REPLIES 5
Top Labels in this Space