Email template trigger cannot retrieve parent record's before and after value

[kennysz]

Hi All,

I have a bot that listens for updates in a Products table. When an update is made to the product, then the email template is sent to the user. 

<<IF: ([_THISROW_BEFORE].[ProductNumber] <> [_THISROW_AFTER].[ProductNumber])>>
Product Number Before: <<[_THISROW_BEFORE].[ProductNumber]>> 
Product Number Updated: <<[_THISROW_AFTER].[ProductNumber]>>
<<EndIf>>
<<IF: ([_THISROW_BEFORE].[ProductNumber] = [_THISROW_AFTER].[ProductNumber])>>
Product Number: <<[ProductNumber]>>
<<EndIf>>
<<IF: ([_THISROW_BEFORE].[Quantity] <> [_THISROW_AFTER].[Quantity])>>
Quantity Before: <<[_THISROW_BEFORE].[Quantity]>>
Quantity Updated: <<[_THISROW_AFTER].[Quantity]>>
<<EndIf>>
<<IF: ([_THISROW_BEFORE].[Quantity] = [_THISROW_AFTER].[Quantity])>>
Quantity: <<[Quantity]>>
<<EndIf>>
Order Date Before: <<[_THISROW_BEFORE].[OrderDate]>>
Order Ship Date Updated: <<[_THISROW_AFTER].[OrderDate]>>
<<IF: ([_THISROW_BEFORE].[OrderDate] = [_THISROW_AFTER].[OrderDate])>>
Order Ship Date: <<[OrderDate]>>
<<EndIf>> 

Basically it will print the before and updated values if it's changed, otherwise it will just print the value. The product number and quantity expressions evaluate as expected but the OrderDate does not. . OrderDate is a virtual column on the Products table referencing the Order table.

The OrderDate is changed in the Order Detail and nested in the detail is the product detail where the product name and quantity are changed. I see in the AppSheet documentation that parent records don't have access to child record updates and vice versa.

How can I retrieve the OrderDate's before and after values from the parent record to the child record? I saw some posts like these that require a few actions/events to update parent records based on child record updates. Is that required here to properly retrieve the OrderDate from the Orders parent record to the Products child record? Any help is greatly appreciated.