File not found

[umin-kyaw]

Hello Everyone,

I'll like to know  about file open.

Please see the photo. 

Why didn't find the file? 

I sure my automation for run data action for file column in automation setup.

My automation work well. Generated pdf file is already in my drive. 

I also inserted folder from drive document.

To open the file, I make a action external open a file.

This error is not only on this table but also on another tables that create like the automation and action to open the file.

I'm sure the URL point to a pdf file.

The left day it's Ok open the file of another tables.

This error happened to open any file.

Please let me know what happened.

[AleksiAlkio]

The path needs to start from the folder where the data source is. If the gSheet is under Root > Appsheet > Data > NeoApp-4381282, you need to start from there.. like "IC Files/12.pdf".

[umin-kyaw]

My expression is

Concatenate ("/Appsheet/data/NeoApp-4381282/IC Files",[Serial],".pdf")

What do you mean "under root"?

Thanks Bro

[AleksiAlkio]

If you are using gSheet, where is it in your gDrive?

[umin-kyaw]

Yes I used gsheet.

My gdrive folders -

Appsheet - Data - NeoApp-4381282 - IC Files

[AleksiAlkio]

Do your mean your main gSheet what the app is using as a data source is in "IC Files" folder?

[umin-kyaw]

IC Files is from gdrive folders.

My gsheet Sample app which have 60 table. 

My problem is not only this error.

The same error happened in any folders to open file.

These files were open as usual in previous days.

Your mean root is 

/appsheet/data/NeoApp-4381282?

 

[AleksiAlkio]

If files were opening just fine earlier and you haven't changed anything in the app itself, it sounds that you have either changed the folder where the main gSheet is, or you have moved your files or subfolders related where the main gSheet is.

So my question still is.. where your main gSheet is in your gDrive? What is the path to it from the Root?

[umin-kyaw]

My main gsheet is in gdrive.

The main gsheet is Sample App.

You can see it in photo.

[AleksiAlkio]

That printscreen shows that this file is in your gDrive, but it doesn't show in which subfolder that file is.

[umin-kyaw]

Do you see IC Files and it's path?

Appsheet - Data - NeoApp-4381282

I am facing this issue for every folders in this photo.

[AleksiAlkio]

No, it's not shown here. For example open the gSheet and go to Upper left menu > Files > Move. It shows you in which subfolder it is.

[umin-kyaw]

 it is my gsheet.

[AleksiAlkio]

You need to click the "Move" to see what is the subfolder name.. and then you can click the arrow in the upper left corner where that subfolder is and so on.. to the Root.

[umin-kyaw]

Click the Appsheet?

[AleksiAlkio]

So.. if this printscreen is from that popup right after you clicked "Move", the gSheet seems to be in your Root. Is my assumption correct?

[umin-kyaw]

Yes.

Correct.

What do I next?

[AleksiAlkio]

What is the path starting from the Root where the 12.pdf exists?

[umin-kyaw]

It's the path. 

I can find the file by using linktofilteredview expression.

But I didn't open the file for file type column.

Even file is exit and all correct actions, I can't find the file by using this expression

Concatenate ("/Appsheet/data/Neo-4321282/IC Files",[Serial],".pdf")

[AleksiAlkio]

As your pdf files are in this folder in gDrive.. Root > appsheet > data > Neo-4321282 > IC Files and the main gSheet is in Root > appsheet > data > Neo-4321282, you can't write the app formula from the Root as the path needs to be related to your gSheet's location. That's why the app formula needs to be..
"IC Files/"&[Serial]&".pdf"

[umin-kyaw]

It's not work 

Please see the photo.

 

[AleksiAlkio]

It doesn't work because your app formula is not correct. Please see my eplanation and how to fix it from one hour ago.

[umin-kyaw]

I have confused this error right now. I'm trying to fix it.

Please write app formula to fix it as example long expression.

Thanks Please.

Really I don't understand what you mean about this sentence

"That's why the app formula needs to be..

"IC Files/"&[Serial]&".pdf".

Let me explain more.

[AleksiAlkio]

You need to change the app formula CONCATENATE("/Appsheet/data/Neo-4321282/IC Files",[Serial],".pdf") to "IC Files/"&[Serial]&".pdf". And then you need to open each of your existing records with the app so the value would be rewritten to your gSheet. Or.. you can change them manually directly in the gSheet if you want.

[umin-kyaw]

It's also not work.

It is so hard to fix.

App default folder is correct.

App formula is correct.

Generated pdf file is exit in default folder.

But file is not found.

[AleksiAlkio]

Please take a printscreen from your Google Sheet and from the column where the file path is saved.

[umin-kyaw]

It's here.

 

 

[AleksiAlkio]

Something is then not correct with your setup.. the gSheet or the files are not in correct place. The default app folder doesn't have anything to do with this. I'm not able to help you more unless you are allowed to share your gDrive temporary so i could check what the reason is. If you are able to do that, please send me a PM.

[umin-kyaw]

What is PM?

I'm able to do that.

I'm able to share .

[AleksiAlkio]

Sorry, PM = personal message

[umin-kyaw]

Let see in direct message.

I already Send message 

[gk898]

Any solutions? 

[umin-kyaw]

My action is to open the file. 

I think my expression and action are correct. Not just open this file.

But I didn't open the file of my folders.

What happened?

Let show me the way.