# How to get filename like URL column type?

**URL:** <https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597>\
**Category:** Ask for Help\
**Created:** [September 5, 2022, 4:50am UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597 "2022-09-05T04:50:29Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\
**Post date:** [September 5, 2022, 4:50am UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/1 "2022-09-05T04:50:30Z")

</div>

HI guys!

I’m wondering how can I get filename from a file in google drive?

When I use URL column type, on Design-\>Label there is an option to select callled **Page Title**

![design](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa7f5c895b2b8ec6819706a4b27bcb52913bd923.png)

This option allow **Link component** to show filename

![app](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b783b88b45e2ab759ffe4c7486cb7e80d57b6dd8.png)

Is there another way to extract it into a text column type? So I could use it in a inlist

Any clue?

Thaks in advance!

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [September 5, 2022, 8:31am UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/2 "2022-09-05T08:31:48Z")

</div>

Could you share the full URL? If the structure of the URL is consistent, two ideas to extract the name of the file:

- Use a split text column with / as the delimiter. Then perhaps do it again with . as the delimiter should you want to remove .pdf.

- Use one of the advanced computed columns in the “Text” group to truncate the URL.

Really I have no idea of these ideas would work, we would need to see the URL.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 6, 2022, 12:13am UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/3 "2022-09-06T00:13:48Z")

</div>

> [@nathanaelb](#):
>
> we would need to see the URL.

I agree with this, since there can be variations of URL for the same file, and the structure of the URL will determine what approach we make here.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [September 6, 2022, 12:24am UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/4 "2022-09-06T00:24:30Z")

</div>

I created a PDF from a Google Docs and uploaded it to Google Drive, and the name of the file doesn’t appear for me in the URL.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 6, 2022, 12:29am UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/5 "2022-09-06T00:29:24Z")

</div>

After some Googling, I believe Google Drive does allow you to store the filename, but not in the URL. The URL seems to only show the file ID as you mentioned. To retrieve the original file name, you must dive into the file’s metadata.

Glide does allow you to keep the file name in the URL when you upload files, though.

---

<div class="post-metadata">

**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\
**Post date:** [September 7, 2022, 4:57pm UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/6 "2022-09-07T16:57:25Z")

</div>

Hi Mate

You are right, there is no name in url’s path

Does anyone knows about an api ?

Cross finger

Thnx guys!!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 8, 2022, 1:33am UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/7 "2022-09-08T01:33:14Z")

</div>

The calling method is provided here, but it also comes with authorization headers.

> **[Files: get  |  Drive API  |  Google Developers](https://developers.google.com/drive/api/v3/reference/files/get)**

If your file name does not get changed frequently, then when you add a new item with a Drive link, I would send that link to Make through a webhook action, then retrieve the file name using an API call/get file action there, update the name back to Glide in a basic column.

---

<div class="post-metadata">

**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\
**Post date:** [September 12, 2022, 6:17pm UTC](https://community.glideapps.com/t/how-to-get-filename-like-url-column-type/48597/8 "2022-09-12T18:17:20Z")

</div>

Working on it!

Thnx Mate!!
