[Collection of files] How to retrieve a file name uploaded from Drive ?

[baba_sawane]

Hi dear Appsheet users. How are you doing ?

I searched the net and a lot of posts but did not find someth. similar, I'd like to ask as i'm not sure : 

To explain my issue,  initially some of my users have to upload files in the app and are using a column with 'Enum' to folderize the uploaded files, so that the data can be found easily. The issue is that, for each construction site there are many files to upload. They are taking ~40 minutes just to do 1 site.

So, I looked for a way to speed up the process, and this was my idea :

1. Creating a folder in my drive that would store all the files
2. Adding a collection of files (let's call it C1) table linked to this folder 
3. Create a new table (new sheet, let's call it C2), where :

• Each row = one category of files (ex: security/quality/etc)
• Each time a construction site is created, an automation will add the corresponding standard categories in that table (they are different based on the site, that's why)
• Creating an enumlist where the user will choose the files of C1 that he want by editing each category

This is where i'm in a little trouble, because it shows me the path (with the original file name inside) but not the file name only.

Is there a trick to get or show only the file name ?

I tried to replace the ID formula, no errors but it's just ignoring it and generate another key (if anybody have an idea of what happens 😕 ) :

edit : it's the drive file ID

I thought it wouldn't be an issue to see the file name since they are uploaded directly from GDrive.

Thanks a lot for reading this, any help is welcome !

[baba_sawane · Accepted solution]

Okay so I just tried to create a virtual column with the same formula in C1 and there were no errors even if the column is a Text type 😲

I was expecting it to fail because it's not a List but I guess Collection of files can allow it (have no idea why).

Anyway, i'll try to use this new column, i'll tell you if this worked out !

ps : I used RIGHT([Path],LEN([Path])-74)

edit : It worked out