idea New function: IfNull() in Suggest an Idea

New function: IfNull()

vegard_bakke — Wed, 25 Nov 2020 15:38:50 GMT

I'd love to have an IF-null function, that basically replaces NULL values.

And the clunky:
If ( IsNull(<big long expression>), 'default', <big long expression> )
could be replaced with:
IfNull( <big long expression>, 'default')

Just like: https://www.w3schools.com/sql/func_mysql_ifnull.asp

Re: New function: IfNull()

andoryuu — Tue, 10 Dec 2019 19:48:11 GMT

This would make code cleaner and easier to read.

Re: New function: IfNull()

Thomas_Spitzer — Fri, 27 Dec 2019 15:44:07 GMT

Even better would be a function like Alt() with unlimited parameters, that works not only on numbers but also on strings (something like AltNull()).

Re: New function: IfNull()

Or — Mon, 23 Mar 2020 11:36:24 GMT

This could be implemented quite easily by expanding the Alt() function to accept non-numeric inputs, too. We don't even need a new function.

Re: New function: IfNull() - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 21 Apr 2020 09:24:59 GMT

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

Re: New function: IfNull() - Status changed to: Closed - Already Available

Patric_Nordstrom — Wed, 18 Nov 2020 18:44:15 GMT

The Coalesce() function does that, returns the first non-null value in a list. Can be used like this:

Coalesce( big long expression, default)

Coalesce is not documented but will be in a near future.

Thanks,
Patric