Hello. I have a canvas app with a gallery connected to a table called Task Responses. That table has a many to one relationship with another table called Task Versions. So each Task Version can have many Task Responses but each Task Response only has one Task Version.
In the Task Responses gallery I need to display some information about the related Task Version and also use it for some formatting and conditional visibility of some controls within the gallery. In the editor this works perfectly well, but when I play the app as an ordinary user all the values from the related Task Version come back blank/empty.
I tried turning off the explicit column selection in the app settings (retired) but the app won't load properly like that, presumably due to the amount of data it's trying to fetch - I get SQL errors. In any case I don't want to implement retired features in a production app.
How can I get around this issue? One of my options is to create formula columns in Task Responses to lookup the relevant record and display values from there as text and numeric columns, but this seems like a lot of work and will make for quite a wide table. Is there another way of simply having the app behave the same way in play mode as in the editor studio?
