Allow to return an empty value from a formula

[evyatar_gefen]

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 applying to it Collection.Filter(true = false).Sort(Some Field).First() which returns the first entity in an empty list (which is an empty value), but this is rather awkward.

[Matt_Blais]

Related:

@Matt_Blais

For that matter it would be useful to have a Null constant in Formulas, so we can actually set something to null/empty.

[Claude_de_Loupy]

And related to that :

If condition: how to return nothing when the returned type is an entity?

Hi, I am missing something? (I searched in this forum but found nothing) The if function needs 3 arguments. So you cannot use: if(test, do this) You must write: if(test, do this, do that) If I want to do nothing, it’s easy when dealing with text: just return “” → `if(test, “test ok”, “”)´ But if the result of a test is an entity (say a Contact), what can I return? What is the equivalent of “” for an entity? if(test, a_given_contact, ????) Thanks

I think this is a prety important feature I come by quite often and must use workarounds.