Skip to main content

Linked field color

  • October 25, 2019
  • 5 replies
  • 29 views

Jean-Philippe_E
Forum|alt.badge.img+12

Hi,

  • I have 3 table: COMPANY, CONTACT, PLACES
  • The COMPANY has a field COLOR
  • CONTACT and PLACES link a COMPANY

How can I use the COMPANY COLOR (a single label field) in PLACES and CONTACT ? The lookup fields only get the value.

In fact a link field is like a “powerfull” select it would be great to handle color feature every where

5 replies

Justin_Barrett
Forum|alt.badge.img+21

As you’ve seen, you can’t directly edit a field via lookup. However, if you add a link to a company in either [Places] or [Contact], you can click on the link to open that company record and edit all fields.


Jean-Philippe_E
Forum|alt.badge.img+12
  • Author
  • Known Participant
  • October 26, 2019

As you’ve seen, you can’t directly edit a field via lookup. However, if you add a link to a company in either [Places] or [Contact], you can click on the link to open that company record and edit all fields.


Thanks, I already understand the Graph Database beahvior.

I’d like to use the color field of COMPANY in my PLACES because it helps to see rows or event in a calendar view.

  • I don’t want to duplicate and maintain a select field
  • I don’t want to use a rule based color view (because I have to duplicate the logic too)

Forum|alt.badge.img+6
  • Known Participant
  • October 26, 2019

What do you mean by “a single label field”?


Jean-Philippe_E
Forum|alt.badge.img+12
  • Author
  • Known Participant
  • October 26, 2019

Sorry mispelled,
Table 1: Field > Single Select > Colored Option
Table 2: Link to Table 1

Table 2 can’t use the color defined in the field of the linked object of Table 1

Exemple:

  • Table 1 : Apple | Color Red
  • Table 2 : John Doe | work for Apple => can’t color it in red
  • Table 3: Meeting with JohnDow | at Apple => can’t get color from John Doe or Apple (can’t use them in Calendar view)

=> I think my question is more a feature request to retrieve the select fields with a rollup


Justin_Barrett
Forum|alt.badge.img+21

Sorry mispelled,
Table 1: Field > Single Select > Colored Option
Table 2: Link to Table 1

Table 2 can’t use the color defined in the field of the linked object of Table 1

Exemple:

  • Table 1 : Apple | Color Red
  • Table 2 : John Doe | work for Apple => can’t color it in red
  • Table 3: Meeting with JohnDow | at Apple => can’t get color from John Doe or Apple (can’t use them in Calendar view)

=> I think my question is more a feature request to retrieve the select fields with a rollup


Yeah, that makes more sense, and now that I understand what you’re talking about, I agree that it would be nice to assign colors to linked record items, and/or have colors from single/multiple select fields carry through when used in rollup/lookup fields. Maybe not all the time, though, but perhaps as an option.

Anyway, I’ll move this thread to the Product Suggestions category for further discussion if anyone else wants to chime in.