Could I use a IronPython script to generate controls in text area?

[Mark123]

Hello,eyeryone

    Now in a text area, many controls need to be created, such as drop-down lists.
    I don't want to create them one by one with using the built-in controls, but rather generate them directly through IronPython script.
    Is there a way to achieve it?

[Niko Maresco]

hi Mark,

unfortunately there are no APIs for instantiating Action or Property Controls or Dynamic Items :/

there is an entry in the Spotfire Idea Portal for this functionality, and i recommend voting for it so that it becomes a higher priority for the product team: https://ideas.spotfire.com/ideas/SPF-I-330

[Mark123]

9 hours ago, Niko Maresco said:

hi Mark,

unfortunately there are no APIs for instantiating Action or Property Controls or Dynamic Items :/

there is an entry in the Spotfire Idea Portal for this functionality, and i recommend voting for it so that it becomes a higher priority for the product team: https://ideas.spotfire.com/ideas/SPF-I-330

I got it.Thank you.

[Jose Leviaguirre]

As a work around, you can create html5 controls such as range sliders, dropdown, input, etc. and then parse those values to a single string document property in which you can later parse using Iron Python to fulfill your needs. Populating the controls can be tricky when you deal with large amounts of data.

 

createJSControls.js  textarea.html.txt  parseData.py.txt JavaScript_Contorls_to_Document_Properties.dxp

Edited August 24 by Jose Leviaguirre

[jojojo]

Thank you for the good information.

Is there a way to use iron python or javascript to quickly create text with '|' from the data table as written in textarea.html?

[Mark123]

Nice weekend,Jose.

This method is quite complicated, so I'd rather choose to create it one by one with built-in controls.
But this method is an inspiration for other developments, thank you very much.

[Jose Leviaguirre]

On 8/24/2024 at 8:30 AM, jojojo said:

Thank you for the good information.

Is there a way to use iron python or JavaScript to quickly create text with '|' from the data table as written in textarea.html?

you can replace the pipe separated values with pipes "|" using a custom expression and place it as a label control on the text area

<pre id="data" xhidden>City|State|Latitude|Longitude|Population|Average Temperature (F)|Air Quality Index|Observation Date
<SpotfireControl id="label Property control here" />
</pre>

Custom expression for the label property control
 

Substitute(UniqueConcatenate(
[City] & "|" 
& [State] & "|" 
& [Latitude] & "|" 
& [Longitude] & "|" 
& [Population] & "|" 
& [Average Temperature (F)] & "|" 
& [Air Quality Index] & "|" 
& [Observation Date]),", ","\n")