Getattachments

I realise I did not follow up on this topic, but the problem was that I was using Velixo Classic instead of Velixo NX. The function "getattachments" did not work with Velixo Classic. I appreciate your help!

I have been trying for a while to get this to work as well as it would be a fantastic way to pull large volumes of docs for various BAU activities

I think I have the GI and GETATTACHMENTS function configured correctly

However I am getting this error

Any help would be much appreciated!

Please reach out to the Velixo Help Desk (support@velixo.com) so that they can assist you with this.

Hi there! Thanks for the quick reply. I tried modifying the function, but the result is still not working :

Do you see anything else that I could try? I also tried with the values in French and English as well (Invoice, Bill, Facture)

Let's do some minor changes to your function in order to match the documentation.

My system is configured for the EN-US settings, so my function would look like this:

=GETATTACHMENTS(B2,B3,HSTACK(VSTACK("Type","ReferenceNbr"),VSTACK(B6,B7)))

The first part of my array consists of all the Key field names ("Type" & "ReferenceNbr").  The second part consists of all the key values (cells B6 and B7).

Each part is created using the VSTACK function.  These are then combined using the HSTACK function.

My bill (002769) has an attachment ("23444.pdf"):

My Distribution List looks like this:

And my report looks very similar to yours:

When I distribute the report, this is the resulting PDF file:

Page 1 (the MyReport worksheet)

Page 2 (the contents of 23444.pdf)

Try your report with the slightly modified GETATTACHMENTS function.