Hi Guys.
I am following the document โEmail Other Attachmentsโ.
The parent table is โqryTransportโ which contains no images.
The child table is โAppQuotesโ, in this table I have setup an EnumList field containing the names of the 4 Image fields of this same table (Image1, Image2, Image3, Image4).
My workflow is triggered from qryTransport, how do I pull the images from Appquotes and attach them to the email output from qryTransport?
Kind Regards
Hi @Dave_Willett Did you do a test run. Usually, related child tables will be included automatically.
Hi Lynn. Iโm not sure what to put in the โOther attachmentsโ field so Iโm a bit stuck now.
This is what I have so far:
LIST(IF(CONTAINS([Attachments], โImage1โ),โImage1.pdfโ,"")) + LIST(IF(CONTAINS([Attachments], โImage2โ),โImage2.pdfโ,"")) + LIST(IF(CONTAINS([Attachments], โImage3โ),โImage3.pdfโ,"")) + LIST(IF(CONTAINS([Attachments], โImage4โ),โImage4.pdfโ,""))
But I get 'Unable to find column โAttachmentsโ
Sorry I have not used โOther attachmentsโ Hopefully someone else will be able to help.
Donโt worry Lynn, thank you anyway
Are your files fixed ones in your data source? And do you have only one child record for one parent?
Hi Aleksi. They are images which are generated from the appquotes form:
I added an โAttachmentsโ column set to enumlist.
The workflow is triggered from qryTransport.
Only one child record per parent?
Iโm not sure if I understand completely Aleksi. There are 4 columns in โAppQuotesโ as above. Should there be 4 records in the parent โqryTransportโ too? If so should there be a formula for each image column in the parent as a ref?
Cheers
You are using related table structure where the โqryTransportโ is a parent and it has child record in โAppQuotesโ table. Because of the structure, you could have more than just one child. My question wasโฆ do you have only one child per parent or is it possible that the parent record will have more child records that just one?
There will be more child records Aleksi. Thanks
And you would like to attach them all when the parent record is triggered?
Yes Aleksi that would be ideal.
Thanks again
You can use something like INDEX([Related AppQuotes][Image1],1) for one Attachment row. Because you donโt know how many child records you will have, you should add quite a lot other attachments rows to your Workflow.
Thanks Aleksi
[Related AppQuotes] is that a ref field in qryTransport, if so, for each image I create a new virtual column in qryTransport as follows:
INDEX([Related AppQuotes][Image1],1)
INDEX([Related AppQuotes][Image2],1)
INDEX([Related AppQuotes][Image3],1)
INDEX([Related AppQuotes][Image4],1)
and then:
LIST(IF(CONTAINS([Attachments], โImage1โ),โImage1.pdfโ,"")) + LIST(IF(CONTAINS([Attachments], โImage2โ),โImage2.pdfโ,"")) + LIST(IF(CONTAINS([Attachments], โImage3โ),โImage3.pdfโ,"")) + LIST(IF(CONTAINS([Attachments], โImage4โ),โImage4.pdfโ,""))
in Other attachments of the workflow?
Just making sure here, thanks again
Actually no. You can add only one image into one Other Attachment row. Using a list, doesnโt seem to work.
For example writing a formula like SELECT(ChildRecords[Image1],[PARENT_ID]=[_THISROW].[ID]) wonโt work.
Thanks Aleksi as ever, Iโll do some testing over the weekend.
Have a great weekend
Youโre welcome
User | Count |
---|---|
15 | |
9 | |
9 | |
7 | |
3 |