Arda Pro Demo
Doc Explorer
All column data
Column name
Table name
Name
Column type
Calculated
Formula
Lookup from
1
Items
Notes
canvas
2
Items
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
3
Items
URL 1
link
4
Items
Supplier
lookup
switchif(
[Order Mechanism].IsBlank() or
Name = "Target Completion Date" or
Name = "Project Start" or
and(
[Order Mechanism].contains(Task, Production).not(),
[Secondary Supplier].IsBlank(),
[Primary Supplier].IsBlank()
),
"",
[Order Mechanism] = Task and Department.IsBlank(),
"",
[Order Mechanism] = Task,
[Master Suppliers]
.filter(
Department = Department and
CurrentValue.Name.IsNotBlank()
),
[Order Mechanism] = Production,
[Master Suppliers]
.filter(
Locations = [Internal Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Use Secondary Supplier] and
[Secondary Supplier].IsNotBlank(),
[Master Suppliers]
.filter(
[External Suppliers] =
[Secondary Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Master Suppliers]
.filter(
[External Suppliers] = [Primary Supplier] and
CurrentValue.Name.IsNotBlank()
)
)
Master Suppliers
5
Items
Database Link
text
[QR Code URL].BarcodeQR("FFFFFF").image(75,75,"QR Code","Auto",false)
6
Items
Add to Cart
button
runactions(
ModifyRows(
thisRow,
[Times Added To Cart],
[Times Added To Cart] + 1,
[Date Added to Cart],
switchif(
[To Order] = 0, now(), [Date Added to Cart]
)
),
switchif(
[Related Items].IsNotBlank(),
[Related Items].[Add to Cart],
""
)
)
7
Items
Internal Supplier
lookup
Locations
8
Items
Location
lookup
Locations
9
Items
Trigger
lookup
Trigger
10
Items
Order Mechanism
lookup
Order Mechanism
11
Items
Print
button
runactions(
switchif([Inlcude Barcode] and Barcode.IsBlank(),ModifyRows(thisRow,Barcode,Barcodecode128(Name, "white", "black"))),
switchif(
Select,
[Bulk Print],
OpenRow(thisRow, [Print Format], "Right")
),
switchif(
Select,
ModifyRows(Items.filter(Select), Printed, true),
ModifyRows(thisRow, Printed, true)
)
)
12
Items
Upload Image
image
13
Items
Receive
button
modifyrows([Order Line Item Archive].filter(Status!=Finished).MinBy(CurrentValue.[Created Date]),Status,Finished)
14
Items
Edit
button
switchif(
[Order Mechanism] = Task,
switchif(
[Advanced Mode],
openrow(thisRow, Tasks, "Right"),
openrow(thisRow, [Task Layout (Basic)], "Right")
),
[Order Mechanism] = Production,
switchif(
[Advanced Mode],
openrow(thisRow, [Production Dashboard], "Right"),
openrow(thisRow, [Workstation Dashboard], "Right")
),
switchif(
[Advanced Mode],
openrow(thisRow, Items, "Right"),
openrow(thisRow, [Shopping Cart], "Right")
)
)
15
Items
Create Order Record
button
runactions(
switchif(
[Project-Specific Cart].IsBlank(),
"",
[Project-Specific Cart]
.[Create Order Record]
),
AddRow(
[Order Line Item Archive],
[Item Image],
[Image (URL)],
[Item Price],
[Total Price],
Person,
user(),
[Order Mechanism],
[Order Mechanism],
Location,
Location,
Supplier,
Supplier,
Status,
switchif(
[Order Mechanism] = Shopping,
Finished,
[Order Mechanism] = Task,
Triggered,
Ordered
),
Item,
Item,
Flag,
Flag,
[Include in Receiving],
switchif(
[Order Mechanism] = Task,
true,
[Receiving Inclusion]
),
Quantity,
[Times Added To Cart] * [Order Qty],
Units,
[Order Units]
),
ModifyRows(
thisRow,
[Times Added To Cart],
0,
[In Cart],
false,
Priority,
Queue,
Flag,
"",
[Date Added to Cart],
""
)
)
16
Items
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
17
Items
Action
button
switchif(
[Order Mechanism] = Task,
runactions(
[Create Order Record],
[Related Items].[Add to Cart]
),
[Order Mechanism] = PO,
switchif(
[Order Documents].Status.ListCombine()
.contains(
[PO Created]
),
openrow(
[Order Documents]
.filter(
Status = [PO Created]
)
.MaxBy(
[Created on]
),
[Order Documents],
"Right"
),
openrow(
addrow(
[Order Documents],
Status,
[PO Created],
[Payment Terms],
Supplier.[External Suppliers]
.[Payment Terms],
[Shipping Terms],
Supplier.[External Suppliers]
.[Shipping Terms],
[Line Items],
[Shopping Cart]
.filter(
Supplier = Supplier and
[Order Mechanism] = PO
),
[PO Created Date],
today(),
Supplier,
Supplier,
Project,
switchif(
[Project-Specific Cart].IsNotBlank(),
[Project-Specific Cart]
.Project
.ListCombine(),
""
)
),
[Order Documents],
"Right"
)
),
[Order Mechanism] = Online,
switchif(
[In Cart] = false,
runactions(
[Shopping Cart]
.filter(
currentvalue.Supplier = Supplier and
[Order Mechanism] = Online and
[In Cart] = false
)
.[Open Link],
modifyrows(
[Shopping Cart]
.filter(
currentvalue.Supplier = Supplier and
[Order Mechanism] = Online and
[In Cart] = false
),
[In Cart],
true
)
),
[In Cart] = true,
[Create Order Record]
),
[Order Mechanism] = Email,
switchif(
[Email Queue].IsNotBlank(),
openrow(
[Email Queue].ListCombine().first(), [Email Queue], "Right"
),
openrow(
AddRow(
[Email Queue],
[Due Date],
switchif(
Trigger = Immediately,
now(),
Trigger = [End of Day],
today(),
switchif(
today().WeekdayName() = "Monday",
today() + 3,
today().WeekdayName() = "Tuesday",
today() + 2,
today().WeekdayName() = "Wednesday",
today() + 1,
today()
)
),
Supplier,
Supplier,
Complete,
"false",
Subject,
switchif(
[Order Mechanism] = Email,
Subject,
""
),
Body,
switchif(
[Order Mechanism] != Email,
"",
thisTable
.filter(
Supplier = Supplier and
[To Order] != 0 and
[To Order].IsNotBlank() and
[Order Mechanism] = Email
)
.foreach(
concatenate(
"Qty: ",
CurrentValue.[To Order],
" ",
[Order Units],
" ",
CurrentValue.[Item Name],
" ",
switchif(
[Include Order Description],
CurrentValue.[Order Description],
""
),
switchif(
[Include Taxable Status],
concatenate(
Character(13),
switchif(
currentvalue.Taxable, "Taxable", "Tax-Exempt"
)
),
""
)
)
)
.BulletedList()
.withname(
[item list],
concatenate(
_color("#000000", [item list]),
character(13),
Supplier.[External Suppliers]
.[Vendor Number & Additional Info]
)
)
.withname(
orderitems,
format(
Body,
Supplier.[External Suppliers]
.[Primary Contact]
.split(
" "
)
.first(),
orderitems,
[Company Name],
[Company Address]
)
)
),
Owner,
user(),
Items,
[Shopping Cart]
.Filter(
Supplier = Supplier and
[To Order].IsNotBlank() and
[Order Mechanism] = Email
)
.Item
.ListCombine(),
[Order Quantity],
[Shopping Cart]
.filter(
currentvalue.Supplier = Supplier and
[Order Mechanism] = Email
)
.[To Order]
.listcombine()
),
[Email Queue],
"right"
)
),
[Order Mechanism] = Production and Priority != [In Process],
modifyrows(thisRow, Priority, [In Process]),
[Order Mechanism] = Production,
[Create Order Record],
[Order Mechanism] = Shopping,
openrow(
Modals.filter(Name = "Shopping List"),
Modals,
"Right"
)
)
18
Items
Taxable
checkbox
19
Items
Order Description
text
20
Items
Remove From Cart
button
switchif(
[Order Mechanism] = Production and
Priority = [In Process],
ModifyRows(thisRow, Priority, Next),
runactions(
DeleteRows([Project-Specific Cart]),
ModifyRows(
thisRow,
[Times Added To Cart],
0,
[In Cart],
false
)
)
)
21
Items
Order Timeline
lookup
[Order Line Item Archive].Filter(Item.Contains(thisRow))
Order Line Item Archive
22
Items
Date Added to Cart
date
23
Items
Email Queue
lookup
[Email Queue].Filter(Items.Contains(thisRow))
Email Queue
24
Items
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
25
Items
Open Link
button
OpenWindow(switchif([Use Secondary Supplier] and [URL 2].IsNotBlank(),[URL 2],[Use Secondary Supplier]=false and [URL 1].IsNotBlank(),[URL 1],[Use Secondary Supplier],[Secondary Supplier].Website, [Primary Supplier].Website))
26
Items
In Cart
checkbox
27
Items
Min Qty
number
28
Items
Order Qty
number
29
Items
Min. Units
text
30
Items
Order Units
text
31
Items
Times Added To Cart
number
32
Items
Card Size
lookup
Formats by Size
33
Items
Total Price
currency
[Unit Price]*[Order Qty]
34
Items
Avg. Time
duration
35
Items
SKU
text
36
Items
Max Time
duration
37
Items
Select
checkbox
38
Items
Receiving Inclusion
checkbox
39
Items
Unit Price
currency
40
Items
Color ID
number
Color.[Color ID].ListCombine()
41
Items
Name
text
42
Items
Color
lookup
switchif(
[Order Mechanism] = Task and Department.IsBlank(),
[Dark Gray],
[Shade Item Names],
[Color Options]
.filter(
Color
.contains(
switchif(
[Color Code Items By] = [Order Cadence],
Trigger.Color.Color,
[Color Code Items By] = [Order Mechanism],
[Order Mechanism].Color
.Color,
[Color Code Items By] = [Storage Location],
[Internal Supplier].Color
.Color,
[Color Code Items By] = [Item Type],
[Item Type].Color.Color
.listcombine(),
[Color Code Items By] = [Item Sub-Type],
[Sub-Type].Color
.Color,
[Color Code Items By] = Department,
Department.Color.Color
.listcombine(),
[Color Code Items By] = [Order Origin],
[Order Origin].Color.Color
.listcombine(),
[Color Code Items By] = Component,
Components.Color.Color
.listcombine(),
[Color Code Items By] = [Use Case],
[Use Case].Color.Color
.listcombine()
)
) and
Shade
.contains(
switchif(
[Shade Items By] = [Order Cadence],
Trigger.Color.Shade,
[Shade Items By] = [Order Mechanism],
[Order Mechanism].Color
.Shade,
[Shade Items By] = [Storage Location],
[Internal Supplier].Color
.Shade,
[Shade Items By] = [Item Type],
[Item Type].Color.Shade
.listcombine(),
[Shade Items By] = [Item Sub-Type],
[Sub-Type].Color
.Shade
.listcombine(),
[Shade Items By] = Department,
Department.Color.Shade
.listcombine(),
[Shade Items By] = [Use Case],
[Use Case].Color.Shade
.listcombine(),
[Shade Items By] = [Order Origin],
[Order Origin].Color.Shade
.listcombine(),
[Shade Items By] = Component,
Components.Color.Shade
.listcombine()
)
)
),
switchif(
[Color Code Items By] = [Order Cadence],
Trigger.Color,
[Color Code Items By] = [Order Mechanism],
[Order Mechanism].Color,
[Color Code Items By] = [Storage Location],
[Internal Supplier].Color,
[Color Code Items By] = [Item Type],
[Item Type].Color,
[Color Code Items By] = [Item Sub-Type],
[Sub-Type].Color,
[Color Code Items By] = [Use Case],
[Use Case].Color,
[Color Code Items By] = Component,
Components.Color,
[Color Code Items By] = Department,
Department.Color,
[Color Code Items By] = [Order Origin],
switchif(
[Order Mechanism] = Task,
[Color Options]
.filter(
Color =
[Order Origin].Color.Color and
Shade = Dark
),
[Order Mechanism] = Production,
[Color Options]
.filter(
Color =
[Order Origin].Color.Color and
Shade =
switchif(
[To Order] = 0 or Priority.contains(Backburner, Queue),
[ ],
Priority.contains(Next),
Light,
Priority.contains([In Process]),
Dark
)
),
[Color Options]
.filter(
Color =
[Order Origin].Color.Color and
Shade = Light
)
)
)
)
.first()
Color Options
43
Items
Item Type
lookup
Item Type
44
Items
Sub-Type
lookup
Item Sub-Type
45
Items
Card Format
text
switchif(
[Item Name].IsBlank(),
"",
format(
switchif(
[Image (URL)].IsBlank(),
[Card Size].[Alternate Template],
[Card Size].Template
),
_color([Medium Hex], [Item Name]),
switchif(
[Order Mechanism] = Production,
[Internal Supplier].ToText(),
Supplier.ToText()
),
switchif(
[Sub-Location].IsNotBlank(),
Concatenate(Location, " - ", [Sub-Location])
.ToText(),
Location.ToText()
),
concatenate([Min Qty], " ", [Min. Units].trim()),
concatenate([Order Qty], " ", [Order Units]).trim(),
[Database Link],
[Image (URL)]
.image(
0,
switchif([Card Size] = [3.5" x 2"], 175, 350),
"Image",
"Auto",
false
),
switchif(
[Card Sub-Heading] = Notes,
Notes,
[Card Sub-Heading] = SKU,
SKU,
[Card Sub-Heading] = Products,
Products
),
Department.totext(),
switchif(
[Include Colored Border on Cards] = false,
"",
[Order Mechanism] = Task,
concatenate(
Department.Color
.[Short Rectangle]
.image(),
[Short Rectangle].image(),
Department.Color
.[Short Rectangle]
.image()
),
[Color Options]
.filter(
Color = Color.Color and
Shade =
switchif(
[Order Mechanism] = Production,
[ ],
Color.Shade
)
)
.Rectangle
.image()
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Supplier"
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
switchif(
[Order Mechanism] = Task,
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
"#000000"
),
"Trigger"
),
""
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Location"
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Finish Criteria"
),
Trigger.totext(),
[Finish Criteria].totext(),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Person"
),
Person.totext(),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Department"
),
switchif([Inlcude Barcode], Barcode.image(0,100), "")
)
)
46
Items
Image (URL)
image
47
Items
Department
lookup
Departments
48
Items
Unique ID
text
concatenate([Unique Identifier] ,[Item Number])
49
Items
Row URL
link
ObjectLink(thisRow)
50
Items
QR Code URL
link
concatenate("https://link.arda.cards/",[Unique Identifier],"/",[Unique ID]).totext()
51
Items
Person
person
52
Items
Order Origin
lookup
switchif(
Name = "Project Start",
[Order Origin]
.filter(
[Order Mechanism] = Task
),
Name = "Target Completion Date",
[Order Origin]
.filter(
[Order Mechanism] = Task
),
[Order Mechanism].isblank(),
"",
[Order Mechanism].contains(Task, Production),
[Order Origin]
.filter(
Department = Department
),
[Order Origin]
.filter(
[Order Mechanism] = [Order Mechanism]
)
)
Order Origin
53
Items
Secondary Supplier
lookup
External Suppliers
54
Items
URL 2
link
55
Items
Primary Supplier
lookup
External Suppliers
56
Items
Use Secondary Supplier
checkbox
57
Items
Switch Suppliers
button
modifyrows(thisRow,[Use Secondary Supplier],switchif([Use Secondary Supplier],false,true ))
58
Items
Item Number
number
59
Items
Order Groups
lookup
[Order Groups].Filter(Items.Contains(thisRow))
Order Groups
60
Items
Delete
button
runactions(
modifyrows(
thisRow,
[Unit Price],
"",
Notes,
"",
Name,
"",
[Depends On],
"",
[Max Time],
"",
[Avg. Time],
"",
[Min Qty],
"",
[Email Queue],
"",
[Finish Criteria],
"",
[Relative Days to Trigger],
"",
[Order Qty],
"",
[URL 1],
"",
[Internal Supplier],
"",
Location,
"",
Trigger,
"",
[URL 2],
"",
[Secondary Supplier],
"",
[Primary Supplier],
"",
[Production Batch],
"",
Products,
"",
Components,
"",
[Upload Image],
"",
[Date Added to Cart],
"",
[Relative Days to Trigger],
"",
[Finish Criteria],
"",
Taxable,
"",
[Order Mechanism],
"",
Person,
"",
[Item Type],
"",
[Sub-Type],
"",
[Times Added To Cart],
0,
[Order Units],
"",
[Min. Units],
"",
Priority,
Queue,
[Receiving Inclusion],
false,
[In Cart],
false,
[Card Size],
[3” x 5”],
[Label Size],
[3.5" x 2"],
SKU,
"",
Select,
false,
[Depends On],
"",
Dependents,
"",
Department,
"",
Barcode,
"",
[Image (URL)],
"",
[Use Secondary Supplier],
false,
Printed,
false
)
)
61
Items
Actions
text
concatenate(
button(
Print,
"",
switchif(Printed, "Blue", "Yellow"),
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-paper", "print")
),
" ",
switchif(
[Order Mechanism] = Task,
"",
button(
[Print Label/Breadcrumb],
"",
"Purple",
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-money", "feed-paper")
)
),
switchif([Order Mechanism] = Task, "", " "),
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
" ",
button(
switchif(
[Order Mechanism] = Task,
[Create Order Record],
[Add to Cart]
),
"",
"Green",
switchif(
[Order Mechanism] = Task,
"",
[Order Qty].IsBlank(),
"+Qty",
[To Order] = 0 or [To Order].IsBlank(),
"",
[To Order]
),
"",
false,
"Small",
switchif(
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Task,
"lightning-bolt",
"add-shopping-cart"
)
)
)
62
Items
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
63
Items
Printed
checkbox
64
Items
Calculate Lead Times
button
ModifyRows(thisRow,[Avg. Duration],[Calculated Avg. Lead Time],[Max Duration],[Order Timeline].filter(Status=Received).[Lead Time].max().roundup(0) )
65
Items
Order Price
currency
[Unit Price]*[To Order]
66
Items
Duplicate
button
openrow(
ModifyRows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
_color(
"#000000", Concatenate("Copy of ", [Item Name])
),
[Primary Supplier],
[Primary Supplier],
Printed,
false,
[Receiving Inclusion],
[Receiving Inclusion],
[Secondary Supplier],
[Secondary Supplier],
Notes,
Notes,
[Image (URL)],
[Image (URL)],
[Order Mechanism],
[Order Mechanism],
[Finish Criteria],
[Finish Criteria],
[Relative Days to Trigger],
[Relative Days to Trigger],
Department,
Department,
[Card Size],
[Card Size],
[Internal Supplier],
[Internal Supplier],
[URL 1],
[URL 1],
Components,
Components,
[Label Size],
[Label Size],
Products,
Products,
[URL 2],
[URL 2],
Location,
Location,
Trigger,
Trigger,
[Order Description],
[Order Description],
[Min Qty],
[Min Qty],
[Min. Units],
[Min. Units],
[Order Units],
[Order Units],
[Order Qty],
[Order Qty],
[Item Type],
[Item Type],
[Unit Price],
[Unit Price],
[Sub-Type],
[Sub-Type]
),
Items,
"Right"
)
67
Items
Calculated Avg. Lead Time
duration
68
Items
Order Documents
lookup
[Order Documents].Filter([Line Items].Contains(thisRow))
Order Documents
69
Items
Components
lookup
Components
70
Items
Add To Project
button
ModifyRows(
[Order Line Item Archive]
.Project,
Items,
listcombine(
[Order Line Item Archive]
.Project
.Items,
Item
)
.filter(
CurrentValue.IsNotBlank() and [Order Mechanism]!=Task
)
)
71
Items
Project Actions
text
Concatenate(
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From BOM],
"",
"Red",
"",
"",
false,
"Small",
"clear-symbol"
),
" ",
button(
[Add To Project],
"",
switchif(
[Order Line Item Archive]
.Project
.Items
.ListCombine()
.contains(
Item
),
"Yellow",
"Green"
),
[Order Line Item Archive].Project.Items.ListCombine().countif(CurrentValue=Item ).withname(count,switchif(count=0,"",count)),
"",
false,
"Small",
"add-database"
)
)
72
Items
Priority
lookup
Priority
73
Items
Production Batch
lookup
Production Batch
74
Items
Print Label/Breadcrumb
button
switchif(Select,[Bulk Print Labels], openrow(thisRow,[Label View],"Right"))
75
Items
Label Size
lookup
Formats by Size
76
Items
Label Format
text
switchif(
[Item Name].IsBlank(),
"",
format(
switchif(
[Image (URL)].IsBlank(),
[Label Size].[Alternate Template],
[Label Size].Template
),
//1//
_color(
[Medium Hex], [Item Name]
),
//2//
_color(
switchif(
[Color Code Title Text],
Color.[Text Color],
"#000000"
),
Location.ToText()
),
//3//
switchif(
[Sub-Location].IsNotBlank(),
Concatenate(Location, " - ", [Sub-Location])
.ToText(),
Location.ToText()
),
//4//
concatenate(
[Min Qty], " ", [Min. Units].trim()
),
//5//
switchif(
[Order Units].IsBlank(),
[Order Qty],
concatenate([Order Qty], " ", [Order Units])
)
.trim(),
//6//
[Database Link],
//7//
[Image (URL)]
.image(
0, 200, "Image", "Auto", false
),
//8//
Notes,
//9//
_color(
switchif(
[Color Code Title Text],
Department.Color.[Text Color],
"#000000"
),
Department.ToText()
),
//10//
switchif(
[Include Colored Border on Cards],
Color.[Light Rectangle],
""
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Location"
),
_color(
switchif(
[Color Code Title Text],
Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
)
)
)
77
Items
Sub-Location
lookup
Sub-Locations
78
Items
Products
lookup
Products
79
Items
Depends On
lookup
Items
80
Items
Surplus
lookup
switchif([Min Qty]=0, [Order Line Item Archive].filter(Item=thisRow and Project=""),"")
Order Line Item Archive
81
Items
Remove From BOM
button
ModifyRows([Order Line Item Archive] .Project.ListCombine().first(),Items,Modals.filter(Name="Configure BOM").[Order Line Item Archive].Project.Items.filter(CurrentValue!=thisRow and CurrentValue.IsNotBlank()).ListCombine())
82
Items
Dependents
lookup
Items.Filter([Depends On].Contains(thisRow))
Items
83
Items
Sequence
number
switchif([Depends On].IsBlank(),1,[Depends On].Sequence.max()+1)
84
Items
Projects
lookup
Projects.Filter(Items.Contains(thisRow))
Projects
85
Items
Related SOPs
lookup
SOPs.Filter(Item.Contains(thisRow))
SOPs
86
Items
SOP
lookup
SOPs
87
Items
Relative Days to Trigger
duration
88
Items
Finish Criteria
lookup
Finished
89
Items
Create/Open SOP
button
switchif(
SOP.IsBlank(),
SOPs.filter(Name.IsBlank()).MinBy([SOP Number]),
SOP
)
.WithName(
target,
runactions(
ModifyRows(
thisRow,
SOP,
ModifyRows(
target,
[SOP Type],
switchif([Order Mechanism] = Task, Task, Item),
Item,
thisRow,
Name,
Concatenate(Name, " SOP"),
Department,
Department,
Location,
Location,
Product,
Products,
Components,
Components
)
),
switchif(
[Order Mechanism] = Task,
openrow(target, [SOPs Task View], "Right"),
openrow(target, [SOPs Item View], "Right")
)
)
)
90
Items
More Actions
text
concatenate(
button(
[Calculate Lead Times],
"",
"Purple",
switchif(
[Calculated Avg. Lead Time].IsBlank(),
"",
[Calculated Avg. Lead Time].split("days").first()
.trim()
.ToNumber()
),
"",
false,
"Small",
"alarm-clock"
),
" ",
button(
Duplicate,
"",
"Pink",
"",
"",
false,
"Small",
"copy"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
)
)
91
Items
Project-Specific Cart
lookup
[Build-Specific Cart Line Items].Filter(Item.Contains(thisRow))
Build-Specific Cart Line Items
92
Items
Related Items
lookup
Items
93
Items
To Order Quantity
text
Concatenate([To Order],switchif([Order Units].IsBlank(),"",Concatenate(" ",[Order Units])))
94
Items
Workstation Dashboard
button
openrow([Internal Supplier],Locations,"Right")
95
Items
Barcode
image
96
Items
Flag
reaction
97
Items
Cart Duration
duration
max( [Date Added to Cart]-today(),[Project-Specific Cart].[Cart Duration]).todays()
98
Items
Use Surplus
button
switchif(Surplus.IsNotBlank(), runactions(modifyrows(Surplus.first(),Project,[Project-Specific Cart].first().Project),DeleteRows([Project-Specific Cart].first())),"")
99
Items
Use Case
lookup
Use Case
100
Items
Avg. Price
currency
foreach([Order Timeline],CurrentValue.[Total Cost]/CurrentValue.Quantity).ListCombine().average()
101
Order Line Item Archive
Item
lookup
Items
102
Order Line Item Archive
Quantity
number
103
Order Line Item Archive
Notes
text
104
Order Line Item Archive
Created Date
dateTime
thisRow.created().DateTimeTruncate("hour")
105
Order Line Item Archive
Supplier
lookup
Master Suppliers
106
Order Line Item Archive
Lead Time
duration
107
Order Line Item Archive
Name
text
_color(
Color.[Text Color],
switchif(
Item.[Order Mechanism] = Task,
Concatenate(
switchif(Project.IsNotBlank(), Concatenate(Project, " - ")),
Item
)
.totext(),
concatenate(
Item, " - ", [Created Date].datetimeTruncate("day")
)
.totext()
.withname(
name, name.left(name.Length() - 5)
)
)
)
108
Order Line Item Archive
Receipt Image
image
109
Order Line Item Archive
Units
text
110
Order Line Item Archive
Item Price
currency
111
Order Line Item Archive
Received/Completion Date
dateTime
112
Order Line Item Archive
Advance
button
runactions(
switchif(
[Order Mechanism] = Task and [Finish Criteria Met],
modifyrows(thisRow, Status, Finished),
//if true//
or(
[Advanced Mode] = false, Finish = [On Completion]
) and
[Order Mechanism] = Task,
//do this//
modifyrows(
thisRow,
Status,
switchif(
Status = [Not Triggered],
Triggered,
Status = Upcoming,
Started,
Status = Triggered,
Started,
Status.contains(Started, Due, Delayed),
Finished
)
),
//if true//
Finish = [External Items Ordered],
//do this//
switchif(
Project.isnotblank() and Project.Finalized and
[Shopping Cart].Projects.ListCombine()
.contains(
Project
),
runactions(
modifyrows(thisRow, Status, Started),
ModifyRows(
[Project Cart], [Order Line Item Archive], thisRow
),
OpenRow([Project Cart], Modals, "Right")
),
Project.IsNotBlank() and Project.Finalized = false,
Project.[Add To Project],
Project.IsNotBlank() and Project.Finalized and
[Shopping Cart].listcombine().contains(Project)
.not() or
Project.isblank(),
modifyrows(thisRow, Status, Finished)
),
//if true//
Finish.contains([BOM Finalized]) and
Project.Finalized = false,
//do this//
runactions(
ModifyRows(
[Configure BOM], [Order Line Item Archive], thisRow
),
openrow([Configure BOM], Modals, "Right"),
Project.[Add To Project],
modifyrows(thisRow, Status, Started)
),
//if true//
Finish = [Link Opened] and
[Link Opened] = false,
//do this//
runactions(
OpenWindow(Link),
modifyrows(
thisRow,
[Link Opened],
true,
Status,
Started
)
),
//if true//
Finish = [BOM Finalized] and
Project.Finalized,
//do this//
ModifyRows(thisRow, Status, Finished),
//if true//
Finish = [External Items Received] and
or(
Project.Orders.Status
.ListCombine()
.unique()
.filter(
CurrentValue.IsNotBlank()
)
.ContainsOnly(
Finished
),
Project.Orders.listcombine()
.filter(
CurrentValue.IsNotBlank()
)
.IsBlank()
),
//do this//
ModifyRows(
thisRow, Status, Finished
),
//if true//
Finish = [Production Completed],
//do this//
switchif(
Project.Items.[Order Mechanism].ListCombine()
.unique()
.contains(
Production
)
.not(),
ModifyRows(thisRow, Status, Finished),
Project.Items.listcombine()
.filter(
[Order Mechanism] = Production
)
.Priority
.contains(
[In Process]
) or
[Build-Specific Cart Line Items]
.filter(
Project = Project and
[Order Mechanism] =
Production
)
.ListCombine()
.IsBlank(),
runactions(
openrow(
modifyrows(
[Project Production],
[Order Line Item Archive],
thisRow
),
Modals,
"Right"
),
modifyrows(thisRow, Status, Started)
),
[Finish Criteria Met],
ModifyRows(thisRow, Status, Finished),
openrow(
modifyrows(
[Project Production],
[Order Line Item Archive],
thisRow
),
Modals,
"Right"
)
),
//if true//
Finish = [External Items Received] AND
Status
.Contains(
[Not Triggered], Triggered, Upcoming, Started
),
//do this//
runactions(
ModifyRows(thisRow, Status, Started),
ModifyRows(
[Project Orders], [Order Line Item Archive], thisRow
),
openrow([Project Orders], Modals, "Right")
)
),
switchif(
[Order Mechanism] != Task,
ModifyRows(
thisRow,
Status,
switchif(
Status = Ordered and
[Order Mechanism] = Production,
Finished,
Status = Ordered,
Shipped,
Status
.contains(
Shipped,
[Ready for Pick-Up],
[Received w/Issues],
[Partially Shipped],
[Partially Received]
),
Finished,
Status = Delayed,
Finished,
Status.IsBlank(),
Ordered
)
)
),
_delay(
runactions(
switchif(
[Received/Completion Date].IsNotBlank() and
Status.IsBlank(),
ModifyRows(thisRow, Status, Finished),
""
),
switchif(
[Order Mechanism] = Task and Status = Finished,
runactions(
switchif(
Dependents.Trigger.listcombine()
.contains(
[Dependency Completed]
),
modifyrows(
Dependents
.filter(
Trigger = [Dependency Completed] and
Status
.contains(
Upcoming, [Not Triggered]
)
),
Status,
Triggered
),
""
),
switchif(
[Received/Completion Date].IsBlank() and
[Actual Start].IsBlank(),
modifyrows(
thisRow,
[Actual Start],
now(),
[Received/Completion Date],
now()
),
[Received/Completion Date].IsBlank(),
modifyrows(
thisRow, [Received/Completion Date], now()
),
""
)
),
Status = Started and [Actual Start].IsBlank(),
modifyrows(thisRow, [Actual Start], now())
)
),
1500
)
)
113
Order Line Item Archive
Item Image
image
114
Order Line Item Archive
Record Issue
button
runactions(ModifyRows(thisRow,Status,[Received w/Issues],[Actual Completion Date],now()), OpenRow(thisRow, viewOrLayout: [Receiving Workflow], viewMode: "right"))
115
Order Line Item Archive
Status
lookup
Order Status
116
Order Line Item Archive
Shipper
lookup
Shipping Providers
117
Order Line Item Archive
Shipment Activity
text
SwitchIf(
[Tracking Number].IsBlank(),
"",
Shipper.contains(UPS),
UPSTrack([Tracking Number]).Status,
Shipper.Contains(FedEx),
FedExtrack([Tracking Number]).Status.Description,
Shipper.contains(USPS),
USPStrack([Tracking Number]).Status,
""
)
118
Order Line Item Archive
Tracking Number
text
119
Order Line Item Archive
Estimated Delivery
date
SwitchIf([Tracking Number].IsNotBlank(),[Created Date]+Item.[Avg. Time],
Shipper.contains(UPS), UPSTrack([Tracking Number]).DeliveryTimeWindowEnd,
Shipper.contains(FedEx), FedExtrack([Tracking Number]).EstimatedDeliveryTime,
Shipper.contains(USPS),USPStrack([Tracking Number]).ExpectedDeliveryDate, "")
120
Order Line Item Archive
Delivered
date
SwitchIf([Tracking Number].IsBlank(),"",
Shipper.contains(UPS), UPSTrack([Tracking Number]).DeliveryDate,
Shipper.contains(FedEx), FedExtrack([Tracking Number]).TimeDelivered,
Shipper.contains(USPS),USPStrack([Tracking Number]).TimeDelivered, "")
121
Order Line Item Archive
Contact Information
text
Concatenate(
switchif(
Supplier.[External Suppliers].[Primary Contact].IsNotBlank(),
concatenate(
Supplier.[External Suppliers].[Primary Contact]._bold(),
Character(13)
)
),
switchif(
Supplier.[External Suppliers].[Primary Contact Phone]
.IsNotBlank(),
concatenate(
Supplier.[External Suppliers].[Primary Contact Phone],
character(13)
)
),
switchif(
Supplier.[External Suppliers].[Primary Contact Email]
.IsNotBlank(),
Supplier.[External Suppliers].[Primary Contact Email].ToText(),
""
)
)
122
Order Line Item Archive
Email Supplier
button
switchif(
Status.contains([Received w/Issues]),
[Report Issue],
Order.Status.ListCombine()
.contains(
[Partially Received]
) and
Status.Contains(Finished, [Received w/Issues]).not(),
[Report Missing],
[Request Update]
)
.withname(
template,
OPENROW(
AddRow(
[Email Queue],
Supplier,
Supplier,
Complete,
false,
Owner,
user(),
Subject,
template.Subject,
Body,
switchif(
template = [Report Issue],
thisRow,
thisTable
.filter(
Supplier = Supplier and
Status != Finished and
[Include in Receiving] = true and
Order = Order
)
)
.foreach(
concatenate(
"Qty: ",
CurrentValue.Quantity,
" ",
currentvalue.Units,
" ",
CurrentValue.Item.totext(),
" ",
switchif(
[Include Order Description],
CurrentValue.Item
.[Order Description],
""
),
switchif(
[Include Taxable Status],
concatenate(
Character(13),
switchif(
currentvalue.Item.Taxable,
"Taxable",
"Tax-Exempt"
)
),
""
)
)
)
.BulletedList()
.withname(
[item list],
concatenate(
[item list],
character(13),
switchif(
template = [Report Issue],
Notes,
Supplier.[External Suppliers]
.[Vendor Number & Additional Info]
)
)
)
.withname(
orderitems,
format(
template.Body,
Supplier
.[External Suppliers]
.[Primary Contact]
.split(
" "
)
.listcombine()
.first(),
[Created Date].totext(),
orderitems
)
)
),
[Email Queue],
"right"
)
)
123
Order Line Item Archive
Include in Receiving
checkbox
124
Order Line Item Archive
Order Quantity
text
Concatenate(Quantity," ",Units)
125
Order Line Item Archive
Order
lookup
[Order Archive].Filter([Line Items].Contains(thisRow))
Order Archive
126
Order Line Item Archive
Line Items from Order
lookup
Order Line Item Archive
127
Order Line Item Archive
Create Order
button
runactions(AddRow([Order Archive], [Line Items], [Line Items from Order]),ModifyRows([Line Items from Order],[Order Archive],[Order Archive]))
128
Order Line Item Archive
Color
lookup
switchif(
[Order Mechanism] != Task,
Status.Color,
[Color Options]
.filter(
Color =
Status.Color.Color and
Shade = Dark
)
)
Color Options
129
Order Line Item Archive
Color ID
number
Color.[Color ID]
130
Order Line Item Archive
Title
text
_color("#000000", Name)
131
Order Line Item Archive
Person
person
132
Order Line Item Archive
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
133
Order Line Item Archive
Order Documents
lookup
[Order Documents].Filter([Order Line Item Archive].Contains(thisRow))
Order Documents
134
Order Line Item Archive
Project
lookup
Projects.Filter([Items & Tasks].Contains(thisRow))
Projects
135
Order Line Item Archive
Order Mechanism
lookup
Order Mechanism
136
Order Line Item Archive
Location
lookup
Locations
137
Order Line Item Archive
Department
lookup
switchif([Order Mechanism]=Task,Item.Department.ListCombine(), Location.Department.ListCombine())
Departments
138
Order Line Item Archive
Order Cards
lookup
139
Order Line Item Archive
Group Items
button
ModifyRows(thisRow, [Line Items from Order], [Order Line Item Archive].filter(Supplier=Supplier and [Order Mechanism]!= Task and [Created Date]=[Created Date] ))
140
Order Line Item Archive
Time Until Next Order
duration
141
Order Line Item Archive
Item Name
text
Item.[Item Name].ListCombine()
142
Order Line Item Archive
Depends On
lookup
Order Line Item Archive
143
Order Line Item Archive
Target Start
date
144
Order Line Item Archive
Stage Order
number
Item.Department.Order
145
Order Line Item Archive
Dependents
lookup
[Order Line Item Archive].Filter([Depends On].Contains(thisRow))
Order Line Item Archive
146
Order Line Item Archive
Trigger
lookup
Item.Trigger.ListCombine()
Trigger
147
Order Line Item Archive
Trigger On
date
switchif( Trigger=[Days After Project Start],Project.[Start Date]+ Item.[Relative Days to Trigger].ListCombine().first().todays() .ListCombine(),"")
148
Order Line Item Archive
Finish
lookup
Item.[Finish Criteria].ListCombine()
Finished
149
Order Line Item Archive
Depends On End
date
[Depends On].[Target Completion Date].ListCombine().Max()
150
Order Line Item Archive
Target Completion Date
date
switchif(
Item = [Target Completion Date],
Project.[Target Completion Date],
[Actual Start].IsBlank(),
[Target Start],
[Actual Start]
) +
switchif([Target Duration].IsBlank(), 0, [Target Duration])
151
Order Line Item Archive
Target Duration
duration
152
Order Line Item Archive
Update Time
button
runactions(
Project.Tasks
.[Find Dependencies],
switchif(
Trigger = [Days Before Dependent],
runactions(
Dependents.[Update Time]
),
""
),
ModifyRows(
thisRow,
[Target Start],
switchif(
Item.Trigger = [Project Start],
Project.[Start Date],
Trigger.contains([Days After Project Start]),
[Trigger On],
Trigger = [Dependency Completed],
[Depends On End],
Item = [Target Completion Date],
Project.[Target Completion Date],
Project.[Start Date]
)
),
switchif(
Dependents.Trigger.ListCombine()
.contains(
[Days After Project Start]
),
foreach(
[Depends On],
switchif(
CurrentValue.Trigger
.contains(
[Days After Project Start]
),
CurrentValue
.WithName(
task,
ModifyRows(
task,
[Target Start],
task.Dependents
.[Target Start] -
task.Item
.[Relative Days to Trigger]
)
),
""
)
),
""
),
switchif(
Dependents.isblank(),
"",
Dependents.[Update Time]
)
)
153
Order Line Item Archive
Actual Start
date
154
Order Line Item Archive
Components
lookup
Components
155
Order Line Item Archive
Find Dependencies
button
runactions(
ModifyRows(
thisRow,
[Depends On],
switchif(
Item = [Target Completion Date],
[Order Line Item Archive]
.filter(
Project = Project
)
.maxby(
[Depends On End]
),
thisTable
.filter(
Item.[Depends On].ListCombine()
.contains(
CurrentValue.Item
) and
Project = Project and
Item.[Order Mechanism] = Task
)
)
)
)
156
Order Line Item Archive
Finish Criteria Met
checkbox
switchif(
//criteria//
[Order Mechanism] = Task and Status = Started and
Finish = [External Items Received] and
Project.IsNotBlank(),
//status//
[Order Line Item Archive]
.filter(
Project = Project and
[Order Mechanism] != Task
)
.Status
.ListCombine()
.Unique()
.containsonly(
Finished
),
//criteria//
[Order Mechanism] = Task and
Finish = [On Completion] and
Status = Started,
//status//
true,
//criteria//
Finish = [Link Opened] and
[Order Mechanism] = Task and
[Link Opened] = false,
//status//
false,
//criteria//
Finish = [Link Opened] and
[Order Mechanism] = Task and
[Link Opened] = true,
//status//
true,
//criteria//
[Order Mechanism] != Task or
Finish.contains([On Completion]),
//status//
true,
//criteria//
[Order Mechanism] = Task and
Finish = [BOM Finalized] and
[Order Line Item Archive]
.Project
.Finalized =
false,
//status//
false,
//criteria//
[Order Mechanism] = Task and
Finish = [BOM Finalized] and
[Order Line Item Archive]
.Project
.Finalized =
true,
//status//
true,
//criteria//
Project.IsBlank() and
Item.[Related Items].IsNotBlank() and
[Order Line Item Archive]
.filter(
[Created Date] >=
[Created Date]
)
.Item
.ListCombine()
.containsall(
Item.[Related Items].ListCombine()
),
//status//
true,
//criteria//
Project.Finalized = true and
Project.[Build-Specific Cart Line Items]
.IsBlank(),
//status//
true,
//criteria//
Project.IsBlank(),
//status//
false,
//criteria//
Finish = [Production Completed],
//status//
switchif(
[Build-Specific Cart Line Items]
.filter(
Project = Project and
[Order Mechanism] =
Production
)
.ListCombine()
.filter(
currentvalue.IsNotBlank()
)
.count() =
0,
true,
false
),
//criteria//
Finish = [External Items Received],
//status//
switchif(
Project.IsBlank() and
Item.[Related Items].IsNotBlank() and
[Order Line Item Archive]
.filter(
[Created Date] >=
[Created Date]
)
.Item
.ListCombine()
.containsall(
Item.[Related Items].ListCombine()
) and
foreach(
Item.[Related Items].listcombine(),
[Order Line Item Archive]
.filter(
[Created Date] >=
[Created Date] and
Item = CurrentValue
)
.Status
.ListCombine()
.contains(
Finished
)
)
.ListCombine()
.unique()
.containsonly(
true
),
true,
Project.Orders.listcombine().IsBlank() or
Project.Orders
.Status
.ListCombine()
.Unique()
.filter(
CurrentValue.IsNotBlank()
)
.ContainsOnly(
Finished
)
)
)
157
Order Line Item Archive
Start Criteria Met
checkbox
switchif([Order Mechanism]!=Task,true,
Trigger = [Dependency Completed],
[Depends On].Status.ListCombine()
.Unique() =
Finished,
Trigger = [Days After Project Start],
[Trigger On]<=today(),
true
)
158
Order Line Item Archive
Delete
button
DeleteRows(thisRow)
159
Order Line Item Archive
Edit
button
switchif(Item.[Order Mechanism]=Task, OpenRow(thisRow,[Project Tasks],"Right"),openrow(thisRow,[Order Line Item Archive],"Right"))
160
Order Line Item Archive
Item Text
text
161
Order Line Item Archive
Icon
text
switchif(
Status = Finished,
"checkmark",
or(
and(
Finish = [BOM Finalized] and
Project.Finalized
),
and(
Finish = [External Items Ordered],
Project.[Build-Specific Cart Line Items]
.ListCombine()
.IsBlank()
),
and(
[Order Mechanism] = Task,
[Finish Criteria Met],
Status = Started
)
),
"finish-flag",
Finish = [Production Completed] and
[Finish Criteria Met] = false,
"gears",
Finish = [External Items Ordered],
"add-shopping-cart",
Finish = [Link Opened] and [Link Opened] = false,
"external-link-squared",
Finish = [BOM Finalized] and
Project.Finalized = false,
"add-database",
[Order Mechanism] = Task and
Status
.contains(
[Not Triggered], Upcoming, Triggered
),
"arrow",
[Order Mechanism] != Production and
Status = Ordered,
"truck",
[Order Mechanism]!=Production and Status
.contains(
Shipped,
[Partially Shipped],
[Partially Received],
[Received w/Issues],
Delayed
) or
and(
Status = Ordered,
[Order Mechanism] = Production
) or and(
Finish = [External Items Received] ,
[Finish Criteria Met] = false),
"sell"
)
162
Order Line Item Archive
Flag
reaction
163
Order Line Item Archive
Row URL
text
ObjectLink(thisRow)
164
Order Line Item Archive
QR Code
text
165
Order Line Item Archive
Print
button
runactions(switchif([QR Code].IsBlank(),[Generate QR Code],"")
,
OpenRow(thisRow, [Received Today], "Right")
)
166
Order Line Item Archive
Print Format
text
format(
[Print Size].Template,
_color("#000000", Name),
"",
Project.[Target Completion Date].totext(),
"",
"",
[QR Code].image(175, 175),
Project.Product.totext(),
"",
Project.[Start Date].ToText(),
concatenate(
Department.Color
.[Short Rectangle]
.image(),
Project.Product.Color
.[Short Rectangle]
.image(),
Department.Color
.[Short Rectangle]
.image()
),
_Color(
switchif(
[Color Code Title Text],
Department.Color.Color
.[Dark Hex],
"#000000"
),
"Start Date"
),
_Color(
switchif(
[Color Code Title Text],
Department.Color.Color
.[Dark Hex],
"#000000"
),
"Target End Date"
),
_Color(
switchif(
[Color Code Title Text],
Department.Color.Color
.[Dark Hex],
"#000000"
),
"Department"
),
Department.ToText(),
Department.ToText(),
_Color(
switchif(
[Color Code Title Text],
Department.Color.Color
.[Dark Hex],
"#000000"
),
"Person"
),Department.totext(),
Person.totext()
)
167
Order Line Item Archive
Generate QR Code
button
ModifyRows(
thisRow,
[QR Code],
BarcodeQR([Row URL], "white", "black")
)
168
Order Line Item Archive
Print Size
lookup
Formats by Size
169
Order Line Item Archive
Additional Cost
currency
170
Order Line Item Archive
Total Cost
currency
[Item Price]+[Additional Cost]
171
Order Line Item Archive
Link
link
Item.[URL 1].listcombine().totext().trim()
172
Order Line Item Archive
Link Opened
checkbox
173
Order Line Item Archive
Open Link
button
OpenWindow(Link)
174
Order Line Item Archive
Average Cost
currency
[Order Line Item Archive].filter(Item=Item).[Total Cost].listcombine().average()
175
Order Line Item Archive
Price Deviation
percent
([Average Cost]-[Total Cost])/[Average Cost]
176
Locations
Name
text
177
Locations
Department
lookup
Departments
178
Locations
Color
lookup
Department.Color
Color Options
179
Locations
Color ID
text
Color.[Color ID].ListCombine()
180
Locations
Sub-Locations
lookup
[Sub-Locations].Filter(Location.Contains(thisRow))
Sub-Locations
181
Locations
ID
text
RowId(thisRow)
182
Locations
Edit
button
OpenRow(thisRow,Locations,"Right")
183
Locations
Create/Open SOP
button
switchif(
SOP.IsBlank(),
SOPs.filter(Name.IsBlank()).MinBy([SOP Number]),
SOP
)
.WithName(
target,
runactions(
ModifyRows(
thisRow,
SOP,
ModifyRows(
target,
[SOP Type],
[Location/Equipment],
Name,
Concatenate(Name, " SOP"),
Department,
Department,
Location,
thisRow
)
),
openrow(target, [SOPs Location View], "Right")
)
)
184
Locations
Delete
button
runactions(DeleteRows(SOPs.filter([SOP Type]=[Location/Equipment] and Location.contains(thisRow) )), DeleteRows(thisRow))
185
Locations
Actions
text
Concatenate(button([Create/Open SOP],"","Blue","","",false,"Small","assignment-turned-in")," ",button(Edit,"","Orange","","",false,"Small","pencil")," ",button(Delete,"","Red","","",false,"Small","trash"))
186
Locations
SOP
lookup
SOPs
187
Locations
Related SOPs
lookup
SOPs.Filter(Location.Contains(thisRow))
SOPs
188
Locations
Department Text
text
Department.Department
189
Locations
Production Queue
lookup
Items
.Filter(
[Internal Supplier].Contains(thisRow) and
[To Order] != 0 and
[To Order].IsNotBlank()
)
Items
190
Locations
Internal Receiving
lookup
[Order Line Item Archive].Filter(Location.Contains(thisRow) and Status!=Finished and [Order Mechanism]=Production)
Order Line Item Archive
191
Company Information
Company Name
text
192
Company Information
Primary Contact
text
193
Company Information
Company Address
canvas
194
Company Information
Primary Contact Phone Number
text
195
Company Information
Primary Contact Email
email
196
Company Information
Logo
image
197
Company Information
Short Company Description
text
198
Company Information
Unique Identifier
text
199
Company Information
Customer Support URl
link
200
External Suppliers
Supplier
lookup
thisTable.filter([Supplier Name]=[Supplier Name])
External Suppliers
201
External Suppliers
Notes
canvas
202
External Suppliers
Zip Code
text
203
External Suppliers
Address
text
204
External Suppliers
Website
link
205
External Suppliers
Primary Contact
text
206
External Suppliers
Email Queue
lookup
[Email Queue].Filter(Supplier.Contains(thisRow))
Email Queue
207
External Suppliers
CityState
text
208
External Suppliers
Vendor Number & Additional Info
text
209
External Suppliers
Edit
button
OpenRow(thisRow, viewOrLayout: [Master Suppliers], viewMode: "right")
210
External Suppliers
Primary Contact Email
email
211
External Suppliers
Primary Contact Phone
text
212
External Suppliers
Secondary Contact
text
213
External Suppliers
Secondary Contact Email
email
214
External Suppliers
Secondary Contact Phone
text
215
External Suppliers
Items
lookup
Items.Filter([Primary Supplier].Contains(thisRow))
Items
216
External Suppliers
Order Mechanism
lookup
Items.[Order Mechanism].ListCombine().Unique().first()
Order Mechanism
217
External Suppliers
Color
lookup
[Order Mechanism].Color
Color Options
218
External Suppliers
Color ID
text
Color.[Color ID].ListCombine()
219
External Suppliers
Supplier Name
text
220
External Suppliers
Related SOPs
lookup
SOPs.Filter([External Supplier].Contains(thisRow))
SOPs
221
External Suppliers
SOP
lookup
SOPs
222
External Suppliers
Username
text
223
External Suppliers
Password
text
224
External Suppliers
Create/Open SOP
button
switchif(
SOP.IsBlank(),
SOPs.filter(Name.IsBlank()).MinBy([SOP Number]),
SOP
)
.WithName(
target,
runactions(
ModifyRows(thisRow, SOP, target),
ModifyRows(
target,
[SOP Type],
Supplier,
[External Supplier],
thisRow,
Item,
Items,
Name,
Concatenate([Supplier Name], " SOP")
),
openrow(target, [SOPs Supplier View], "Right")
)
)
225
External Suppliers
Delete
button
runactions(switchif(Items.IsBlank(),"",
ModifyRows(
Items, [Primary Supplier], "", [URL 1], ""
)),
DeleteRows(thisRow)
)
226
External Suppliers
Order Minimum
currency
227
External Suppliers
Payment Terms
lookup
Payment Terms
228
External Suppliers
Shipping Terms
lookup
Shipping Terms
229
Email Queue
Task Name
text
Concatenate("Order from ", Supplier.totext()," - ",[Due Date])
230
Email Queue
Contact
text
switchif(
[Use Secondary Contact],
Concatenate(
Supplier.[External Suppliers]
.[Secondary Contact]._bold(),
" - ",
Supplier.[External Suppliers]
.[Secondary Contact Email]
),
Concatenate(
Supplier.[External Suppliers]
.[Primary Contact]._bold(),
" - ",
Supplier.[External Suppliers]
.[Primary Contact Email]
)
).ToText()
231
Email Queue
Due Date
date
232
Email Queue
Supplier
lookup
Master Suppliers
233
Email Queue
Complete
checkbox
234
Email Queue
Detail
text
235
Email Queue
Recipient Emai
email
switchif([Use Secondary Contact],Supplier.[External Suppliers].[Secondary Contact Email],Supplier.[External Suppliers]. [Primary Contact Email] )
236
Email Queue
Subject
text
237
Email Queue
Body
canvas
238
Email Queue
Alternate Recipient Email Address
email
239
Email Queue
Finish/Send Email
button
runactions(
OpenWindow(ObjectLink([Shopping Cart])),
switchif(
[Order Documents].IsNotBlank(),
ModifyRows(
[Order Documents], Status, Ordered
),
""
),
switchif(
Outlook,
AddRow(
[Outlook Emails],
Subject,
Subject,
Body,
Body,
[CC Email Addresses],
[CC Email Address],
Recipient,
[Recipient Emai]
),
GmailSendEmail(
[User's private Gmail account],
[Recipient Emai],
Subject,
Body,
[CC Email Address]
)
),
ModifyRows(thisRow, Complete, true),
[Shopping Cart]
.filter(
Items.ListCombine()
.contains(
currentvalue.Item
)
)
.[Create Order Record],
Delete
)
240
Email Queue
Task Finished Time
dateTime
Complete.Modified()
241
Email Queue
Owner
person
242
Email Queue
CC Email Address
email
243
Email Queue
Items
lookup
Items
244
Email Queue
Order Quantity
text
245
Email Queue
Use Secondary Contact
checkbox
246
Email Queue
Delete
button
DeleteRows(thisRow)
247
Email Queue
Send To Myself
button
switchif(
Outlook,
AddRow(
[Outlook Emails],
Subject,
Subject,
Body,
Body,
[CC Email Addresses],
[CC Email Address],
Recipient,
user().Email
),
GmailSendEmail(
[User's private Gmail account],
user().Email,
Subject,
Body,
cc: [CC Email Address]
)
)
248
Email Queue
Projects
lookup
Projects.Filter([Email Queue].Contains(thisRow))
Projects
249
Email Queue
Order Documents
lookup
Order Documents
250
Format Templates
Handle
text
251
Format Templates
Template
canvas
252
Email Templates
Name
text
253
Email Templates
Subject
canvas
254
Email Templates
Body
canvas
255
Email Templates
Master Tasks - Sales
lookup
[Campaign Email Tasks].Filter(Template.Contains(thisRow)).Unique()
256
Email Templates
Campaign Stages
lookup
[Campaign Timeline].Filter(Template.Contains(thisRow))
257
Email Templates
Campaign Type
lookup
[Marketing Campaigns].Type.Unique()
258
Email Templates
Step
number
[Campaign Timeline].Filter([Campaign Stages].Contains(Name)).Step.unique().max()
259
Email Templates
Character Count
text
length(Body)
260
Order Mechanism
Order Mechanism
text
261
Order Mechanism
Color
lookup
Color Options
262
Order Mechanism
Color ID
number
Color.[Color ID].ListCombine()
263
Departments
Department
text
264
Departments
Color
lookup
Color Options
265
Departments
Color ID
number
Color.[Color ID]
266
Departments
Locations
lookup
Locations.Filter(Department.Contains(thisRow))
Locations
267
Departments
ID
text
RowId(thisRow)*100
268
Departments
SOP
lookup
SOPs
269
Departments
Edit
button
openrow(thisRow,Departments,"Right")
270
Departments
Related SOPs
lookup
SOPs.Filter(Department.Contains(thisRow))
SOPs
271
Departments
Create/Open SOP
button
switchif(
SOP.IsBlank(),
SOPs.filter(Name.IsBlank()).MinBy([SOP Number]),
SOP
)
.WithName(
target,
runactions(
ModifyRows(
thisRow,
SOP,
ModifyRows(
target,
[SOP Type],
Department,
Item,
thisRow,
Name,
Concatenate(Department, " SOP"),
Department,
Department,
Location,
Locations
)
),
openrow(target, [SOPs Department View], "Right")
)
)
272
Departments
Delete
button
runactions(DeleteRows([Sub-Locations].Filter(Locations.listcombine().contains(CurrentValue.Location))), deleterows(Locations),switchif(SOP.IsBlank(),"", DeleteRows(SOP)),DeleteRows(thisRow))
273
Departments
Actions
text
Concatenate(
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
)
)
274
Departments
Order
number
switchif(Tasks.[Depends On].IsBlank(),1, Tasks.[Depends On].Sequence.ListCombine().max()+1)
275
Departments
Tasks
lookup
Items.Filter(Department.Contains(thisRow) and [Order Mechanism]=Task)
Items
276
Shopping Cart
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
277
Shopping Cart
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
278
Shopping Cart
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
279
Shopping Cart
Order Units
text
280
Shopping Cart
Order Description
text
281
Shopping Cart
Unit Price
currency
282
Shopping Cart
Order Price
currency
[Unit Price]*[To Order]
283
Shopping Cart
Trigger
lookup
Trigger
284
Shopping Cart
Projects
lookup
Projects.Filter(Items.Contains(thisRow))
Projects
285
Shopping Cart
Receiving Inclusion
checkbox
286
Shopping Cart
Taxable
checkbox
287
Shopping Cart
Flag
reaction
288
Shopping Cart
Supplier
lookup
switchif(
[Order Mechanism].IsBlank() or
Name = "Target Completion Date" or
Name = "Project Start" or
and(
[Order Mechanism].contains(Task, Production).not(),
[Secondary Supplier].IsBlank(),
[Primary Supplier].IsBlank()
),
"",
[Order Mechanism] = Task and Department.IsBlank(),
"",
[Order Mechanism] = Task,
[Master Suppliers]
.filter(
Department = Department and
CurrentValue.Name.IsNotBlank()
),
[Order Mechanism] = Production,
[Master Suppliers]
.filter(
Locations = [Internal Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Use Secondary Supplier] and
[Secondary Supplier].IsNotBlank(),
[Master Suppliers]
.filter(
[External Suppliers] =
[Secondary Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Master Suppliers]
.filter(
[External Suppliers] = [Primary Supplier] and
CurrentValue.Name.IsNotBlank()
)
)
Master Suppliers
289
Shopping Cart
Notes
canvas
290
Trigger
Task Triggered
text
_color(Color.[Text Color],Name)
291
Trigger
Color
lookup
Color Options
292
Trigger
Color ID
text
Color.[Color ID].ListCombine()
293
Trigger
Order Mechanism
lookup
Order Mechanism
294
Trigger
Name
text
295
Trigger
Tasks
lookup
Items.filter([Order Mechanism]=Task and Trigger=thisRow)
Items
296
Trigger
Criteria
checkbox
switchif(
[Task Triggered] = "Mondays",
today().WeekdayName() = "Monday",
[Task Triggered] = "Tuesdays",
today().WeekdayName() = "Tuesday",
[Task Triggered] = "Wednesdays",
today().WeekdayName() = "Wednesday",
[Task Triggered] = "Thursdays",
today().WeekdayName() = "Thursday",
[Task Triggered] = "Fridays",
today().WeekdayName() = "Friday",
[Task Triggered] = "Every Other Monday",
today().WeekdayName() = "Monday" and today().day() < 8 and
or(today().day() > 14 and today().day() < 22),
[Task Triggered] = "1st of Each Month",
today().day() = 1,
[Task Triggered] = "1st of Every Even Month",
today().day() = 1 and today().Month().IsEven(),
[Task Triggered],
Today().day() = 1 and today().month().IsOdd(),
[Task Triggered] = "1st of the Quarter",
today().day() = 1 and
list(1, 3, 6, 9).contains(today().month()),
[Task Triggered] = "1st of the Year",
today().day() = 1 and today().month() = 1,
[Task Triggered] = "1st of the Half",
today().day() = 1 and list(1, 6).contains(today().month())
)
297
Trigger
Trigger Tasks
button
runactions(Tasks.[Add to Cart])
298
Trigger
Next Date
date
switchif([Task Triggered].contains("Immediately","End of Day","On Demand","Project Start","Days After Project Start","Dependency Completed"),"",
[Task Triggered] = "1st of The Month",
date(
switchif(
today().month() = 12, today().Year() + 1, today().year()
),
switchif(
today().day() = 1, today().month(), today().month() + 1
),
1
),
[Task Triggered] = "1st of the Year",
switchif(
today().day() = 1 and today().month() = 1,
today(),
date(today().year() + 1, 1, 1)
),
[Task Triggered] = "1st of the Half",
switchif(
today().day() = 1 and list(1, 6).contains(today().month()),
today(),
today().month() < 6,
date(today().year(), 6, 1),
date(today().year() + 1, 1, 1)
),
[Task Triggered] = "1st of the Quarter",
switchif(
today().day() = 1 and
list(1, 3, 6, 9).contains(today().month()),
today(),
today().month() < 3,
date(today().year(), 3, 1),
today().month() < 6,
date(today().year(), 6, 1),
today().month() < 9,
date(today().year(), 9, 1),
date(today().year() + 1, 1, 1)
),
[Task Triggered] = "1st of Every Even Month",
switchif(
today().day() = 1 and today().month().IsEven(),
today(),
date(
switchif(
today().month() = 12, today().year() + 1, today().year()
),
switchif(today().month().IsEven(), today().month() + 2,today().month()+1),
1
)
),
[Task Triggered] = "1st of Every Odd Month",
switchif(
today().day() = 1 and today().month().Isodd(),
today(),
date(
switchif(
today().month() = 11, today().year() + 1, today().year()
),
switchif(today().month().Isodd(), today().month() + 2,today().month()+1),
1
)
),
foreach(
sequence(1, 7),
listcombine(today() + CurrentValue)
.WithName(
day,
day
.Filter(
CurrentValue.WeekdayName().lower() =
Name.lower().left(length(Name) - 1)
)
)
)
.ListCombine()
)
299
Trigger
Notiy
button
foreach(Tasks, Notify(currentvalue.Person,Concatenate(CurrentValue, " has been triggered." ) ))
300
Shopping Lists
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
301
Shopping Lists
Supplier
lookup
switchif(
[Order Mechanism].IsBlank() or
Name = "Target Completion Date" or
Name = "Project Start" or
and(
[Order Mechanism].contains(Task, Production).not(),
[Secondary Supplier].IsBlank(),
[Primary Supplier].IsBlank()
),
"",
[Order Mechanism] = Task and Department.IsBlank(),
"",
[Order Mechanism] = Task,
[Master Suppliers]
.filter(
Department = Department and
CurrentValue.Name.IsNotBlank()
),
[Order Mechanism] = Production,
[Master Suppliers]
.filter(
Locations = [Internal Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Use Secondary Supplier] and
[Secondary Supplier].IsNotBlank(),
[Master Suppliers]
.filter(
[External Suppliers] =
[Secondary Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Master Suppliers]
.filter(
[External Suppliers] = [Primary Supplier] and
CurrentValue.Name.IsNotBlank()
)
)
Master Suppliers
302
Shopping Lists
To Order Quantity
text
Concatenate([To Order],switchif([Order Units].IsBlank(),"",Concatenate(" ",[Order Units])))
303
Shopping Lists
In Cart
checkbox
304
Bulk Print Layouts
2x2
canvas
305
Bulk Print Layouts
Print 2 Template
canvas
306
Bulk Print Layouts
Vertical
canvas
307
Bulk Print Layouts
2 Columns
canvas
308
Bulk Print Layouts
3 Columns
canvas
309
Bulk Print Layouts
4 Columns
canvas
310
Formats by Size
Size
text
_color(Color.[Text Color], switchif([Metric Mode],[Metric Measurements],[Imperial Measurementss]))
311
Formats by Size
Input
text
312
Formats by Size
Color
lookup
Color Options
313
Formats by Size
Color ID
number
Color.[Color ID].ListCombine()
314
Formats by Size
Template
canvas
315
Formats by Size
Alternate Template
canvas
316
Formats by Size
Print Document Type
lookup
Print Document Type
317
Formats by Size
Imperial Measurementss
text
318
Formats by Size
Metric Measurements
text
319
Outstanding Items
Item
lookup
Items
320
Outstanding Items
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
321
Outstanding Items
Supplier
lookup
Master Suppliers
322
Outstanding Items
Contact Information
text
Concatenate(
switchif(
Supplier.[External Suppliers].[Primary Contact].IsNotBlank(),
concatenate(
Supplier.[External Suppliers].[Primary Contact]._bold(),
Character(13)
)
),
switchif(
Supplier.[External Suppliers].[Primary Contact Phone]
.IsNotBlank(),
concatenate(
Supplier.[External Suppliers].[Primary Contact Phone],
character(13)
)
),
switchif(
Supplier.[External Suppliers].[Primary Contact Email]
.IsNotBlank(),
Supplier.[External Suppliers].[Primary Contact Email].ToText(),
""
)
)
323
Outstanding Items
Lead Time
duration
324
Outstanding Items
Tracking Number
text
325
Outstanding Items
Shipper
lookup
Shipping Providers
326
Outstanding Items
Shipment Activity
text
SwitchIf(
[Tracking Number].IsBlank(),
"",
Shipper.contains(UPS),
UPSTrack([Tracking Number]).Status,
Shipper.Contains(FedEx),
FedExtrack([Tracking Number]).Status.Description,
Shipper.contains(USPS),
USPStrack([Tracking Number]).Status,
""
)
327
Outstanding Items
Estimated Delivery
date
SwitchIf([Tracking Number].IsNotBlank(),[Created Date]+Item.[Avg. Time],
Shipper.contains(UPS), UPSTrack([Tracking Number]).DeliveryTimeWindowEnd,
Shipper.contains(FedEx), FedExtrack([Tracking Number]).EstimatedDeliveryTime,
Shipper.contains(USPS),USPStrack([Tracking Number]).ExpectedDeliveryDate, "")
328
Outstanding Items
Delivered
date
SwitchIf([Tracking Number].IsBlank(),"",
Shipper.contains(UPS), UPSTrack([Tracking Number]).DeliveryDate,
Shipper.contains(FedEx), FedExtrack([Tracking Number]).TimeDelivered,
Shipper.contains(USPS),USPStrack([Tracking Number]).TimeDelivered, "")
329
Outstanding Items
Status
lookup
Order Status
330
Outstanding Items
Project
lookup
Projects.Filter([Items & Tasks].Contains(thisRow))
Projects
331
Outstanding Items
Order
lookup
[Order Archive].Filter([Line Items].Contains(thisRow))
Order Archive
332
Bulk Printing
Bulk Printing
canvas
switchif(
RowId(thisRow) = 1,
concatenate(
switchif(
[Select Bulk Print Card Format] = [1 Column],
[4 Cards (1 Column)]
.filter(
CurrentValue.IsNotBlank()
),
[Select Bulk Print Card Format] = [2 x 2],
[4 Cards (2 Columns)]
.Filter(
CurrentValue.IsNotBlank()
),
[Select Bulk Print Card Format] = [Size Selected],
[1 Card].Filter(CurrentValue.IsNotBlank()),
[Select Bulk Print Card Format] = [2 Columns],
[Grouped Items]
.Filter(
[Groups of 10].IsNotBlank()
)
.[10 Cards]
)
),
rowid(thisRow) = 6,
concatenate(
SwitchIf(
[Select Bulk Print Label Format] = [1 Column],
[Labels 1 Column]
.Filter(
CurrentValue.IsNotBlank()
),
[Select Bulk Print Label Format] = [2 Columns] ,
[Labels 2 Columns]
.Filter(
CurrentValue.IsNotBlank()
),
[Select Bulk Print Label Format] = [4 Columns],
[Labels 4 Columns]
.Filter(
CurrentValue.IsNotBlank()
)
)
.filter(
CurrentValue.IsNotBlank() and
CurrentValue.containstext(" ").not()
)
)
)
333
Receiving Workflow
Name
text
_color(
Color.[Text Color],
switchif(
Item.[Order Mechanism] = Task,
Concatenate(
switchif(Project.IsNotBlank(), Concatenate(Project, " - ")),
Item
)
.totext(),
concatenate(
Item, " - ", [Created Date].datetimeTruncate("day")
)
.totext()
.withname(
name, name.left(name.Length() - 5)
)
)
)
334
Receiving Workflow
Estimated Delivery
date
SwitchIf([Tracking Number].IsNotBlank(),[Created Date]+Item.[Avg. Time],
Shipper.contains(UPS), UPSTrack([Tracking Number]).DeliveryTimeWindowEnd,
Shipper.contains(FedEx), FedExtrack([Tracking Number]).EstimatedDeliveryTime,
Shipper.contains(USPS),USPStrack([Tracking Number]).ExpectedDeliveryDate, "")
335
Receiving Workflow
Lead Time
duration
336
Receiving Workflow
Status
lookup
Order Status
337
Receiving Workflow
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
338
Order Status
Order Status
text
339
Order Status
Color
lookup
Color Options
340
Order Status
Color ID
number
Color.[Color ID]
341
Order Status
Order Mechanism
lookup
Order Mechanism
342
Order Status
Order
number
343
Order Archive
Order Items
lookup
Items
344
Order Archive
Supplier
lookup
Master Suppliers
345
Order Archive
Quantities
text
346
Order Archive
Order Date
date
347
Order Archive
Line Items
lookup
Order Line Item Archive
348
Order Archive
Status
lookup
[Line Items].Status.filter(CurrentValue.IsNotBlank()).unique().WithName(statuses,switchif(statuses.ListCombine().contains([Received w/Issues]),[Received w/Issues], statuses.ListCombine().count()>1 and statuses.Contains(Finished,[Received w/Issues],[Partially Received]),[Partially Received],statuses.contains(Shipped) and statuses.contains(Ordered),[Partially Shipped],statuses) )
Order Status
349
Order Archive
Name
text
_color(Color.[Text Color], Concatenate(Supplier," - ",[Order Date]).ToText())
350
Order Archive
Receive All
button
RunActions([Line Items].Advance)
351
Order Archive
Email Supplier
button
RunActions([Line Items].filter(CurrentValue.Status!=Finished).listcombine().unique().first().[Email Supplier])
352
Order Archive
Price
currency
[Line Items].[Total Cost].listcombine().sum()
353
Order Archive
Color
lookup
Status.Color.ListCombine()
Color Options
354
Order Archive
Color ID
number
Color.[Color ID]
355
Order Archive
TItle
text
_color([Medium Hex], Concatenate(Supplier," - ",[Order Date]).ToText())
356
Order Archive
Actions
text
switchif(
Status.ContainsOnly(Finished),
"",
concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" ",
button(
[Receive All],
"",
"Green",
"",
"",
false,
"Small",
switchif(Status = Ordered, "truck", "receive-cash")
),
" ",
button(Delete, "", "Red", "", "", false, "Small", "trash")
)
)
357
Order Archive
Lead Time
duration
switchif([Line Items].[Received/Completion Date].ListCombine().IsBlank(),today()-[Order Date],[Order Date]-[Line Items].[Received/Completion Date].ListCombine().max())
358
Order Archive
Delete
button
runactions(DeleteRows([Line Items]),DeleteRows(thisRow))
359
Order Archive
Order
lookup
[Order Archive].filter(CurrentValue=thisRow )
Order Archive
360
Orders
Name
text
_color(Color.[Text Color], Concatenate(Supplier," - ",[Order Date]).ToText())
361
Orders
Status
lookup
[Line Items].Status.filter(CurrentValue.IsNotBlank()).unique().WithName(statuses,switchif(statuses.ListCombine().contains([Received w/Issues]),[Received w/Issues], statuses.ListCombine().count()>1 and statuses.Contains(Finished,[Received w/Issues],[Partially Received]),[Partially Received],statuses.contains(Shipped) and statuses.contains(Ordered),[Partially Shipped],statuses) )
Order Status
362
Orders
Lead Time
duration
switchif([Line Items].[Received/Completion Date].ListCombine().IsBlank(),today()-[Order Date],[Order Date]-[Line Items].[Received/Completion Date].ListCombine().max())
363
Orders
Actions
text
switchif(
Status.ContainsOnly(Finished),
"",
concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" ",
button(
[Receive All],
"",
"Green",
"",
"",
false,
"Small",
switchif(Status = Ordered, "truck", "receive-cash")
),
" ",
button(Delete, "", "Red", "", "", false, "Small", "trash")
)
)
364
Shade
Name
canvas
365
Colors
Name
text
366
Colors
Light Hex
text
367
Colors
Medium Hex
text
368
Colors
Dark Hex
text
369
Color Options
Name
text
_color([Text Color] ,Concatenate(Shade," ",Color).ToText()).trim()
370
Color Options
Color
lookup
Colors
371
Color Options
Shade
lookup
Shade
372
Color Options
Color ID
number
switchif([Dark Mode],[Night ID],[Day ID])
373
Color Options
Text Color
text
switchif([Dark Mode] and [Night ID] > 24, "#000000", [Dark Mode] and [Night ID]>8,"#FFFFFF",[Dark Mode],Color.[Light Hex], Shade.contains(Light,[ ]),Color.[Dark Hex], Color.[Light Hex])
374
Color Options
Rectangle
canvas
image(SVG)
375
Color Options
Raw SVG
canvas
376
Color Options
SVG
text
Concatenate(
"data:image/svg+xml,",[Raw SVG]
.RegexReplace("\n|\t", "").Split("").FormulaMap(
CurrentValue.Switch(
" ", "%20",
"<", "%3C",
">", "%3E",
"#", "%23",
CurrentValue
)
)
)
377
Color Options
Night ID
number
378
Color Options
Day ID
number
379
Color Options
Light Rectangle
canvas
image([Light SVG])
380
Color Options
Light Raw SVG
canvas
381
Color Options
Light SVG
text
Concatenate(
"data:image/svg+xml,",[Light Raw SVG]
.RegexReplace("\n|\t", "").Split("").FormulaMap(
CurrentValue.Switch(
" ", "%20",
"<", "%3C",
">", "%3E",
"#", "%23",
CurrentValue
)
)
)
382
Color Options
Short Rectangle
canvas
image([Short SVG])
383
Color Options
Short Raw SVG
canvas
384
Color Options
Short SVG
text
Concatenate(
"data:image/svg+xml,",[Short Raw SVG]
.RegexReplace("\n|\t", "").Split("").FormulaMap(
CurrentValue.Switch(
" ", "%20",
"<", "%3C",
">", "%3E",
"#", "%23",
CurrentValue
)
)
)
385
Color Coding Options
Color Coding Option
text
386
Color Coding Options
Table
text
387
Item Type
Item Type
text
388
Item Type
Color
lookup
Color Options
389
Item Type
Item Sub-Type
lookup
[Item Sub-Type].Filter([Item Type].Contains(thisRow))
Item Sub-Type
390
Item Type
Color ID
text
Color.[Color ID].ListCombine()
391
Item Sub-Type
Item Sub-Type
text
392
Item Sub-Type
Item Type
lookup
Item Type
393
Item Sub-Type
Notes
canvas
394
Item Sub-Type
Color
lookup
[Item Type].Color
Color Options
395
Item Sub-Type
Color ID
text
Color.[Color ID].ListCombine()
396
Received Today
Name
text
_color(
Color.[Text Color],
switchif(
Item.[Order Mechanism] = Task,
Concatenate(
switchif(Project.IsNotBlank(), Concatenate(Project, " - ")),
Item
)
.totext(),
concatenate(
Item, " - ", [Created Date].datetimeTruncate("day")
)
.totext()
.withname(
name, name.left(name.Length() - 5)
)
)
)
397
Received Today
Status
lookup
Order Status
398
Received Today
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
399
Grouped Items
Sequence of 4
text
400
Grouped Items
Groups of 4
lookup
foreach([Sequence of 4].listcombine(),Items.filter(Select).listcombine().nth(CurrentValue)).Filter(CurrentValue.IsNotBlank())
Items
401
Grouped Items
4 Cards (2 Columns)
canvas
concatenate(
[Groups of 4].nth(1)
.WithName(
first,
switchif(
[Groups of 4].count() = 1,
Items.filter(Name.IsBlank()).last(),
[Groups of 4].nth(2)
)
.WithName(
second,
switchif(
[Groups of 4].count() < 3,
Items.filter(Name.IsBlank()).last(),
[Groups of 4].nth(3)
)
.WithName(
third,
switchif(
[Groups of 4].count() < 4,
Items.filter(Name.IsBlank()).last(),
[Groups of 4].nth(4)
)
.WithName(
fourth,
format(
[2x2],
_color("#000000", first.[Item Name]),
switchif(
first.[Order Mechanism] = Production,
first.[Internal Supplier].ToText(),
first.Supplier.ToText()
),
switchif(
first.[Sub-Location].IsNotBlank(),
Concatenate(
first.Location, " - ", first.[Sub-Location]
)
.ToText(),
first.Location.ToText()
),
concatenate(
first.[Min Qty], " ", first.[Min. Units].trim()
),
switchif(
first.[Order Units].IsBlank(),
first.[Order Qty],
concatenate(
first.[Order Qty], " ", first.[Order Units]
)
)
.trim(),
first.[Database Link]
.image(
75, 75, "Image", "Auto", false
),
first.[Image (URL)].image(0, 300),
concatenate(
switchif(
[Include Colored Border on Cards],
first.Color.Rectangle,
character(13),
"",
first.Notes
)
),
first.Notes,
switchif(
second.[Order Mechanism] = Production,
second.[Internal Supplier].ToText(),
second.Supplier.ToText()
),
switchif(
second.[Sub-Location].IsNotBlank(),
Concatenate(
second.Location, " - ", second.[Sub-Location]
)
.ToText(),
second.Location.ToText()
),
concatenate(
second.[Min Qty],
" ",
second.[Min. Units].trim()
),
switchif(
second.[Order Units].IsBlank(),
second.[Order Qty],
concatenate(
second.[Order Qty], " ", second.[Order Units]
)
)
.trim(),
second.[Database Link]
.image(
75, 75, "Image", "Auto", false
),
second.Notes,
second.[Image (URL)].image(0, 300),
_color("#000000", second.[Item Name]),
concatenate(
switchif(
[Include Colored Border on Cards],
second.Color.Rectangle,
character(13),
"",
second.Notes
)
),
_color("#000000", third.[Item Name]),
concatenate(
switchif(
[Include Colored Border on Cards],
third.Color.Rectangle,
character(13),
"",
third.Notes
)
),
switchif(
third.[Order Mechanism] = Production,
third.[Internal Supplier].ToText(),
third.Supplier.ToText()
),
concatenate(
third.[Min Qty], " ", third.[Min. Units].trim()
),
third.[Database Link]
.image(
75, 75, "Image", "Auto", false
),
switchif(
third.[Sub-Location].IsNotBlank(),
Concatenate(
third.Location, " - ", third.[Sub-Location]
)
.ToText(),
third.Location.ToText()
),
switchif(
third.[Order Units].IsBlank(),
third.[Order Qty],
concatenate(
third.[Order Qty], " ", third.[Order Units]
)
)
.trim(),
third.Notes,
third.[Image (URL)].image(0, 300),
_color("#000000", fourth.[Item Name]),
concatenate(
switchif(
[Include Colored Border on Cards],
fourth.Color.Rectangle,
character(13),
"",
fourth.Notes
)
),
switchif(
fourth.[Order Mechanism] = Production,
fourth.[Internal Supplier].ToText(),
fourth.Supplier.ToText()
),
switchif(
fourth.[Sub-Location].IsNotBlank(),
Concatenate(
fourth.Location, " - ", fourth.[Sub-Location]
)
.ToText(),
fourth.Location.ToText()
),
concatenate(
fourth.[Min Qty],
" ",
fourth.[Min. Units].trim()
),
switchif(
fourth.[Order Units].IsBlank(),
fourth.[Order Qty],
concatenate(
fourth.[Order Qty], " ", fourth.[Order Units]
)
)
.trim(),
fourth.[Database Link]
.image(
75, 75, "Image", "Auto", false
),
fourth.Notes,
fourth.[Image (URL)].image(0, 200),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
)
)
)
)
)
),
character(13)
)
402
Grouped Items
Sequence of 2
text
403
Grouped Items
Groups of 2
lookup
foreach([Sequence of 2].listcombine(),Items.filter(Select).listcombine().nth(CurrentValue)).Filter(CurrentValue.IsNotBlank())
Items
404
Grouped Items
2 Cards
canvas
concatenate(
[Groups of 2].nth(1)
.WithName(
first,
switchif(
[Groups of 2].count() = 1,
Items.first(),
[Groups of 2].nth(2)
)
.WithName(
second,
format(
[Print 2 Template],
_color(
first.Color.Color,
switchif(
[Include Colored Border on Cards],
concatenate(
first.Color.Rectangle,
character(13),
first.[Item Name]
),
first.[Item Name]
)
),
switchif(
first.[Order Mechanism] = Production,
first.[Internal Supplier].ToText(),
first.Supplier.ToText()
),
switchif(
first.[Sub-Location].IsNotBlank(),
Concatenate(
first.Location, " - ", first.[Sub-Location]
)
.ToText(),
first.Location.ToText()
),
concatenate(
first.[Min Qty], " ", first.[Min. Units].trim()
),
switchif(
first.[Order Units].IsBlank(),
first.[Order Qty],
concatenate(
first.[Order Qty], " ", first.[Order Units]
)
)
.trim(),
first.[Database Link]
.image(
200, 200, "Image", "Auto", false
),
first.[Image (URL)].image(0, 200),
concatenate(
switchif(
[Include Colored Border on Cards],
first.Color.Rectangle,
character(13),
"",
first.Notes
)
),
"",
switchif(
second.[Order Mechanism] = Production,
second.[Internal Supplier].ToText(),
second.Supplier.ToText()
),
switchif(
second.[Sub-Location].IsNotBlank(),
Concatenate(
second.Location, " - ", second.[Sub-Location]
)
.ToText(),
second.Location.ToText()
),
concatenate(
second.[Min Qty],
" ",
second.[Min. Units].trim()
),
switchif(
second.[Order Units].IsBlank(),
second.[Order Qty],
concatenate(
second.[Order Qty], " ", second.[Order Units]
)
)
.trim(),
second.[Database Link]
.image(
200, 200, "Image", "Auto", false
),
"",
second.[Image (URL)].image(0, 200),
_color(
second.Color.Color,
switchif(
[Include Colored Border on Cards],
concatenate(
second.Color.Rectangle,
character(13),
second.[Item Name]
),
second.[Item Name]
)
),
concatenate(
switchif(
[Include Colored Border on Cards],
second.Color.Rectangle,
character(13),
"",
second.Notes
)
),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
)
)
)
),
character(13),
character(13)
)
405
Grouped Items
4 Cards (1 Column)
canvas
concatenate(
[Groups of 4].nth(1)
.WithName(
first,
switchif(
[Groups of 4].count() = 1,
Items.first(),
[Groups of 4].nth(2)
)
.WithName(
second,
switchif(
[Groups of 4].count() < 3,
Items.first(),
[Groups of 4].nth(3)
)
.WithName(
third,
switchif(
[Groups of 4].count() < 4,
Items.first(),
[Groups of 4].nth(4)
)
.WithName(
fourth,
format(
Vertical,
switchif(
[Include Colored Border on Cards],
concatenate(
first.Color.Rectangle,
character(13),
_color("#000000", first.[Item Name])
),
_color("#000000", first.[Item Name])
),
switchif(
first.[Order Mechanism] = Production,
first.[Internal Supplier].ToText(),
first.Supplier.ToText()
),
switchif(
first.[Sub-Location].IsNotBlank(),
Concatenate(
first.Location, " - ", first.[Sub-Location]
)
.ToText(),
first.Location.ToText()
),
concatenate(
first.[Min Qty], " ", first.[Min. Units].trim()
),
switchif(
first.[Order Units].IsBlank(),
first.[Order Qty],
concatenate(
first.[Order Qty], " ", first.[Order Units]
)
)
.trim(),
first.[Database Link]
.image(
200, 200, "Image", "Auto", false
),
first.[Image (URL)].image(0, 200),
concatenate(
switchif(
[Include Colored Border on Cards],
first.Color.Rectangle,
character(13),
"",
first.Notes
)
),
"",
switchif(
second.[Order Mechanism] = Production,
second.[Internal Supplier].ToText(),
second.Supplier.ToText()
),
switchif(
second.[Sub-Location].IsNotBlank(),
Concatenate(
second.Location, " - ", second.[Sub-Location]
)
.ToText(),
second.Location.ToText()
),
concatenate(
second.[Min Qty],
" ",
second.[Min. Units].trim()
),
switchif(
second.[Order Units].IsBlank(),
second.[Order Qty],
concatenate(
second.[Order Qty], " ", second.[Order Units]
)
)
.trim(),
second.[Database Link]
.image(
200, 200, "Image", "Auto", false
),
"",
second.[Image (URL)].image(0, 200),
switchif(
[Include Colored Border on Cards],
concatenate(
second.Color.Rectangle,
character(13),
_color("#000000", second.[Item Name])
),
_color("#000000", second.[Item Name])
),
concatenate(
switchif(
[Include Colored Border on Cards],
second.Color.Rectangle,
character(13),
"",
second.Notes
)
),
switchif(
[Include Colored Border on Cards],
concatenate(
third.Color.Rectangle,
character(13),
_color("#000000", third.[Item Name])
),
_color("#000000", third.[Item Name])
),
concatenate(
switchif(
[Include Colored Border on Cards],
third.Color.Rectangle,
character(13),
"",
third.Notes
)
),
switchif(
third.[Order Mechanism] = Production,
third.[Internal Supplier].ToText(),
third.Supplier.ToText()
),
concatenate(
third.[Min Qty], " ", third.[Min. Units].trim()
),
third.[Database Link]
.image(
200, 200, "Image", "Auto", false
),
switchif(
third.[Sub-Location].IsNotBlank(),
Concatenate(
third.Location, " - ", third.[Sub-Location]
)
.ToText(),
third.Location.ToText()
),
switchif(
third.[Order Units].IsBlank(),
third.[Order Qty],
concatenate(
third.[Order Qty], " ", third.[Order Units]
)
)
.trim(),
"",
third.[Image (URL)].image(0, 200),
switchif(
[Include Colored Border on Cards],
concatenate(
fourth.Color.Rectangle,
character(13),
_color("#000000", fourth.[Item Name])
),
_color("#000000", fourth.[Item Name])
),
concatenate(
switchif(
[Include Colored Border on Cards],
fourth.Color.Rectangle,
character(13),
"",
fourth.Notes
)
),
switchif(
fourth.[Order Mechanism] = Production,
fourth.[Internal Supplier].ToText(),
fourth.Supplier.ToText()
),
switchif(
fourth.[Sub-Location].IsNotBlank(),
Concatenate(
fourth.Location, " - ", fourth.[Sub-Location]
)
.ToText(),
fourth.Location.ToText()
),
concatenate(
fourth.[Min Qty],
" ",
fourth.[Min. Units].trim()
),
switchif(
fourth.[Order Units].IsBlank(),
fourth.[Order Qty],
concatenate(
fourth.[Order Qty], " ", fourth.[Order Units]
)
)
.trim(),
fourth.[Database Link]
.image(
200, 200, "Image", "Auto", false
),
"",
fourth.[Image (URL)].image(0, 200),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
first.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
second.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
third.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
),
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
fourth.Color.Color.[Medium Hex],
[Light Hex]
),
"Order Qty."
)
)
)
)
)
),
character(13)
)
406
Grouped Items
Groups of 1
lookup
foreach([Sequence of 1].listcombine(),Items.filter(Select).listcombine().nth(CurrentValue)).Filter(CurrentValue.IsNotBlank())
Items
407
Grouped Items
Sequence of 1
text
RowId(thisRow)
408
Grouped Items
1 Card
canvas
concatenate(
format(
[Groups of 1].[Card Size]
.Template,
switchif(
[Include Colored Border on Cards],
concatenate(
[Groups of 1].Color.Rectangle,
character(13)
._color(
switchif(
[Color Code Title Text],
[Groups of 1].Color.Color
.[Medium Hex],
[Medium Hex]
),
[Groups of 1].[Item Name]
)
),
_color(
[Light Hex], [Groups of 1].[Item Name]
)
),
switchif(
[Groups of 1].[Order Mechanism] = Production,
[Groups of 1].[Internal Supplier].ToText(),
[Groups of 1].Supplier.ToText()
),
switchif(
[Groups of 1].[Sub-Location].IsNotBlank(),
Concatenate(
[Groups of 1].Location,
" - ",
[Groups of 1].[Sub-Location]
)
.ToText(),
[Groups of 1].Location.ToText()
),
concatenate(
[Groups of 1].[Min Qty],
" ",
[Groups of 1].[Min. Units].trim()
),
switchif(
[Groups of 1].[Order Units].IsBlank(),
[Groups of 1].[Order Qty],
concatenate(
[Groups of 1].[Order Qty],
" ",
[Groups of 1].[Order Units]
)
)
.trim(),
[Groups of 1].[Database Link],
[Groups of 1].[Image (URL)]
.image(
0, 200, "Image", "Auto", false
),
[Groups of 1].Notes,
"",
switchif(
[Include Colored Border on Cards],
[Groups of 1].Color.Rectangle,
""
),
_color(
switchif(
[Color Code Title Text],
[Groups of 1].Color.Color
.[Medium Hex],
[Light Hex]
),
"Order From"
),
_color(
switchif(
[Color Code Title Text],
[Groups of 1].Color.Color
.[Medium Hex],
[Light Hex]
),
"Minimum"
),
"",
_color(
switchif(
[Color Code Title Text],
[Groups of 1].Color.Color
.[Medium Hex],
[Light Hex]
),
"Deliver To"
),
_color(
switchif(
[Color Code Title Text],
[Groups of 1].Color.Color
.[Medium Hex],
[Light Hex]
),
"Order Qty."
)
),
character(13),
character(13)
)
409
Grouped Items
Sequence of 10
text
410
Grouped Items
Groups of 10
lookup
foreach([Sequence of 10].listcombine(),Items.filter(Select).listcombine().nth(CurrentValue)).Filter(CurrentValue.IsNotBlank())
Items
411
Grouped Items
10 Cards
canvas
412
Grouped Items
Labels 2 Columns
canvas
413
Grouped Items
Labels 1 Column
canvas
concatenate([Groups of 1].listcombine().[Label Format],character(13))
414
Grouped Items
Groups of 3
lookup
foreach([Sequence of 3].listcombine(),Items.filter(Select).listcombine().nth(CurrentValue)).Filter(CurrentValue.IsNotBlank())
Items
415
Grouped Items
Sequence of 3
text
416
Grouped Items
Labels 4 Columns
canvas
417
Grouped Items
PFEP Groups of 1
lookup
[Order Cards].filter(Select).nth([Sequence of 1])
418
Grouped Items
PFEP Groups of 2
lookup
foreach([Sequence of 2].listcombine(),[Order Cards].filter(Select).listcombine().nth(CurrentValue)).Filter(CurrentValue.IsNotBlank())
419
Order Origin
Input
text
ListCombine(Departments,[Order Mechanism] ).nth(RowId(thisRow)).totext()
420
Order Origin
Department
lookup
switchif(Input.isblank(),"",Departments.filter(CurrentValue.totext().containstext(Input)))
Departments
421
Order Origin
Order Mechanism
lookup
switchif(Input.isblank(),"",[Order Mechanism].filter(CurrentValue.totext().containstext(Input)))
Order Mechanism
422
Order Origin
Order Origin
text
_color(Color.[Text Color],Input )
423
Order Origin
Color
lookup
switchif(
Input.IsBlank(),
"",
Department.IsBlank(),
[Order Mechanism].Color,
Department.Color
)
Color Options
424
Order Origin
Color ID
text
Color.[Color ID].ListCombine()
425
Shipping Providers
Shipper
text
_color(Color.[Text Color],Input )
426
Shipping Providers
Color
lookup
Color Options
427
Shipping Providers
Color ID
number
Color.[Color ID].ListCombine()
428
Shipping Providers
Input
text
429
Order Groups
Order Group
text
430
Order Groups
Items
lookup
Items
431
Order Groups
Add To Cart
button
RunActions(Items.[Add to Cart])
432
Order Groups
Delete Group
button
DeleteRows(thisRow)
433
New External Item
Enter Item Name
text
434
New External Item
Triggered
lookup
Trigger
435
New External Item
Primary Supplier
lookup
External Suppliers
436
New External Item
Notes
canvas
437
New External Item
Order Description
text
438
New External Item
Internal Supplier
lookup
Locations
439
New External Item
Min Qty
number
440
New External Item
Order Qty
number
441
New External Item
Location
lookup
Locations
442
New External Item
Link
link
443
New External Item
Create & Print
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Use Case],
[Use Case],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Printed,
true,
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
true
)
),
OpenRow(
[Created Order Card],
[Print Format],
viewMode: "right"
),
DeleteRows(thisRow)
)
444
New External Item
Order Mechanism
lookup
Order Mechanism
445
New External Item
Created Order Card
lookup
Items
446
New External Item
Min Units
text
447
New External Item
Order Units
text
448
New External Item
Type
lookup
Item Type
449
New External Item
Sub-Type
lookup
Item Sub-Type
450
New External Item
Order Card Size
lookup
Formats by Size
451
New External Item
Saved
checkbox
452
New External Item
Delete
button
DeleteRows(thisRow)
453
New External Item
Image URL
image
454
New External Item
Image
image
455
New External Item
Unit Price
currency
456
New External Item
Create & Add Another
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Use Case],
[Use Case],
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
runactions(
switchif(
[Order Mechanism] = Production,
runactions([Draft Internal Item 7]),
[Order Mechanism] = Task,
runactions([Draft Process Item 2]),
runactions([Draft New Order Card 6])
)
),
DeleteRows(thisRow)
)
457
New External Item
Production Priority
lookup
Priority
458
New External Item
Production Batch
lookup
Production Batch
459
New External Item
Secondary Supplier
lookup
External Suppliers
460
New External Item
Secondary URL
link
461
New External Item
Label Size
lookup
Formats by Size
462
New External Item
SKU
text
463
New External Item
Sub-Location
lookup
Sub-Locations
464
New External Item
Create
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],File,File,
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Use Case],
[Use Case],
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
DeleteRows(thisRow)
)
465
New External Item
Component
lookup
Components
466
New External Item
Varaint
lookup
467
New External Item
Depends On
lookup
Items
468
New External Item
Previous Draft
button
thisTable.filter(Created(CurrentValue) < created(thisRow))
.MaxBy(
created(CurrentValue)
)
.WithName(
previous,
switchif(
previous.[Order Mechanism] = Production,
switchif(
[Advanced Mode],
openrow(previous, [New Internal Item], "Right"),
openrow(previous, [New Internal Item (Basic)], "Right")
),
previous.[Order Mechanism] = Task,
switchif(
[Advanced Mode],
openrow(previous, [New Task], "Right"),
openrow(previous, [New Task (Basic)], "Right")
),
switchif(
[Advanced Mode],
openrow(previous, [New External Item], "Right"),
openrow(previous, [New External Item (Basic)], "Right")
)
)
)
469
New External Item
Next Draft
button
thisTable.filter(Created(CurrentValue) > created(thisRow))
.minBy(
created(CurrentValue)
)
.WithName(
next,
switchif(
next.[Order Mechanism] = Production,
switchif(
[Advanced Mode],
openrow(next, [New Internal Item], "Right"),
openrow(next, [New Internal Item (Basic)], "Right")
),
next.[Order Mechanism] = Task,
switchif(
[Advanced Mode],
openrow(next, [New Task], "Right"),
openrow(next, [New Task (Basic)], "Right")
),
switchif(
[Advanced Mode],
openrow(next, [New External Item], "Right"),
openrow(next, [New External Item (Basic)], "Right")
)
)
)
470
New External Item
Product
lookup
Products
471
New External Item
Department
lookup
Departments
472
New External Item
Est. Days To Complete
duration
473
New External Item
Dependents
lookup
Items
474
New External Item
Trigger Days After Project Start
duration
475
New External Item
Finish Criteria
lookup
Finished
476
New External Item
Person
person
477
New External Item
Use Case
lookup
Use Case
478
New External Item
File
attachments
479
New External Item
Get Amazon Info
button
AmazonToArdaGetAmazonInfo([Kyle Henson], [Amazon URL]).WithName([amazon object],
ModifyRows(thisRow,[Enter Item Name],[amazon object].ItemName,[Unit Price],[amazon object].Price,[Primary Supplier],Amazon,[Order Mechanism],Online,[Order Qty],[amazon object].Quantity,[Order Units],[amazon object].Units,[Image URL],[amazon object].ImageUrl,Link,[amazon object].AmazonUrl ))
480
New External Item
Amazon URL
link
481
Usage Statistics
Company Name
text
[Company Name]
482
Usage Statistics
Items
number
483
Usage Statistics
Orders
number
484
Usage Statistics
30-Day Orders
number
485
Usage Statistics
30-Day Unique Items
number
486
Usage Statistics
Last Order Date
date
487
Usage Statistics
Last Item Modified Date
date
488
Usage Statistics
Master Row URL
link
489
Usage Statistics
Update
button
[Cross-doc]ModifyRow([User's private Cross-doc account], [Master Row URL], "Company Name", [Company Name], "Items", Items, "Orders", Orders, "30-Day Orders", [30-Day Orders], "30-Day Unique Items", [30-Day Unique Items], "Last Order Date", [Last Order Date], "Last Item Modified Date", [Last Item Modified Date], "Their Row URL", [This Row URL])
490
Usage Statistics
This Row URL
link
ObjectLink(thisRow)
491
Usage Statistics
Clean
button
runactions(
DeleteRows(
[External Suppliers]
.filter(
[Supplier Name] != "Amazon"
)
),
DeleteRows([Order Line Item Archive]),
DeleteRows([Item Type]),
DeleteRows([Item Sub-Type]),
DeleteRows([Use Case]),
DeleteRows([Order Archive]),
DeleteRows([New External Item]),
DeleteRows(Projects),
deleterows(Components),
DeleteRows([Component Types]),
DeleteRows([New Project]),
DeleteRows([New SOP]),
DeleteRows([Email Queue]),
DeleteRows(
Departments
.filter(
Department != "Finished" or
Department != "Finishing"
)
),
DeleteRows(Locations),
DeleteRows([Sub-Locations]),
DeleteRows(Products),
DeleteRows(Components),
DeleteRows([Component Types]),
DeleteRows([Production Batch]),
DeleteRows([Order Groups]),
DeleteRows([Email Queue]),
DeleteRows([Order Documents]),
Items.filter(Name.IsNotBlank()).Delete,
Delete,
SetControlValue(Cleaned, true),
Update
)
492
Order Document Templates
Name
text
493
Order Document Templates
Template
canvas
494
Order Document Templates
Column 5
canvas
format(
Template,
Logo.image(70, 0),
Name,
today(),
[Company Name],
Items.Supplier
)
495
Bulk Print Options
Bulk Print Options
text
496
Bulk Print Options
Color
lookup
Color Options
497
Bulk Print Options
Color ID
text
Color.[Color ID].ListCombine()
498
Bulk Print Options
Print Document Type
lookup
Print Document Type
499
Order Documents
Name
text
_color(Color.[Text Color], Concatenate(Supplier," - #",[PO Number]).ToText())
500
Order Documents
Line Items
lookup
Items
501
Order Documents
Status
lookup
Order Status
502
Order Documents
PO Created Date
date
503
Order Documents
PO Number
text
504
Order Documents
Supplier
lookup
Master Suppliers
505
Order Documents
PO Download Link
link
506
Order Documents
Packing List Link
link
507
Order Documents
Color
lookup
Status.Color.ListCombine()
Color Options
508
Order Documents
Color ID
number
Color.[Color ID]
509
Order Documents
Step 4: Create Email
button
switchif(
[Email Draft].isblank(),
runactions(
openrow(
AddRow(
[Email Queue],
Supplier,
Supplier,
[Order Documents],
thisRow,
Complete,
"false",
Subject,
concatenate(
Subject, " PO #", [PO Number]
),
Body,
format(
Body,
Supplier.[External Suppliers]
.[Primary Contact]
.split(
" "
)
.first(),
hyperlink([PO Download Link].totext(), "here")
),
Owner,
user(),
Items,
[Line Items],
[Order Quantity],
[Line Items].[To Order]
),
[Email Queue],
"Right"
)
),
openrow([Email Draft], [Email Queue], "Right")
)
510
Order Documents
PO
canvas
format(
[Order Document Templates].first()
.Template,
Logo
.image(
75, 0, "logo", "auto", false
),
concatenate(
[Company Name],
" - PO# ",
[PO Number]
),
today(),
[Company Name],
Supplier.totext(),
[Primary Contact],
[Primary Contact Phone Number],
[Primary Contact Email].totext(),
switchif(
Supplier.[External Suppliers]
.[Vendor Number & Additional Info]
.IsBlank(),
"",
concatenate(
" - ",
Supplier.[External Suppliers]
.[Vendor Number & Additional Info]
)
),
[Company Address],
"",
Supplier.[External Suppliers]
.[Primary Contact],
Supplier.[External Suppliers]
.[Primary Contact Phone],
Supplier.[External Suppliers]
.[Primary Contact Email]
.totext(),
Supplier.[External Suppliers]
.Address,
concatenate(
Supplier.[External Suppliers]
.CityState,
" ",
Supplier.[External Suppliers]
.[Zip Code]
),
[Good Through],
Supplier.[External Suppliers]
.[Vendor Number & Additional Info],
[Payment Terms].totext(),
[Shipping Terms].ToText()
)
511
Order Documents
Template
lookup
Email Templates
512
Order Documents
Pricing Overview
canvas
format(
[Order Document Templates].last().Template,
[Line Items].[Order Price].sum(),
[Line Items].[Order Price].sum() *
[Tax Rate],
Shipping,
sum(
[Line Items].[Order Price].sum() +
[Line Items].[Order Price].sum() *
[Tax Rate] +
Shipping
)
)
513
Order Documents
Tax Rate
percent
514
Order Documents
Shipping
currency
515
Order Documents
Print PO
button
openrow(thisRow,[PO View],"Right")
516
Order Documents
Upload PO
attachments
517
Order Documents
Order Line Item Archive
lookup
Order Line Item Archive
518
Order Documents
Use Secondary Contact
checkbox
519
Order Documents
Email Draft
lookup
[Email Queue].Filter([Order Documents].Contains(thisRow))
Email Queue
520
Order Documents
Created on
dateTime
thisRow.Created()
521
Order Documents
Delete
button
DeleteRows(thisRow)
522
Order Documents
Project
lookup
Projects
523
Order Documents
Step 3: Create Link
button
ModifyRows(thisRow,[PO Download Link], _Deref_Object(_Merge([Upload PO]), "publicUrl"))
524
Order Documents
Payment Terms
lookup
Payment Terms
525
Order Documents
Shipping Terms
lookup
Shipping Terms
526
Order Documents
Good Through
text
527
Packing List 2
Item Reference
lookup
[Shopping Cart].filter(Supplier.contains([Select Vendor for Packing List])).[Preceding Items].ListCombine().filter(currentvalue.isnotblank()).unique().Nth(RowId(thisRow))
Items
528
Packing List 2
Qty.
number
[Item Reference].[Qty. Per Following]
529
Packing List 2
Unit
text
[Item Reference].[Unit for Following].ListCombine().filter(CurrentValue.IsNotBlank()).first()
530
Packing List 2
Unit Price
currency
[Item Reference].[Unit Price].ListCombine()
531
Packing List 2
Total Value
currency
[Qty.]*[Unit Price]
532
Packing List 2
Quantity
text
Concatenate([Qty.]," ",Unit)
533
Packing List 2
Description
text
[Item Reference].[Order Description].ListCombine()
534
Packing List 2
Item Name
text
[Item Reference].Name.ListCombine()
535
Packing List 2
SKU
text
[Item Reference].SKU.ListCombine()
536
Bulk Import
SKU #
text
537
Bulk Import
Item Name
text
538
Bulk Import
URL
link
539
Bulk Import
Image URL
link
540
Bulk Import
Supplier
lookup
External Suppliers
541
Bulk Import
Order Qty
number
542
Bulk Import
Min Qty
number
543
Bulk Import
Extracted Hyperlink
link
RegexExtract(_Merge(URL) + "", '(?<="url":").*?(?=")').First()
544
Bulk Import
Import
button
runactions(
modifyrows(
Items.filter(Name.IsBlank())
.MinBy(
[Item Number]
),
[Item Name],
[Item Name],
SKU,
[SKU #],
[Image (URL)],
[Image URL],
[Internal Supplier],
[Storage Location],
Location,
[Deliver To],
[Min. Units],
[Min Units],
[Order Units],
[Order Units],
[URL 1],
[Extracted Hyperlink],
Trigger,
[Order Cadence],
[Avg. Time],
[Lead Time],
[Unit Price],
[Unit Price],
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
[Min Qty],
[Min Qty],
[Order Qty],
[Order Qty],
[Primary Supplier],
switchif(
Supplier.Supplier.IsBlank(),
AddRow(
[External Suppliers],
[Supplier Name],
Supplier.totext()
),
Supplier
)
),
DeleteRows(thisRow),
switchif(
[Bulk Import].count() = 1, AddRow([Bulk Import]), ""
)
)
545
Bulk Import
Order Mechanism
lookup
Order Mechanism
546
Bulk Import
Notes
canvas
547
Bulk Import
Storage Location
lookup
Locations
548
Bulk Import
Deliver To
lookup
Locations
549
Bulk Import
Min Units
text
550
Bulk Import
Order Units
text
551
Bulk Import
Order Cadence
lookup
Trigger
552
Bulk Import
Unit Price
currency
553
Bulk Import
Lead Time
duration
554
Projects
Title
text
_color(
Color.[Text Color],
[Contact Name]
)
555
Projects
Contact Name
text
556
Projects
Phone Number
text
557
Projects
Notes
canvas
558
Projects
Email Address
email
559
Projects
Product
lookup
Products
560
Projects
Items
lookup
Items
561
Projects
Items & Tasks
lookup
Order Line Item Archive
562
Projects
Start Date
date
563
Projects
Target Completion Date
date
564
Projects
Completion Date
date
565
Projects
Color
lookup
switchif(
[Current Task].IsBlank(),
[Dark Green],
[Current Task].Item =
[Target Completion Date],
[Light Green],
[Current Task].Status
.Color
)
Color Options
566
Projects
Color ID
number
Color.[Color ID]
567
Projects
Item Total
currency
Items.[Total Price].ListCombine().sum()
568
Projects
Add To Project
button
runactions(ModifyRows(Modals.filter(Name="Configure BOM"),[Order Line Item Archive],[Items & Tasks].listcombine().first()), openrow(Modals.filter(Name="Configure BOM"),Modals,"Right"))
569
Projects
Open
button
switchif([Advanced Mode],
openrow(thisRow,Projects,"Right"),openrow(thisRow,[Projects (Simple View)],"Right"))
570
Projects
Finalized
checkbox
571
Projects
Delete
button
runactions(
deleterows(
[Build-Specific Cart Line Items]
.filter(
Project = thisRow
)
),
DeleteRows(
[Order Line Item Archive]
.filter(
Project = thisRow and
[Order Mechanism] = Task
)
),
ModifyRows(
[Order Line Item Archive]
.filter(
Project = thisRow
),
Project,
""
),
DeleteRows(thisRow)
)
572
Projects
Actions
text
Concatenate(
button(Open, "", "Orange", "", "", false, "Small", "pencil"),
" ",
button(
[Add To Project],
"",
"Purple",
"",
"",
false,
"Small",
"add-book"
),
" ",
button(
[Print Task Cards], "", "Blue", "", "", false, "Small", "print"
),
" ",
button(
Progress,
"",
"Green",
"",
"",
false,
"Small",
switchif(Task = [Target Completion Date], "finish-flag", "arrow")
),
" ",
button(Delete, "", "Red", "", "", false, "Small", "trash")
)
573
Projects
Next Step
lookup
[Current Task].Dependents
Order Line Item Archive
574
Projects
Progress
button
[Order Line Item Archive]
.filter(
Project = thisRow and
[Received/Completion Date].IsBlank()
)
.minby(
[Target Start]
)
.Advance
575
Projects
Person
person
576
Projects
Current Task
lookup
Tasks.filter(Status!=Finished)
.MinBy(
[Target Start]
)
Order Line Item Archive
577
Projects
Department
lookup
[Current Task].Department.ListCombine().filter(CurrentValue.IsNotBlank()).WithName(dept,switchif(dept.IsBlank(),Departments.filter(Department="Finished") ,dept) )
Departments
578
Projects
Print Task Cards
button
runactions(Tasks.[Generate QR Code],
ModifyRows([Project Cards],Project,thisRow) ,openrow([Project Cards].first(),[Project Cards],"Right"))
579
Projects
Tasks
lookup
[Items & Tasks].filter([Order Mechanism]=Task and Department.IsNotBlank())
Order Line Item Archive
580
Projects
Task
lookup
[Current Task].Item
Items
581
Projects
Slider
slider
[Order Line Item Archive]
.filter(
[Order Mechanism] = Task and
Project = thisRow and
Status = Finished
)
.count() /
[Order Line Item Archive]
.filter(
[Order Mechanism] = Task and
Project = thisRow
).count()
582
Projects
Orders
lookup
[Items & Tasks].filter([Order Mechanism]!=Task).ListCombine().filter(CurrentValue.IsNotBlank())
Order Line Item Archive
583
Projects
Build-Specific Cart Line Items
lookup
[Build-Specific Cart Line Items].Filter(Project.Contains(thisRow))
Build-Specific Cart Line Items
584
Bill of Materials
Item
lookup
[Order Line Item Archive].Project.Items .ListCombine().filter( [Order Mechanism]!=Task ).unique().nth(RowId(thisRow))
Items
585
Bill of Materials
Add To Cart
button
AddRow(
[Build-Specific Cart Line Items],
Item,
Item,
Project,
[Order Line Item Archive]
.Project
)
586
Bill of Materials
Remove From Build
button
runactions(
switchif(
Order.IsNotBlank(),
runactions(
DeleteRows([Build-Specific Cart Line Items]),
ModifyRows(Order, Project, "")
),
[Build-Specific Cart Line Items].IsNotBlank(),
DeleteRows([Build-Specific Cart Line Items])
),
ModifyRows(
[Order Line Item Archive]
.Project,
Items,
[Order Line Item Archive]
.Project
.Items
.filter(
CurrentValue != Item
).ListCombine()
)
)
587
Bill of Materials
Notes
canvas
588
Bill of Materials
Component
lookup
switchif(
Item.IsBlank(),
"",
Item.IsNotBlank(),
Item.Components,
[Order Line Item Archive]
.Project
.Product
.Components
.ListCombine()
.filter(
CurrentValue.IsNotBlank()
)
.nth(
RowId(thisRow) -
[Order Line Item Archive]
.Project
.Items
.ListCombine()
.unique()
.count()
)
)
Components
589
Bill of Materials
Total Price
currency
Item .[Unit Price].ListCombine()*Item.[Order Qty]
590
Bill of Materials
Unit Price
currency
Item .[Unit Price]
591
Bill of Materials
Edit
button
Item.Edit
592
Bill of Materials
Actions
text
switchif(
Item.IsBlank(),
"",
Concatenate(
button(Edit, "", "Orange", "", "", false, "Small", "pencil"),
" ",
button(
[Remove From Build],
"",
"Red",
"",
"",
false,
"Small",
switchif(Order.IsNotBlank(), "ingredients", "clear-symbol")
),
" ",
button(
[Add To Cart],
"",
"Green",
switchif(
Item.[To Order] = 0,
"",
Item.[To Order]
),
"",
false,
"Small",
"add-shopping-cart"
)
)
)
593
Bill of Materials
Order
lookup
[Order Line Item Archive].filter(Item=Item and Project=[Order Line Item Archive].Project )
Order Line Item Archive
594
Bill of Materials
Build-Specific Cart Line Items
lookup
[Build-Specific Cart Line Items].filter(Project= [Order Line Item Archive].Project and Item=Item )
Build-Specific Cart Line Items
595
Bill of Materials
Order Status
lookup
switchif(
Item.isblank(),
"",
Order.IsNotBlank(),
Order.Status,
[Added to BOM]
)
.Filter(
currentvalue.IsNotBlank()
)
Order Status
596
Bill of Materials
Item Name
text
_color(Color.Color, Item.Name.ListCombine())
597
Bill of Materials
Order Qty
number
Item.[Order Qty].ListCombine() *
[Order Line Item Archive]
.Project
.Items
.listcombine()
.countif(
CurrentValue = Item
)
.filter(
CurrentValue != 0
)
598
Bill of Materials
Order Units
text
Item.[Order Units].ListCombine()
599
Bill of Materials
Color
lookup
Item.Color.ListCombine()
Color Options
600
Bill of Materials
Color ID
text
Color.[Color ID].ListCombine()
601
Bill of Materials
Order Quantity
text
Concatenate([Order Qty]," ",[Order Units])
602
Bill of Materials
Min Qty
number
Item.[Min Qty].ListCombine()
603
Finalize Bill of Materials
Item
lookup
[Order Line Item Archive].Project.Items .ListCombine().filter( [Order Mechanism]!=Task ).unique().nth(RowId(thisRow))
Items
604
Finalize Bill of Materials
Actions
text
switchif(
Item.IsBlank(),
"",
Concatenate(
button(Edit, "", "Orange", "", "", false, "Small", "pencil"),
" ",
button(
[Remove From Build],
"",
"Red",
"",
"",
false,
"Small",
switchif(Order.IsNotBlank(), "ingredients", "clear-symbol")
),
" ",
button(
[Add To Cart],
"",
"Green",
switchif(
Item.[To Order] = 0,
"",
Item.[To Order]
),
"",
false,
"Small",
"add-shopping-cart"
)
)
)
605
Finalize Bill of Materials
Component
lookup
switchif(
Item.IsBlank(),
"",
Item.IsNotBlank(),
Item.Components,
[Order Line Item Archive]
.Project
.Product
.Components
.ListCombine()
.filter(
CurrentValue.IsNotBlank()
)
.nth(
RowId(thisRow) -
[Order Line Item Archive]
.Project
.Items
.ListCombine()
.unique()
.count()
)
)
Components
606
Finalize Bill of Materials
Unit Price
currency
Item .[Unit Price]
607
Finalize Bill of Materials
Order Quantity
text
Concatenate([Order Qty]," ",[Order Units])
608
Finalize Bill of Materials
Total Price
currency
Item .[Unit Price].ListCombine()*Item.[Order Qty]
609
Finalize Bill of Materials
Notes
canvas
610
Components
Component
text
611
Components
Color
lookup
[Component Group].Color.ListCombine()
Color Options
612
Components
Color ID
text
Color.[Color ID].ListCombine()
613
Components
Title
text
_color("#000000",Component )
614
Components
Products
lookup
Products.Filter(Components.Contains(thisRow))
Products
615
Components
All Related Items & Tasks
lookup
Items.Filter(Components.Contains(thisRow))
Items
616
Components
Related SOPs
lookup
SOPs.Filter(Components.Contains(thisRow))
SOPs
617
Components
Component Group
lookup
Component Types
618
Components
Quantity
number
619
Components
Edit
button
openrow(thisRow,Components,"Right")
620
Components
SOP
lookup
SOPs
621
Components
Delete
button
DeleteRows(thisRow)
622
Components
Create/Open SOP
button
switchif(
SOP.IsBlank(),
SOPs.filter(Name.IsBlank()).MinBy([SOP Number]),
SOP
)
.WithName(
target,
runactions(
ModifyRows(
thisRow,
SOP,
ModifyRows(
target,
[SOP Type],
Component,
Item,
thisRow,
Name,
Concatenate(Component, " SOP"),
Product,
Products,
Components,
thisRow
)
),
[SOPs Product View],
"Right"
)
)
623
Components
Actions
text
624
Components
Standard Items
lookup
Items
625
Components
Related Tasks
lookup
Items
626
Components
Optional Items
lookup
Items
627
Tables
Table
text
628
Tables
URL
canvas
629
Tables
Type
lookup
Table Sub-Types
630
Tables
Color
lookup
Type.Color
Color Options
631
Tables
Color ID
text
Color.[Color ID].ListCombine()
632
Tables
On Update
lookup
Update Options
633
Tables
Table Type
lookup
Table Types
634
Tables
Reference
text
635
Tables
New Table URL
link
switchif([New Instance URL] .IsBlank(),"",Concatenate([New Instance URL],"#",URL.totext().split("#").last() ))
636
Tables
Copy Table (Archive)
canvas
637
Tables
Copy Table
button
runactions(
modifyrows(
thisRow,
Results,
switchif(
Table = "Departments",
foreach(
Departments,
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Department",
CurrentValue.Department,
"Color",
CurrentValue.Color
)
),
Table = "Storage Locations",
foreach(
Locations,
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Storage Location",
CurrentValue.Name,
"Color",
CurrentValue.Color,
"Department",
CurrentValue.Department
)
),
Table = "Item Type",
foreach(
[Item Type],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Item Type",
CurrentValue.[Item Type],
"Color",
CurrentValue.Color
)
),
Table = "Item Sub-Type",
foreach(
[Item Sub-Type],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Item Sub-Type",
CurrentValue.[Item Sub-Type],
"Color",
CurrentValue.Color,
"Item Type",
CurrentValue.[Item Type]
)
),
Table = "Item Use Case",
foreach(
[Item Use Case],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Use Case",
CurrentValue.[Use Case],
"Color",
CurrentValue.Color
)
),
Table = "Order Status",
foreach(
[Order Status],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Order Status",
CurrentValue.[Order Status],
"Color",
CurrentValue.Color
)
),
Table = "Order Mechanism",
foreach(
[Order Mechanism],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Order Mechanism",
CurrentValue.[Order Mechanism],
"Color",
CurrentValue.Color
)
),
Table = "Order Cadence",
foreach(
Trigger,
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Order Cadence",
CurrentValue.[Task Triggered],
"Color",
CurrentValue.Color
)
),
Table = "Formats by Size",
foreach(
[Formats by Size],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Template",
CurrentValue.Template,
"Color",
CurrentValue.Color,
"Input",
CurrentValue.Input,
"Alternate Template",
CurrentValue.[Alternate Template]
)
),
Table = "Vehicle Type",
foreach(
[Vehicle Type],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Vehicle Type",
CurrentValue.[Vehicle Type],
"Color",
CurrentValue.Color
)
),
Table = "Order Documents",
foreach(
[Order Documents],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"PO Download Link",
CurrentValue.[PO Download Link],
"Upload PO",
CurrentValue.[Upload PO],
"Status",
currentvalue.Status,
"Template",
currentvalue.Template,
"Tax Rate",
currentvalue.[Tax Rate],
"Shipping",
currentvalue.Shipping,
"Edit and Send Email",
currentvalue.[Edit and Send Email]
)
),
Table = "Vehicle Area",
foreach(
Components,
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Vehicle Area",
CurrentValue.Component,
"Color",
CurrentValue.Color
)
),
Table = "Vehicle Model",
foreach(
[Vehicle Model],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Vehicle Model",
CurrentValue.[Vehicle Model],
"Color",
CurrentValue.Color,
"Manufacturer",
CurrentValue.Manufacturer,
"Vehicle Type",
CurrentValue.[Vehicle Type]
)
),
Table = "Company Information",
foreach(
[Company Information],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Company Name",
CurrentValue.[Company Name],
"Primary Contact",
CurrentValue.[Primary Contact],
"Unique Identifier",
CurrentValue.[Unique Identifier],
"Company Address",
CurrentValue.[Company Address],
"Primary Contact Phone Number",
CurrentValue
.[Primary Contact Phone Number],
"Primary Contact Email",
CurrentValue.[Primary Contact Email],
"Logo",
CurrentValue.Logo,
"Short Company Description",
CurrentValue
.[Short Company Description]
)
),
Table = "Build Stages",
foreach(
[Build Stages],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Build Stage",
CurrentValue.[Build Stage],
"Color",
CurrentValue.Color,
"Order",
CurrentValue.Order
)
),
Table = "Build Component",
foreach(
Components,
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Vehicle Area",
CurrentValue.Component,
"Color",
CurrentValue.Color
)
),
Table = "Build Milestones",
foreach(
[Build Milestones],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Build Milestone",
CurrentValue.[Build Milestone],
"Color",
CurrentValue.Color,
"Build Phase",
CurrentValue.[Build Phase],
"Days Relative to Build Start",
CurrentValue
.[Days Relative to Build Start]
)
),
Table = "Task Status",
foreach(
[Task Status],
[Cross-doc]addrow(
[User's private Cross-doc account],
[New Table URL],
"Task Status",
currentvalue.Title,
"Color",
currentvalue.Color
)
),
Table = "Build Timeline",
foreach(
[Project Timeline],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Build",
CurrentValue.Project,
"Milestone",
CurrentValue.Task,
"Task Date",
CurrentValue.[Target Start],
"Owner",
CurrentValue.Owner,
"Days Upcoming/Overdue",
currentvalue.[Days Upcoming/Overdue],
"Duration",
currentvalue.[Days Since Project Start]
)
),
Table = "Master Builds",
foreach(
Projects,
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Customer Name",
CurrentValue.Title,
"Vehicle Model",
CurrentValue.Product,
"Stage",
CurrentValue.Stage,
"Start Date",
CurrentValue.[Start Date],
"Target Completion Date",
CurrentValue.[Target Completion Date],
"Notes",
CurrentValue.Notes,
"Phone Number",
CurrentValue.[Phone Number],
"Email Address",
CurrentValue.[Email Address],
"Build Timeline",
currentvalue.[Order Line Item Archive],
"Finalized",
currentvalue.Finalized,
"Items",
currentvalue.Items,
"Completion Date",
currentvalue.[Completion Date]
)
),
Table = "New Custom Build",
"",
Table = "New Order Card & Item",
"",
Table = "Email Templates",
foreach(
[Email Templates],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Name",
CurrentValue.Name,
"Subject",
CurrentValue.Subject,
"Body",
CurrentValue.Body
)
),
Table = "Format Templates",
foreach(
[Format Templates],
[Cross-doc]addrow(
[User's private Cross-doc account],
[New Table URL],
"Template",
currentvalue.Template,
"Handle",
currentvalue.Handle
)
),
Table = "Order Groups",
foreach(
[Order Groups],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Order Group",
CurrentValue.[Order Group],
"Items",
CurrentValue.Items
)
),
Table = "Master Task Type",
foreach(
[Master Task Type],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Task Type",
CurrentValue.[Task Type],
"Abbreviation",
CurrentValue.Abbreviation
)
),
Table = "Build-Specific Cart Line Items",
foreach(
[Build-Specific Cart Line Items],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Item",
CurrentValue.Item,
"Build",
CurrentValue.Project,
"Orders",
CurrentValue.Orders,
"Tasks",
CurrentValue.[Email Queue],
"Unit Price",
currentvalue.[Unit Price],
"Notes",
currentvalue.Notes
)
),
Table = "Master Tasks",
foreach(
[Email Queue],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Task Name",
CurrentValue.[Task Name],
"Type",
CurrentValue.Type,
"Supplier Name",
CurrentValue.Supplier,
"Items",
CurrentValue.Items,
"Link",
CurrentValue.Link,
"Due Date",
CurrentValue.[Due Date],
"Owner",
CurrentValue.Owner,
"Complete",
CurrentValue.Complete,
"Notes",
CurrentValue.Notes,
"Use Secondary Contact",
CurrentValue.[Use Secondary Contact],
"CC Email Address",
CurrentValue.[CC Email Address],
"Order Quantity",
CurrentValue.[Order Quantity],
"Order Documents",
CurrentValue.[Order Documents],
"Start Date",
currentvalue.[Start Date],
"Task Finished Time",
currentvalue.[Task Finished Time],
"Body",
currentvalue.Body,
"Email: Subject",
CurrentValue.Subject
)
),
Table = "Master Suppliers",
foreach(
[External Suppliers],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Supplier Name",
CurrentValue.[Supplier Name],
"Supplier",
currentvalue.Supplier,
"CityState",
CurrentValue.CityState,
"Primary Contact",
currentvalue.[Primary Contact],
"Primary Contact Email",
CurrentValue.[Primary Contact Email],
"Primary Contact Phone",
CurrentValue.[Primary Contact Phone],
"Secondary Contact",
CurrentValue.[Secondary Contact],
"Secondary Contact Email",
CurrentValue.[Secondary Contact Email],
"Secondary Contact Phone",
CurrentValue.[Secondary Contact Phone],
"Vendor Number & Additional Info",
CurrentValue
.[Vendor Number & Additional Info],
"Website",
currentvalue.Website,
"Zip Code",
CurrentValue.[Zip Code],
"Notes",
CurrentValue.Notes,
"Address",
CurrentValue.Address
)
),
Table = "Order Document Templates",
foreach(
[Order Document Templates],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Template",
CurrentValue.Template,
"Name",
CurrentValue.Name
)
),
Table = "Order Line Item Archive",
foreach(
[Order Line Item Archive],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Item",
CurrentValue.Item,
"Status",
CurrentValue.Status,
"Date Received",
CurrentValue.[Received/Completion Date],
"Include in Receiving",
CurrentValue
.[Include in Receiving],
"Quantity",
CurrentValue.Quantity,
"Units",
CurrentValue.Units,
"Lead Time",
CurrentValue.[Lead Time],
"Notes",
CurrentValue.Notes,
"Person",
CurrentValue.Person,
"Price",
CurrentValue.[Item Price],
"Receipt Image",
CurrentValue.[Receipt Image],
"Item Image",
CurrentValue.[Item Image],
"Tracking Number",
CurrentValue.[Tracking Number]
)
),
Table = "Order Archive",
foreach(
[Order Archive],
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Order Date",
CurrentValue.[Order Date],
"Order Items",
CurrentValue.[Order Items],
"Supplier",
CurrentValue.Supplier,
"Line Items",
CurrentValue.[Line Items],
"Name",
currentvalue.Name,
"Lead Time",
currentvalue.[Lead Time]
)
),
Table = "Master Order Card Layout",
foreach(
Items,
[Cross-doc]AddRow(
[User's private Cross-doc account],
[New Table URL],
"Storage Location",
CurrentValue.[Internal Supplier],
"Printed",
CurrentValue.Printed,
"Deliver To",
CurrentValue.Location,
"Database Link",
CurrentValue.[Database Link],
"Item Number",
CurrentValue.[Item Number],
"Name",
CurrentValue.Name,
"Item Type",
CurrentValue.[Item Type],
"Item Use Case",
CurrentValue.Task,
"Item Sub-Type",
CurrentValue.[Sub-Type],
"Unit Price",
CurrentValue.[Unit Price],
"Notes",
CurrentValue.Notes,
"Order Cadence",
CurrentValue.Trigger,
"URL 1",
CurrentValue.[URL 1],
"Primary Supplier",
CurrentValue.[Primary Supplier],
"Secondary Supplier",
CurrentValue.[Secondary Supplier],
"Upload Image",
CurrentValue.[Upload Image],
"URL 2",
CurrentValue.[URL 2],
"Following Items",
CurrentValue.[Following Items],
"Preceding Items",
CurrentValue.[Preceding Items],
"Order Mechanism",
CurrentValue.[Order Mechanism],
"Forwarding Link Database URL",
CurrentValue
.[Forwarding Link Database URL],
"Order Qty",
currentvalue.[Order Qty],
"Order Units",
CurrentValue.[Order Units],
"Min. Units",
currentvalue.[Min. Units],
"Min Qty",
CurrentValue.[Min Qty],
"Qty. per Following",
CurrentValue.[Qty. Per Following],
"Image (URL)",
CurrentValue.[Image (URL)],
"Order Description",
currentvalue.[Order Description],
"Unique ID",
currentvalue.[Unique ID],
"QR Code URL",
currentvalue.[QR Code URL]
)
),
Table = "Usage Statistics",
[Cross-doc]ModifyRow(
[User's private Cross-doc account],
[Master Row URL],
"Their Row URL",
[This Row URL]
.Substitute(
[New Instance URL].first()
.[Old Document ID]
.ToText(),
[New Instance URL].first()
.[New Document ID]
)
)
)
)
)
638
Tables
Results
text
639
Table Sub-Types
Support Table Type
text
640
Table Sub-Types
Support Tables
lookup
Tables.Filter(Type.Contains(thisRow))
Tables
641
Table Sub-Types
Color
lookup
Color Options
642
Table Sub-Types
Color ID
text
Color.[Color ID].ListCombine()
643
New Project
Customer Name
text
644
New Project
Phone Number
text
645
New Project
Email Address
email
646
New Project
Notes
canvas
647
New Project
Product
lookup
Products
648
New Project
Start Date
date
649
New Project
Target Completion Date
date
650
New Project
Add Build
button
runactions(
OpenWindow(ObjectLink(Projects)),
modifyrows(
thisRow,
[Created Project],
AddRow(
Projects,
[Contact Name],
[Customer Name],
[Phone Number],
[Phone Number],
[Email Address],
[Email Address],
[Start Date],
[Start Date],
Items,
Product.Components
.[Standard Items]
.ListCombine(),
Person,
[Project Owner],
[Target Completion Date],
[Target Completion Date],
Notes,
Notes,
Product,
Product
)
),
addrow(
[Order Line Item Archive],
Item,
[Project Start],
[Target Start],
[Start Date],
[Include in Receiving],
true,
[Actual Start],
[Start Date],
Supplier,
"",
[Order Mechanism],
Task,
Project,
[Created Project],
[Received/Completion Date],
[Start Date],
Status,
Finished
),
addrow(
[Order Line Item Archive],
Item,
[Target Completion Date],
[Actual Start],
[Target Completion Date],
[Target Start],
[Target Completion Date],
[Order Mechanism],
Task,
Project,
[Created Project],
[Include in Receiving],
true,
Supplier,
"",
Status,
[Not Triggered]
),
switchif(
[Advanced Mode] = false,
"",
foreacH(
Tasks.ListCombine(),
currentvalue
.withname(
t,
runactions(
modifyrows(
thisRow,
[Created Task],
addrow(
[Order Line Item Archive],
Item,
t,
Components,
t.Components,
[Order Mechanism],
t.[Order Mechanism],
[Include in Receiving],
true,
Project,
[Created Project],
Status,
switchif(t.Sequence = 1, Triggered, [Not Triggered]),
[Target Duration],
t.[Avg. Time],
Person,
t.listcombine().Person,
[Target Start],
switchif(
t.Sequence = 1,
[Start Date],
Trigger =
[Days After Project Start],
[Start Date] + t.[Relative Days to Trigger],
Trigger = [Days Before Dependent],
Dependents
.MinBy(
[Target Start]
) -
t.[Relative Days to Trigger],
""
)
)
),
[Created Task].[Update Time]
)
)
)
),
switchif(
[Advanced Mode],
[Created Project].Tasks
.[Update Time],
""
),
[Delete Draft]
)
651
New Project
Save Draft
button
OpenWindow(objectlink(Projects ))
652
New Project
Delete Draft
button
DeleteRows(thisRow)
653
New Project
Project Owner
person
654
New Project
Created Project
lookup
Projects
655
New Project
Tasks
lookup
Product.Tasks.ListCombine().Filter([Order Mechanism]=Task)
Items
656
New Project
Items
lookup
Product.Components.[Standard Items].ListCombine().filter(CurrentValue.IsNotBlank() and [Order Mechanism]!=Task)
Items
657
New Project
Created Task
lookup
Order Line Item Archive
658
New Instance URL
New Instance URL
link
659
New Instance URL
Create New Instance
button
runactions(
modifyrows(
thisRow,
[Old New Instance URL Row URL],
objectlink(thisRow),
[Old Document ID],
thisDocument.Url().Split('_').Slice(2).Join(''),
[Enable Delete],
true
),
_delay(
modifyrows(
thisRow,
[New Instance URL],
CopyDoc(
[Company Name],
"https://coda.io/d/_dy9-aNYpZAA"
)
),
30000
),
_delay(
[Cross-doc]PushButton(
[User's private Cross-doc account],
Concatenate(
Tables.filter(Table.containstext("New Instance URL"))
.[New Table URL]
.totext(),
"/r1"
),
"Delete Tables"
),
120000
),
ModifyRows(thisRow, [Enable Delete], false),
_delay(runactions([Copy Data]), 60000)
)
660
New Instance URL
Demo Environment Document ID
text
661
New Instance URL
New Document ID
text
switchif([New Instance URL].IsBlank(),"", [New Instance URL] .totext().Split('_').Slice(2).Join(''))
662
New Instance URL
Old Document ID
text
663
New Instance URL
Delete Tables
button
RunActions(
switchif(
Tables.filter(Table = "Departments")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows(Departments),
""
),
switchif(
Tables.filter(Table = "Storage Locations")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows(Locations),
""
),
switchif(
Tables.filter(Table = "Item Type").[On Update]
.contains(
Clear, Copy
),
DeleteRows([Item Type]),
""
),
switchif(
Tables.filter(Table = "Item Sub-Type")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Item Sub-Type]),
""
),
switchif(
Tables.filter(Table = "Item Use Case")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Item Use Case]),
""
),
switchif(
Tables.filter(Table = "Order Status")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Order Status]),
""
),
switchif(
Tables.filter(Table = "Order Mechanism")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Order Mechanism]),
""
),
switchif(
Tables.filter(Table = "Order Cadence")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows(Trigger),
""
),
switchif(
Tables.filter(Table = "Formats by Size")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Formats by Size]),
""
),switchif(
Tables.filter(Table = "Master Suppliers")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([External Suppliers]),
""
),
switchif(
Tables.filter(Table = "Vehicle Type")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Vehicle Type]),
""
),
switchif(
Tables.filter(Table = "Vehicle Model")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Vehicle Model]),
""
),
switchif(
Tables.filter(Table = "Vehicle Area")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows(Components),
""
),
switchif(
Tables.filter(Table = "Build Stages")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Build Stages]),
""
),
switchif(
Tables.filter(Table = "Build Components")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Build Components]),
""
),
switchif(
Tables.filter(Table = "Build Milestones")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Build Milestones]),
""
),
switchif(
Tables.filter(Table = "Build Timeline")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Project Timeline]),
""
),
switchif(
Tables.filter(Table = "Email Templates")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Email Templates]),
""
),
switchif(
Tables.filter(Table = "New Custom Build")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([New Project]),
""
),
switchif(
Tables.filter(Table = "Order Document Templates")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Order Document Templates]),
""
),
switchif(
Tables.filter(Table = "Task Status")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Task Status]),
""
),
switchif(
Tables.filter(Table = "Master Task Type")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Master Task Type]),
""
),
switchif(
Tables.filter(Table = "Company Information")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Company Information]),
""
),
switchif(
Tables.filter(Table = "Order Documents")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Order Documents]),
""
),
switchif(
Tables.filter(Table = "Order Archive")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Order Archive]),
""
),
switchif(
Tables.filter(Table = "Order Line Item Archive")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Order Line Item Archive]),
""
),
switchif(
Tables
.filter(
Table = "Build-Specific Cart Line Items"
)
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Build-Specific Cart Line Items]),
""
),
switchif(
Tables.filter(Table = "Build-Specific Cart")
.[On Update]
.contains(
Clear, Copy
),
deleterows([Build-Specific Cart]),
""
),
switchif(
Tables.filter(Table = "Master Builds")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows(Projects),
""
),
switchif(
Tables.filter(Table = "Order Groups")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Order Groups]),
""
),
switchif(
Tables.filter(Table = "Build Timeline")
.[On Update]
.contains(
Clear, Copy
),
DeleteRows([Project Timeline]),
""
),
switchif(
Tables.filter(Table = "Master Order Card Layout")
.[On Update]
.contains(
Clear, Copy
),
Delete,
""
),
modifyrows(thisRow, [Enable Delete], false)
)
664
New Instance URL
Enable Delete
checkbox
665
New Instance URL
Copy Data
button
RunActions([Copy Table])
666
New Instance URL
Old New Instance URL Row URL
link
667
Table Types
Table Type
text
668
Table Types
Color
lookup
Color Options
669
Table Types
Color ID
text
Color.[Color ID].ListCombine()
670
Table Types
Tables
lookup
Tables.Filter([Table Type].Contains(thisRow))
Tables
671
Build-Specific Cart Line Items
Item
lookup
Items
672
Build-Specific Cart Line Items
Project
lookup
Projects
673
Build-Specific Cart Line Items
Orders
lookup
Order Line Item Archive
674
Build-Specific Cart Line Items
Notes
canvas
675
Build-Specific Cart Line Items
Vehicle Area
lookup
Item.Components.ListCombine()
676
Build-Specific Cart Line Items
Order Qty. Price
currency
[Unit Price]*[Order Qty]
677
Build-Specific Cart Line Items
Unit Price
text
Item.[Unit Price].ListCombine()
678
Build-Specific Cart Line Items
Create Order Record
button
runactions(
AddRow(
[Order Line Item Archive],
[Item Image],
[Image (URL)],
[Item Price],
Item.[Total Price],
[Order Mechanism],
[Order Mechanism],
Location,
Item.Location,
Supplier,
Supplier,
Status,
switchif(
[Order Mechanism] = Shopping, Finished, Ordered
),
Item,
Item,
[Include in Receiving],
Item.[Receiving Inclusion],
Quantity,
[Order Qty],
Units,
[Order Units],
Project,
Project
),
switchif(
Task.IsNotBlank(),
ModifyRows(
Task,
[Received/Completion Date],
now()
)
),
DeleteRows(thisRow)
)
679
Build-Specific Cart Line Items
Order Qty
number
Project.Items.listcombine().filter(CurrentValue=Item).count()*Item.[Order Qty]
680
Build-Specific Cart Line Items
Image (URL)
image
Item.[Image (URL)].ListCombine()
681
Build-Specific Cart Line Items
Primary Supplier
lookup
Item.[Primary Supplier].ListCombine()
External Suppliers
682
Build-Specific Cart Line Items
Secondary Supplier
lookup
Item.[Secondary Supplier].ListCombine()
External Suppliers
683
Build-Specific Cart Line Items
Use Secondary Supplier
checkbox
684
Build-Specific Cart Line Items
Supplier
lookup
Item.Supplier
Master Suppliers
685
Build-Specific Cart Line Items
Switch Supplier
button
modifyrows(thisRow,[Use Secondary Supplier],switchif([Use Secondary Supplier],false,true ))
686
Build-Specific Cart Line Items
Order Mechanism
lookup
Item.[Order Mechanism].ListCombine()
Order Mechanism
687
Build-Specific Cart Line Items
Order Units
text
Item.[Order Units].ListCombine()
688
Build-Specific Cart Line Items
Order
button
runactions(
switchif(
[Order Mechanism] = PO,
runactions(
addrow(
[Order Documents],
Status,
[PO Created],
[Line Items],
[Shopping Cart]
.filter(
Supplier = Supplier and
[Order Mechanism] = PO
),
[PO Created Date],
today(),
Supplier,
Supplier,
Project,
Project
),
openwindow(objectlink([Order Documents].last()))
),
[Order Mechanism] = Online and
[In Cart] = false,
runactions(
[Shopping Cart]
.filter(
currentvalue.Supplier = Supplier and
[Order Mechanism] = Online and
[In Cart] = false
)
.[Open Link],
modifyrows(
[Shopping Cart]
.filter(
currentvalue.Supplier = Supplier and
[Order Mechanism] = Online and
[In Cart] = false
),
[In Cart],
true
)
),
[Order Mechanism] = Online and
[In Cart] = true,
[Create Order Record],
[Order Mechanism] = Email,
switchif(
[Email Queue].IsNotBlank(),
openrow([Email Queue], [Email Queue], "Right"),
openrow(
AddRow(
[Email Queue],
[Due Date],
switchif(
[Execution Cadence] = Immediately,
now(),
[Execution Cadence] = [End of Day],
today(),
switchif(
today().WeekdayName() = "Monday",
today() + 3,
today().WeekdayName() = "Tuesday",
today() + 2,
today().WeekdayName() = "Wednesday",
today() + 1,
today()
)
),
Supplier,
Supplier,
Complete,
"false",
Subject,
switchif(
[Order Mechanism] = Email,
Subject,
""
),
Body,
switchif(
[Order Mechanism] != Email,
"",
thisTable
.filter(
Supplier = Supplier and
[Order Qty] != 0 and
[Order Qty].IsNotBlank() and
[Order Mechanism] = Email
)
.foreach(
concatenate(
"Qty: ",
CurrentValue.[Order Qty],
" ",
[Order Units],
" ",
CurrentValue.Item
.Name,
" ",
switchif(
[Include Order Description],
CurrentValue.Item
.[Order Description],
""
),
switchif(
[Include Taxable Status],
concatenate(
Character(13),
switchif(
currentvalue.Item
.Taxable,
"Taxable",
"Tax-Exempt"
)
),
""
)
)
)
.BulletedList()
.withname(
[item list],
concatenate(
_color("#000000", [item list]),
character(13),
Supplier.[External Suppliers]
.[Vendor Number & Additional Info]
)
)
.withname(
orderitems,
format(
Body,
Supplier.[External Suppliers].[Primary Contact]
.split(
" "
)
.first(),
orderitems,
[Company Name],
[Company Address]
)
)
),
Owner,
user(),
Items,
[Shopping Cart]
.Filter(
Supplier = Supplier and
[To Order].IsNotBlank() and
[Order Mechanism] = Email
)
.Item
.ListCombine(),
[Order Quantity],
[Order Qty]
),
[Email Queue],
"Right"
)
),
[Order Mechanism] = Shopping,
OpenWindow(ObjectLink([Shopping Lists]))
),
switchif(
Task.IsNotBlank(),
ModifyRows(
Task, [Actual Start], now()
)
)
)
689
Build-Specific Cart Line Items
Open Link
button
OpenWindow(switchif([Use Secondary Supplier] and Item.[URL 2].IsNotBlank(),Item.[URL 2],[Use Secondary Supplier]=false and Item.[URL 1].IsNotBlank(),Item.[URL 1],[Use Secondary Supplier],[Secondary Supplier].Website, [Primary Supplier].Website))
690
Build-Specific Cart Line Items
Edit
button
OpenRow(Item,Items,"Right")
691
Build-Specific Cart Line Items
Remove
button
runactions(ModifyRows([Order Line Item Archive].Project ,Items,[Order Line Item Archive].Project.Items.filter(CurrentValue.contains(Item).not())),DeleteRows(thisRow))
692
Build-Specific Cart Line Items
Email Queue
lookup
Email Queue
693
Build-Specific Cart Line Items
Execution Cadence
lookup
Item.Trigger.ListCombine()
Trigger
694
Build-Specific Cart Line Items
In Cart
checkbox
695
Build-Specific Cart Line Items
Task
lookup
[Order Line Item Archive]
.filter(
[Order Mechanism] = Task and
Project = Project and
Item.Components.ListCombine()
.contains(
Item.Components
)
)
Order Line Item Archive
696
Build-Specific Cart Line Items
Added To Cart
date
created(thisRow)
697
Build-Specific Cart Line Items
Cart Duration
duration
[Added To Cart]-today()
698
Update Options
Update Option
text
699
Update Options
Color
lookup
Color Options
700
Update Options
Color ID
text
Color.[Color ID].ListCombine()
701
Production Dashboard
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
702
Production Dashboard
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
703
Production Dashboard
Internal Supplier
lookup
Locations
704
Production Dashboard
Production Batch
lookup
Production Batch
705
Production Dashboard
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
706
Production Dashboard
Priority
lookup
Priority
707
Production Dashboard
Department
lookup
Departments
708
Priority
Priority
text
709
Priority
Color
lookup
Color Options
710
Priority
Color ID
text
Color.[Color ID].ListCombine()
711
Priority
Priority Rank
number
rank(
RowId(thisRow),
foreach(thisTable, RowId(CurrentValue)),
false
)*1000000
712
Production Batch
Name
text
713
Production Batch
Color
lookup
Department.Color.ListCombine()
Color Options
714
Production Batch
Department
lookup
Departments
715
Production Batch
Color ID
text
Color.[Color ID].ListCombine()
716
Print Document Type
Print Document Type
text
717
Print Document Type
Color
lookup
Color Options
718
Print Document Type
Color ID
text
Color.[Color ID].ListCombine()
719
Sub-Locations
Sub-Location
text
720
Sub-Locations
Color
lookup
Location.Color
Color Options
721
Sub-Locations
Location
lookup
Locations
722
Sub-Locations
Department
lookup
Location.Department
Departments
723
Sub-Locations
Color ID
number
Color.[Color ID].ListCombine()
724
Sub-Locations
ID
text
RowId(thisRow)
725
Add Items to Build
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
726
Add Items to Build
Project Actions
text
Concatenate(
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From BOM],
"",
"Red",
"",
"",
false,
"Small",
"clear-symbol"
),
" ",
button(
[Add To Project],
"",
switchif(
[Order Line Item Archive]
.Project
.Items
.ListCombine()
.contains(
Item
),
"Yellow",
"Green"
),
[Order Line Item Archive].Project.Items.ListCombine().countif(CurrentValue=Item ).withname(count,switchif(count=0,"",count)),
"",
false,
"Small",
"add-database"
)
)
727
Add Items to Build
Supplier
lookup
switchif(
[Order Mechanism].IsBlank() or
Name = "Target Completion Date" or
Name = "Project Start" or
and(
[Order Mechanism].contains(Task, Production).not(),
[Secondary Supplier].IsBlank(),
[Primary Supplier].IsBlank()
),
"",
[Order Mechanism] = Task and Department.IsBlank(),
"",
[Order Mechanism] = Task,
[Master Suppliers]
.filter(
Department = Department and
CurrentValue.Name.IsNotBlank()
),
[Order Mechanism] = Production,
[Master Suppliers]
.filter(
Locations = [Internal Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Use Secondary Supplier] and
[Secondary Supplier].IsNotBlank(),
[Master Suppliers]
.filter(
[External Suppliers] =
[Secondary Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Master Suppliers]
.filter(
[External Suppliers] = [Primary Supplier] and
CurrentValue.Name.IsNotBlank()
)
)
Master Suppliers
728
Add Items to Build
Order Qty
number
729
Add Items to Build
Order Units
text
730
Add Items to Build
Unit Price
currency
731
Add Items to Build
Avg. Time
duration
732
Add Items to Build
Max Time
duration
733
Add Items to Build
Components
lookup
Components
734
SOPs
Name
text
735
SOPs
Description
text
736
SOPs
Department
lookup
Departments
737
SOPs
Notes
canvas
738
SOPs
Resources
canvas
739
SOPs
Location
lookup
Locations
740
SOPs
Product
lookup
Products
741
SOPs
Last Edited
text
concatenate(Modified(thisRow)," by ",thisRow.ModifiedBy()).totext()
742
SOPs
People
person
743
SOPs
SOP
canvas
744
SOPs
Print Format
text
format(
[Print Size].Template,
Name,
Department.ToText(),
[SOP Type].ToText(),
Location.totext(),
SOP,
[QR Code],
[Image URL],
Description,
"",
concatenate(
Rectangle(100, 25, "#000000"),
Rectangle(
100,
25,
Department.Color.Color
.[Light Hex]
),
Rectangle(100, 25, "#000000"),
Rectangle(
100,
25,
Department.Color.Color
.[Light Hex]
),
Rectangle(100, 25, "#000000")
),
_Color(
switchif(
[Color Code Title Text],
Department.Color.Color
.[Dark Hex],
"#000000"
),
"Department"
),
_Color(
switchif(
[Color Code Title Text],
Department.Color.Color
.[Dark Hex],
"#000000"
),
"Location"
),
"",
_Color(
switchif(
[Color Code Title Text],
Department.Color.Color
.[Dark Hex],
"#000000"
),
"SOP Type"
)
)
745
SOPs
QR Code
text
image(
BarcodeQR([Forwarding Link], "white", "black"),
switchif([Print Size] = [3” x 5”], 300, 75),
switchif([Print Size] = [3” x 5”], 300, 75),
"Database Link",
"auto",
false
)
746
SOPs
Row URL
link
ObjectLink(thisRow)
747
SOPs
Forwarding Link
link
Concatenate("https://link.arda.cards/",[Company Information].first().[Unique Identifier],"/",[Unique Identifier],"SOP",[SOP Number])
748
SOPs
SOP Number
number
rank(RowId(thisRow),thisTable.foreach(RowId(currentvalue)).listcombine(),true)
749
SOPs
Template
lookup
SOP Templates
750
SOPs
Delete
button
runactions(
ModifyRows(
thisRow,
Name,
"",
[SOP Type],
"",
Description,
"",
Department,
"",
Notes,
"",
Resources,
"",
SOP,
"",
Location,
"",
Product,
"",
[Image URL],
"",
Template,
"",
People,
"",
[Next SOP],
"",
[Previous SOP],
"",[External Supplier],"",
[Parent SOP],
"",
[Child SOPs],
""
)
)
751
SOPs
Color
lookup
[SOP Type].Color.ListCombine()
Color Options
752
SOPs
Color ID
text
Color.[Color ID]
753
SOPs
Title
text
concatenate(_color(Color.[Text Color],Name.totext()))
754
SOPs
Print
button
openrow(thisRow,SOPs,"Right")
755
SOPs
Open
button
switchif(
[SOP Type] = Product,
OpenRow(thisRow, [SOPs Product View], "Right"),
[SOP Type] = [Product Variant],
OpenRow(thisRow, [SOPs Product View], "Right"),
[SOP Type].contains(Other),
OpenRow(thisRow, [SOPs Product View], "Right"),
[SOP Type] = Task,
OpenRow(thisRow, [SOPs Task View], "Right"),
[SOP Type] = Department,
OpenRow(thisRow, [SOPs Location View], "Right"),
[SOP Type] = Item,
OpenRow(thisRow, [SOPs Item View], "Right"),
[SOP Type] = Supplier,
OpenRow(thisRow, [SOPs Supplier View], "Right"),
[SOP Type] = [Location/Equipment],
OpenRow(thisRow, [SOPs Location View], "Right")
)
756
SOPs
Print Size
lookup
Formats by Size
757
SOPs
Parent SOP
lookup
SOPs
758
SOPs
Child SOPs
lookup
SOPs.Filter([Parent SOP].Contains(thisRow))
SOPs
759
SOPs
Actions
text
Concatenate(
button(Print, "", "Blue", "", "", false, "small", "print"),
" ",
button(
Open,
"",
"Pink",
"",
"",
false,
"small",
"external-link-squared"
),
" ",
button(Edit, "", "Orange", "", "", false, "small", "pencil"),
" ",
button(Delete, "", "Red", "", "", false, "small", "trash")
)
760
SOPs
Previous SOP
lookup
SOPs
761
SOPs
Next SOP
lookup
SOPs.Filter([Previous SOP].Contains(thisRow))
SOPs
762
SOPs
Go To Next SOP
button
OpenWindow(ObjectLink([Next SOP].first()))
763
SOPs
Go To Prior SOP
button
OpenWindow(ObjectLink([Previous SOP]))
764
SOPs
Generate w/AI
button
openrow(
ModifyRows(
[AI SOP].first(),
Name,
thisRow,
[AI Prompt],
format(
[SOP Type].[AI SOP Prompt],
switchif(
[SOP Type] = Item,
Item.totext(),
[SOP Type] = Task,
Item.totext(),
[SOP Type] = Department,
Department.totext(),
[SOP Type] = [Location/Equipment],
Location.totext(),
[SOP Type] = Supplier,
[External Supplier].totext(),
[SOP Type] = Product,
Product.totext(),
[SOP Type] = Component,
Components.totext()
)
)
),
[AI SOP],
"Right"
)
765
SOPs
SOP Type
lookup
SOP Type
766
SOPs
Related SOPs
lookup
switchif(Name.isblank(),"",
[SOP Type] = Item,
SOPs.filter(Item.contains(Item)),
[SOP Type] = Product,
SOPs.filter(Product.contains(Product)),
[SOP Type].contains([Location/Equipment]),
SOPs
.filter(
Location.contains(Location.listcombine())
),
[SOP Type] = Department,
SOPs.filter(Department.contains(Department)),
[SOP Type] = Supplier,
SOPs
.filter(
[External Supplier] = [External Supplier]
)
)
.filter(
CurrentValue != thisRow
)
SOPs
767
SOPs
Image URL
image
768
SOPs
Apply Template
button
ModifyRows(thisRow ,SOP,Template.Template )
769
SOPs
Internal Supplier
lookup
Locations
770
SOPs
External Supplier
lookup
External Suppliers
771
SOPs
Item
lookup
Items
772
SOPs
Edit
button
switchif(
[SOP Type] = Item,
openrow(thisRow, [SOPs Item View], "Right"),
[SOP Type] = [Location/Equipment],
openrow(thisRow, [SOPs Location View], "Right"),
[SOP Type] = Supplier,
openrow(thisRow, [SOPs Supplier View], "Right"),
[SOP Type] = Task,
openrow(thisRow, [SOPs Task View], "Right"),
[SOP Type] = Department,
openrow(thisRow, [SOPs Department View], "Right"),
[SOP Type] = Product,
openrow(thisRow, [SOPs Product View], "Right"),
[SOP Type] = Component,
openrow(thisRow, [SOPs Product View], "Right"),
[SOP Type] = Other,
openrow(thisRow, [SOPs Supplier View], "Right"),
openrow(thisRow, SOPs, "Right")
)
773
SOPs
Flag
reaction
774
SOPs
Components
lookup
Components
775
Products
Name
text
776
Products
Color
lookup
Color Options
777
Products
Color ID
text
Color.[Color ID].ListCombine()
778
Products
Related SOPs
lookup
SOPs.Filter(Product.Contains(thisRow))
SOPs
779
Products
Delete
button
runactions(
SOPs
.filter(
[SOP Type].contains(Product) and
Product.Contains(thisRow)
)
.Delete
, DeleteRows(thisRow))
780
Products
Edit
button
OpenRow(thisRow,thisTable,"Right")
781
Products
Tasks
lookup
Items.Filter(Products.Contains(thisRow) and [Order Mechanism]=Task)
Items
782
Products
Create/Open SOP
button
runactions(
modifyrows(
thisRow,
SOP,
modifyrows(
switchif(
SOP.IsBlank(),
SOPs.filter(Name.IsBlank()).MinBy([SOP Number]),
SOP
),
Product,
thisRow,
[SOP Type],
Product,
Department,
Tasks.Department.ListCombine(),
Name,
_color("#000000", Name, " SOP")
)
),
openrow(SOP, [SOPs Product View], "Right")
)
783
Products
SOP
lookup
SOPs
784
Products
Product
lookup
lookup(Products,Name,Name)
Products
785
Products
Image URL
image
786
Products
Actions
text
787
Products
Inputs
text
788
Products
Outputs
text
789
Products
Components
lookup
Components
790
Products
Create Component
button
openrow(addrow(Components,Products,thisRow),Components,"Right")
791
SOP Type
SOP Type
text
792
SOP Type
Color
lookup
Color Options
793
SOP Type
Color ID
text
Color.[Color ID].ListCombine()
794
SOP Type
SOPs
lookup
SOPs.Filter([SOP Type].Contains(thisRow))
SOPs
795
SOP Type
Hierarchy
number
796
SOP Type
Canvas
canvas
797
SOP Type
AI SOP Prompt
canvas
798
New SOP
Color
lookup
[SOP Type].Color.ListCombine()
Color Options
799
New SOP
Color ID
text
Color.[Color ID]
800
New SOP
Title
text
"Create New SOP"
801
New SOP
SOP Type
lookup
SOP Type
802
New SOP
SOP Subject
select
803
New SOP
Description
text
804
New SOP
Create SOP
button
runactions(
modifyrows(
thisRow,
[Created SOP],
modifyrows(
SOPs.filter(Name.IsBlank()).MinBy([SOP Number]),
[SOP Type],
[SOP Type],
Name,
concatenate([SOP Subject], " SOP").totext(),
Description,
Description,
Item,
switchif(
[SOP Type].contains(Item, Task),
[SOP Subject],
""
),
Location,
switchif(
[SOP Type] = [Location/Equipment],
[SOP Subject],
""
),
Department,
switchif(
[SOP Type] = Department,
[SOP Subject],
[SOP Type] = [Location/Equipment],
Locations
.filter(
Name = [SOP Subject].ToText()
)
.Department,
""
),
Product,
switchif(
[SOP Type] = Product, [SOP Subject], ""
),
Components,
switchif(
[SOP Type] = Component, [SOP Subject], ""
),
[External Supplier],
switchif(
[SOP Type] = Supplier, [SOP Subject], ""
),
[Internal Supplier],
switchif(
[SOP Type] = [Location/Equipment],
[SOP Subject],
""
)
)
),
[Created SOP].Edit,
deleterows(thisRow)
)
805
New SOP
Created SOP
lookup
SOPs
806
AI Prompts
Name
text
807
AI Prompts
Prompt
text
808
AI Prompts
Key
text
809
AI Prompts
Notes
button
switchif(Name="Attributing Items to Products",RefreshColumn(Product),Name="Attributing Items to Variant Options",runactions(refreshcolumn([Variant 1]),refreshcolumn([Variant 2]),refreshcolumn([Variant 3]),refreshcolumn([Variant 4])),Name="Attributing Production Stages to Departments",Department,Name="Next Stage",[Next Stage],Name="Sequencing Production Operations",[Next Operation])
810
AI Prompts
Column 5
text
811
SOP Templates
Name
text
812
SOP Templates
Template
canvas
813
SOP Templates
Color
lookup
Color Options
814
SOP Templates
Color ID
text
Color.[Color ID].ListCombine()
815
SOP Templates
Delete
button
DeleteRows(thisRow)
816
SOP Templates
Duplicate
button
openrow(DuplicateRows(thisRow, Name, _color("#000000",concatenate("Copy of ", Name))),thisTable,"Right")
817
AI SOP
Name
lookup
SOPs
818
AI SOP
Description
text
Name.Description
819
AI SOP
Department
lookup
Name.Department
Departments
820
AI SOP
Est. Time
duration
Name.[Est. Time]
821
AI SOP
Location
lookup
Name.Location
Locations
822
AI SOP
Product
lookup
Name.Product.ListCombine()
823
AI SOP
Product Variant
lookup
Name.Variants.ListCombine()
824
AI SOP
Operation
lookup
Name.[Production Operations].ListCombine()
825
AI SOP
QR Code
text
image(BarcodeQR([Forwarding Link],"white","black"),75,75,"Database Link","auto",false)
826
AI SOP
Row URL
link
ObjectLink(thisRow)
827
AI SOP
Forwarding Link
link
Concatenate("https://link.arda.cards/",[Company Information].first().[Unique Identifier],"/SOP",[SOP Number])
828
AI SOP
SOP Number
number
rank(RowId(thisRow),thisTable.foreach(RowId(currentvalue)).listcombine(),true)
829
AI SOP
Template
lookup
SOP Templates
830
AI SOP
Title
text
Name.ToText()
831
AI SOP
Previous SOP
lookup
Name.[Previous SOP].ListCombine()
AI SOP
832
AI SOP
Next SOP
lookup
Name.[Next SOP].ListCombine()
AI SOP
833
AI SOP
AI-Generated SOP
canvas
834
AI SOP
Copy
button
runactions(ModifyRows(Name,SOP,[AI-Generated SOP]),Openrow(Name))
835
AI SOP
AI Prompt
canvas
836
AI SOP
Refresh AI
button
RefreshAssistant([AI-Generated SOP])
837
SOPs Location View
Title
text
concatenate(_color(Color.[Text Color],Name.totext()))
838
SOPs Location View
Actions
text
Concatenate(
button(Print, "", "Blue", "", "", false, "small", "print"),
" ",
button(
Open,
"",
"Pink",
"",
"",
false,
"small",
"external-link-squared"
),
" ",
button(Edit, "", "Orange", "", "", false, "small", "pencil"),
" ",
button(Delete, "", "Red", "", "", false, "small", "trash")
)
839
SOPs Location View
Flag
reaction
840
SOPs Location View
SOP Type
lookup
SOP Type
841
SOPs Product View
Title
text
concatenate(_color(Color.[Text Color],Name.totext()))
842
SOPs Product View
Actions
text
Concatenate(
button(Print, "", "Blue", "", "", false, "small", "print"),
" ",
button(
Open,
"",
"Pink",
"",
"",
false,
"small",
"external-link-squared"
),
" ",
button(Edit, "", "Orange", "", "", false, "small", "pencil"),
" ",
button(Delete, "", "Red", "", "", false, "small", "trash")
)
843
SOPs Product View
SOP Type
lookup
SOP Type
844
SOPs Task View
Title
text
concatenate(_color(Color.[Text Color],Name.totext()))
845
SOPs Task View
Actions
text
Concatenate(
button(Print, "", "Blue", "", "", false, "small", "print"),
" ",
button(
Open,
"",
"Pink",
"",
"",
false,
"small",
"external-link-squared"
),
" ",
button(Edit, "", "Orange", "", "", false, "small", "pencil"),
" ",
button(Delete, "", "Red", "", "", false, "small", "trash")
)
846
SOPs Task View
SOP Type
lookup
SOP Type
847
SOPs Department View
Title
text
concatenate(_color(Color.[Text Color],Name.totext()))
848
SOPs Department View
Actions
text
Concatenate(
button(Print, "", "Blue", "", "", false, "small", "print"),
" ",
button(
Open,
"",
"Pink",
"",
"",
false,
"small",
"external-link-squared"
),
" ",
button(Edit, "", "Orange", "", "", false, "small", "pencil"),
" ",
button(Delete, "", "Red", "", "", false, "small", "trash")
)
849
SOPs Department View
SOP Type
lookup
SOP Type
850
SOPs Item View
Title
text
concatenate(_color(Color.[Text Color],Name.totext()))
851
SOPs Item View
Actions
text
Concatenate(
button(Print, "", "Blue", "", "", false, "small", "print"),
" ",
button(
Open,
"",
"Pink",
"",
"",
false,
"small",
"external-link-squared"
),
" ",
button(Edit, "", "Orange", "", "", false, "small", "pencil"),
" ",
button(Delete, "", "Red", "", "", false, "small", "trash")
)
852
SOPs Item View
SOP Type
lookup
SOP Type
853
SOPs Supplier View
Title
text
concatenate(_color(Color.[Text Color],Name.totext()))
854
SOPs Supplier View
Actions
text
Concatenate(
button(Print, "", "Blue", "", "", false, "small", "print"),
" ",
button(
Open,
"",
"Pink",
"",
"",
false,
"small",
"external-link-squared"
),
" ",
button(Edit, "", "Orange", "", "", false, "small", "pencil"),
" ",
button(Delete, "", "Red", "", "", false, "small", "trash")
)
855
SOPs Supplier View
SOP Type
lookup
SOP Type
856
New Internal Item
Enter Item Name
text
857
New Internal Item
Triggered
lookup
Trigger
858
New Internal Item
Primary Supplier
lookup
External Suppliers
859
New Internal Item
Internal Supplier
lookup
Locations
860
New Internal Item
Location
lookup
Locations
861
New Internal Item
Notes
canvas
862
New Internal Item
Order Description
text
863
New Internal Item
Min Qty
number
864
New Internal Item
Order Qty
number
865
New Internal Item
Link
link
866
New Internal Item
Secondary URL
link
867
New Internal Item
Create & Print
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Use Case],
[Use Case],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Printed,
true,
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
true
)
),
OpenRow(
[Created Order Card],
[Print Format],
viewMode: "right"
),
DeleteRows(thisRow)
)
868
New Internal Item
Order Mechanism
lookup
Order Mechanism
869
New Internal Item
Created Order Card
lookup
Items
870
New Internal Item
Min Units
text
871
New Internal Item
Order Units
text
872
New Internal Item
Type
lookup
Item Type
873
New Internal Item
Sub-Type
lookup
Item Sub-Type
874
New Internal Item
Order Card Size
lookup
Formats by Size
875
New Internal Item
Label Size
lookup
Formats by Size
876
New Internal Item
Saved
checkbox
877
New Internal Item
Delete
button
DeleteRows(thisRow)
878
New Internal Item
Image URL
image
879
New Internal Item
Image
image
880
New Internal Item
Unit Price
currency
881
New Internal Item
Create & Add Another
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Use Case],
[Use Case],
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
runactions(
switchif(
[Order Mechanism] = Production,
runactions([Draft Internal Item 7]),
[Order Mechanism] = Task,
runactions([Draft Process Item 2]),
runactions([Draft New Order Card 6])
)
),
DeleteRows(thisRow)
)
882
New Internal Item
Production Priority
lookup
Priority
883
New Internal Item
Production Batch
lookup
Production Batch
884
New Internal Item
Secondary Supplier
lookup
External Suppliers
885
New Internal Item
SKU
text
886
New Internal Item
Sub-Location
lookup
Sub-Locations
887
New Internal Item
Create
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],File,File,
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Use Case],
[Use Case],
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
DeleteRows(thisRow)
)
888
New Internal Item
Component
lookup
Components
889
New Internal Item
Varaint
lookup
890
New Internal Item
Depends On
lookup
Items
891
New Internal Item
Dependents
lookup
Items
892
Component Types
Component Group
text
893
Component Types
Color
lookup
Color Options
894
Component Types
Color ID
text
Color.[Color ID].ListCombine()
895
Component Types
Products
lookup
Products.Filter([Variant Type].Contains(thisRow))
Products
896
Component Types
Components
lookup
Components.Filter([Component Group].Contains(thisRow))
Components
897
Holidays
Name
text
898
Holidays
Date
date
899
Tasks
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
900
Tasks
Actions
text
concatenate(
button(
Print,
"",
switchif(Printed, "Blue", "Yellow"),
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-paper", "print")
),
" ",
switchif(
[Order Mechanism] = Task,
"",
button(
[Print Label/Breadcrumb],
"",
"Purple",
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-money", "feed-paper")
)
),
switchif([Order Mechanism] = Task, "", " "),
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
" ",
button(
switchif(
[Order Mechanism] = Task,
[Create Order Record],
[Add to Cart]
),
"",
"Green",
switchif(
[Order Mechanism] = Task,
"",
[Order Qty].IsBlank(),
"+Qty",
[To Order] = 0 or [To Order].IsBlank(),
"",
[To Order]
),
"",
false,
"Small",
switchif(
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Task,
"lightning-bolt",
"add-shopping-cart"
)
)
)
901
Tasks
Person
person
902
Tasks
Printed
checkbox
903
Tasks
Card Size
lookup
Formats by Size
904
Tasks
Department
lookup
Departments
905
Tasks
Trigger
lookup
Trigger
906
Tasks
Relative Days to Trigger
duration
907
Tasks
Depends On
lookup
Items
908
Tasks
Finish Criteria
lookup
Finished
909
Tasks
URL 1
link
910
Tasks
Related Items
lookup
Items
911
Tasks
Dependents
lookup
Items.Filter([Depends On].Contains(thisRow))
Items
912
Tasks
Avg. Time
duration
913
Tasks
Max Time
duration
914
Tasks
Products
lookup
Products
915
Tasks
Components
lookup
Components
916
Tasks
Notes
canvas
917
Tasks
More Actions
text
concatenate(
button(
[Calculate Lead Times],
"",
"Purple",
switchif(
[Calculated Avg. Lead Time].IsBlank(),
"",
[Calculated Avg. Lead Time].split("days").first()
.trim()
.ToNumber()
),
"",
false,
"Small",
"alarm-clock"
),
" ",
button(
Duplicate,
"",
"Pink",
"",
"",
false,
"Small",
"copy"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
)
)
918
New Task
Enter Item Name
text
919
New Task
Triggered
lookup
Trigger
920
New Task
Primary Supplier
lookup
External Suppliers
921
New Task
Internal Supplier
lookup
Locations
922
New Task
Location
lookup
Locations
923
New Task
Notes
canvas
924
New Task
Order Description
text
925
New Task
Min Qty
number
926
New Task
Order Qty
number
927
New Task
Link
link
928
New Task
Secondary URL
link
929
New Task
Create & Print
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Use Case],
[Use Case],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Printed,
true,
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
true
)
),
OpenRow(
[Created Order Card],
[Print Format],
viewMode: "right"
),
DeleteRows(thisRow)
)
930
New Task
Order Mechanism
lookup
Order Mechanism
931
New Task
Created Order Card
lookup
Items
932
New Task
Min Units
text
933
New Task
Order Units
text
934
New Task
Type
lookup
Item Type
935
New Task
Sub-Type
lookup
Item Sub-Type
936
New Task
Order Card Size
lookup
Formats by Size
937
New Task
Label Size
lookup
Formats by Size
938
New Task
Saved
checkbox
939
New Task
Delete
button
DeleteRows(thisRow)
940
New Task
Image URL
image
941
New Task
Image
image
942
New Task
Unit Price
currency
943
New Task
Create & Add Another
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Use Case],
[Use Case],
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
runactions(
switchif(
[Order Mechanism] = Production,
runactions([Draft Internal Item 7]),
[Order Mechanism] = Task,
runactions([Draft Process Item 2]),
runactions([Draft New Order Card 6])
)
),
DeleteRows(thisRow)
)
944
New Task
Production Priority
lookup
Priority
945
New Task
Production Batch
lookup
Production Batch
946
New Task
Secondary Supplier
lookup
External Suppliers
947
New Task
SKU
text
948
New Task
Sub-Location
lookup
Sub-Locations
949
New Task
Create
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],File,File,
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Use Case],
[Use Case],
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
DeleteRows(thisRow)
)
950
New Task
Component
lookup
Components
951
New Task
Varaint
lookup
952
New Task
Previous Draft
button
thisTable.filter(Created(CurrentValue) < created(thisRow))
.MaxBy(
created(CurrentValue)
)
.WithName(
previous,
switchif(
previous.[Order Mechanism] = Production,
switchif(
[Advanced Mode],
openrow(previous, [New Internal Item], "Right"),
openrow(previous, [New Internal Item (Basic)], "Right")
),
previous.[Order Mechanism] = Task,
switchif(
[Advanced Mode],
openrow(previous, [New Task], "Right"),
openrow(previous, [New Task (Basic)], "Right")
),
switchif(
[Advanced Mode],
openrow(previous, [New External Item], "Right"),
openrow(previous, [New External Item (Basic)], "Right")
)
)
)
953
New Task
Next Draft
button
thisTable.filter(Created(CurrentValue) > created(thisRow))
.minBy(
created(CurrentValue)
)
.WithName(
next,
switchif(
next.[Order Mechanism] = Production,
switchif(
[Advanced Mode],
openrow(next, [New Internal Item], "Right"),
openrow(next, [New Internal Item (Basic)], "Right")
),
next.[Order Mechanism] = Task,
switchif(
[Advanced Mode],
openrow(next, [New Task], "Right"),
openrow(next, [New Task (Basic)], "Right")
),
switchif(
[Advanced Mode],
openrow(next, [New External Item], "Right"),
openrow(next, [New External Item (Basic)], "Right")
)
)
)
954
New Task
Department
lookup
Departments
955
New Task
Est. Days To Complete
duration
956
New Task
Trigger Days After Project Start
duration
957
New Task
Person
person
958
Finished
Finished
text
959
Finished
Color Options
lookup
Color Options
960
Finished
Color ID
number
[Color Options].[Color ID]
961
Master Suppliers
Name
text
_color(Color.[Text Color], switchif([External Suppliers].IsNotBlank(),[External Suppliers].ToText(),Locations.IsNotBlank(),Locations.ToText(),Department.IsNotBlank(), Department.ToText() ).filter(CurrentValue.IsNotBlank()))
962
Master Suppliers
External Suppliers
lookup
switchif( RowId(thisRow)>[External Suppliers].count(),"", [External Suppliers].nth(RowId(thisRow)))
External Suppliers
963
Master Suppliers
Locations
lookup
switchif(
[External Suppliers].IsNotBlank() or
Locations.count() = 0,
"",
Locations.filter(CurrentValue.IsNotBlank())
.nth(
RowId(thisRow) - [External Suppliers].count()
)
)
Locations
964
Master Suppliers
Department
lookup
switchif(
Locations.IsnotBlank() or
[External Suppliers].IsnotBlank(),
"",
Locations.count() = 0 or
[External Suppliers].IsNotBlank(),
"",
Departments
.nth(
RowId(thisRow) - [External Suppliers].count() -
Locations.count()
)
)
Departments
965
Master Suppliers
Color
lookup
switchif(
Department.IsNotBlank(),
Department.Color,
Locations.IsNotBlank(),
Locations.Color,
[External Suppliers].IsNotBlank(),
[External Suppliers].Color,
""
)
.ListCombine()
Color Options
966
Master Suppliers
Color ID
number
Color.[Color ID]
967
View of Departments
Department
text
968
View of Departments
Color
lookup
Color Options
969
View of Departments
Locations
lookup
Locations.Filter(Department.Contains(thisRow))
Locations
970
Modals
Modal
canvas
971
Modals
Name
text
972
Modals
Order Line Item Archive
lookup
Order Line Item Archive
973
PDF BOM
Item
lookup
[Order Line Item Archive] .Project.Items.ListCombine().filter(CurrentValue.[Order Mechanism]!=Task ).unique().filter(CurrentValue.IsNotBlank()).nth(RowId(thisRow))
Items
974
PDF BOM
Component
lookup
switchif(Item.IsNotBlank(),Item.Components,[Order Line Item Archive].Project.Product.Components.ListCombine().filter(CurrentValue.IsNotBlank()).nth(RowId(thisRow)-[Order Line Item Archive].Project.Items.ListCombine().unique().count())).first()
Components
975
PDF BOM
Total Price
currency
Item.[Unit Price].ListCombine()*Item.[Order Qty]
976
PDF BOM
Unit Price
currency
switchif(Item.[Unit Price].IsBlank(),"", Item.[Unit Price].ListCombine().ToNumber())
977
PDF BOM
Item Name
text
Item.Name
978
PDF BOM
Order Qty
number
Item.[Order Qty].ListCombine()* [Order Line Item Archive].Project.Items.listcombine().countif(CurrentValue=Item ).filter(CurrentValue!=0)
979
PDF BOM
Order Units
text
Item.[Order Units].ListCombine()
980
PDF BOM
Order Quantity
text
Concatenate([Order Qty]," ",[Order Units])
981
Internal Receiving
Item Name
text
Item.[Item Name].ListCombine()
982
Internal Receiving
Order Quantity
text
Concatenate(Quantity," ",Units)
983
Internal Receiving
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
984
Internal Receiving
Status
lookup
Order Status
985
Workstation Dashboard
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
986
Workstation Dashboard
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
987
Workstation Dashboard
Production Batch
lookup
Production Batch
988
Workstation Dashboard
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
989
Workstation Dashboard
Priority
lookup
Priority
990
Task Layout (Basic)
Select
checkbox
991
Task Layout (Basic)
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
992
Task Layout (Basic)
Actions
text
concatenate(
button(
Print,
"",
switchif(Printed, "Blue", "Yellow"),
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-paper", "print")
),
" ",
switchif(
[Order Mechanism] = Task,
"",
button(
[Print Label/Breadcrumb],
"",
"Purple",
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-money", "feed-paper")
)
),
switchif([Order Mechanism] = Task, "", " "),
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
" ",
button(
switchif(
[Order Mechanism] = Task,
[Create Order Record],
[Add to Cart]
),
"",
"Green",
switchif(
[Order Mechanism] = Task,
"",
[Order Qty].IsBlank(),
"+Qty",
[To Order] = 0 or [To Order].IsBlank(),
"",
[To Order]
),
"",
false,
"Small",
switchif(
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Task,
"lightning-bolt",
"add-shopping-cart"
)
)
)
993
Task Layout (Basic)
Person
person
994
Task Layout (Basic)
Printed
checkbox
995
Task Layout (Basic)
Receiving Inclusion
checkbox
996
Task Layout (Basic)
Card Size
lookup
Formats by Size
997
Task Layout (Basic)
Label Size
lookup
Formats by Size
998
Task Layout (Basic)
Order Mechanism
lookup
Order Mechanism
999
Task Layout (Basic)
Internal Supplier
lookup
Locations
1000
Task Layout (Basic)
Department
lookup
Departments
1001
Task Layout (Basic)
Primary Supplier
lookup
External Suppliers
1002
Task Layout (Basic)
URL 1
link
1003
Task Layout (Basic)
Secondary Supplier
lookup
External Suppliers
1004
Task Layout (Basic)
URL 2
link
1005
Task Layout (Basic)
Location
lookup
Locations
1006
Task Layout (Basic)
Sub-Location
lookup
Sub-Locations
1007
Task Layout (Basic)
Min Qty
number
1008
Task Layout (Basic)
Min. Units
text
1009
Task Layout (Basic)
Order Qty
number
1010
Task Layout (Basic)
Order Units
text
1011
Task Layout (Basic)
Unit Price
currency
1012
Task Layout (Basic)
Image (URL)
image
1013
Task Layout (Basic)
Upload Image
image
1014
Task Layout (Basic)
Notes
canvas
1015
Task Layout (Basic)
More Actions
text
concatenate(
button(
[Calculate Lead Times],
"",
"Purple",
switchif(
[Calculated Avg. Lead Time].IsBlank(),
"",
[Calculated Avg. Lead Time].split("days").first()
.trim()
.ToNumber()
),
"",
false,
"Small",
"alarm-clock"
),
" ",
button(
Duplicate,
"",
"Pink",
"",
"",
false,
"Small",
"copy"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
)
)
1016
New Task (Basic)
Enter Item Name
text
1017
New Task (Basic)
Triggered
lookup
Trigger
1018
New Task (Basic)
Primary Supplier
lookup
External Suppliers
1019
New Task (Basic)
Internal Supplier
lookup
Locations
1020
New Task (Basic)
Location
lookup
Locations
1021
New Task (Basic)
Notes
canvas
1022
New Task (Basic)
Order Description
text
1023
New Task (Basic)
Min Qty
number
1024
New Task (Basic)
Order Qty
number
1025
New Task (Basic)
Link
link
1026
New Task (Basic)
Secondary URL
link
1027
New Task (Basic)
Create & Print
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Use Case],
[Use Case],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Printed,
true,
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
true
)
),
OpenRow(
[Created Order Card],
[Print Format],
viewMode: "right"
),
DeleteRows(thisRow)
)
1028
New Task (Basic)
Order Mechanism
lookup
Order Mechanism
1029
New Task (Basic)
Created Order Card
lookup
Items
1030
New Task (Basic)
Min Units
text
1031
New Task (Basic)
Order Units
text
1032
New Task (Basic)
Type
lookup
Item Type
1033
New Task (Basic)
Sub-Type
lookup
Item Sub-Type
1034
New Task (Basic)
Order Card Size
lookup
Formats by Size
1035
New Task (Basic)
Label Size
lookup
Formats by Size
1036
New Task (Basic)
Saved
checkbox
1037
New Task (Basic)
Delete
button
DeleteRows(thisRow)
1038
New Task (Basic)
Image URL
image
1039
New Task (Basic)
Image
image
1040
New Task (Basic)
Unit Price
currency
1041
New Task (Basic)
Create & Add Another
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Use Case],
[Use Case],
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
runactions(
switchif(
[Order Mechanism] = Production,
runactions([Draft Internal Item 7]),
[Order Mechanism] = Task,
runactions([Draft Process Item 2]),
runactions([Draft New Order Card 6])
)
),
DeleteRows(thisRow)
)
1042
New Task (Basic)
Production Priority
lookup
Priority
1043
New Task (Basic)
Production Batch
lookup
Production Batch
1044
New Task (Basic)
Secondary Supplier
lookup
External Suppliers
1045
New External Item (Basic)
Enter Item Name
text
1046
New External Item (Basic)
Triggered
lookup
Trigger
1047
New External Item (Basic)
Primary Supplier
lookup
External Suppliers
1048
New External Item (Basic)
Internal Supplier
lookup
Locations
1049
New External Item (Basic)
Location
lookup
Locations
1050
New External Item (Basic)
Notes
canvas
1051
New External Item (Basic)
Order Description
text
1052
New External Item (Basic)
Min Qty
number
1053
New External Item (Basic)
Order Qty
number
1054
New External Item (Basic)
Link
link
1055
New External Item (Basic)
Secondary URL
link
1056
New External Item (Basic)
Create & Print
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Use Case],
[Use Case],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Printed,
true,
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
true
)
),
OpenRow(
[Created Order Card],
[Print Format],
viewMode: "right"
),
DeleteRows(thisRow)
)
1057
New External Item (Basic)
Order Mechanism
lookup
Order Mechanism
1058
New External Item (Basic)
Created Order Card
lookup
Items
1059
New External Item (Basic)
Min Units
text
1060
New External Item (Basic)
Order Units
text
1061
New External Item (Basic)
Type
lookup
Item Type
1062
New External Item (Basic)
Sub-Type
lookup
Item Sub-Type
1063
New External Item (Basic)
Order Card Size
lookup
Formats by Size
1064
New External Item (Basic)
Label Size
lookup
Formats by Size
1065
New External Item (Basic)
Saved
checkbox
1066
New External Item (Basic)
Delete
button
DeleteRows(thisRow)
1067
New External Item (Basic)
Image URL
image
1068
New External Item (Basic)
Image
image
1069
New External Item (Basic)
Unit Price
currency
1070
New External Item (Basic)
Create & Add Another
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Use Case],
[Use Case],
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
runactions(
switchif(
[Order Mechanism] = Production,
runactions([Draft Internal Item 7]),
[Order Mechanism] = Task,
runactions([Draft Process Item 2]),
runactions([Draft New Order Card 6])
)
),
DeleteRows(thisRow)
)
1071
New External Item (Basic)
Production Priority
lookup
Priority
1072
New External Item (Basic)
Production Batch
lookup
Production Batch
1073
New External Item (Basic)
Secondary Supplier
lookup
External Suppliers
1074
New Internal Item (Basic)
Enter Item Name
text
1075
New Internal Item (Basic)
Triggered
lookup
Trigger
1076
New Internal Item (Basic)
Primary Supplier
lookup
External Suppliers
1077
New Internal Item (Basic)
Internal Supplier
lookup
Locations
1078
New Internal Item (Basic)
Location
lookup
Locations
1079
New Internal Item (Basic)
Notes
canvas
1080
New Internal Item (Basic)
Order Description
text
1081
New Internal Item (Basic)
Min Qty
number
1082
New Internal Item (Basic)
Order Qty
number
1083
New Internal Item (Basic)
Link
link
1084
New Internal Item (Basic)
Secondary URL
link
1085
New Internal Item (Basic)
Create & Print
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Use Case],
[Use Case],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Printed,
true,
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
true
)
),
OpenRow(
[Created Order Card],
[Print Format],
viewMode: "right"
),
DeleteRows(thisRow)
)
1086
New Internal Item (Basic)
Order Mechanism
lookup
Order Mechanism
1087
New Internal Item (Basic)
Created Order Card
lookup
Items
1088
New Internal Item (Basic)
Min Units
text
1089
New Internal Item (Basic)
Order Units
text
1090
New Internal Item (Basic)
Type
lookup
Item Type
1091
New Internal Item (Basic)
Sub-Type
lookup
Item Sub-Type
1092
New Internal Item (Basic)
Order Card Size
lookup
Formats by Size
1093
New Internal Item (Basic)
Label Size
lookup
Formats by Size
1094
New Internal Item (Basic)
Saved
checkbox
1095
New Internal Item (Basic)
Delete
button
DeleteRows(thisRow)
1096
New Internal Item (Basic)
Image URL
image
1097
New Internal Item (Basic)
Image
image
1098
New Internal Item (Basic)
Unit Price
currency
1099
New Internal Item (Basic)
Create & Add Another
button
runactions(
ModifyRows(
thisRow,
Saved,
false,
[Created Order Card],
modifyrows(
Items.filter(Name.IsBlank() and Printed = false)
.MinBy(
[Item Number]
),
Name,
[Enter Item Name],
Person,
Person,File,File,
[Use Case],
[Use Case],
[Secondary Supplier],
[Secondary Supplier],
[Finish Criteria],
[Finish Criteria],
Department,
switchif(
[Order Mechanism] = Production,
[Internal Supplier].Department,
[Order Mechanism] = Task,
Department,
Location.Department
),
[Label Size],
[Label Size],
[URL 2],
[Secondary URL],
[Production Batch],
[Production Batch],
SKU,
SKU,
[Order Description],
[Order Description],
[Avg. Time],
[Est. Days To Complete],
[Sub-Location],
[Sub-Location],
[Min Qty],
switchif(
[Min Qty].IsBlank() and
[Order Mechanism] = Task,
0,
[Min Qty]
),
Priority,
[Production Priority],
[Card Size],
[Order Card Size],
[Item Type],
Type,
[Sub-Type],
[Sub-Type],
[Relative Days to Trigger],
[Trigger Days After Project Start],
Trigger,
Triggered,
[Min. Units],
[Min Units],
[Order Qty],
switchif(
[Order Qty].IsBlank() and
[Order Mechanism] = Task,
1,
[Order Qty]
),
[Order Units],
[Order Units],
Location,
Location,
[Internal Supplier],
[Internal Supplier],
[Primary Supplier],
[Primary Supplier],
[Avg. Time],
[Est. Days To Complete],
[Unit Price],
[Unit Price],
Trigger,
Triggered,
[URL 1],
Link,
Dependents,
Dependents.listcombine(),
[Depends On],
[Depends On].listcombine(),
Notes,
Notes,
[Order Mechanism],
[Order Mechanism],
Products,
Product,
Components,
Component,
[Receiving Inclusion],
switchif(
[Order Mechanism] = Task,
true,
[Unit Price] >= [Receiving Minimum Dollar Format],
true,
false
),
[Image (URL)],
[Image URL],
[Upload Image],
Image,
Printed,
false
)
),
runactions(
switchif(
[Order Mechanism] = Production,
runactions([Draft Internal Item 7]),
[Order Mechanism] = Task,
runactions([Draft Process Item 2]),
runactions([Draft New Order Card 6])
)
),
DeleteRows(thisRow)
)
1100
New Internal Item (Basic)
Production Priority
lookup
Priority
1101
New Internal Item (Basic)
Production Batch
lookup
Production Batch
1102
New Internal Item (Basic)
Secondary Supplier
lookup
External Suppliers
1103
Packing List
Packing List
canvas
1104
PO View
Name
text
_color(Color.[Text Color], Concatenate(Supplier," - #",[PO Number]).ToText())
1105
PO View
PO
canvas
format(
[Order Document Templates].first()
.Template,
Logo
.image(
75, 0, "logo", "auto", false
),
concatenate(
[Company Name],
" - PO# ",
[PO Number]
),
today(),
[Company Name],
Supplier.totext(),
[Primary Contact],
[Primary Contact Phone Number],
[Primary Contact Email].totext(),
switchif(
Supplier.[External Suppliers]
.[Vendor Number & Additional Info]
.IsBlank(),
"",
concatenate(
" - ",
Supplier.[External Suppliers]
.[Vendor Number & Additional Info]
)
),
[Company Address],
"",
Supplier.[External Suppliers]
.[Primary Contact],
Supplier.[External Suppliers]
.[Primary Contact Phone],
Supplier.[External Suppliers]
.[Primary Contact Email]
.totext(),
Supplier.[External Suppliers]
.Address,
concatenate(
Supplier.[External Suppliers]
.CityState,
" ",
Supplier.[External Suppliers]
.[Zip Code]
),
[Good Through],
Supplier.[External Suppliers]
.[Vendor Number & Additional Info],
[Payment Terms].totext(),
[Shipping Terms].ToText()
)
1106
PO View
Print PO
button
openrow(thisRow,[PO View],"Right")
1107
PO View
Upload PO
attachments
1108
PO View
PO Download Link
link
1109
PO View
Step 4: Create Email
button
switchif(
[Email Draft].isblank(),
runactions(
openrow(
AddRow(
[Email Queue],
Supplier,
Supplier,
[Order Documents],
thisRow,
Complete,
"false",
Subject,
concatenate(
Subject, " PO #", [PO Number]
),
Body,
format(
Body,
Supplier.[External Suppliers]
.[Primary Contact]
.split(
" "
)
.first(),
hyperlink([PO Download Link].totext(), "here")
),
Owner,
user(),
Items,
[Line Items],
[Order Quantity],
[Line Items].[To Order]
),
[Email Queue],
"Right"
)
),
openrow([Email Draft], [Email Queue], "Right")
)
1110
PO View
Email Draft
lookup
[Email Queue].Filter([Order Documents].Contains(thisRow))
Email Queue
1111
PO View
Created on
dateTime
thisRow.Created()
1112
PO View
Delete
button
DeleteRows(thisRow)
1113
PO View
Project
lookup
Projects
1114
PO View
Step 3: Create Link
button
ModifyRows(thisRow,[PO Download Link], _Deref_Object(_Merge([Upload PO]), "publicUrl"))
1115
Shipping Terms
Shipping Terms
text
1116
Shipping Terms
Color
lookup
Color Options
1117
Shipping Terms
Color ID
number
Color.[Color ID]
1118
Payment Terms
Payment Terms
text
1119
Payment Terms
Color
lookup
Color Options
1120
Payment Terms
Color ID
number
Color.[Color ID]
1121
Outlook Emails
Name
text
1122
Outlook Emails
Subject
text
1123
Outlook Emails
Sender
text
1124
Outlook Emails
Body
canvas
1125
Outlook Emails
Recipient
text
1126
Outlook Emails
CC Email Addresses
text
1127
Outlook Emails
Created Date
date
1128
Print Format
Select
checkbox
1129
Print Format
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
1130
Print Format
Actions
text
concatenate(
button(
Print,
"",
switchif(Printed, "Blue", "Yellow"),
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-paper", "print")
),
" ",
switchif(
[Order Mechanism] = Task,
"",
button(
[Print Label/Breadcrumb],
"",
"Purple",
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-money", "feed-paper")
)
),
switchif([Order Mechanism] = Task, "", " "),
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
" ",
button(
switchif(
[Order Mechanism] = Task,
[Create Order Record],
[Add to Cart]
),
"",
"Green",
switchif(
[Order Mechanism] = Task,
"",
[Order Qty].IsBlank(),
"+Qty",
[To Order] = 0 or [To Order].IsBlank(),
"",
[To Order]
),
"",
false,
"Small",
switchif(
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Task,
"lightning-bolt",
"add-shopping-cart"
)
)
)
1131
Print Format
Person
person
1132
Print Format
Printed
checkbox
1133
Print Format
Receiving Inclusion
checkbox
1134
Print Format
Card Size
lookup
Formats by Size
1135
Print Format
Label Size
lookup
Formats by Size
1136
Print Format
Order Mechanism
lookup
Order Mechanism
1137
Print Format
Internal Supplier
lookup
Locations
1138
Print Format
Primary Supplier
lookup
External Suppliers
1139
Print Format
URL 1
link
1140
Print Format
Location
lookup
Locations
1141
Print Format
Min Qty
number
1142
Print Format
Min. Units
text
1143
Print Format
Order Qty
number
1144
Print Format
Order Units
text
1145
Print Format
Unit Price
currency
1146
Print Format
Notes
canvas
1147
Print Format
More Actions
text
concatenate(
button(
[Calculate Lead Times],
"",
"Purple",
switchif(
[Calculated Avg. Lead Time].IsBlank(),
"",
[Calculated Avg. Lead Time].split("days").first()
.trim()
.ToNumber()
),
"",
false,
"Small",
"alarm-clock"
),
" ",
button(
Duplicate,
"",
"Pink",
"",
"",
false,
"Small",
"copy"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
)
)
1148
Label View
Select
checkbox
1149
Label View
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
1150
Label View
Actions
text
concatenate(
button(
Print,
"",
switchif(Printed, "Blue", "Yellow"),
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-paper", "print")
),
" ",
switchif(
[Order Mechanism] = Task,
"",
button(
[Print Label/Breadcrumb],
"",
"Purple",
SWITCHIF(
[Number of Selected Items] = 0 or Select = false,
"",
[Number of Selected Items]
),
"",
false,
"Small",
switchif(Select, "stack-of-money", "feed-paper")
)
),
switchif([Order Mechanism] = Task, "", " "),
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
" ",
button(
switchif(
[Order Mechanism] = Task,
[Create Order Record],
[Add to Cart]
),
"",
"Green",
switchif(
[Order Mechanism] = Task,
"",
[Order Qty].IsBlank(),
"+Qty",
[To Order] = 0 or [To Order].IsBlank(),
"",
[To Order]
),
"",
false,
"Small",
switchif(
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Task,
"lightning-bolt",
"add-shopping-cart"
)
)
)
1151
Label View
Person
person
1152
Label View
Printed
checkbox
1153
Label View
Receiving Inclusion
checkbox
1154
Label View
Card Size
lookup
Formats by Size
1155
Label View
Label Size
lookup
Formats by Size
1156
Label View
Order Mechanism
lookup
Order Mechanism
1157
Label View
Internal Supplier
lookup
Locations
1158
Label View
Primary Supplier
lookup
External Suppliers
1159
Label View
URL 1
link
1160
Label View
Location
lookup
Locations
1161
Label View
Min Qty
number
1162
Label View
Min. Units
text
1163
Label View
Order Qty
number
1164
Label View
Order Units
text
1165
Label View
Unit Price
currency
1166
Label View
Notes
canvas
1167
Label View
More Actions
text
concatenate(
button(
[Calculate Lead Times],
"",
"Purple",
switchif(
[Calculated Avg. Lead Time].IsBlank(),
"",
[Calculated Avg. Lead Time].split("days").first()
.trim()
.ToNumber()
),
"",
false,
"Small",
"alarm-clock"
),
" ",
button(
Duplicate,
"",
"Pink",
"",
"",
false,
"Small",
"copy"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
)
)
1168
Project Tasks
Name
text
_color(
Color.[Text Color],
switchif(
Item.[Order Mechanism] = Task,
Concatenate(
switchif(Project.IsNotBlank(), Concatenate(Project, " - ")),
Item
)
.totext(),
concatenate(
Item, " - ", [Created Date].datetimeTruncate("day")
)
.totext()
.withname(
name, name.left(name.Length() - 5)
)
)
)
1169
Project Tasks
Target Completion Date
date
switchif(
Item = [Target Completion Date],
Project.[Target Completion Date],
[Actual Start].IsBlank(),
[Target Start],
[Actual Start]
) +
switchif([Target Duration].IsBlank(), 0, [Target Duration])
1170
Project Tasks
Project
lookup
Projects.Filter([Items & Tasks].Contains(thisRow))
Projects
1171
Project Tasks
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
1172
Project Tasks
Status
lookup
Order Status
1173
Project Tasks
Department
lookup
switchif([Order Mechanism]=Task,Item.Department.ListCombine(), Location.Department.ListCombine())
Departments
1174
Shopping Cart 2
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
1175
Shopping Cart 2
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
1176
Shopping Cart 2
Receiving Inclusion
checkbox
1177
Shopping Cart 2
Taxable
checkbox
1178
Shopping Cart 2
Trigger
lookup
Trigger
1179
Shopping Cart 2
Projects
lookup
Projects.Filter(Items.Contains(thisRow))
Projects
1180
Shopping Cart 2
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
1181
Shopping Cart 2
Order Units
text
1182
Shopping Cart 2
Order Description
text
1183
Shopping Cart 2
Unit Price
currency
1184
Shopping Cart 2
Order Price
currency
[Unit Price]*[To Order]
1185
Shopping Cart 2
Supplier
lookup
switchif(
[Order Mechanism].IsBlank() or
Name = "Target Completion Date" or
Name = "Project Start" or
and(
[Order Mechanism].contains(Task, Production).not(),
[Secondary Supplier].IsBlank(),
[Primary Supplier].IsBlank()
),
"",
[Order Mechanism] = Task and Department.IsBlank(),
"",
[Order Mechanism] = Task,
[Master Suppliers]
.filter(
Department = Department and
CurrentValue.Name.IsNotBlank()
),
[Order Mechanism] = Production,
[Master Suppliers]
.filter(
Locations = [Internal Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Use Secondary Supplier] and
[Secondary Supplier].IsNotBlank(),
[Master Suppliers]
.filter(
[External Suppliers] =
[Secondary Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Master Suppliers]
.filter(
[External Suppliers] = [Primary Supplier] and
CurrentValue.Name.IsNotBlank()
)
)
Master Suppliers
1186
View of Order Line Item Archive
Name
text
_color(
Color.[Text Color],
switchif(
Item.[Order Mechanism] = Task,
Concatenate(
switchif(Project.IsNotBlank(), Concatenate(Project, " - ")),
Item
)
.totext(),
concatenate(
Item, " - ", [Created Date].datetimeTruncate("day")
)
.totext()
.withname(
name, name.left(name.Length() - 5)
)
)
)
1187
View of Order Line Item Archive
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
1188
View of Order Line Item Archive
Status
lookup
Order Status
1189
View 2 of Items
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
1190
View 2 of Items
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
1191
View 2 of Items
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
1192
View 2 of Items
Receiving Inclusion
checkbox
1193
View 2 of Items
Taxable
checkbox
1194
View 2 of Items
Supplier
lookup
switchif(
[Order Mechanism].IsBlank() or
Name = "Target Completion Date" or
Name = "Project Start" or
and(
[Order Mechanism].contains(Task, Production).not(),
[Secondary Supplier].IsBlank(),
[Primary Supplier].IsBlank()
),
"",
[Order Mechanism] = Task and Department.IsBlank(),
"",
[Order Mechanism] = Task,
[Master Suppliers]
.filter(
Department = Department and
CurrentValue.Name.IsNotBlank()
),
[Order Mechanism] = Production,
[Master Suppliers]
.filter(
Locations = [Internal Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Use Secondary Supplier] and
[Secondary Supplier].IsNotBlank(),
[Master Suppliers]
.filter(
[External Suppliers] =
[Secondary Supplier] and
CurrentValue.Name.IsNotBlank()
),
[Master Suppliers]
.filter(
[External Suppliers] = [Primary Supplier] and
CurrentValue.Name.IsNotBlank()
)
)
Master Suppliers
1195
View 2 of Items
Unit Price
currency
1196
View 2 of Items
Total Price
currency
[Unit Price]*[Order Qty]
1197
View 2 of Items
Order Description
text
1198
View 2 of Items
Trigger
lookup
Trigger
1199
View 3 of Items
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
1200
View 3 of Items
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
1201
View 3 of Items
Priority
lookup
Priority
1202
Task Modal
Name
text
_color(
Color.[Text Color],
switchif(
Item.[Order Mechanism] = Task,
Concatenate(
switchif(Project.IsNotBlank(), Concatenate(Project, " - ")),
Item
)
.totext(),
concatenate(
Item, " - ", [Created Date].datetimeTruncate("day")
)
.totext()
.withname(
name, name.left(name.Length() - 5)
)
)
)
1203
Task Modal
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
1204
Task Modal
Status
lookup
Order Status
1205
Production Dashboard 2
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
1206
Production Dashboard 2
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
1207
Production Dashboard 2
Internal Supplier
lookup
Locations
1208
Production Dashboard 2
Projects
lookup
Projects.Filter(Items.Contains(thisRow))
Projects
1209
Production Dashboard 2
Cart Actions
text
Concatenate(
button(
switchif(
[Order Mechanism] = Task or [Order Mechanism] = [3rd Party],
[Create Order Record],
Action
),
"",
switchif(
Flag.IsNotBlank(),
"Red",
[Order Mechanism] = Production and Priority != [In Process],
"Purple",
[Order Mechanism] = Online and [In Cart] = false,
"Pink",
[Order Mechanism] = Online and [In Cart],
"Green",
"Blue"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"finish-flag",
[Order Mechanism] = Production,
"gears",
[Order Mechanism] = Email,
"filled-sent",
[Order Mechanism] = PO,
"document",
[Order Mechanism] = Shopping,
"shop",
[Order Mechanism] = Online and [In Cart] = false,
"external-link-squared",
[Order Mechanism] = Online and [In Cart] = true,
"create-new"
)
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
[Remove From Cart],
"",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"Yellow",
"Red"
),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production and Priority = [In Process],
"deployment",
[Order Mechanism] = Production,
"cancel",
"clear-shopping-cart"
)
),
" ",
button(
[Create/Open SOP],
"",
"Blue",
"",
"",
false,
"Small",
"assignment-turned-in"
),
switchif(
[Order Mechanism] = Online and [In Cart],
concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
),
switchif(
[Order Mechanism].contains(PO, Email),
Concatenate(
" ",
button(
[Create Order Record],
"",
"Green",
"",
"",
false,
"Small",
"create-new"
)
),
""
),
switchif(
Surplus.IsNotBlank(),
concatenate(
" ",
button(
[Use Surplus],
"",
"Green",
"",
"",
false,
"Small",
"ingredients"
),
" "
),
""
),
switchif(
[Secondary Supplier].IsBlank() and
[Internal Supplier].IsBlank(),
"",
Concatenate(
" ",
button(
switchif(
[Order Mechanism] = Production,
[Workstation Dashboard],
[Switch Suppliers]
),
"",
switchif([Order Mechanism] = Production, "Green", "Purple"),
"",
"",
false,
"Small",
switchif(
[Order Mechanism] = Production, "dashboard", "swap"
)
)
)
)
)
1210
Production Dashboard 2
Priority
lookup
Priority
1211
Task Management
Name
text
_color(
Color.[Text Color],
switchif(
Item.[Order Mechanism] = Task,
Concatenate(
switchif(Project.IsNotBlank(), Concatenate(Project, " - ")),
Item
)
.totext(),
concatenate(
Item, " - ", [Created Date].datetimeTruncate("day")
)
.totext()
.withname(
name, name.left(name.Length() - 5)
)
)
)
1212
Task Management
Target Completion Date
date
switchif(
Item = [Target Completion Date],
Project.[Target Completion Date],
[Actual Start].IsBlank(),
[Target Start],
[Actual Start]
) +
switchif([Target Duration].IsBlank(), 0, [Target Duration])
1213
Task Management
Project
lookup
Projects.Filter([Items & Tasks].Contains(thisRow))
Projects
1214
Task Management
Actions
text
Concatenate(
button(
Advance,
"",
switchif(
Status = Ordered and
Item.[Order Mechanism].contains(Task),
"Blue",
"Green"
),
"",
"",
false,
"Small",
Icon
),
" ",
switchif(
[Order Mechanism].contains(Task, Production) or
Supplier.[External Suppliers]
.[Primary Contact Email]
.IsBlank(),
"",
Concatenate(
button(
[Email Supplier],
"",
"Blue",
"",
"",
false,
"Small",
"filled-sent"
),
" "
)
),
button(
[Record Issue],
"",
"Yellow",
"",
"",
false,
"Small",
"high-priority"
),
" ",
button(
Edit, "", "Orange", "", "", false, "Small", "pencil"
),
" ",
button(
Delete, "", "Red", "", "", false, "Small", "trash"
),
switchif(
Finish = [Link Opened],
Concatenate(
" ",
button(
[Open Link],
"",
"Pink",
"",
"",
false,
"Small",
"external-link-squared"
)
)
)
)
1215
Task Management
Status
lookup
Order Status
1216
Task Management
Person
person
1217
Task Management
Department
lookup
switchif([Order Mechanism]=Task,Item.Department.ListCombine(), Location.Department.ListCombine())
Departments
1218
Task Management
Supplier
lookup
Master Suppliers
There are no rows in this table
Doc tables
Tables
Name
Type
Browser link
Page location
Is pack table
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.