Other attachment not working

[Lovkesh_Aggarwa]

I want if i request some documet then appsheet send automaticaly attachment file from gdrive.

[Aurelien]

Hi @Lovkesh_Aggarwal

I suggest you have a look to the section “How AppSheet locates other attachment files”

help.appsheet.com

Adding other attachments to an email

Add other attachments to your email, including photographs, drawings, and more.

In other words, your expression might be instead:

IF(yourCondition, 
"YourFolderNameFromDefaultPath/Bank_Mandate.pdf",
"")

[Lovkesh_Aggarwa]

Thanks but if i want to attach folder or more files in code then what should i need to write? and is there any videos where i learn multi expression coding?

[Aurelien]

To my knowledge you can’t attach folder, but you can attach various files.
(beware of example, you still need to write “fileFolder/nameFile.pdf”

I think you can also use that expression (not tested yet):

IF(yourCondition, 
 LIST(
  "YourFolderNameFromDefaultPath/file1.pdf",
  "YourFolderNameFromDefaultPath/file2.pdf",
  "YourFolderNameFromDefaultPath/file3.pdf"
  ),
"")

Here is another helpful ressource:

help.appsheet.com

Email Other Attachments

Adding Other Attachments to your workflow email.

Lovkesh_Aggarwal:

is there any videos where i learn multi expression coding

I don’t know about this specific request, but this is a good ressource:

YouTube

AppSheet Training

Helping you unlock the full power of AppSheet! We replace time-wasting processes with flexible digital tools to achieve your goals and save money, and this channel is one of the ways that we are trying to help people do just that! This channel is...

[Lovkesh_Aggarwa]

not working and how appsheet is no coding platform? there is alot coding! there must be browse and attachment option and its common feature

[Aurelien]

Hi @Lovkesh_Aggarwal

Did you try removing the “welthertaskmanager-4122587/” part on your expression ?
This is supposed to be the relative path from the default folder.
Because of it, there is no need to add it to the path.

Let us know if that works for you

[Lovkesh_Aggarwa]

this is the path from defaultu folder

[Aurelien]

I agree this is your default path
I probably mis-expressed myself, sorry for that.

Aurelien:

Did you try removing the “welthertaskmanager-4122587/” part on your expression ?

What I meant is to change your expression,
From:

IF(CONTAINS([Purpose], "Welher Investment Account Opening ( Mutual Funds)"), 
 LIST(
  "Welthertaskmanager-4122587/Files/Mutual Funds/AOF/Bank_Mandate.pdf",
  "Welthertaskmanager-4122587/Files/Mutual Funds/AOF/AOF FORM.pdf",
  "Welthertaskmanager-4122587/Files/Mutual Funds/AOF/cams kyc.pdf"
  ),
"")

Into:

IF(CONTAINS([Purpose], "Welher Investment Account Opening ( Mutual Funds)"), 
 LIST(
  "Files/Mutual Funds/AOF/Bank_Mandate.pdf",
  "Files/Mutual Funds/AOF/AOF FORM.pdf",
  "Files/Mutual Funds/AOF/cams kyc.pdf"
  ),
"")

(please check the expression, I’m not sure I copied it correctly from your screenshot)

This way, you will have the relative path from your relative folder, which is implicit.

[Lovkesh_Aggarwa]

Now they giving condition error! why appsheet dont make it simple? make a coloum as per rules by default

[Aurelien · Accepted solution]

Can you try this instead:

IF(CONTAINS([Purpose], "Welher Investment Account Opening ( Mutual Funds)"), 
 LIST(
  "Files/Mutual Funds/AOF/Bank_Mandate.pdf",
  "Files/Mutual Funds/AOF/AOF FORM.pdf",
  "Files/Mutual Funds/AOF/cams kyc.pdf"
  ),
  LIST("")
)

(add the “list” expression on the 3rd input, that’s my mistake I didn’t think about this one as I was focusing on the pdf file path )