A better way to pull a value from DataMaster to be used in a formula?

Answered Ivan Kandi ● 6 years ago

Good morning,

I have a question. I'm working on a dynamic chart with vertical bars, the height of these bars are determined by two values in DataMaster, Rate and Height. Each bar represents a rate, ie: if the rate is 10%, then the height of the bar is 100px.

The way I'm doing it right now is just complicated. I'm looking for a better way to do this.

1. Let's say I have 10 bars, each bars is loaded with onPageLoad, so when it's loaded it will resize the bar accordingly.

2. The first event I assigned is SetValue to a dynamic panel with an inputTextfield that I hide. The purpose is to spit out the height value from the DataMaster. The way I'm doing it is to filter the DataMaster FT [ Rate.value [ rate = '5% ]] . What is so complicated with this method is I have to create 10 dynamic panel with input text field for each of the bars. So each bars have an assigned height to it. Also I have to manually change the rate value in the filter for each bar ie: 5%, 6%, 7% etc

3.Then the second event is the resize.

Questions:

1. Is there a simpler way of doing this? I'm trying to make this more scalable and easier. ie: in the actual programming I can do for loop to simplify things.

2. If I need to pull out a certain value from DataMaster to be used in a formula, can I do it without spitting the value into a dynamic panel first?

Thank you