Bulk selection (select all) of rows in a filtered view

[ThisIsIdrees]

Hi everyone,

@Fabian_Weller 's post about bulk select is really interesting and I would like to know how to create a primary button to select records (rows) in a filtered view (a view that i switched to using an action with LINKTOFILTEREDVIEW() function)

If any one can help I would be thankful 

[WillowMobileSys]

Which previous post about bulk select are you referring to?

I found it:  https://www.googlecloudcommunity.com/gc/Tips-Tricks/Bulk-Select-Multiselect-Select-All/m-p/361654

[ThisIsIdrees]

You right, I mean that one exactly 

[WillowMobileSys]

All you need to do is create a "Primary" positioned action, set it to "navigate to a view" type and then copy the expression into the Target:

LINKTOVIEW('Text')&'&selected='&ENCODEURL('["'&SUBSTITUTE(FILTER('Text',true),' , ','","')&'"]')

Then replace 'Text'  with the view name you used in the filtered view.  Replace the true in the FILTER() expression with the exact same criteria you used in the filtered view expression - literally copy/paste.

Report back here and let us know how it goes for you.

I hope this helps!

[ThisIsIdrees]

Thanks for responding. Unfortunately, when i replace the condition (true) with my actual condition (AND([Client]=[_THISROW].[Client],[Rétention]=[_THISROW].[Rétention]) simply the primary action button is disappeared!!!

[WillowMobileSys · Accepted solution]

I see.  Your criteria uses row column data to filter with, the button cannot be a Primary button when it is row dependent - i.e. for a button not associated with any row, what row does it use to filter by??

You could make this an Inline button that shows on every row - not the best solution.

If you could setup a Slice to filter the rows, then you could use a LINKTOVIEW() function with the Slice as the source instead of the LINKTOFILTEREDVIEW().  Then you could add the Primary button as originally written to perform the Select All.  

Alternatively, You can include a SECOND button where you originally launch the filtered view - your original button as "View XYZ Data" and the second button as "Select XYZ Data".  Not ideal since after viewing the rows, the user would need to navigate backward to then tap the "Select" button.

Another solution would be to "save" the filter criteria temporarily in some table.  I quite frequently create a "Variables" table to temporarily store values that I want to retrieve later.  This idea would be to create a Grouped action to replace the LINKTOFILTEREDVIEW().  The first action would add your Client and Retention values to the "Variables" table.  A second action is your existing LINKTOFILTEREDVIEW().  Then you can adjust the "Select All"  action button to retrieve the values from the "Variables" table to perform the filtering.

Several options, I know - choose the one you think give the best user experience and go with it!!

I hope this helps!