Lookup does not inherit styling

1

I have created a list of members with their different type of datas.

I have a main table and I have subtables for contacts, social media etc.
For the sub-tables I created labels/types of contacts, social media, etc. and I even give them colors.

When I bring the contacts and social media to the main table, the coloring disappears even if I check the Apply styling option at the Lookup options. What do I miss??

2

Hi @Tamas_Mahner :blush: !

From what I see, with your [Social Media] table (for example) your formatting is applied on the Platform table … Not the [Social Media] one :blush: …

So, still for the [Social Media] table (still as an example), you could add a simple text field to that table, gather the text value [Social media platform] from thisRow.Platform (what’s currently selected in the lookup Platform) with a formula such as :

thisRow.Platform.[Social media platform]

Platform 2
Platform 21332Ă—416 32.6 KB

… and use that new field as a Display Column instead of the lookup field Platform

Platform
Platform646Ă—874 30 KB

It will give you the same result you already have in your table [Members, Partners, Guests] but with the formatting applied :blush:

Platform 3
Platform 3438Ă—1110 37.9 KB

And you could do this for all the other “problematic” lookup field :blush:

2 Likes
3

Yes! How the hell I did not thought of this such simple solution?

Thank you so much!

2 Likes
4

No problem @Tamas_Mahner :wink: ! Glad to know it helped :grin: !

I know the feeling :sweat_smile: !

1 Like
5

If you don’t mind I would ask one more question! Probably same simple!

In the main table there are the contacts name. And some contacts have more title and when they do, the same name shows several times. Is there any formula I could apply to show only the unique items and avoid duplication of names?

1 Like
6

Maybe this in your table [Members, Partners, Guests] could do the job in your [Contacts name] field :blush:

thisRow.[Contacts by title].[Full name].Unique().BulletedList()
1 Like
7

Yep you can use Unique()

As with most functions in Coda, you can either wrap your existing formula that’s producing duplicates in the brackets (Excel style):Unique(…your formula…)

Or tack it on the end with a dot (JavaScript style): YourFormula.Unique()

2 Likes
8

ooooh! Here I used the Unique in the wrong place… :slight_smile: after the Bulletedlist () not before.

Maybe I should leave it for today :smiley:

1 Like
9

It happens :wink: !

And yes, this one

… says something like : take thisRow.[Contacts by title] and get the .[Full name] then give me the .Unique() values and .BulletedList() the whole thing :blush:

2 Likes
10

Thanks a lot! The table got waaaay better now!

3 Likes
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.