I am trying to load student images into a dashboard so when the user selects the ID for that student, the image appears. I have bundle loaded a table in script with two fields - first the ID which then joins to other data within the dashboard and secondly a field containing the filepath to the image. The load appears to work but I cannot get the text object to show the photos:
I create a text object, put in the code
=info([Student ID])
and change the Representation to Image. I also set it to be conditional so it only shows when just one Student ID is selected. This just shows '-' rather than the image. However, if I go into the expression and select images from the tabs at the bottom, I can select 'Student ID/' from the Image Folder drop down list but then it just lists all the images for me (and I can see them) but they don't appear in the text box. I want to just see the image depending on the selected Student ID.
The thing that seems to be missing is something like 'qmem' - this appears in all the other examples I've found when you look a the text object properties BUT I can't get this to change anywhere.
I've attached the screenshot of the load - the commented out section is how i was originally loading the files in using SQL. I tried creating an excel file with the images in and that didn't work. The next thing I tried was renaming the field in the bundle load so it wasn't a key with an existing field (seems like it needs to be an orphan?) And this worked! But without joining it to the other data it is not so useful - it means users will probably have to select the ID twice - once for most data and once for the photo.
Then in your text object you will need to add the desired image as follows (don't forget to set Image as value forRepresentation in text object properties General tab):
I saved the file and closed it and opened it again and it appears to now be working. Not sure at all why this is the case but lets hope it stays that way.
