Set field value
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
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.
<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?
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?
If you would like to submit an answer or comment, please sign in to the eOne portal.
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?
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)