Skip to content
+1-888-319-3663

COMMUNITY FORUM

Set field value

BLChan asked 8 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 8 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 8 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
Best Answer
Nicole answered 8 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 8 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 8 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.