Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
below is my script and would like to amend it so that the result shows as an image instead of "Y"
=agg (concat (DISTINCT if ([code]='EGG', if ([status]='Y','Y',),null()),'-')
If the image has an ASCII number that's indeed possible.
I would like to use the Tick in the images below, but haven’t got a clue how to
<http://www.thomasridley.co.uk/>
Mike Dube ACCA
Business Process Manager
T: 01359 270536
Favourite Dish: Lamb Stew and Dumplings<http://www.countryrange.co.uk/recipes/?ID=7> Follow us on Twitter<https://www.twitter.com/ThomasRidleyFS> <https://www.twitter.com/ThomasRidleyFS>
Delivering the best in Foodservice...
For loading the pictures look at the "bundle info" load statement in the help. Then for using the loaded images in an expression look at the second expression in the object with the colored arrow in the attached example. This is one of the build in images, but the way and syntax is the same.
Here is an example with country flags with the bundle info in the load script and a listbox with an expression to display the loaded images (so in the expressions tab of the listbox). In this case the images are linked to the dimension country, so it will display the images for a listbox with country as field. Any expression resulting in the correct link to the loaded images will work, so you are not required to link your images to another field.
Sorry am a bit new to scripting, basically what I need to do is for the results on the table its either a Y or N, so what i would like is to get the Y in a green background and N in red background.
Above is the script im using.