How about creating a date field, named "
Restricted Intro Date", not visible to users?
Create a rule or change notification that will always copy the value from
Intro Date into
Restricted Intro Date when Product Status is not a "locked value".
When the Product Status is set to the locked value, reverse the rule... now
Intro Date mimics the final entered value of
Restricted Intro Date. Every time a user tries to change the value of
Intro Date while
Product Status is
N or
R, they won't be able to because the system will simply ignore the new entry in favor of what's in the
Restricted Intro Date field.
Would that work?
------------------------------
Jon Varo | Manager - Master Data and PIM Teams
Fender Musical Instruments Corporation | (480) 845-5823
------------------------------
Original Message:
Sent: 02-07-2023 10:59
From: Ruthy Sleeth
Subject: editing an attribute based on the value of another attribute
Hi Jon,
Thank you for the suggestion – it's close. You are correct in that we want the user to be able to edit the Intro Date only when Product Status equals N or R, however, Intro Date always needs a value. Intro Date can be updated when the Product Status is N or R, but once the Product Status is A, then Intro Date can no longer be updated.
So to create a rule to error when the Product Status = A and Intro Date was changed from one value to another. I don't know how to do this last part.
Thanks
Original Message:
Sent: 2/7/2023 10:38:00 AM
From: Jon Varo
Subject: RE: editing an attribute based on the value of another attribute
Hi Ruthy,
It sounds as if you're wanting to adjust the Attribute Security Filter in real time, which I've never seen in my experience (unless EW has a trick up it's sleeve that I'm not aware of.). To go over the need here, essentially, you want Intro Date to be available only when Product Status equals N or R. Correct?
What you can do is create a rule that will cause a validation error if Intro Date has a value in it when Product Status does not equal N or R. At least, the system will throw an error and the explanation as to why the rule is there will be available for the user to read.
Does that work?
Best,
-Jon
------------------------------
Jon Varo | Manager - Master Data and PIM Teams
Fender Musical Instruments Corporation | (480) 845-5823
Original Message:
Sent: 02-03-2023 11:13
From: Ruthy Sleeth
Subject: editing an attribute based on the value of another attribute
Hi All,
is there a way to make an attribute editable based on the value of another attribute?
we want users to be able to edit an attribute in the Product repository called "Intro Date" ONLY when another attribute in the Product repository called "Product Status" equals N or R.
is this possible?
thanks!
Ruthy
------------------------------
Ruthy Sleeth | Business Process Analyst
New Pig | 814-686-2254
------------------------------