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

Certified Senior Developer

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

  Discussion posts and replies are publicly visible

  • 0
    Certified Senior Developer
    in reply to Mike Schmitt

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

  • 0
    Certified Senior Developer
    in reply to Maria

    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