You can help by commenting or suggesting your edit directly into the transcript. We'll review any changes before posting them. All comments are completely anonymous. For any comments that need a reply, consider emailing training@inductiveautomation.com.
Version:
LESSON LIST
-
2:47Property Binding
-
2:15Property Binding – Bidirectional
-
2:19Tag Binding
-
2:17Tag Binding – Drag and Drop
-
2:19Tag Binding – Bidirectional
-
1:40Tag and Component Overlays
-
3:20Indirect Tag Binding
-
2:17Tag Historian Binding
-
3:21Expression Binding
-
1:24Expression Binding – Concat Strings
-
1:01Expression Binding – Celsius to Fahrenheit
-
2:01Expression Binding – Format Date
-
2:46Expression Binding – Date Manipulations
-
1:23Expression Binding – Bit Functions
-
2:06Expression Binding – Switch
-
1:43Expression Binding – Checking Conditions
-
2:40DB Browse Binding
-
2:05DB Browse Binding – Dynamic Filters
-
1:16SQL Query Binding
-
2:26SQL Query Binding – Polling
-
1:47SQL Query Binding – Dynamic Filters
-
1:55SQL Query Binding – Scalar Query and Fallback
-
1:47SQL Query Binding – Scalar Query and Update
-
2:24Cell Update Binding
-
2:07Function Binding
-
4:22Component Styles
Take Topic Challenge
Supplemental Videos
-
2:27Named Query Binding
LESSON
Cell Update Binding
Description
The Cell Update binding enables you to easily make one or more cells inside a dataset dynamic. This is particularly useful for components such as the Linear Scale or the Easy Chart, that store configuration information inside datasets.
Video recorded using: Ignition 7.7
Transcript
(open in window)[00:00] The cell update binding enables you to easily make one or more cells inside of a data set dynamic. This is be useful for components such as linear scale or the easy chart since they store configuration information inside those data sets. So here for example, I've a linear scale on my window. I can right click on the component and go to customizers, scale indicators to add one or more indicators. As you can see, I have two right now, low and high. The low is at a value of 15 and the high is at a value of 85. I can certainly add another indicator like an arrow, and I can put the arrow at value 65 here. As soon as I press okay, I can see all the indicators and all these indicators are actually stored inside our property over here called indicators. It's a data set. If I look inside a data set, I can see that there are three rows, for each of the different indicators, and the actual values are inside of this data set. It is possible to bind each individual value to a tag or to a property on the screen. We can do this by binding the indicator's data set to a cell update binding. The cell update binding only exists for data sets. As you can see here at the top, we're going to see what the data set looks like right now. So here I can see all three of my indicators. Each one of these I can actually bind to a tag or to a property individually. So I click on 15, I can press the plus icon down the bottom right to add it to the cell bindings. So basically, at row zero for column value, I'm going to link that to whatever the value I have over here. So I can actually click on that row and link it to a property or to a tag. Let's say we're going to go to a tag. So here in a tag, I'm going to expand it. I'm going to basically say, this is my low set point. I'm going to do the same thing for the 85. This is my high set point. Click on 85, press the plus icon to add it down below. Click on that row and then link it to a tag. This time I'm going to select the high set point. And lastly, the arrow. Click on 65, add it down below, click on that row and go and link it to a tag, selecting the arrow value. So essentially, we can link one or more cells to properties or to tags, making them all dynamic. As soon as I press okay, I'll see these values come through on my linear scale. As you can see, the arrow is actually changing for us automatically since the tag values changing. If I go over here to my tag and change my low set point to a value of 25, you're going to see the green line jump up. Same thing with the high set point. If I set it to a value of 60, I'm going to see it jump down. So it's very easy to modify or to link these values inside of a data set to a tag or to a property.