Numbering System
Hoping I can get some help. I'm new to writing formulas so that's not a huge help. I'm looking to create a unique number system for each entry. For example the first entry would have "IA202...
Forum Discussion
One way I get a unique number is by utilizing the record ID in a formula. So for example, I have a table of Orders and my Unique ID is "O-" & [Record ID#].
So maybe you could have "IA" & [Year] & "-" & [Record ID#]
Year you could replace with a formula to get the current year which I know is simple but I don't know it off the top of my head.
------------------------------
Mike Tamoush
------------------------------
So maybe you could have "IA" & [Year] & "-" & [Record ID#]
Year you could replace with a formula to get the current year which I know is simple but I don't know it off the top of my head.
------------------------------
Mike Tamoush
------------------------------
Hello Mark,
Can you please help me, I am trying to do a simple formula by adding # to another # and then dividing it into another (example: Total Complete + Total Exempt / Total Training Assignments) Is there something I am doing wrong in the system because the # comes out very large and it shouldn't?
1303282+67040/1942651=.70% but the system says 130,328,203.5%
Here is how I have it in the system:
Thanks,
Alan
------------------------------
Alan Orbach
------------------------------
Can you please help me, I am trying to do a simple formula by adding # to another # and then dividing it into another (example: Total Complete + Total Exempt / Total Training Assignments) Is there something I am doing wrong in the system because the # comes out very large and it shouldn't?
1303282+67040/1942651=.70% but the system says 130,328,203.5%
Here is how I have it in the system:
Thanks,
Alan
------------------------------
Alan Orbach
------------------------------
- MarkShnier__You
Qrew Legend
Alan, Forum Etiquette is to not post he same question twice and also please do not post an unrelated question into a thread. Post it as a new question.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
