+1-888-319-3663

COMMUNITY FORUM

Set field value

BLChan asked 10 years ago

I have an extender form to store Progress ID (key), scheduledPercentage. In another form, I create a lookup field on Progress ID.

I need to display the schedulePercentage value (read-only) after selecting a progress ID from the lookup. I tried the Set field value but cannot get done.

Please advice the correct way to do it. Thanks

Nicole replied 10 years ago

Couple of questions for you to try to help out with an example on how to call the schedulePercentage.

1. What version of Extender are you using?
2. Is the schedulePercentage the Description Prompt or just a field on the form?

BLChan replied 10 years ago

hi Nicole,

1.) This is what I see in "About Extender"
Version:12.00.0232.000 Microsoft Dynamics GP Extender: 12.00.0080

2.) The schedulePercentage is a field on the form (data type – number)

Answers

0 Vote Up Vote Down

Best Answer

Nicole answered 10 years ago

You can try using an action running Dynamics GP scripting with something like the script below to pull in the field from another form.

local long VARIABLE;

VARIABLE= GetRecordID("FORM_ID", <Field1>, "") of form ExtenderDataObject_Form;
<Field2> = Get_Description(VARIABLE) of form ExtenderDataObject_Form;

In the above script, you would want to replace the following variables with the appropriate values.
VARIABLE = replace with the name of a variable for your field.
FORM_ID = replace with the name of the form you are pulling the data from.
<Field1> = replace with the parameter (from the right side of the window) of the field looking up the Progress ID
<Field2> = replace with the parameter (from the right side of the window) of the field to pull in the scheduldPercentage

If that doesn't work or you aren't able to figure out the script, you may want to create a support case as we may need to look at the setup of your forms to understand how the fields are all setup and the best way to call them.

BLChan replied 10 years ago

<Field2> is a number type field in my calling form that is suppose to display the percentage value after I select a progress ID from the Progress ID lookup

I got the error message "Type incompatibility 'i486'

Btw, I cannot find the syntax of GetRecordID nor Get_Description. Aren't they sanscript function?

Thanks

BLChan replied 10 years ago

hi Nicole,
I figured out that Get_Description returns the description of the Progress ID.

However, the percentage is not the "description" field, it is a number type field in the Progress form. Is there anything like Get_Field function that allows me to return a field's value?

Thanks

If you would like to submit an answer or comment, please sign in to the eOne portal.