Hello, I am noticing that empty field values returned from an Airtable search are presented to the CSV generator as null. Fields with values display fine.
How can I process all those values so my CSV is not generated with any null value?
A configuration of the Airtable module, some sort of utility module in between Airtable and CSV? Search results treated like a multidimensional array? Or at the CSV module itself?
It is not quite clear to me which point of the workflow will resolve (let alone most simply), even after doing a search of the knowledgebase and asking the NLP chatbot with several different prompts.
Thanks for any information! I appreciate the speed of Make scenario automation but I sometimes have issues visualizing the workflow if abstracted data structures and transformers are inobvious 
I have added the Tools - Set Multiple Variables and tried
{{if(1.Email = “null”; emptystring; 1.Email)}}
Hrmmm, I see “null” appears as a string over auto-populating the reserved name. I’m out of my tier operations for the next few days, but I will try again with the properly populated null value.
Edit: Nope, that didn’t work. Nor did if( {{1.Email}} = {{null}} ; {} ; {{1.Email}} ) or {{ifempty(1.Email + "; " + emptystring)}}
I did see after disabling confidential data in debugging that from Airtable, 1.Email is missing from a bundle.
At the tool level I get
Email if( = ; {} ; )
So there’s probably an easy substitution logic I’m missing somewhere to note the non-existence of the Airtable 1.Email field when composing the CSV file.
Edit edit: Could I possibly use a formula in the airtable module to populate any missing fields per bundle instead of dropping them entirely?
Any possible tips on how to get where I’d like to be?
Can you provide a screenshot of the input module where you’re seeing the issue with missing values? It’s a little hard to visualise your issue, but with some examples it’ll help me to better understand what’s happening