Objects need to have clients list by not duplicating them

[nooleenu]

Hello,

I need help with one of primary navigation menu, where we want to have clients list. By selecting client we would get list of project with that particular client. At the moment I have same client duplicating with other projects. For example,

Client                            Project

Client name A            Alfa
Client name B           Beta
Client name A           Delta

We want to achieve this output;

Client                            

Client name A           
Client name B           
Client name C         

By pressing on Client A, for example, we should get a list of projects;

Client A

Project 1
Project 2

Any suggestions or perhaps someone can share a good template example? Would appreciate in advance. Thank you.

[AleksiAlkio]

One workaround is to create a slice and filter all duplicate clients away other than the first one. Then you can add an action with the LINKTOFILTEREDVIEW("Projects",[Client]=[_THISROW].[Client])

[nooleenu]

Ok, I have created a slice, but in Row filter condition there true/false expression. So I'm trying to think of the condition statement which would make sense. If I understand correctly I'm allowed to use only Yes/No type. 

Interestingly, to create a filter condition in Google AppSheet that shows unique client names (i.e., if a client name has duplicates, only one instance is shown), I would need to use a combination of expressions that help in deduplicating the client names. However, it's important to note that AppSheet does not natively support a direct "DISTINCT" or "UNIQUE" function in the way SQL does for filtering directly on the view level.

Instead,  typically work around this by creating a slice or using virtual columns to handle the deduplication logic. Since showing only one instance of each client name essentially requires a unique list, one approach is to create a Virtual Column that aggregates client names uniquely and then reference this column for views. However, this method might not be straightforward because AppSheet's primary functions focus on row-based logic rather than set-based operations found in traditional databases.

[AleksiAlkio]

There are multiple ways how to filter the data.. MINROW("Projects","_ROWNUMBER",[Client]=[_THISROW].[Client])=[ID]

If you want to be sure there are no duplicates with a different name, add a Clients table and then use it for your Client column.

[nooleenu]

Okay it seems worked, but another problem  now when I click on Client, I get only one Project in details. Even though we have several projects within one Client.

[AleksiAlkio]

And what formula do you use with the action?

[nooleenu]

Do you mean Slice Action? 

I have created Clients slice which using New Installation source table which has all required data. In row filter condition I used your suggested formula just changed naming which accurate to our data. 

MINROW("Nauja Instaliacija","_RowNumber",[Kliento įmonės pavadinimas]=[_THISROW].[Kliento įmonės pavadinimas])=[Row ID]

"Nauja instaliacija" refers to  New installation database table which contains all records
Kliento įmonės pavadinimas refers to Client name column

To represent data output which we want I use only _RowNumber, Row ID(key) and Kliento įmonės pavadinimas which outputs only Client Name.

Now when I select Client Name it goes to Details section which outputs only one Project, even though, in the main database we have more projects.

[AleksiAlkio]

You need to have an action that you can trigger when the row is selected. That action needs to have that LINKTOFILTEREDVIEW() I explained in the beginning.