I have a zap created that sends data from a Ninja Form to a Google Drive folder and Google Sheet.
There is a “non-required’ file upload field on the Ninja Form. If the user uploads a file to the Ninja Form, the file is sent to a Google Drive folder.
All data from the Ninja Form is sent to the google sheet with the exception of the file upload field. I have that this mapped to the “Alternate Link” from the Google Drive.
If the user uploads a file to the Ninja Form, everything works correctly. However, if they do not upload a file to the Ninja Form, then no data at all is sent to the Google Sheet. I see an error in the zap history…
“Required field "file" (file) is missing.”
“This Google Sheets step didn‘t run because it depended on a previous step or filter that wasn‘t successful.”
How do I get the zap to accept that someone may not upload a file and still send the remaining data onto the Google Sheet?