Linking a document created by appsheet and saved in a shared drive

[Peter_Griffiths]

Hi again folks,

I’ve managed to create a link in my app to a document that has been created using an automation, meaning that my users can access the file through the app, which is great. However, I am now saving these documents to a shared drive and am having difficulty recreating the desired effect.

The expression for accessing the file when it was in my own drive was:

appsheet/data/SpaceWolf-3293159/Files/filename.pdf

To save the file in the shared drive I have changed the default root folder to /[TeamDrive]Complaints/SpaceWolf - and then complete the file name with CONCATENATE([Policy number]&" CDF.pdf")

This saves the file in the correct place but using the same logic to create the expression to link the document to the app - [TeamDrive]Complaints/SpaceWolf/Files/filename.pdf - isn’t working. I don’t want all of the documents sat in my drive as if I leave or move to a different team they’ll continue filling up my drive.

Can anyone help?

[Aurelien]

Hi @Peter_Griffiths

Your first action, ie changing the default folder, is correct.

Is it the answer to your question ?

How to call the PDF Link that i created Questions

Hi @John_Paul_Armisa What you want to achieve is pretty similar to what is described in this post: You have to keep in mind that the link you want to provide is a relative path from your default folder path. With Automation, I reproduced it this way (other similar options exist, this is ONE option). The purpose here is to create a quote, store it in a team drive and giving access to user then. To do so, I make an action, visible to users, to write “filename” in quoteFile column. Then, the…

[Peter_Griffiths]

Hi @Aurelien,

Sadly not. The issue I seem to be having is creating the correct expression to direct the app to the document.

The document is in the following location - Complaints>SpaceWolf>Files. The document is called [policy number] CDF.pdf.

So in theory the path should be Complaints/SpaceWolf/Files/[Policy number] CDF.pdf but that just takes me to an error. I’m sure it is to do with the fact that it is a shared drive but I just don’t know how to fix it.

[Aurelien]

Hi @Peter_Griffiths

Peter_Griffiths:

I’m sure it is to do with the fact that it is a shared drive

I don’t think so, provided you have administrator permissions on this Drive (or something that allows you to create a file).

I notice something:

Peter_Griffiths:

The document is in the following location - Complaints>SpaceWolf>Files. The document is called [policy number] CDF.pdf.

So in theory the path should be Complaints/SpaceWolf/Files/[Policy number] CDF.pdf b

And previously, you said:

Peter_Griffiths:

To save the file in the shared drive I have changed the default root folder to /[TeamDrive]Complaints/SpaceWolf - and then complete the file name with CONCATENATE([Policy number]&" CDF.pdf")

That makes me think your file path should be instead:
\SpaceWolf\Files\[Policy number] CDF.pdf

• without the “Complaints” part, as it is your default folder
• with a backslash first
• with backslash instead of normal slashes

I’m not fully at ease with the use of slash or backslash, but I have an app where it is a backslash and it works, so…I suggest it

Let us know if that works

[Peter_Griffiths]

Howdy,

So I have tried every variation of the file path, including just using the name of the file, using backslashes, forward slashes, the full file path, and everything in between.

I have the relevant permissions to write to the folder and the file itself is created, my app just cannot pull the file out.

For the time being I am directing users to the folder where all of the files created are kept for them to pull out manually as this is still quicker than them creating the report manually.

Thanks for trying to solve this one guys.

[Aurelien]

So bad that doesn’t work, we must be missing something.
Do you mind if I ask you to share the link to a short video detailing the whole process you set and showing expressions as well ?

EDIT: In case that may help:

Here is my Team Drive Structure:

Here is my default app folder:

Here is what I write on my file column: