Linktofilteredview question

[tcanelli]

I’m using the linktofilteredview as shown in one of the sample apps. My question is do I really need a separate table to collect the info entered on the filter form? or is there a way to do still have a form filter the data without needing to save it.

[WillowMobileSys]

I am not following.

A filtered view is a way of narrowing down rows of data based on criteria and send them to an existing view to show that list of rows. For example, I might have a list of Orders that I show in a table view. But then I want to see rows just for a particular Customer. I can use the same table view but call it with a LINKTOFILTEREDVIEW() and display only the rows for that customer. No need for additional slice and view combination.

A Form operates on one logical row at a time (or a row and its children). I am not understanding what you are intending to do on Form using LINKTOFILTEREDVIEW().

[Fernando_Lopez1]

Maybe you can check this sample and adapt it to your needs:

https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266...

[tcanelli]

I used this sample app - https://www.appsheet.com/samples/This-app-shows-how-to-filter-your-data-using-a-form?appGuidString=c... - which has the user using a form - all entries are saved to a sheet.

I’m just trying to figure out if you can filter without a form and saving to a sheet.

[tcanelli]

Here is the form used to filter - and it works like I want - I just don’t need the saved data that comes with it. Can you accomplish the same thing without saving is the question.

[WillowMobileSys]

Ah, I get it. You need user input in order to know how to filter the data but you do not need to save the choices.

I am not aware of any way you can do that. But this is probably a good Feature Request!

---

There is one observation I can make. If you are using a Form (or even Quick Edits in a Detail view), you only ever need a single row. When the Form is loaded, always load that one row and perform a Reset on each of the columns to their Initial Values in the Form.

Because you are only using the choices to feed into a filtered view and this all happens on the client side, it doesn’t matter what gets saved. Other users will not be impacted.

[tcanelli]

That’s a great idea! Is the reset feature something I would do in Appsheet or where the underlying sheet/table is (for now Smartsheet)?

[WillowMobileSys]

It is a property is named “Reset on edit?” and made available in each AppSheet column except key columns. You’ll find this property under the Update Behavior section.

[tcanelli]

So I made all the columns (except key) reset on edit but the data is still being saved to the Smartsheet.

[WillowMobileSys]

The intent was to always update the SAME row. You would need to open the Form to Edit that row, rather than open a NEW Form each time. The Reset options will always load the Initial Values so to a user it looks like a NEW entry.

This may mean that you have to change in the app how a user access’s this Filter selection Form. Most likely a custom button.