Mapping vs derived lookups
Workspace admin3 min readUpdated 14 Aug 2026
In this article
Recognise an existing value, or fill in a new one.
01 · Why
Why you'd use this
A mapping lookup recognises what the document said and points at a record you already have. A derived lookup fills in a value the document never carried, worked out from the fields around it. Reaching for the wrong one produces confidently wrong data rather than an obvious failure.