Activity id increment
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
You are welcome.
Thanks a lot sir,
Its working..
I ve thought of doing it in P3 and then import to P6.
But now I have got the Solution.
Thanks & Regards,
Anbin
Hi Anbin,
Try this.
If Activity id contains P1-ST1-S1
Then:
user_text1 = LeftString(Activity ID,3)
user_text2 = SF1 & SubString(Activity ID,7,12)
Activity ID = user_text1 & user_text2
Let me know if you have done it.
Regards,
Arnold
Thanks Sir,
I have listed my activity id as P1-ST1-S1-01....etc till 70
P1 for Phase 1
ST1 for Students Housing
S1 - Stage 1
Now while incrementing for next phases and other housings I followed your first advice and I have done it.
When I tried to modify it If suppose I have to change the Code ST1 as SF1 ,I tried with global Change I could not do it.
I used as,
If Activity id contains P1-ST1-S1
Then,
Activity id eq P1-SF1-S1.
Its comitting change only for the first one ie,P1-ST1-S1-01
and others 02,03 .. remains the same.
I tried with user defined field also..
Regards,
Anbin
Hi Anbin,
It is possible. There are lot of approach and steps you can perform.
1. Filter first all the group of activities prior to perform global change. In this case, no need for you to utilize the If statement.
2. Use only the LeftString, RightString & SubString Parameters and the operator of "&".
Cite an example and I will tell you how.
Regards,
Arnold
Thanks Sir,
Changing the Activity id globally wheather its possible?
I ve tried with different (If then Statements),But error occurs.
How to Modify activity id only for some particular group of activities.
Hi Anbin,
First of all welcome to Planning Planet.
Go to project details --> defaults tab, under auto-numbering defaults, change the activity prefix, suffix and increment depending on your requirements.
Untick the checkbox next to "Increment Activity ID based on selected activity".
Go back to activities window and start copying and pasting.
Regards,
Arnold