Different URL for the Same Record When Edit is Cancel

  • 0
  • 1
  • Question
  • Updated 2 days ago
  • In Progress
When I select a record from a table I see the following link:
https://********.quickbase.com/db/bpdyd4kbj?a=dr&rid=5&rl=crz
I can clearly see the record id ("5")
If In this record I click "edit" and then in edit mode I click Cancel to exit edit mode the new url for the same record is the following:
https://********.quickbase.com/db/bpdyd4kbj?a=dr&r=f&rl=crz

Now record id information is encoded as f  (r=f))(a=0,b=1,c=2,d=3,e=4,f=5...). Why is this happening? Why we cant have the same first url? This complicates the creation of some types of scripts. Also I haven't been able to figure it out the letters encoding:

I have a record with rid = 2536 that is encoded  as "cri" in letters, and  2535 is "crh". If somebody knows the formula of the encoding please let me know. (it is not as simple as base 26, unless I made some mistakes)

Thank you.
Photo of Diego Orellana

Diego Orellana

  • 136 Points 100 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of AustinK

AustinK

  • 1,338 Points 1k badge 2x thumb
I've been wondering about this for a while and there doesn't seem to be much info out there about it. The last post I saw about it suggested it might be base36 or closely related. I found this nice website to help at least eliminate some options.

http://www.unitconversion.org//unit_converter/numbers-ex.html
Photo of Diego Orellana

Diego Orellana

  • 136 Points 100 badge 2x thumb
Thanks for the link.
Photo of AustinK

AustinK

  • 1,338 Points 1k badge 2x thumb
I was poking around in the QuickBase formula functions and I came across QB32Encode and QB32Decode. "Encodes/Decodes text to an integer using a Quick Base specific base32 encoding". This may be what you are missing here.

I tested this on a record of mine and the part of the url that says "r=wqu" is the record number. Doing a QB32Decode on wqu got me 20,946 which is the exact right number for my record. It also has a section of the url with "&rl=" but I'm unsure what that number is.

Hopefully this is helpful to someone. I'm just happy I found this today and was able to put it to bed.
(Edited)