Hi everyone, thank you in advance if you're reading this. I have a Form set up whereby a parent child table relationship exists (in Appsheet you know these will usually be auto named 'Related etc etc' and use a REF_ROWS() expression. Anyways, I'm aware of a deference list expression whereby you can single out a column from this list of rows, by adding the column after the ref rows one (for example, [Related Training][Attendees].
My issue relates to the viewing of this deference list inside of an email body template. For example a normal attachment in the parent table can easily be viewed using a hyperlink, and Appsheet is clever enough to build the URL link for the column even though the actual column simply has the file upload path (e.g Upload/Training/4abb3cb1a.Attachment.191753.png)
A deference list item though does not have this same format when fetching it from a virtual column expression. My aim is to view these deference list columns as clickable links inside of an email.
P.S I don't have appsheet open in front of me right now, so apologies for not attaching screenshots, please ask in the comments below if you would like some more visual info on the issue I'm facing.
LinkedIn
Twitter
