I have an automation set to send an email (via gmail) when a record is created (when a purchase is completed - this is one of the tables). This pulls from a number of fields across different tables, via look ups. All the fields populate fine in the p...