topic Re: Assigning Pointer Data For More Rows In Schedule in FlexSim Forum

Assigning Pointer Data For More Rows In Schedule

rajankur6494 — Thu, 28 Apr 2022 07:02:07 GMT

[ FlexSim 21.0.10 ]

I like the way you defined location name in terms of pointer data in schedule table itself.

How to Set Overflow Location Logic Based on Chair Availability? - FlexSim Community

It looks more scalable in this way. But I think I have to use picker for every row after assigning pointer data to cells. It will be much difficult to do it for more number of rows (1000) having multiple location.

What is the best way to do it?

Thank you!

Re: Assigning Pointer Data For More Rows In Schedule

moehlmann_fe — Thu, 28 Apr 2022 08:44:57 GMT

You don't have to use the picker. If the entered values are all the same or follow a regular pattern, you can copy and paste blocks of previous cells.

You can also use code to assign values to the schedule. An example is provided in the script window of the attached model.

As is, the code assigns "RegularChair" to each cell in the fifth column. You could also modify it to assign different values depending on some condition, for example the value in another row.

test13-chairs_1.fsm

Re: Assigning Pointer Data For More Rows In Schedule

rajankur6494 — Thu, 28 Apr 2022 11:33:47 GMT

Thank you so much @Felix Möhlmann for this piece of code!

Still I would like to ask 1 more question. Actually, there are multiple locations based on provider. Suppose if user want to add provider in existing model, this process looks little bit difficult for new user. Is there any other easy way to do it? I am expecting something in excel and paste directly here that data.

Re: Assigning Pointer Data For More Rows In Schedule

moehlmann_fe — Thu, 28 Apr 2022 11:51:04 GMT

Values pasted from excel will automatically interpreted as either a string (text) or a number. You can paste in the name of the object and then run code (similar to before) to find the correct object and replace the name with a pointer. This could also be done as part of the "Post Import Code" if you set up an automatic excel import.

Alternatively yoiu can leave the value in the soure as text and replace the token label with a pointer in the arrivals flow before creating the patient.

test13-chairs_2.fsm

Re: Assigning Pointer Data For More Rows In Schedule

rajankur6494 — Thu, 28 Apr 2022 15:02:05 GMT

Thank you so much! @Felix Möhlmann

I really like the second approach of doing it. But I have 1 question here if I may ask.

If we have two location with respect to chair label "regular_chair", let say "regular_chair_MD" for MD, "regular_chair_clerk" for clerk. So, is there any way to join suffix in the label "regular_chair" and get the chair pointer to access these locations?

test13-chairs3.fsm

Re: Assigning Pointer Data For More Rows In Schedule

rajankur6494 — Fri, 29 Apr 2022 01:31:57 GMT

I got it. Thank you for you support! @Felix Möhlmann

Re: Assigning Pointer Data For More Rows In Schedule

moehlmann_fe — Fri, 29 Apr 2022 05:59:33 GMT

Happy to hear that you figured it out. Just for completeness sake, in case other users are searching for the same question:

You can simply add strings together with a "+" operator. So if "token.chair" is "regular_chair" and "token.MD" is "MD", then

Model.find(token.chair + "_" + token.MD)

would search for the object named "regular_chair_MD".

Re: Assigning Pointer Data For More Rows In Schedule

rajankur6494 — Fri, 29 Apr 2022 12:33:28 GMT

@Felix Möhlmann

I want to change my label name "Chair" based on whatever is acquired from overflow location (randomly picked). While clicking on token, I can see that pointer data "/Chair6" is allocated in locations label field. But I only want to assign "Chair6" to my Chair label.

Is there any way to do it?

Thank you!

Re: Assigning Pointer Data For More Rows In Schedule

moehlmann_fe — Sat, 30 Apr 2022 07:29:15 GMT

"object.name" returns the name of the object. So the following would assign the name of the last acquired location to the Chair label.