Forum Discussion

WadeDavis1's avatar
WadeDavis1
Qrew Trainee
8 years ago

I'm attempting to generate a ""Unique"" identifier for a tracking number that is auto generating.

I'm attempting to have a number generated using "TORC" as the beginning identifier then the year. and then starting at 10000 and using the record ID#. I'm new to "formulas and I am stumped This i...
App builders
Errors
KyleChase1's avatar
KyleChase1
Qrew Trainee
8 years ago
I also (as a result of attempting to automate a manual input process) am attempting to do the same thing.  However, my question is about the structure rather than the formula.

Being new to QB, I'm having to decipher what you guys are saying about the fields.

In a new test table, I created a formula-text field and placed the above formula in it.  I created a 'Request Date' field to satisfy the arguement, and it populates the 'TORC-' but not a number.

Could someone please briefly explain what else I'm missing to test this?  The Noob wants to learn.

Thank you so much in advance!

-Kyle