Other attachment files. On the workflow, I m...

expressions
(tsuji koichi) #1

Other attachment files.

On the workflow, I m trying to attach files which are saved in a column of child table.

Simply put the column name (ref type on parent table) to “the other attachment”

like this snapshot.

Tried select expression to pull the list of the file from child table, but all failed.

What s wrong?

(Aleksi Alkio) #2

It should work correctly but it seems that you are trying to add file(s) from related table, not from one column on the same table. Is this correct?

(tsuji koichi) #3

@Aleksi_Alkio yes, you are absolutely correct, I’m trying to get file type data from related table ( child table ) .

(Aleksi Alkio) #4

When you calling that virtual column, it will give you key column’s value from that related table as a result. That’s why it doesn’t add any file or files to your workflow. With the file option, you can add files one by one. If you need to send more files, you need to add more rows into the workflow and create suitable expression for that option.

(tsuji koichi) #5

@Aleksi_Alkio hi Alexksi,

I assumed we need to run select expression. So I added

select(Attachment[Attachment

File],[_Thisrow].[Inspection ID]=[Inspection ID]), and workflow run successfully!

Thank you again.