Is there a way to filter duplicates from an inline list?

That did work. Thanks Jeff. My only glitch now is when I am looking at their details card and see the office list below, that persons picture is there too. Not that it’s a big deal, which I am beginning to not mind, but how cold I omit that person from appearing in the office list when I am looking at their details card: to maintain the “Other People in this office” list without seeing them too?

1 Like

Darren,
That sounds amazing. I am glad my problem brought Jeff in with that solution for you too!

1 Like

You should be able to filter the list using Screen Values where the name is not the name of the current contact being viewed.

6 Likes

Thank you Jeff. That makes so much sense. I truly enjoy learning these bits that allow me to re-evaluate my problem solving skills!

2 Likes

Hi Jeff,
This solution looks great, but I couldn’t get it to work :frowning:
I’d like to check if a client name is repeated, so we can put a warning text for the users to notice there is more than one client with the same exact name. I think that I did what you mentioned:

  1. Relation column - client name to itself
    image

  2. SV column - last ROW ID
    image

  3. ITE column - current ROWID to SV column
    image

What Have I missed?

And what was the result? What you are showing looks OK if that is the intended result you want, although it might not apply to your particular situation. What is the problem you are running into? What is not working? Your current setup should mark each duplicate row as ‘true’, except for the last row within a same name, or any row that is not a duplicate. Last row names and non duplicate names will be false with the way you have set up your columns.

But, wouldn’t it be more beneficial for your use case if you kept the same relation, but got rid of the single value and IF columns and replaced them with a Rollup Count column instead? Then any name with a count greater than 1 would be a duplicated name.

1 Like

Thanks, that works perfectly!

2 Likes