Skip to main content
H
harshav
February 2, 2022
Solved

Export to Excel in Records working in Tempo but not in Grid

  • February 2, 2022
  • 14 replies
  • 0 views

Hi All,

I have a Record type configured in a Grid and the Grid i have configured some set of columns which are coming from the Record Type.

The Export to excel button works in Tempo.

However in the Grid when we configure the Export to Excel button It is throwing an error. 

It says expression evaluation error at function if parameter 2 line 73 invalid symbol found comma.

But when i validate the interface it is working fine.

Can someone help me out.

    Best answer by harshav

    Hi [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] and [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] i did change my query for a one grid column like this and tried and it worked, but

    i replaced my contains parameter with search and tried and it worked. But why is contains not working i am not able to figure it out. Any thoughts on this please.

    a!gridColumn(
    label: "Org - Position Desc",
    sortField: 'recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{orgPosition}orgPosition',
    value:
    a!richTextDisplayField(
    value: {
    a!richTextItem(
    text: fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{orgPosition}orgPosition'],
    color:
    if(search("orgPosition",fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{updatedFields}updatedFields'])>0,


    "#FFBF00",
    "STANDARD"
    ),

    style:
    if(search("orgPosition",fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{updatedFields}updatedFields'])>0,
    "STRONG",
    "PLAIN"
    )

    )
    }
    ),
    width: "NARROW_PLUS"
    ),

    14 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 2, 2022

    The message

    It says expression evaluation error at function if parameter 2 line 73 invalid symbol found comma.

    is a hint to a possible syntax error in the code. Can you share that code?

    H
    harshavAuthor
    February 2, 2022

    a!gridColumn(
    label: "Org - Position Desc",
    sortField: 'recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{orgPosition}orgPosition',
    value:
    a!richTextDisplayField(
    value: {
    a!richTextItem(
    text: fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{orgPosition}orgPosition'],
    color: if(
    a!isNullOrEmpty(
    fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{updatedFields}updatedFields']
    ),
    "STANDARD",
    if(
    contains(
    trim(
    split(
    fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{updatedFields}updatedFields'],
    ";"
    )
    ),
    "orgPosition"
    ),
    "#FFBF00",
    "STANDARD"
    )
    ),
    style: if(
    a!isNullOrEmpty(
    fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}As.fields.{updatedFields}updatedFields']
    ),
    "PLAIN",
    if(
    contains(
    trim(
    split(
    fv!row['recordType!{d806002b-c5b8-4f1f-b67e-f5ffa63826a4}s.fields.{updatedFields}updatedFields'],
    ";"
    )
    ),
    "orgPosition"
    ),
    "STRONG",
    "PLAIN"
    )
    )
    )
    }
    ),
    width: "NARROW_PLUS"
    ),

    H
    harshavAuthor
    February 2, 2022

    Hi [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] this is the above code and its working in tempo perfectly fine. But not in the Grid which i have configured in the interface.

    Terms & ConditionsAccessibility statement