Hello all, I am new to Ignition and not a developer by education/trade. I am looking for some direction to achieve the following:
I am trying to create a data entry form for operators to use on the floor. The page will contain machine parameters with their target and tolerance ranges for each setpoint as shown below.
I need to have a vertically oriented data entry section to the right of this table. The idea is that operators are presented with the target ranges and then input the setpoint actually used.
My first thought is to use a table with a single column, and blank cells for each row in the reference table. Users would enter in settings and then press an enter button which would add the data in each cell to a new row in a historical table (see schematic below).
The hope is that using a single-column table would be a more elegant solution than adding 70+ numeric text fields. I am also hoping to bind the number of rows presented in the single-column “entry” table to the number of rows in the reference table shown earlier.
To summarize, my questions are:
- Can cells in an editable table be used to set values for an INSERT query?
- Can the number of rows displayed in a table be bound to the number of rows in a different table?
Let me know if this is possible in perspective. Any relevant documentation or tips are greatly appreciated!