Skip to Content
0
Former Member
Jan 22, 2009 at 07:53 PM

Adding data from the record to notifications (emails) going out to the user

40 Views

Hello all,

We have a process where users can request a new material from our master data "approver". When they do so, they should leave the material number blank, and we have a validation to make sure they do leave it blank (which will come up later).

When the "approver" approves the new material request, he enters the Material number and Communicates the Decision in Workflow. This sends an email to the requestor notifying them that their material has been accepted (and will get syndicated to ECC), and triggers the syndication to ECC.

We would like to include the Material number in the email to the user. But, the documentation regarding Notifications seems to indicate that the only way to include data in the email is via the %Records% variable. And, that seems to only pull in the Display fields.

I changed the Material to a Display field, and it then comes across on the email. But, it causes issues with the validation I mentioned earlier. The validation that ensures the requestor leaves the Material blank doesn't work. It pops up the error message, even if the material is blank. The only way to not get the error is to do the following:

1. enter a character in the material field, then save (getting the error)

2. Delete the character that was just entered in the material field.

3. When saving after deleting the character, I don't get the Validation error.

The validation works well if the Material is not a Display field, but has issues if it is a Display field. Does this sound like a bug I should enter an OSS note about? Or, is it just an issue with how Display fields work? Everything I've read about Display fields talks about them being a reference to the whole record (almost like a key).

Please let me know your thoughts. And, please let me know if you know of another way to get data from the main table into an email / notification.

Thanks,

Chuck