Return custom text if query data is empty

[elijah.zhang]

query3 will be empty if there's no data on that day. query4 has this error when it happens: Error evaluating query4: Use File Picker to upload a file and ensure file is uploaded before query is fired.

How do I handle this? Transform papa unparse if data is empty?

[stefancvrkotic]

Hey Elijah,

You can do a branch after query3 and state if the .length>0 send query4 email, else send a different email.

[elijah.zhang]

Thanks for your help!