[rt-users] Best way to make one custom field change, based on entry in another, using a many to one scenario

[Kevin Falcone]

On Fri, Jul 15, 2011 at 12:13:52PM +1000, Roger Lockerbie wrote:
>    To set the scene, I'm after a user being able to set the newspaper masthead they work for via
>    a  populated dropdown custom field, many mastheads may map to one database, and one terminal
>    server so something like
> 
>    Masthead,Database
>    Border Mail, RegionalDB
>    Ballarat Courier, REgionalDB
>    SMH, MetroDB
>    TheAge, MetroDB
>    Mercury, MetroDB
> 
>    CF1 would be where you select the masthead, CF2 would result in showing the associated
>    Database.
> 
>    Note that there could be hundreds, and they may change regularly hence the desire to provide
>    some sort of CRUD interface rather than hand coding it within a Scrip.
> 
>    Any suggestions/pointers would be gratefully received.

You may be able to do some of what you want with Linked customfields
and/or external custom fields.  You should see the linking mechanism
in the Admin UI when you have a select one custom field, and you can
find external custom fields documentation in the docs directory.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110718/cf415ce2/attachment.sig>