I have an MYSQL database connected to Zapier.
It’s my order table
Each order has a order_id
I’d like to only search the last 200 lines
For a specific order for order_status that equals the number 20
Then, send an email via my connected GMAIL to a colleague
Is that possible?
Hello! Yes - It should be possible - Are you running into any particular problems here?
Only possible in zapier if there is one such row. If there are more, then the query will not retrieve all the information.
@IcarusZaps! If you were able to find the query that you needed for this, we’d love to hear about it 🙂