# Rowid with slash - can that be avoided

**URL:** <https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185>\
**Category:** Ask for Help\
**Created:** [June 20, 2020, 11:15pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185 "2020-06-20T23:15:41Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [June 20, 2020, 11:15pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/1 "2020-06-20T23:15:41Z")

</div>

I’m trying to use rowid as part of a filename - but I run into troubles as the rowid can include slash (i didn’t know that was possible in an unique identifier)

I had a rowid like IAQB91waTCWeHy/ECMopag

Is is correct that a slash should be able to occur in a unique identifier?

If a slash can be expected and I want to use an unique identifier for a file name - what should I do to avoid the slashes?

---

<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:** [June 20, 2020, 11:18pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/2 "2020-06-20T23:18:41Z")

</div>

Hi @Krivo! I’m not answering you’re question (because I have no idea) but asking a question of my own: what are you working on? It sounds interesting.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [June 20, 2020, 11:21pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/3 "2020-06-20T23:21:42Z")

</div>

@nathanaelb working on trying to go to bed ! Well, trying to upload directly to Cloudinary from within Glide which is possible but a bit cumbersome. Expecially when you have do do javascript on a webpage and I don’t know how to do it. But I can do some copying - and seems to work 🙂

---

<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:** [June 20, 2020, 11:24pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/4 "2020-06-20T23:24:19Z")

</div>

@Krivo it seems like you won’t be getting to bed early tonight, it’s already 1:30 AM!

---

<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:** [June 20, 2020, 11:26pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/5 "2020-06-20T23:26:07Z")

</div>

Didn’t know about the slash thing as well. How about making an ARRAYFORMULA with SUBSTITUTION to change all slashes to question marks?

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [June 20, 2020, 11:27pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/6 "2020-06-20T23:27:19Z")

</div>

@ThinhDinh well, might need to. But is that normal that an UUID can include slash? Or are Glide doing something strange?

---

<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:** [June 20, 2020, 11:52pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/7 "2020-06-20T23:52:45Z")

</div>

Whether they have slashes or not depends on Glide’s setup of allowed characters, I don’t think they anticipated this case.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [June 21, 2020, 12:16pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/8 "2020-06-21T12:16:12Z")

</div>

@mark Is it intentionally that you in unique identifiers use slash **/** (seen in RowId)? You also use other special characters.

I causes me problems as I use the RowId as a name for a file placed in Cloudinary

Would it be possible that you would change this so slash will not occur in the future for RowId?

Of course you cannot remove it all together as some people already depend on the RowId - but could be nice for future work if such special characters were not present.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [June 21, 2020, 2:48pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/9 "2020-06-21T14:48:22Z")

</div>

We can do that.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [July 28, 2020, 10:22pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/10 "2020-07-28T22:22:43Z")

</div>

@mark I have also had problems with + (plus sign) as well as Cloudinary will not accept such character when uploading files. I have been using webview for that.

Any idea when such a change will come through?

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [July 28, 2020, 10:30pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/11 "2020-07-28T22:30:26Z")

</div>

New Row IDs should not have slashes or plusses in them. When did you see a new row ID that had them?

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [July 28, 2020, 10:40pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/12 "2020-07-28T22:40:27Z")

</div>

@mark ok. Everything ok.  
My mistake. I haven’t created a new row in the problematic app since I reported it. And you would not change the rowid back in time (which is of course totally correct) - therefore the + sign is still there.

---

<div class="post-metadata">

**Author:** ![Pat\_Baker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pat_baker/32/2472_2.png) [@Pat\_Baker](https://community.glideapps.com/u/Pat_Baker)\
**Post date:** [September 17, 2020, 1:16pm UTC](https://community.glideapps.com/t/rowid-with-slash-can-that-be-avoided/11185/13 "2020-09-17T13:16:19Z")

</div>

Hi,  
I’m curious about how the ROW\_ID is created. I’d like my sheet to be maintainable from the normal Sheets UI, but would then need to add a value for the ROW\_ID for which I’m planning to use the built in

> Utilities.getUuid()

This gives a value in the format **a9a3d01c-1866-4379-a68d-943ab6ee8205** which is uniform presentation used in Java / Python etc with a 8-4-4-4-12 representation regardless of the UUID version.

Would also sort @Krivo 's issue with file naming.
