About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • How Do I
  • How do I pull an ECWID text box into a spreadsheet and only if other fields in the order are true?
Question

How do I pull an ECWID text box into a spreadsheet and only if other fields in the order are true?

TheAlchemist

Hi, so I have some very detaiiled products on my store and they involve several options and some text fields. I am interested in being able to display ONLY the contents of a particular text box and only if two other options are selected with specific values on a Google Sheet, (or alternatively send by email to one or more addresses even),

So the example is that the product has a Text Box called “Notes” and the contents are “Test”, the “Time” option is set up as a size and would have the N/A size selected and the “Place” option is also set up as a size and would have the N/A size selected. There are other options selected, but I only wish to put the text box contents on the sheet if the Time AND Place options have “N/A” values selected and only when the status is “delivered”..

I have tried creating a Zap with delivered trigger and keywords “Notes” and I have set up 3 columns on the spreadsheet and I haven’t even managed to get the Notes on the sheet yet, let alone filter in the N/A only Time and Place options.

HELP!

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

Charie
Userlevel 3
Badge +4

Hi @TheAlchemist 

Thanks for reaching out to the Community!

To ensure we’re on the same page, could you kindly send screenshots of how you’ve configured the Zap so far? That’ll help me make sure I give you the best suggestion possible.

(If there’s any personal information, kindly blur them.)

Also, with the information you provided above, you need to use Filter by Zapier. You may check this link to learn more about how to use the Filter: https://zapier.com/help/create/customize/add-conditions-to-zaps-with-filters

Looking forward to your response!

TheAlchemist

Hello Charlie,

I think I’ve cracked it. I find it difficult to grasp some of the concepts and the tutorials are for people who already get the basics. Quite frustrating. Thanks. If I still can’t get exactly what I want done, I’ll post again.

ken.a
Userlevel 7
Badge +6

Hey there @TheAlchemist,

Glad to hear that you were able to sort things out. If you come across any further hurdles, please don't hesitate to reach out to the Community. We're always here to help.

Have a great day! 😊

Terms & Conditions