How can a write values to a Global Table?

Question

question

Ruben Mariduena asked Oct 23 2016 at 9:30 PM Ruben Mariduena commented Oct 24 2016 at 3:56 PM

How can a write values to a Global Table?

Can I write values from custom created labels or statistic from objects onto a blank global tables that I have created for the values to go to? I will then export those GTs onto Excel with the excelexporttable() on the Excel Data interface. For example when you click on an object and you see its statistics you have the option to pin to a dashboard, this is pretty much what I would like to do but push to a specific row and column on a GT

Software Version:

FlexSim 16.2.0

global table labels statistics export data excel export

· 2

Answer 1 · 2016-10-24T15:00:33Z

Matt Long answered Oct 24 2016 at 3:00 PM

There are a couple of different pick options in the object triggers, namely 'Write to GlobalTable' and 'Add Row and Data to GlobalTable'. If you're comfortable coding there are some global table commands you can use like:

settablenum(Table, Row, Column);
settablestr(Table, Row Column);
settablesize(Table, Rows, Columns);
addtablerow(Table);
addtablecol(Table);

Refer to the Command Helper or Commands documentation for more information about these commands as well as additional commands.

question