Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Populating an Extender field with the “Description” of Another


Have you ever wanted to have a lookup on an Extender Form/Window and then populate another field with the description for that lookup?

Example 1:  I have Column 2, Row 1 on my form doing a lookup to the Customer Number.  I want Column 2, Row 2 to show the Customer Name automatically so I don’t have to type it in manually. 

Populating an Extender Field

The first thing to note is that to do this, it will require Extender Enterprise to do this.

To complete this setup, you will need to setup an Action.  Here are the steps to do that.
  1. On your Extender Window, click the Actions button.
  2. In the Extender Actions Window, click the Add button.
  3. In the Add Actions window, set the Event Type to “Change field value” and the Field to Customer Number.
  4. Click the Add button and select “Run Dynamics GP script”.
  5. In the Enter Script window, enter the following script.
    • clear table ‘RM_Customer_MSTR’;
      ‘Customer Number’ of table ‘RM_Customer_MSTR’ = <Customer Number>;
      get table ‘RM_Customer_MSTR’;
      <Customer Name> = trim(‘Customer Name’ of table ‘RM_Customer_MSTR’);
      close table ‘RM_Customer_MSTR’;  
  6. Validate the script and click Save on the Enter Script window.
  7. Click Save on the Add Actions window and OK on the Extender Actions window.  
  8. Save your Extender Window and test out the new action to see if the Customer Name automatically populates when you select a Customer Number.  On a window you will automatically 
Populating an Extender Field



Another example, I have an Extender Form where the ID Field Prompt is using a lookup to the Customer.  I want the Description Prompt to show the Customer Name.  If you are using Microsoft Dynamics GP 2018, later versions of 2016 or the latest version of 2015, there is already a feature included that will populate the Description Prompt with the Name field for the ID lookup that you select.  If you are on an earlier version, you can use the same script included in example one.

NOTE:  The script used here can always be edited to match the fields you are using.  It doesn’t have to be for the Customer Number/Name combination.   Here is another example for the Employee ID/Name combination.
clear table ‘UPR_MSTR’;
‘Employee ID’ of table ‘UPR_MSTR’ = <Employee ID>;
get table ‘UPR_MSTR’;
<Employee Name> = trim(‘First Name’ of table ‘UPR_MSTR’) + ” ” + trim(‘Last Name’ of table ‘UPR_MSTR’);
close table ‘UPR_MSTR’;


If you have any more questions about populating an Extender field with the description of another, or anything regarding Extender, feel free to reach out to us here.

2 Comments

  1. Don McNulty on June 13, 2023 at 3:23 pm

    i have a extender field under the customer address called prepaid. it stores an amount.
    on the Sales order we want to add a field called prepaid to the header and default the customer address prepaid amount to this header record when first entered. The user can then update as required at the transaction level not affecting the customer address. can we do this with out customization

  2. Patrick Roth on June 30, 2023 at 9:30 am

    Don,

    No, you would need to use an event to populate this value meaning you would need Extender Enterprise.

    In your code, you’d have to read the Extender Data to pull in that “prepaid” value from the customer address extender info.

    And then populate the Extender Data for the SOP record.

    If you want this to default w/o having to open up the Extender WIndow, you probably could do that but you end up having to write that new SOP Extender record yourself (since it doesn’t exist yet).

    If you would make your user open up the Extender window, then its a bit easier since you just set it on the UI and the user presses Save manually so Extender has to write that record.

    patrick

Leave a Comment





RECENT POSTS


Join Us in Chicago at the Zendesk Showcase!
Tech Tuesday: Popdock - Joining the tale of two States
Meet eOne Solutions at Directions EMEA 2023!
Connect with eOne Solutions at SuiteWorld 2023!
What is a Data Lake/Data Lake Management?

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce Salesforce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.