- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Iโm trying to use a lookup function to help me avoid running a zap within zapier. But it seems Iโm limited to do a lookup (count sum function) within a specific table, not within a specific view within that table.
Hereโs the dealโฆ
I currently keep track of my customers that have requested quotes from our shirt shop (but donโt have an actual order going yet) in a specific view within my โorderโ table. When they convert their quote into an actual order, we just change the โorder statusโ within that specific record.
In order to help each quote customer remember to reply to us (if they want to move forward or not), we automatically send them a โ1 week reminder messageโ and if they still donโt reply a โ2 week reminder messageโ - These messages are zaps running within zapier. These reminder messages are great and help us convert a lot of customers into actual orders, but sometimes we have an issue where certain customers call, email or physically come into our shop to start their order, versus going through our suggested route of converting their quote into an order. The problem that arises from them starting a new order while also having a quote with us is, even though they now have an active order record with us (displayed in our โall active ordersโ view), they also still have an active quote record with us (displayed in our โall quotesโ view). Because they have two records for the same order, specifically the one in the quote view, we donโt have a way to check for conflicting records automatically and their โ1 weekโ and โ2 weekโ quote reminder messages will still be sent out (which is awkward when they have an active order at the same time).
If I could do a โlookupโ function, and have it be limited to a specific view, I could do a lookup within our โall active ordersโ view and have it count how many records exist, displaying a number. If this field displayed a number greater than 0, I could have our โquoteโ order status records (that also have a number greater than 1 in the look field) show up in their own view. This view would then trigger an integration within zapier to auto-create a todo for our team to manually look into this, verifying if we need to delete the quote record or to see if it is, in fact, a unique quote.
So, does this feature already exist and I just canโt find it?
If not, Iโd love to add it as a feature request. I can think of a dozen uses for this functionality.
Thanks again!