Text button with count which opens a new sheet with filtered results

[martin_hamilton]

@I have a Text Object which is performing a COUNT of records which when selected opens another sheet. I want to filter the next sheet of results based on the COUNT records. I thought about using a sheet action such as Select In Field but have no idea how to apply the search filter using the records i have counted.

My Text Object looks like this:

=Count({<Sub_Contract_End_Date={"$(='>=' & Date(Today(), 'DD/MM/YYYY') & '<=' & Date(Today()+30, 'DD/MM/YYYY'))"}>} Distinct Sub_Number)

Thanks

Martin

[sunny_talwar]

What do you plan to filter on?

[martin_hamilton]

Hi Sunny

I plan to filter on the field Sub_Number (which would be the Sub_Number' contained in the COUNT value

Thanks

[sunny_talwar]

May be use select in field with the following search string for selection

Dimension:

Sub_Number

Search String

='(' & Concat({<Sub_Contract_End_Date={"$(='>=' & Date(Today(), 'DD/MM/YYYY') & '<=' & Date(Today()+30, 'DD/MM/YYYY'))"}>} Distinct Chr(34) & Sub_Number & Chr(34), ', ') & ')'

[martin_hamilton]

Hi Sunny

Is this within my existing Text Box in addition to Activate New Sheet or within the sheet I am going to as a sheet event trigger?

If I add within my Text Object it doesnt seem to work.

Thanks

Martin

[sunny_talwar]

Did you add the field name with = or without the = sign? You need to have it without. Also, make sure that the casing and spelling of Sub_Number is correct. Not sure what else could be the problem? May be share a sample if it still doesn't work

[martin_hamilton]

Hi Sunny - i have a sample but dont know how to upload onto the community?

[sunny_talwar]

Here, check this link out

Uploading a Sample

[martin_hamilton]

Thanks Sunny

Have uploaded an attachment to my original post.

Thanks for your patience!

[sunny_talwar]

Check now and see if this work for you.

Best,

Sunny