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??
Hi @Tamas_Mahner !
From what I see, with your
[Social Media] table (for example) your formatting is applied on the
Platform table … Not the
[Social Media] one …
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]
… and use that new field as a
Display Column instead of the lookup field
It will give you the same result you already have in your table
[Members, Partners, Guests] but with the formatting applied
And you could do this for all the other “problematic” lookup field
Yes! How the hell I did not thought of this such simple solution?
Thank you so much!
No problem @Tamas_Mahner ! Glad to know it helped !
I know the feeling !
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?
Maybe this in your table
[Members, Partners, Guests] could do the job in your
[Contacts name] field
thisRow.[Contacts by title].[Full name].Unique().BulletedList()
Yep you can use
As with most functions in Coda, you can either wrap your existing formula that’s producing duplicates in the brackets (Excel style):
ooooh! Here I used the Unique in the wrong place… after the Bulletedlist () not before.
Maybe I should leave it for today
It happens !
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
Thanks a lot! The table got waaaay better now!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.