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

AppSheet AppSheet Q&A
1

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

1 Like
2

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.

1 Like
3

anapinkg:

the original name of the uploaded file

Not available.

4

Thanks.

1 Like
5

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