Items
Item Name
text
_color(
Color.[Text Color],
switchif(
Name.IsBlank(), [Unique ID], Name
)
)
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
Items
Database Link
text
[QR Code URL].BarcodeQR("FFFFFF").image(75,75,"QR Code","Auto",false)
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],
""
)
)
Items
Internal Supplier
lookup
Locations
Items
Location
lookup
Locations
Items
Trigger
lookup
Trigger
Items
Order Mechanism
lookup
Order Mechanism
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)
)
)
Items
Receive
button
modifyrows([Order Line Item Archive].filter(Status!=Finished).MinBy(CurrentValue.[Created Date]),Status,Finished)
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")
)
)
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],
""
)
)
Items
To Order
number
([Times Added To Cart]*[Order Qty])+[Project-Specific Cart].[Order Qty].ListCombine().sum()
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"
)
)
Items
Order Description
text
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
)
)
)
Items
Order Timeline
lookup
[Order Line Item Archive].Filter(Item.Contains(thisRow))
Order Line Item Archive
Items
Date Added to Cart
date
Items
Email Queue
lookup
[Email Queue].Filter(Items.Contains(thisRow))
Email Queue
Items
Item
lookup
thisTable.filter(Name=Name and Name.IsNotBlank())
Items
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))
Items
Times Added To Cart
number
Items
Card Size
lookup
Formats by Size
Items
Total Price
currency
[Unit Price]*[Order Qty]
Items
Receiving Inclusion
checkbox
Items
Unit Price
currency
Items
Color ID
number
Color.[Color ID].ListCombine()
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
Items
Item Type
lookup
Item Type
Items
Sub-Type
lookup
Item Sub-Type
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), "")
)
)
Items
Department
lookup
Departments
Items
Unique ID
text
concatenate([Unique Identifier] ,[Item Number])
Items
Row URL
link
ObjectLink(thisRow)
Items
QR Code URL
link
concatenate("https://link.arda.cards/",[Unique Identifier],"/",[Unique ID]).totext()
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
Items
Secondary Supplier
lookup
External Suppliers
Items
Primary Supplier
lookup
External Suppliers
Items
Use Secondary Supplier
checkbox
Items
Switch Suppliers
button
modifyrows(thisRow,[Use Secondary Supplier],switchif([Use Secondary Supplier],false,true ))
Items
Order Groups
lookup
[Order Groups].Filter(Items.Contains(thisRow))
Order Groups
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
)
)
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"
)
)
)
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"
)
)
)
)
)
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) )
Items
Order Price
currency
[Unit Price]*[To Order]
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"
)
Items
Calculated Avg. Lead Time
duration
Items
Order Documents
lookup
[Order Documents].Filter([Line Items].Contains(thisRow))
Order Documents
Items
Components
lookup
Components
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
)
)
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"
)
)
Items
Priority
lookup
Priority
Items
Production Batch
lookup
Production Batch
Items
Print Label/Breadcrumb
button
switchif(Select,[Bulk Print Labels], openrow(thisRow,[Label View],"Right"))
Items
Label Size
lookup
Formats by Size
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."
)
)
)
Items
Sub-Location
lookup
Sub-Locations
Items
Products
lookup
Products
Items
Depends On
lookup
Items
Items
Surplus
lookup
switchif([Min Qty]=0, [Order Line Item Archive].filter(Item=thisRow and Project=""),"")
Order Line Item Archive
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())
Items
Dependents
lookup
Items.Filter([Depends On].Contains(thisRow))
Items
Items
Sequence
number
switchif([Depends On].IsBlank(),1,[Depends On].Sequence.max()+1)
Items
Projects
lookup
Projects.Filter(Items.Contains(thisRow))
Projects
Items
Related SOPs
lookup
SOPs.Filter(Item.Contains(thisRow))
SOPs
Items
Relative Days to Trigger
duration
Items
Finish Criteria
lookup
Finished
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")
)
)
)
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"
)
)
Items
Project-Specific Cart
lookup
[Build-Specific Cart Line Items].Filter(Item.Contains(thisRow))
Build-Specific Cart Line Items
Items
Related Items
lookup
Items
Items
To Order Quantity
text
Concatenate([To Order],switchif([Order Units].IsBlank(),"",Concatenate(" ",[Order Units])))
Items
Workstation Dashboard
button
openrow([Internal Supplier],Locations,"Right")
Items
Cart Duration
duration
max( [Date Added to Cart]-today(),[Project-Specific Cart].[Cart Duration]).todays()
Items
Use Surplus
button
switchif(Surplus.IsNotBlank(), runactions(modifyrows(Surplus.first(),Project,[Project-Specific Cart].first().Project),DeleteRows([Project-Specific Cart].first())),"")
Items
Use Case
lookup
Use Case
Items
Avg. Price
currency
foreach([Order Timeline],CurrentValue.[Total Cost]/CurrentValue.Quantity).ListCombine().average()
Order Line Item Archive
Item
lookup
Items
Order Line Item Archive
Quantity
number
Order Line Item Archive
Notes
text
Order Line Item Archive
Created Date
dateTime
thisRow.created().DateTimeTruncate("hour")
Order Line Item Archive
Supplier
lookup
Master Suppliers
Order Line Item Archive
Lead Time
duration
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)
)
)
)
Order Line Item Archive
Receipt Image
image
Order Line Item Archive
Units
text
Order Line Item Archive
Item Price
currency
Order Line Item Archive
Received/Completion Date
dateTime
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
)
)
Order Line Item Archive
Item Image
image
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"))
Order Line Item Archive
Status
lookup
Order Status
Order Line Item Archive
Shipper
lookup
Shipping Providers
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,
""
)
Order Line Item Archive
Tracking Number
text
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, "")
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, "")
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(),
""
)
)
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"
)
)
Order Line Item Archive
Include in Receiving
checkbox
Order Line Item Archive
Order Quantity
text
Concatenate(Quantity," ",Units)
Order Line Item Archive
Order
lookup
[Order Archive].Filter([Line Items].Contains(thisRow))
Order Archive
Order Line Item Archive
Line Items from Order
lookup
Order Line Item Archive
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]))