Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello!  I am hoping for some insight from those more experienced that I am.  I’ve spent a couple days in the Help resources, but have tried everything advised and have no solution.  This Zap was set up by our previous marketing company, which we no longer have.  I’ve been thrown in as the default problem solver. :)

Our trigger is the user inputting info requests into our website through a platform called iHomeFinder. The result is that info populating a Google Sheet.  This was working well until a couple months ago, when we started getting errors.  I may give more information than is needed, but as a rookie, I am not sure what information is most helpful.

We are a real estate brokerage.  If someone is searching on our website for a house and find one that interests them, they have an option to either:

  1. “Click to schedule a showing”
  2. “Click to contact the agent for more information about this listing”
  3. “Click to save the listing to a favorites list”

All three of these route through iHomeFinder. The first two are tied to a specific listing that has a Listing ID attached to it.  The third option allows them to input their into and create a general list of all houses they mark as favorites. That option is Not tied to a specific property with a specific Listing ID.  

The Google sheet set up in included in the screenshot attached (this is an exact copy of the set-up, but with test info, as there is too much personal client on the actual). 

A couple months ago we starting getting errors when someone attempted to execute the third option (the one Not tied to a Listing ID) above.  Prior to that, the info would populate the Google sheet and the Listing ID field would just be empty. Suddenly we started to get the error: “Required field "Lookup value" (lookup_value) is missing”. 

I recently set up another Zap that is nearly identical to this one, just routing the input of client info managed by another platform, into an identical Google sheet. I noticed that none of the fields set up as “required”.  I went back and looked at our problem child Zap and see that some of the fields are set as “required”, including the Listing ID.  This made me wonder if the error was caused there.  I’ve been unable to figure out how to make it not required.  I attempted to add a formatting step to make a default entry in the Listing ID field on Google sheets, if there was empty on iHomeFinder.  Either I did it incorrectly, or it didn’t fix the problem.  

Screenshots attached that may be helpful, with personal info marked out.  If there is anything else I can provide, please let me know. 

Thank You!

Hi ​@Dechri 

For us to have more info about the error, post screenshots showing how your Zap step 2 is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

Thanks for the prompt reply.  I snipped screen shots and hope the are readable!

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.

​@Dechri 

First, make sure to remove the “Extra Fields” at the bottom of Zap step 2.

 

The Zap Run error in Step 2 is because there is no Lookup Value present, which is a required field.

You have the Lookup Value using a mapped variable: Listing Number

But the DATA OUT from Zap step 1 in the Zap Run has no Listing Number data point, thus the error.

To prevent the Zap Run error, you can add a Filter step to check the Listing Number data point is returned from Zap step 1.

Filter: https://zapier.com/apps/filter/help

 

 

 

I reviewed the Filter tutorials and am still stuck.  Everything you said above makes sense.  I am unsure how to structure the Filter step to work out the following:

If the User inputs a Listing ID in step one, then data out becomes the Listing Number in my Google sheet (this current works appropriately).

and

If the User does not input a Listing ID in step one (if it is left blank), then I would like the Listing Number field in Google sheet in step 2 to be left blank instead of getting the error.

Can this be done with a Default step, make that Listing Number field default to a blank field, or even just a filler word like “none”, if it is left blank in step 1?  Or a way to make it not a required field?

​@Dechri 

Options:

Hey there ​@Dechri, just checking in—were you able to get this sorted? 

Let us know if you still need any help setting up the filters or paths to handle cases where information has and hasn’t been supplied. Happy to lend a hand! 🙂

Reply


Terms & Conditions