First of all: it is very very impressive how many excellent design decisions you have made for the Glide platform. Thank you so much for building Glide.
Question: Is there a specification for Row IDs that I can take a look at? E.g. how they are constructed or what kind of characters they might contain (now and going forward?). I noticed they sometimes include dots (".") but not always.
I am currently working on documentation for how to add Clubhouse-like audio rooms (powered by Jam (https://jamshelf.com)) to Glide apps. In a sense Jam is an audio room server which lets you construct an audio room via an URL that you then can add to your app using an iframe.
Every room on Jam has an ID, those IDs are at least 4 characters long, alphanumeric (upper and lowercase) and can also contain minus signs ("-").
Very similar to Row IDs on Glide.
Unfortunately IDs for rooms on Jam can not include dots (".") at the moment (because we want to avoid confusion with potential future URLs that end in .json or similar).
Now Glide has Row IDs which are super helpful but it seems like they can sometimes contain characters we would not expect in IDs used for Jam which means we can’t use Row IDs as they are.
My current workaround is to create another column which is a “template” that replaces “.” in Row ID values with “-” which seems to work well (h/t @Karim). But I am not sure how robust that is @ potential collisions and if dots are the only characters that can appear in Row IDs which cause problems for us.
Do you have a specification or description about Row IDs? I only found
which doesn’t describe them in detail.
Cheers & again thank you for building Glide!