How to link a table from a dashboard to the real table?

Question

question

Laura Vasquez asked Feb 14, '17 Matt Long commented Feb 14, '17

How to link a table from a dashboard to the real table?

Hi @Matthew, thanks for your fast reply!.

It is my first time that I´m using the "model inputs" in the dashboard and I´m little lost!

I wonder if you could help me a little bit with the syntax of the code, I want to develop the following template for the managers of the company I work for; shown in the picture down.

The template will be a visual help for the user; where the user has to choose the date of the initiation, turn (3 possible options) and select the operator for each station depend on the turn; the table will show the plan of the day work and the bottom down will calculate

How long will the order be completed with selected operators.

-the user will first select the "time" in the combobox----Do you know how to link the

the combobox "time" to the table "plan of the day" from other table where the info will be display.

-Then, the user will choose one of the three possible turns- Do you know how to link the listbox "turn" to each of the listbox "subassembly stations" or "personalitation stations" to show different operator of each turn based also from other tables with the information of each turn.

I hope you had time to reply and give me a clearer idea of how to get started.

Regards!

Software Version:

FlexSim 7.7.4

model input

capture.png (18.1 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2017-02-14T18:07:34Z

Sam Stubbs answered Feb 14, '17 Matt Long commented Feb 14, '17

I think an approach you may want to take for this UI design, is to assign the data to a Global Table instead of the internal table of the dashboard. That way when you use your other UI controls, you can have their OnSelect triggers save whatever desired data from the selection to your Global Table. (Via settablenum() and settablestring() commands.

Then if you want that table's information to display on the Dashboard table, simply add the node path to the Global table's data in the dashboard table's Link field:

(The node path will look something like this: MODEL:/Tools/GlobalTables/GlobalTable1>variables/data) But instead of GlobalTable1 it will be whatever name you give your GlobalTable.

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Matt Long commented · Feb 14, 2017 at 06:15 PM

Yes, dashboard tables don't store their own table data. They are just a view into another table's data.

1 ·

question