Activity id increment

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

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,

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,

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,

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 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

You are welcome.