I need please a automation with the following logic:
I have the table 1 with the name: “table_data” and a table 2 with the name “table_email”.

I need please the following logic.

Step 1:
If in table “table_data” all existing entries with same “email” and same “finish_date” has the “status” = “Fotografiert” we must do a entrie in table “table_email”.
In table “table_email” we write the following fields from table “table_data”:

• salutation (in table_email = email_salutation)
• firstname (in table_email = email_firstname)
• lastname (in table_email = email_lastname)
• order_id (in table_email = email_order_id)
• finish_date (in table_email = email_finish_date)
• number_records (in table_email = email_number_records)
• email (in table_email = email_email)

Step 2:
Each 2 minutes we proof if we have a entry in table “table_email” without value in field “email_send_date”. In this case we send a email (lets say the one with template name = “email_done”) to the email address from from field “email_email”.

Thanks very much.