How to change null value to blank?

[LawrenceK]

When downloading looks to csv format via webhook, all null fields have the literal word “null”. We need this to be blank. How can we change that?

[leobardor]

Hi Lawrence!

Did you try using any SQL function to catch this null value and print an empty char instead? https://www.w3schools.com/sql/sql_isnull.asp

For instance:

Best,

Leo

[masutaka]

How about using table caliculations?​​

if(is_null(${the_field}), "", ${the_field})