Skip to main content
Best answer

How to allow Zap to continue if no file is uploaded to Ninja Forms?

  • December 1, 2021
  • 3 replies
  • 249 views

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?

Best answer by Troy Tessalone

Hi @Dietz Group

Alternatively you can try these Zap steps.

  1. Trigger: Ninja Forms - New Form Submission
  2. Action: GSheets - Create Row
  3. Action: Filter (check if file exists)
  4. Action: GDrive - Upload File
  5. Action: GSheets - Update Row (map Row ID # from Step 2)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

robschmidt
Forum|alt.badge.img+9
  • Zapier Solution Partner
  • December 2, 2021

Hi @Dietz Group 

Use this formatter: https://zapier.com/help/create/format/set-default-values-for-blank-fields-in-zaps

What it does essentially is when your file field has no data (user didn’t add a file) you can specify a default value for this, which will pass over when there is no data.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • December 2, 2021

Hi @Dietz Group

Alternatively you can try these Zap steps.

  1. Trigger: Ninja Forms - New Form Submission
  2. Action: GSheets - Create Row
  3. Action: Filter (check if file exists)
  4. Action: GDrive - Upload File
  5. Action: GSheets - Update Row (map Row ID # from Step 2)

  • Author
  • Beginner
  • December 2, 2021

@Troy Tessalone that’s perfect. Thanks for the answer!