Column Binding Based on Another Column Same Row

Ignition
1

Gurus,

What's the best way to achieve this ?

image
image564×170 2.28 KB

I want to enable/disable the checkbox based on the same row column value.
according to the image posted, i want "From Something" to be based on "Something"

My colleague pointed me the to the lookup function (lookup | Ignition User Manual) which seems to work but was wondering if there is something better to achieve this.

Regards.

2

Generate a True or False in the query populating the table.

Show us how you are generating the table data. If SQL then post your query (Wiki - how to post code on this forum).

3

@Transistor to be more clear on my question,

  1. According to the value of another column I should decide if the column is editable or not.
4

I understood that from your original post. Show us how you are generating the table data.

5 
select something,from_something from ABC

where from_something is a boolean
and something is a string.

6

I had a similar problem a few years ago. I don't remember what the outcome was but my posts on Perspective table disable editing on certain rows may give you some ideas. You might need to return a hidden column. e.g.,

SELECT 
    something, 
    from_something 
    from_something AS canEdit
FROM ABC

and use that hidden value to decide whether or not a row can be edited.