I am using a dataset tag as a "lookup table" to change the background color of a label. [image] So I want to bind an expression to the backgroundColor of a label. Here is some pseudo-code of what I am looking for (assume 'dataset' refers to the pictured dataset above): subassembly = '720342' row…

Use a lookup() expression. lookup | Ignition User Manual This looks for lookupValue in the lookupColumn of dataset. lookup({'path/to/dataset/tag'},'720342',color(250,250,251),'Subassembly','Color')

Use this: lookup | Ignition User Manual This looks for lookupValue in the lookupColumn of dataset. (Expressions are not scripts.)

lookup() will also work a lot better if the dataset is sorted on the lookupColumn.

I should also say, that you may need to do some work to convert the java.awt.color type that you are providing into CSS compatible with perspective styling.

What would the syntax look like for my path to dataset tag? I've worked out some other issues and I'm still getting an error with this expression. I used {'[edge]Subassembly_lookup'} [image] But every other time I've seen lookup() used in other examples, the dataset tag is specified by {Root Con…

You'll want to bind the dataset to a custom property on your view, then reference that property in your expression. While there's a way to directly reference a tag, it's slow and not recommended doing it that way.

Is this related to your other post? [image] Issue with lookup() in tag change script Ignition I'm trying to use lookup() in a tag change script to assign a string value to a memory tag based on the results of a lookup in a dataset tag. My script is showing an error in the…

What is the syntax for referencing a custom property, specifically a dataset?

{path.to.component.customProperty}. Consider browsing inductive university/the docs. Expression Language and Syntax | Ignition User Manual Expression Language For a script the path is the same, just minus the curly braces and you use .getValueAt(row, col) t…

When building your expression, you'll be able to directly browse to it. The exact path/syntax you'll need varies depending on where you bind it, but if you put one on the view named myDS then it would be named {view.custom.myDS} in your expression.

Get Row Index of Dataset Tag

Ignition

JordanCClark September 30, 2024, 8:51pm 8

Is this related to your other post?