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]))