Forum Discussion

DiegoOrellana's avatar
DiegoOrellana
Qrew Trainee
5 years ago

Different URL for the Same Record When Edit is Cancel

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.

3 Replies

  • AustinK's avatar
    AustinK
    Qrew Commander
    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.