customcode dashboard button (warehousing)

Question

question

kryczka_17 asked Nov 12, '23 Jason Lightfoot commented Nov 16, '23

customcode dashboard button (warehousing)

How to write in the code dashboard button , so that when I assign the column "Kategoria" in the table "BazaDanych" it automatically assigns me the article code that is column "Kodartykulu" from the table "daneflexsim" and if there are not enough article codes it prints "0"?

magazynowanie.fsm

Software Version:

FlexSim 20.2.3

warehousing customcode dashboard button

magazynowanie.fsm (61.3 KiB)

· 1

Jason Lightfoot ♦ commented · Nov 16, 2023 at 04:09 PM

Hi @kryczka_17, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 ·

Answer 1 · 2023-11-13T10:42:17Z

Felix Möhlmann answered Nov 13, '23

You could use SQL to find all article numbers that belong to a category. If you do this for all possible categories, you can then loop through the "BazaDanych" table and assign entries based on the category. (Check which category the row belongs to and check if there are still entries for that category. If yes, assign the first available value and remove it from the available ones. If not, assign 0 instead.)

question