In Extender, we’ve created an Extender Form for states that we are going to attach to our new Extender Data form as a Lookup Field.
In this simple example, the “lookup field” will be a 2 letter State Code and then the spelled-out State Name.
On my new Extender Data form, the intention would be use add new data fields to “look up” that data which works fine per the screenshot.
However, what would be useful is if we could see the Description/State Name as well in the new Extender Form.
Extender Form
While Extender Enterprise does have scripting and action capabilities, that won’t be required to solve this issue.
The easiest way to use a lookup field and also to display the description of that is to put the field on the left side of the Extender window/form instead of the right side.
If the column on the right side of that row does not have a field created, Extender will automatically add a read-only string to show the field/form description – the full State Name in this example.
If we would prefer the field to be on the right side (or perhaps we will use all 30 fields in Extender), then the suggested method to add the Description field would be to create a calculation to do this for us.
In the calculated field, we could write our own SQL to query the EXT01200 table to find data, but we don’t have to because Extender will do it for us!
Browsing the Fields on the right side, we can find our “State2”, which is the Lookup field used here, and then choose the State Name (which is the Description field of that form).
By selecting it in this manner, Extender will actually write the “SQL lookup code” for us to find the data for our selected state.
This also works if we add a State Lookup field to the Grid/Scrolling window in the Options window as shown here.
Here, Column 1 was added for “Additional States” using the same lookup form, and a Column 2 calculation for “Additional State Names” was added, again selecting the “State Name” field from the Form Lookup field in the scrolling window.
After creating the lookup and corresponding calculated field for the scrolling window, we use the form and add some data to it, and we can see that Extender shows our descriptions/names as expected for all state lookup fields added.
If you have any questions on how to get your form description to display correctly in Extender, please contact us, and our team will be happy to help.
