Using Hammer’s Rule, “if won’t fit hit it with a hammer until it fits”.
Try concatenating by first converting number fields to text using a custom text field and a formula. [Custom Text Field]= [Number Field]. Then concatenate Text Fields using a formula with the text fields and + sign in between. You can enter your letters on a text field, a formula or any other way it occurs to you. Seems like the trick is converting number fields into text fields and then use these new fields ito concatenate on a separate custom text field.
Member for
15 years 9 monthsHi Colin and Rafael, Thank
Hi Colin and Rafael,
Thank you for this lovely information.
This helps me a lot.
It seems that there is no limit to knowledge and good ideas in this community
Regards
Dan
Member for
21 years 8 monthsUsing Hammer’s Rule
Using Hammer’s Rule, “if won’t fit hit it with a hammer until it fits”.
Try concatenating by first converting number fields to text using a custom text field and a formula. [Custom Text Field]= [Number Field]. Then concatenate Text Fields using a formula with the text fields and + sign in between. You can enter your letters on a text field, a formula or any other way it occurs to you. Seems like the trick is converting number fields into text fields and then use these new fields ito concatenate on a separate custom text field.
Member for
21 years 6 monthsHi Dan I can get the prefix
Hi Dan
I can get the prefix but not the automatic generation (as in P3) I use MS Project 2003
First I added 3 new fields Text 1 & Text 2
Changes the tiltle of Text 1 to New unique ID
Text 2 will st the KF identifier
I then Right clicked on Text 1 and selected Customized Fields (make sure Text 1 is selected)
Then Select Formula
Then Type
([Text2] & "-" & [Unique ID])
Click OK
(Create a new Table)
View - Tables - More Tables
Click Copy
Then Click Edit
Delete old ID & replace with Text 1 (tick lock 1st column)
Hope this helps
Colin