How to determine what object a Note (update ) is attached to?

[GeraintJo]

Hi,

I've created a FUSION scenario that listens for Notes being added, and if they are done by certain user groups, and the task/project is in a certain status - it updates that status to be 'Updated by Stakeholder'

I'm nearly there but have struggled to clearly identify what object the note is attcahed to - project, task, document attached at project level, document attached at task level.

The 'noteObjCode' seems to be right for when the note is attached to a document or task.

But when i add a note to a Project - the' noteObjCode' isn't getting set to 'PROJ'

I'm having to check - if the documentID and TaskID  for the Note are NULL - then I'm assuming it's attached to a Project.

Can anyone offer any other help ?

[imgrund]

Hi GeraintJo - On the Note object, there actually is projectID. I did a quick report to confirm that the Project ID appears when it is on a project directly as well as when it is a task or document note.  

[GeraintJo]

Thanks,

but that still doesn't give me clear logic to define when it is an update added to a project - rather than an update added to a document attached to the project for example

[imgrund · Accepted solution]

If projectID is not blank and noteObjCode is blank, then it is a project update.  

[GeraintJo]

Thanks v much.

It is strange that the 'noteObjCode' doesn't work when the note is attached directly to a project.

[imgrund]

Agree, very strange!