Trigger an email after data change in another table

[SKETCHwade]

Hello,

I have a Jobs table that contains basic job details.

Then a cylinders table. this table will usually have one entry and reference the jobs table.

When I want a quote to be produced I used the following condition:

AND([Quote Required?]=TRUE,ISNOTBLANK([Related Cylinders][Employee Scope]))

The idea here is that the job is marked as though a quote is required.

When a cylinder entry has been completed it should email me the quote details.

This condition is not triggered. I assume because the related cylinders is updated after it does a check to see if an event should be triggered. It works fine If I create a new change after this but I want it triggered right when the necessary information has been uploaded.

How else can this be achieved?

[Suvrutt_Gurjar]

The below is not tested, so may or may not work

You could trigger the BOT with a  condition

[Jobs Table Reference column in Cylinders Table].[Quote Required?]

and on Add  of record to the Cylinders table.

You could try to get the desired  parent record fields by the expressions like

[Jobs Table Reference column in Cylinders].[Parent table field 1]
and so on.