Forum Discussion

AustinK's avatar
AustinK
Qrew Commander
4 years ago

Re: OneDrive and Pipelines

If it is using letters as the RID then it is being converted to "QB32" format, a form of encoding Quick Base uses.

Here are some examples. The formula converting the rid to QB32 format is just "QB32Encode([Fake Record ID#])".



It might be possible to just create a formula field there and have that create your QB32 RID and just insert that instead of the original Record ID#.

3 Replies

Sort By
  • JeffreyMoore's avatar
    JeffreyMoore
    Qrew Trainee
    4 years ago
    Hi Austin, 

    Thank you so much for your help! That makes a lot of sense. Do you know what the code for "QB32Encode([Fake Record ID#])" would look like in Jinja by chance? (the language for pipelines)?

    Thanks again.

    Jeff

    ------------------------------
    Jeffrey Moore
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      Jeffery, a convenient cheat if you don't want to have to code with too much Jinja coding to make the field in Quick Base and refer to the Quick Base field in the Pipeline.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • JeffreyMoore's avatar
        JeffreyMoore
        Qrew Trainee
        4 years ago
        Thank you Mark! Works great! You are the best.

        ------------------------------
        Jeffrey Moore
        ------------------------------