Quick Tip for Troi Dialog Plugin...

[Ocean West]

Suppose you have a field let's call it Product_Code and another field Product_Description in a typical user interface you would have the field defined as a popup list or menu on a layout you would show a value list of the codes and also a the description so it is more human readable. This is typical for using a layout but what about with a plug in.

Since lookups are based upon the Product_Code and don't have users entering into the description field, defining the plug in to show only the codes, it's not very rememberable, here is a way to make it more useable.

In the file where the list is looked up from create a field like this, use this field when you define your dialog.

FieldForPlugin: Result: Text

Product_Description & " ("& Product_Code & ") "

Left Handed Widget (2024)

Right Handed Widget (2078)

Then when you use the External Function to get the text from the plug in you convert it to a number positive. And then set it into the appropriate field.

Abs(TextToNum(External("TrDl-GetInput", "-text1")))

The result would be "2024" if you chose Left handed Widget as per this example.

Enjoy.