Skip to main content
January 4, 2024
Solved

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

  • January 4, 2024
  • 12 replies
  • 1 view

Hi All,

Does anyone know if in appian is possible to show "..." and it you put the cursor on top you see rest of text? when we have multiple values for one column of one specific record. For example I have a grid with multiple columns and one of them for each records has multiple values , like the user record has a column with "favorite colors" and each user has 3-4 colors. In grid I want to display only first color and .... so the height of row is not so big.

thanks in advance

Best answer by mikes0011

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"
)

12 replies

harshitb6843
January 4, 2024

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

January 4, 2024

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

mikes0011
Brainy
January 4, 2024

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

The Expression Guru