Random Pin Generator

Question

I am trying to figure out a way if its possible to make a field that will generate a random four digit pin number. Is this possible in QB?

------------------------------
William Hunter
------------------------------

williamhunter · Answer

Understood. I think that was my issue was I was trying to force it to do padding with a numeric field and it did not seem to be a compatible format. Thank you both again.&nbsp;------------------------------William Hunter------------------------------

markshnier__you · Answer

One way is to have a pipeline

The other way is to try this&nbsp;
ToNumber(Right(ToText(Int([Record ID#]*9973/127)),4))

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

joevandervest · Answer

Mark's pipeline sample works well, I use a version of it to send out random surveys on record save. Complete this with a check box/flag to record if you have already generated the pin or not. e.g. pipeline would trigger on update, set the random pin to the jinja output, set the "it's already set" flag to TRUE and then end. You'd trigger only on record update where the "it's already set" flag is false.

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

williamhunter · Answer

Perfect thank you both!------------------------------William Hunter------------------------------

williamhunter · Answer

Mark,
Can you explain the elements of this formula so I can better understand it?&nbsp;
ToNumber(Right(ToText(Int([Record ID#]*9973/127)),4))
I am asking because this seems like a good quick way of doing this, but I am getting some values under 4 digits. ------------------------------William Hunter------------------------------

Forum Discussion

Random Pin Generator