The data problem Event and transform Worth knowing
Full name in one field, CRM wants first and last Text, Split Text Choose which segment to return. Names with a middle name or two surnames split in odd places.
Order number buried in an email subject Text, Extract Pattern (regex) Test against several real subjects, not just the one sample Zapier pulled.
Shouty capitals or stray HTML from a form Text, case conversion, Remove extra text, or HTML to plain text Run cleanup before you split or extract, or the pattern won't match.
"1,250.00" stored as text, or a phone number in five formats Numbers, Format Number or Format Phone Number Set the input's decimal mark. European amounts use a comma.
Tax, discount or a total across two fields Numbers, Perform Math Operation or spreadsheet-style formula A formula reaches further than one math operation per step.
Date in the wrong format or time zone Date / Time, Format Set both the From and To formats. Leaving the input format to guesswork is how 03/04 becomes April.
Due date 30 days after the invoice date Date / Time, Add/Subtract Time Use Compare Dates if the next step needs to know which date is later.
"Gold" in one app has to become plan ID 7 in another Utilities, Lookup Table The table lives inside the Zap. If the codes change, someone edits every Zap that copies it.
An order with several products Utilities, Create Line Items or Line Items to Text The next app has to accept line items, or you'll get only the first product.