Selecting one pull down Ticket Field from another
I'd like to be able to select one pull down field from another. Here's the scenario:
Our company has Regions, Districts and Stores. If I select the pull down with the store, I'd like to automatically select the correct region and district.
Anyone do this before?
thanks
-
You could create a trigger that says:
ALL
Ticket | Is | Updated
ANY
Store | Is | X
Store | Is | Y
ACTION
Region | Is | Z
Then another trigger for region
ALL
Ticket | Is | Updated
ANY
Region | Is | X
Region | Is | Y
ACTION
District | Is | Z
This may result in a lot of triggers.
Alternatively you can use categories in your drop-down. Name each option something like District::Region::Store and you'll be able to nest down to the store level on each option. The double colon creates a folder structure on the field. It's a bit harder to report on the top levels, but it's doable.
-
Thanks Dan! That gives me some good direction.
Vous devez vous connecter pour laisser un commentaire.
2 Commentaires