Question

How to change null value to blank?


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?


2 replies

Userlevel 2

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

Userlevel 3

How about using table caliculations?​​

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

 

Reply