Hello! I have been trying to create an automation that changes the status of an item based off of what keywords the text column contains.
For example, I would have Zapier send the TEXT column a string of words from Quickbooks → if this string contains the words “Screen Printing”, then it would change the status of my job to “Screen Printing”. If it contains BOTH of the words “Screen Printing” & “Embroidery” - then it would change the status of that item to “Combo”. So on and so forth.
Has anyone ran across a similar function? It doesn’t seem like this is possible but it would be extremely helpful to me.