OnPublished /OnPublishing event

[question]

Hi,

I have requirement to populate a task level custom field with the values
taken from a project level custom field, when the user publish a project.
I tried writing a database update in onpublished event, but since after the
change, we r not publishign the chages, these changes are not visible.

Can I do it in onpublishing event, if yes how.
Any pointers would be helpful.

Thanks.

 

[Jonathan Sofer]

What is the true requirement here? Maybe there is another way to accomplish
what you are truly trying to achieve here.

Sounds like you are trying to populate a custom task field with a value from
a custom project field. This means that all tasks would have the same
value. Is this for reporting purposes?

 

[question]

yes,
I need to display a project level custom field in resource assignment view(
When creating this view, it only takes task and assignment fields and not
project fields).
It is fine to for all task to have the same project level custom field
value. Can you suggest any way to achieve this?

 

[Jonathan Sofer]

Yes, all you need to do is create a custom enterprise task field and set the
formula equal to the name of the project level field.

For example if you had a project dropdown field called "Business Alignment",
you would create a custom enterprise task text field and the formula would
be =[Business Alignment]

In any project now, each time you make a change to the project level field
value, that change will be automatically reflected in the task level field
value.

 

[question]

Thanks, that works for me.

Yes, all you need to do is create a custom enterprise task field and set the
formula equal to the name of the project level field.

For example if you had a project dropdown field called "Business Alignment",
you would create a custom enterprise task text field and the formula would
be =[Business Alignment]

In any project now, each time you make a change to the project level field
value, that change will be automatically reflected in the task level field
value.

--
Jonathan Sofer [MVP]
http://www.epmcentral.com

yes,
I need to display a project level custom field in resource assignment
view(
When creating this view, it only takes task and assignment fields and not
project fields).
It is fine to for all task to have the same project level custom field
value. Can you suggest any way to achieve this?

 

[question]

Hi,

I have another issue with this approach.
I have a project custom field which is asociated with a look up table. So
when I create a task custom field with formula as =[proj custom field] , this
is not getting populted. It shows the value ERROR.

Can you help me with this.

Thanks.

Thanks, that works for me.

Yes, all you need to do is create a custom enterprise task field and set the
formula equal to the name of the project level field.

For example if you had a project dropdown field called "Business Alignment",
you would create a custom enterprise task text field and the formula would
be =[Business Alignment]

In any project now, each time you make a change to the project level field
value, that change will be automatically reflected in the task level field
value.

--
Jonathan Sofer [MVP]
http://www.epmcentral.com

yes,
I need to display a project level custom field in resource assignment
view(
When creating this view, it only takes task and assignment fields and not
project fields).
It is fine to for all task to have the same project level custom field
value. Can you suggest any way to achieve this?

:

What is the true requirement here? Maybe there is another way to
accomplish
what you are truly trying to achieve here.

Sounds like you are trying to populate a custom task field with a value
from
a custom project field. This means that all tasks would have the same
value. Is this for reporting purposes?

--
Jonathan Sofer [MVP]
http://www.epmcentral.com


Hi,

I have requirement to populate a task level custom field with the
values
taken from a project level custom field, when the user publish a
project.
I tried writing a database update in onpublished event, but since after
the
change, we r not publishign the chages, these changes are not visible.

Can I do it in onpublishing event, if yes how.
Any pointers would be helpful.

Thanks.

 

[Jonathan Sofer]

Referencing a project custom field that uses a lookup table in a task
formula should not be a problem at all. The ERROR could be due to the auto
calculate either not being on or not being initiated on the project plan.
Try hitting the F9 key which forces a calculation to see if the data
populates then.

If not, then we can do some more investigating.

--
Jonathan Sofer [MVP]
http://www.epmcentral.com

Hi,

I have another issue with this approach.
I have a project custom field which is asociated with a look up table. So
when I create a task custom field with formula as =[proj custom field] ,
this
is not getting populted. It shows the value ERROR.

Can you help me with this.

Thanks.

Thanks, that works for me.

Yes, all you need to do is create a custom enterprise task field and
set the
formula equal to the name of the project level field.

For example if you had a project dropdown field called "Business
Alignment",
you would create a custom enterprise task text field and the formula
would
be =[Business Alignment]

In any project now, each time you make a change to the project level
field
value, that change will be automatically reflected in the task level
field
value.

--
Jonathan Sofer [MVP]
http://www.epmcentral.com


yes,
I need to display a project level custom field in resource assignment
view(
When creating this view, it only takes task and assignment fields and
not
project fields).
It is fine to for all task to have the same project level custom
field
value. Can you suggest any way to achieve this?

:

What is the true requirement here? Maybe there is another way to
accomplish
what you are truly trying to achieve here.

Sounds like you are trying to populate a custom task field with a
value
from
a custom project field. This means that all tasks would have the
same
value. Is this for reporting purposes?

--
Jonathan Sofer [MVP]
http://www.epmcentral.com


Hi,

I have requirement to populate a task level custom field with the
values
taken from a project level custom field, when the user publish a
project.
I tried writing a database update in onpublished event, but since
after
the
change, we r not publishign the chages, these changes are not
visible.

Can I do it in onpublishing event, if yes how.
Any pointers would be helpful.

Thanks.