On fields where there’s no mapped values or if the mapped value is empty, I am getting “null” in my cell instead of blank. Even when using ifEmpty(), I am still getting “null”. How can I just get no value or blank in my cell when the mapped value is empty?
Do I really have to do how it was mentioned in this post or am I using ifEmpty() incorrectly?
looks like the value of
is not empty (maybe it is NULL).
Try to use a green “=” compare operator and compare with green “NULL” from Helper widget
it is empty. The workflow i have is simple, fill up an Airtable form and pass it to Google Sheet. The Use Case (Others) field will appear in the Airtable form is they chose ‘Other’ in one of the questions.
Also, even if for example that field in Latenode is set to empty (nothing is mapped), it will still put ‘null’ in my Google Sheet. I find it counter intuitive if there are a lot of steps to do. I initially just mapped without the ifEmpty() but I’m getting the same result.
Send your email, workflow url to latenode support team on [email protected] - they will take a closer look
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
