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?
That sounds amazing. I am glad my problem brought Jeff in with that solution for you too!
You should be able to filter the list using Screen Values where the name is not the name of the current contact being viewed.
Thank you Jeff. That makes so much sense. I truly enjoy learning these bits that allow me to re-evaluate my problem solving skills!
This solution looks great, but I couldn’t get it to work
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:
Relation column - client name to itself
SV column - last ROW ID
ITE column - current ROWID to SV column
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.
Thanks, that works perfectly!