# Change Vision Table max/min progress bar range using scripting

**URL:** <https://forum.inductiveautomation.com/t/change-vision-table-max-min-progress-bar-range-using-scripting/50778>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [September 9, 2021, 2:47pm UTC](https://forum.inductiveautomation.com/t/change-vision-table-max-min-progress-bar-range-using-scripting/50778 "2021-09-09T14:47:25Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![william.thompson3](https://avatars.discourse-cdn.com/v4/letter/w/7ba0ec/32.png) [@william.thompson3](https://forum.inductiveautomation.com/u/william.thompson3)\
**Post date:** [September 9, 2021, 2:47pm UTC](https://forum.inductiveautomation.com/t/change-vision-table-max-min-progress-bar-range-using-scripting/50778/1 "2021-09-09T14:47:25Z")

</div>

Using Ign 8.1 and would like to change the range (min/max) of a Vision table progress bar using a script. I need it to change dynamically when a different product is switched to in production. The min/max range is not showing up in the Column Attributes Dataset.

---

<div class="post-metadata">

**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Post date:** [September 9, 2021, 7:00pm UTC](https://forum.inductiveautomation.com/t/change-vision-table-max-min-progress-bar-range-using-scripting/50778/2 "2021-09-09T19:00:01Z")

</div>

min/max should be in the properties of the component if i remember correctly. You should be able to bind them either to a tag or tag change event.

---

<div class="post-metadata">

**Author:** ![leonardo.godoi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/leonardo.godoi/32/27178_2.png) [@leonardo.godoi](https://forum.inductiveautomation.com/u/leonardo.godoi)\
**Post date:** [September 9, 2021, 7:57pm UTC](https://forum.inductiveautomation.com/t/change-vision-table-max-min-progress-bar-range-using-scripting/50778/3 "2021-09-09T19:57:10Z")

</div>

Hi William, i’ve tried on my end and i was able to find the property on the Column Attributes Dataset, it’s called “progressRange” but it’s in a weird string format.  
Since you’ve asked for a script, this should do it:

```auto
#Get a refference to your table dataset with column atributes

columnAtributes = YourTablePath.columnAttributesData
newMax = 200 #Your new max value
newMin = 50 #Your new minimum value
columnNumber = 0 #Number of the column that's your progress bar. 0 Based.
changes = {'progressRange':
		  '<doubledimension><width>%d</width><height>%d</height></doubledimension>'%(newMin,newMax)}
YourTablePath = system.dataset.updateRow(columnAtributes,columnNumber,changes)

```

You can achieve a similar result by using a cell update binding on the Column Attributes Dataset and bind it to a custom property with an expression similar to this:

```auto
 '<doubledimension><width>' +
 {Refference to your Min here} +
 '</width><height>' +
 {Refference to your Max here} +
 '</height></doubledimension>'

```

---

<div class="post-metadata">

**Author:** ![william.thompson3](https://avatars.discourse-cdn.com/v4/letter/w/7ba0ec/32.png) [@william.thompson3](https://forum.inductiveautomation.com/u/william.thompson3)\
**Post date:** [September 9, 2021, 11:57pm UTC](https://forum.inductiveautomation.com/t/change-vision-table-max-min-progress-bar-range-using-scripting/50778/4 "2021-09-09T23:57:47Z")

</div>

Thank you, I hadn’t thought of that. Best

---

<div class="post-metadata">

**Author:** ![william.thompson3](https://avatars.discourse-cdn.com/v4/letter/w/7ba0ec/32.png) [@william.thompson3](https://forum.inductiveautomation.com/u/william.thompson3)\
**Post date:** [September 9, 2021, 11:59pm UTC](https://forum.inductiveautomation.com/t/change-vision-table-max-min-progress-bar-range-using-scripting/50778/5 "2021-09-09T23:59:13Z")

</div>

Thank you Leonardo. I will give these ideas a try. Best