Discussions

 View Only
  • 1.  URL parameters

    Posted 05-25-2020 22:48
    Hi Can any one could explain me what its mean this values in the URL

    https://msoto.quickbase.com/db/bqidanmyc?a=dr&r=c9

    a=dr
    r=c9

    Thanks


  • 2.  RE: URL parameters

    Posted 05-25-2020 23:27
    np


    a=dr. This means Action = Display Record
    r=c9 this means to display the record c9, but the c9 I think is base 64 encoded.

    often you see

    &rid=123

    that means to act on record ID 123. 

    When it just says r and not rid, then it expects Base 64 encoding. 




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: URL parameters

    Posted 05-26-2020 13:19
    Quick Base is using a proprietary(afaik) base 32 encoding of some sort. The command itself is QB32Encode to find the r when you just have the rid.

    Base 64 encode 500 = NTAw

    Base 32 encode 500 = GUYDA===

    QB32 encode 500 = rw

    I assume this is just like a URL friendly version of some type of encoding. But I really have no clue why it was done in this way.

    Fun fact(disclaimer: fact may not be fun) I found when messing with this is Quick Base actually does have a limit on the number they will convert using this function and the limit is 5000000000000000000. After 19 numbers it spits out only "-a" as a result.