How to determine uploaded file name and keep it in a text column

I know I canโ€™t change an uploaded file name. It is explained here.
What I need, in this case, is the original name of the uploaded file stored in a text column.

Is it possible?

Thanks

Solved Solved
1 4 490
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Not available.

View solution in original post

4 REPLIES 4

Assuming youโ€™re using GSheets and GDrive, the filename (and path) is the literal value saved into that column. You just reference the column value [file column]. Perhaps wrap it in TEXT() if necessary. You can use INDEX( SPLIT(... , "\") , 2 ) to get just the name without the path.

Steve
Platinum 4
Platinum 4

Not available.

Thanks.

With the new integration with Google Apps Script, there is now a way .
See the Tips & Resources below:
How to control or rename uploaded files in a [file] column