Sometimes, when using a formula field that returns a single entity, the user might want to return an empty value (meaning no entity). For example, if (X is true return entity Y, else return nothing) There is a workaround for this, which is taking a collection of entities of the type returned and a…

Allow to return an empty value from a formula

Matt_Blais June 20, 2022, 5:24pm 2

Related:

4 Likes

Return "no-entity" from a formula

End an automation partway through with script

Topic		Replies	Views
Formula 'Generate using AI' keeps on using 'null' Bugs & Issues automations , formulas , ai	1	37	August 1, 2025
Return "no-entity" from a formula Get Help	7	398	March 23, 2023
If condition: how to return nothing when the returned type is an entity? Get Help formulas	4	469	January 27, 2022
Can a number formula return nothing instead of zero? Get Help	1	98	June 6, 2024
How to check entity is NOT empty (in formula)? Get Help	4	423	January 22, 2022