Personalization, Customization and Productivity Tools

[dosborn]

Is there anyway to create a drop down that pulls its list of items from an external source and stores what the user selects into a UDF?

[Gator]

Maybe, and it would be a lookup, not a dropbox.

If you maintained a UDT that would be the validation for the UDF field, then this would work.  So how do you maintain this UDT if the external source changes?

Using BOI, you can refresh the UDT with a script, or you can have a User-Defined Script attached to a button in MAS that would have to read the external source and refresh the UDT.

Not sure if this would fit the business requirements that you need or not though.

[dosborn]

Can you programatically invoke a look up?  What I am thinking is have a button that is clicked, a script behind it populates the external data, then the script invokes the lookup.  Does this seem possible?

[Gator]

Maybe Elliott can answer that.  I know in ProvideX you can do this, but I'm not sure it can be done on the vbscript side.

[BigLouie]

Actually this was one of the early scripts that was written. A long thread on the old Sage Talk discussed how to do this. The person who detailed how to do it was Slade. Alas retrieving this is not going to be easy as Sage Talk is no more and Slade has faded away. Maybe some old timers remember how to do this.