Read only grid - 1 record with multiple values for 1 column

Configure the value of the grid row with richTextDisplayField() like shown below. 

But I'm using fv!row[recordtype.field etc] , how can I make the value to only show the first value only?

But I'm using fv!row[recordtype.field etc] , how can I make the value to only show the first value only?

value: if(len(fv!row.value) > 10, left(fv!row.value, 10) & "...", fv!row.value)

when I use this it shows each value like blue, red green blue....., red green blue...., red green blue... The tooltip is working fine but the value is showing repeated 

I assume you adjusted my example code to actually reflect your data structure?  Can you post a code snippet and/or screenshot of what you currently have?

a!gridColumn(
  value: a!richTextDisplayField(
    value: if(
      len(
        index(
          rule!AM_getRegion(
             regionKey: fv!row['recordType!{04a9783cb7-4d51-b3ce-a347b0a390ea}regionkey'] ),
          "description",
          {}
        )
      ) > 10,
      left(
        index(
          rule!NO_getRegion(
             regionKey: fv!row['recordType!{04a9783cb7-4d51-b3ce-a347b0a390ea}regionkey'] ),
          "description",
          {}
        ),
        10
      ) & "...",
      index(
        rule!AM_getRegion(
          regionKey: fv!row['recordType!{04a9783cb7-4d51-b3ce-a347b0a390ea}regionkey']
          ),
        "description",
        {}
      )
    ),
    tooltip: index(
      rule!AM_getRegion(
        regionKey: fv!row['recordType!{04a9783cb7-4d51-b3ce-a347b0a390ea}regionkey']
      ),
      "description",
      {}
    )
  ),
  width: "NARROW_PLUS"
)

I'd recommend against repeating the exact same query 4 separate times, just sayin'. (hint: we have local variables...)

Also if you're using RecordType data, i'm unclear why you wouldn't have "description" as a column in the RecordType data, so you don't need to keep re-querying it?

a!gridColumn(
  value: a!localVariables(
    local!description: property(
      rule!AM_getRegion( regionKey: fv!row['recordType!{04a9783cb7-4d51-b3ce-a347b0a390ea}'] ),
      "description",
      {}
    ),
    a!richTextDisplayField(
      value: if(
        len(local!description) > 10,
        left(local!description, 10) & "...",
        local!description
      ),
      tooltip: local!description
    )
  ),
  width: "NARROW_PLUS"
)

its because its a mapping table one with the actual description and then the other with the key, each key is different based on the row

Maria said:

its a mapping table one with the actual description and then the other with the key, each key is different based on the row

Are you using modern / synced record types?  Because if so, like I mentioned, you should be able to add a record relationship to the mapping table, and thus get the description to just come through as a column.

Otherwise, the code I've provided above shows how to do the query once instead of repeating it 4 times (and it makes the code considerably more readable at the same time).

even doing it the way of mapping the relationship the values keep repeating themselves

a!gridColumn(
 

 value: a!richTextDisplayField(
    value: if(
      len(fv!row['recordType!{04a978d2-3e47-4d42-93d0-bd6d7cf7fd32}MA Color.relationships.{b9049f61-821d-4b2c-ac4a-284e7d4e8011}.relationships.{de4b16af-de71-4696-8b32-16ca9f1ca1c1}.fields.{db58f262-cc95-41a1-92e5-7d17e351c2d6}description']) > 10,
      left(fv!row['recordType!{04a978d2-3e47-4d42-93d0-bd6d7cf7fd32}MA Color.relationships.{b9049f61-821d-4b2c-ac4a-284e7d4e8011}.relationships.{de4b16af-de71-4696-8b32-16ca9f1ca1c1}.fields.{db58f262-cc95-41a1-92e5-7d17e351c2d6}description'], 10) & "...",
      fv!row['recordType!{04a978d2-3e47-4d42-93d0-bd6d7cf7fd32}MA Color.relationships.{b9049f61-821d-4b2c-ac4a-284e7d4e8011}.relationships.{de4b16af-de71-4696-8b32-16ca9f1ca1c1}.fields.{db58f262-cc95-41a1-92e5-7d17e351c2d6}description']
    ),
    tooltip:fv!row['recordType!{04a978d2-3e47-4d42-93d0-bd6d7cf7fd32}MA Color.relationships.{b9049f61-821d-4b2c-ac4a-284e7d4e8011}.relationships.{de4b16af-de71-4696-8b32-16ca9f1ca1c1}.fields.{db58f262-cc95-41a1-92e5-7d17e351c2d6}description']
  ),
  width: "NARROW_PLUS"
)

even doing it the way of mapping the relationship the values keep repeating.

I found a way instead of having the same value if if statement is false it should be null - now it doesn't repeat. thanks! 

But it still keeps showing 10 characters of each value- instead of just showing first value only