Issue using icons on grid with validation.

Question

Hi, I want to create a tempo Reports for the first time and I want to use an icon to showed on the grid column with validation. If the result of the validation is yes for Product A, so it will show an Icon A on the grid column, and if the result of the validation is no for product A, it will show an icon B on the grid column. Here, I attach a file that was my script, may someone could help me to correct my script if I have some wrong script on it, because my script can't work as well. Thank you very much for helping :) ----------------------------------------------------------------- load( local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10, sort: { field: "dateTimeSubmit", ascending: false } ), with( local!datasubset: rule!Get_ProjectReport( local!pagingInfo ), if( local!datasubset.totalCount < 1, rule!APN_uiTextReadOnly( label: "There are no Project Report" ), ... 
 
 OriginalPostID-111898 
 OriginalPostID-111898

Jess · Accepted Answer

Hi, here's a sample code --------------------------------- 1. Create first expression rule with a rule input - product 2. Enter the code something like below and save if(ri!product="A", a!documentImage(document: cons!Icon_A) , if(ri!product="B", a!documentImage(document: cons!Icon_B) , null ) ) save the expression rule with filename like - displayProductIcon (this will be called/used in the form as rule!displayProductIcon) 3. Once the expression rule is created, go to the form and enter the following code a!gridImageColumn( label: "Product", field: "product", size: "ICON", data: apply(rule!displayProductIcon,index(local!datasubset.data,"product",{})) ) The apply loop will call the displayProductIcon expression/function and will loop on each product in the product datasubset.