Data change trigger

[vinson_Mirdif_S]

I have a Parent Table (Table A) and Child Table (Table B),

Child Table is the reference table with '[ID]' as a key column.

Now I want to automatically copy '[date]' from 'Table A' to 'Table B' (for every related entries) when I change '[date]' in 'Table A'

Someone please help me.

[Rafael_ANEIC-PY]

Hello @vinson_Mirdif_S , there are a couple of ways to do this:

1- Create a virtual column in your 'Table B' with a dereference to pull the date from 'Table A' with this expression:

[Table REF].[date]

2- Go with the bot+actions solution:

2.1- Create an action that changes the date value on a row of table B, that action should be to change [date] to [Table REF].[date]

2.2 - Create an action that executes an action on a set of rows, the action to execute is the one created on step 2.1, and the rows to execute are [Related Table B Rows]

2.3 - Create a bot that looks for updates in table A using this expression:

[_THISROW_BEFORE].[date]<>[_THISROW_AFTER].[date]

2.4- Make the bot run the action we made in step 2.2

That's about it.

[vinson_Mirdif_S]

Hi,

This is my actual table & Column names

Parent Table Name - Main Order Sheet

Child Table Name - Order Detail Sheet

Parent Table Name - Main Order Sheet – date column name [Date of training]

Child Table Name - Order Detail Sheet – date column name [Order Date]

I am little confused upon creating Action, Can you please help me in this ?