Skip to main content
  • EN
Choosing parameter value from a list stored in an Excel field,

 

 

I couldn’t figure out how the a parameter value can be selected from a list saved in an Excel table

 

 

For example, in the screenshot below, I wanted to choose the “PlanType” value from the shown Excel table

 

 

 

 

 

How this might be accomplished?

 

 

 

Thank you

 

 

Best

 

 

Jamal
Hi Jamal,

 

 

If you choose "Choice" as the parameter type, you can import the Excel list to its choices. Note that the configuration is static. After you once imported, the configuration will not be changed even if you change the original Excel list. You should import again or edit directly, if necessary.

 

 

Takashi
Perfect. Many thanks Takashi for the help.

 

 

I would prefer it to be dynamic such that if any change occur in the excel, it will be reflected on the list.

 

 

However, it is great now. I can live with it

 

 

Best

 

 

Jamal

 

 

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.