change Global table cell

change Global table cell

a9080109
Collaborator Collaborator
492 Views
8 Replies
Message 1 of 9

change Global table cell

a9080109
Collaborator
Collaborator

@FelixMoehlmann 

I need to update a global table, but I'm having trouble selecting a cell. The cell I need to select is the number in my token.boover.

a9080109_1-1765365551861.png

Of course I know that changing the table header will solve the problem! But what I want to know is that if my table header is 123456 and I currently have a token.boover = 3, what I want to update is to search for the column specified (in this case, the fifth row), but what I need is the column where the name field has a value of 3.

 

0 Likes
493 Views
8 Replies
Replies (8)
Message 2 of 9

a9080109
Collaborator
Collaborator

Additionally, I encountered a problem when updating the database! It didn't update successfully!

0 Likes
Message 3 of 9

FelixMoehlmann
Collaborator
Collaborator

It sounds like you are looking for getRowByKey() or getValueByKey().

0 Likes
Message 4 of 9

a9080109
Collaborator
Collaborator

I'd like to ask if there's a function to link text. I currently have text AS001, but I need to look up a table to perform the linking. Is there a more convenient way to handle this, or do I have to create them one by one?

a9080109_0-1765442537223.png

 

0 Likes
Message 5 of 9

FelixMoehlmann
Collaborator
Collaborator

Referring from one control point to another is the main use case of control point connections. I would use those instead of a table.

The AGV Process Flow templates use a list to pull the next CP. But you can also use the "cpconnection()" command.

https://docs.flexsim.com/en/25.2/Reference/Tools/AGVNetworkTool/ControlPointConnections/ControlPoint...

0 Likes
Message 6 of 9

a9080109
Collaborator
Collaborator

I don't understand how to use the information you gave me! Could you give an example? My problem is that I can only get text files, and I need to link them to objects (so I can only use tables for comparison). I'd like to ask if there's a better method, or some kind of automatic comparison mechanism?

0 Likes
Message 7 of 9

FelixMoehlmann
Collaborator
Collaborator

I suggested control point connections because in the file you uploaded it looked like you were trying to define a route along the control points.

The only way to get an object reference based on a string (name) is to use .find()

Depending on the number of objects in the model this can slow down the model if done very frequently. It could make sense to create a map that links strings to objects on model reset/start and use that to get pointers during the model run.

 

 

0 Likes
Message 8 of 9

a9080109
Collaborator
Collaborator

Could you downgrade the version? I only have version 25.0.

0 Likes
Message 9 of 9

FelixMoehlmann
Collaborator
Collaborator

Here's the same model in 25.0

0 Likes