Skip to content

Kanban Loops

Kanban Loops

This table controls card generation and printing (PFEP-style).

Setup

Add an Item lookup column that references the ArdaItems sync table
Add a Card Size lookup column that references the Format Templates table
Add a Label Size lookup column that references the Format Templates table
Configure formulas:
Loop ID: concatenate(Item.Name, " - ", rank(RowId(thisRow), ...))
Actual: [Order Cards].count() (after Order Cards table is added)
Calculated: RE + LO + WI + SA (or use Simple Calculation Mode)

Card Generation

Use the ArdaCreateCardForItem pack action to generate cards:
Button: “Create Order Cards”
Action: ArdaCreateCardForItem(TenantId, Author, Item.Eid, NPK, Unit, ...)
Creates cards up to the Planned count

Printing

Cards generated from loops will appear in the ArdaKanbanCards sync table and can be printed from the Order Cards page.

Kanban Loops
Item
Item Name
Loop ID
Planned
Actual
NPK
Calculated
Cards Generated
Cards Needed
Is Complete
Location
RT1
RT2
RT3
RT4
RT5
RT6
TT
LS
WA
SA1
SA2
SA3
RT (Loop)
RE
LO
WI
SA
Color
Color ID
Cards
1
Misty Heavy-Duty Spray Adhesive
5
1
2
0
1
4
0
0
1
1/2" GPO3 Tube
3
1
4
0
1
2
0
0
1
Black Lightning Gloves XL
1
1
4
0
1
0
0
0
1
Black Lightning Gloves XL
2
1
4
0
1
1
0
0
1
Black Lightning Gloves XL
2
1
4
0
1
1
0
0
1
3 inch Double Sided Template Tape
2
1
4
0
1
1
0
0
1
Binder Clips, Medium
2
1
6
0
1
1
0
0
1
Binder Clips, Small
2
1
8
0
1
1
0
0
1
Pelican iM2750 Storm Case
2
1
6
0
1
1
0
0
1
Pelican iM2950 Storm Case
5
1
3
0
1
4
0
0
1
#12 (0.189") Cobalt Jobber Drill
7
1
8
0
1
6
0
0
1
#12 (0.189") Cobalt Taper-Length Drill
1
1
12
0
1
0
0
0
1
1/4"-20 UNC Spiral Flute Bottoming Tap
2
1
8
0
1
1
0
0
1
1/2" 3FL HI PERF ALUM EM W .120" RADIUS
3
1
8
0
1
2
0
0
1
HP EM 5 FLUTE 1/2" DIAMETER W/FLATE
5
1
3
0
1
4
0
0
1
HP EM 5 FLUTE 3/16" DIAMETER
4
1
1
0
1
3
0
0
1
6" Deburr Wheel Density 8, Fine-Grade
0
1
1
0
1
-1
0
0
1
Pelican iM2700 Storm Case
1
1
1
0
1
0
0
0
1
Pelican 1637Air
1
1
1
0
1
0
0
0
1
Tungsten Carbide Scribe
2
1
1
0
1
1
0
0
1
1/4" Flush Trim Router Bit
8
1
1
0
1
7
0
0
1
8Mil Orange Nitrile Gloves - Large
0
1
1
0
1
-1
0
0
1
3M General Purpose Adhesive Cleaner, Quart
1
1
1
0
1
0
0
0
1
Kool Mist #77
1
1
1
0
1
0
0
0
1
1 inch Double Sided Template Tape
2
1
1
0
1
1
0
0
1
3/16 x 2-13/16" Clevis (Hinge) Pin
8
1
1
0
1
7
0
0
1
1/4-20 x 3/4 Low-Profile Socket Head Screw
0
1
1
0
1
-1
0
0
1
1-1/8" Open End Wrench
2
1
1
0
1
1
0
0
1
1/4-20 x 3/8 Truss Head Screw
2
1
1
0
1
1
0
0
1
7x16 x 1" Rectangle Punch and Die
2
1
1
0
1
1
0
0
1
9/16 x 1.25" Rectangle Punch and Die
8
1
1
0
1
7
0
0
1
9/16 x 1" Rectangle Punch and Die
0
1
1
0
1
-1
0
0
1
OLFA 9mm Snap Off Replacement Blades
1
1
1
0
1
0
0
0
1
OLFA SVR-1 Utility Knife
1
1
1
0
1
0
0
0
1
3" x 5" Laminating Pouch
1
1
1
0
1
0
0
0
1
3 x 5 Index Cards
4
1
1
0
1
3
0
0
1
Epson Black Ink High Capacity Cartridge
0
1
1
0
1
-1
0
0
1
Epson Color Ink Cartridge Combo Pack
1
1
1
0
1
0
0
0
1
Center Punch
1
1
3
0
1
0
0
0
1
Milwaukee INKZALL Black Marker
1
1
3
0
1
0
0
0
1
AAA Batteries
1
1
3
0
1
0
0
0
1
AAA Batteries
1
1
3
0
1
0
0
0
1
AAA Batteries
1
1
32
0
1
0
0
0
7
1
0
28
0
0
1
0
0
2
0
5
0
0
2
0
0
2
0
5
0
0
2
0
0
1
0
5
0
0
1
0
0
2
0
20
0
0
2
0
0
2
0
8
0
0
2
0
0
4
0
25
0
0
4
0
0
43
30
50
20

Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.