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.
Discussion posts and replies are publicly visible
Hi Peter Lewis I did check the code probably its the copy paste issue and i still tried by saving it as fields.updatedFields. but still it is throwing me the same error. Not sure what is the issue. Any other thoughts pls
Hi Peter Lewis and 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"),
In the past, I have been in situations in which I had an error and while trying to solve it, I change too many things at the same time. At the end I had working code, but could not really tell what the initial problem was.
In the meantime, I made it a habit to investigate and improve my code after I got it working. Then I try to understand what the initial problem was and why I came to a certain conclusion in the first place.
TLDR: Both, search and contains should work.
Yeah For me it was concat() function which concatenated two record fields ,that was failing the export grid to excel, I just removed that function and used "&" instead of it, which eventually resolved it.