topic Re: Is there any code that can select/open a Global Table? in FlexSim Forum

Is there any code that can select/open a Global Table?

manuel_s4 — Fri, 31 Jan 2020 19:44:11 GMT

[ FlexSim 19.1.0 ]

I'm developing a GUI using the dashboard part, so I want to add a custom code that opens a Global table each time the user presses a button.

Re: Is there any code that can select/open a Global Table?

Matthew_Gillespie — Fri, 31 Jan 2020 19:50:40 GMT

applicationcommand("edittable", Model.find("MODEL:/Tools/GlobalTables/GlobalTable1"));

Re: Is there any code that can select/open a Global Table?

manuel_s4 — Fri, 31 Jan 2020 20:05:52 GMT

As ALWAYS it worked. Thanks Matt!!

Re: Is there any code that can select/open a Global Table?

manuel_s4 — Fri, 31 Jan 2020 20:15:11 GMT

Another question Matt, is there a similar code to open the Time Tables view?

Re: Is there any code that can select/open a Global Table?

Matthew_Gillespie — Fri, 31 Jan 2020 20:24:58 GMT

treenode timeTable = Model.find("Tools/TimeTables/TimeTable1");
createview("VIEW:/pages/tools/TimeTable Parameters", timeTable.getPath(), timeTable.getPath());

Re: Is there any code that can select/open a Global Table?

manuel_s4 — Fri, 31 Jan 2020 20:34:34 GMT

Great! Thanks again Matt!

Re: Is there any code that can select/open a Global Table?

tay_l — Tue, 05 Oct 2021 07:12:14 GMT

Hi Mr. Matthew, Im encountered error msg when using this code: applicationcommand("edittable", Table(""));

Flexscript Error VIEW:/active/GUI testing1054953478/button>OnPress line 1 The function Table is not recognized.

Why?

Re: Is there any code that can select/open a Global Table?

Matthew_Gillespie — Tue, 05 Oct 2021 16:46:08 GMT

@Tay L I don't understand what you're trying to do. Table("") doesn't do anything. You have to put the name of the table you want in the Table() constructor. But you should really use my example above which works best.

applicationcommand("edittable", Model.find("MODEL:/Tools/GlobalTables/YOUR_TABLE_NAME_HERE"));

Re: Is there any code that can select/open a Global Table?

tay_l — Wed, 06 Oct 2021 01:38:50 GMT

Hi @Matthew Gillespie thanks for the quick response.

If I use the code below:

This is the error:

If use the code:

The table display NULL, and the error mesage belwo:

Thank you.

Re: Is there any code that can select/open a Global Table?

Matthew_Gillespie — Wed, 06 Oct 2021 04:31:31 GMT

@Tay L What version of the software are you using? If you're using an older version you should replace Model.find with model().find

Re: Is there any code that can select/open a Global Table?

tay_l — Wed, 06 Oct 2021 04:53:25 GMT

Im using Flexsim 7.3. After i use model().find, the table shows NULL and error message :

"Flexscript Error VIEW:/active/GUI testing564263746/button>OnPress line 1 The method find is not recognized"

Re: Is there any code that can select/open a Global Table?

mischa_spelt — Wed, 06 Oct 2021 12:12:34 GMT

In FlexSim 7.3 it's

node("MODEL:/Tools/...")

But why are you still using a version of over 7 years old?

Re: Is there any code that can select/open a Global Table?

tay_l — Wed, 06 Oct 2021 14:55:42 GMT

Hi @Mischa Spelt, many thanks. We are using this version, for learning and familiarise the software functions.

Could you share what is the code for sorting and filtering the global table data? For example, I would like to use GUI to find a part name or part number in the Global table.

Re: Is there any code that can select/open a Global Table?

Matthew_Gillespie — Wed, 06 Oct 2021 14:58:22 GMT

@Tay L Please post this as a new question and choose 7.3 in the software version dropdown.

Re: Is there any code that can select/open a Global Table?

tay_l — Wed, 06 Oct 2021 15:00:26 GMT

@Matthew Gillespie ok Thanks!