Automated Email with a List of Certain Product in a Certain Country

[Giora_Giora]

I have a table with a list of Products, with various details about the them.

I have a linked table with the products' prices.
The reasoning behind the decision to separate the two is that the prices change from time to time, and for different sales channels, the prices vary.

I'd like to set an automated email that is fired when a new product price record is created.

The email should include a grid table that shows:

1. The records of the current and previous prices of the relevant product.
2. I'd like to pull not only all the prices of the same product, but to also include some conditions.
   For example: all the filtered records should be the prices in the same country (e.g. Germany, or the United States).

Please recommend the best practice to configure this requirement.

[TheTimeSavingCo]

Check out Airtable's guide on how to send out an email digest; should cover everything you need for this: https://support.airtable.com/docs/how-to-create-email-digests-with-automations

How you trigger the automation is going to depend on how the data's keyed in.  If it's done via a form, you can use the "When form submitted" trigger.  If you're creating it manually, field by field within the "Prices" table, then I'd suggest a checkbox to trigger the automation

The automation would:
1. Find all the records in the "Prices" table that are linked to the triggering record's Product, as well as any other filtered conditions you want, e.g. by country
2. Send out the email