Does anyone have a tried and true formula to identify an Item's Type? The native type field doesn't exactly say if an 'Inventory Item' is a 'Serialized Inventory Item'. I'm looking for identification similar to how the CSV Import tool identifies item type.

field: is serialized? yes/no

Right, I'm wanting to build a formula that will check all the other fields so I can get the type from a single field. Unless someone else already has one

At the surface level it sounds like a nested CASE custom formula field

(case

when {isserialitem} = 'T'

then 'Serialized '

when {islotitem} = 'T'

then 'Lot Numbered '

else null end)

|| {type} ||

(case

when {subtype} is not null

then ' ' || {subtype}

else null end)