Forum Discussion

MelissaHale's avatar
MelissaHale
Qrew Member
2 years ago

Random String Generation in Quickbase

Hello! 

I am trying to figure out if there is a simple way to get a QuickBase formula field to generate a random string of characters (ideally 15-20 characters in length) once and then use that as a value to base the tables record ID off of. 

Does anyone more versed in QuickBase have any thoughts on how I would do this? 



------------------------------
Melissa Hale
------------------------------
  • I'm not sure if I have an answer but what dies 5his part of your question mean?

    once and then use that as a value to base the tables record ID off of. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • joevandervest's avatar
      joevandervest
      Qrew Cadet

      If it helps, I used a triggered pipeline to generate a number as a test for sending a survey or not. (jinja has a random function)

      I'd think a pipeline with some looping jinja code to determine a 15 place alphanumeric random might work somehow...  .. but if this is going to a unique key - even though it is unlikely - probably want to also check for pre-existing unique ID before saving... 



      ------------------------------
      joe vandervest
      ------------------------------