I’m trying to create a workflow rule to change data in table A based on an add/update in table B
I have set up:
An action to update Life Map (table A) Activity column (datetime type) with the current date and time (NOW()) whenever a reflection is added/updated in the Reflections Table (Table B)
An action to get the list of Life Map records to update (from Table A) based on the Domain ID of the current row in the reflections table (Table B)
A workflow rule so that changes (add/updates) in Table B trigger the workflow.
I’m a little confused by how to use the built in test suite for this. But I’ve tried to test it by adding and updating records in Table B, but the date time stamp doesn’t appear in Table A when I do.
Can anyone provide any helpful pointers?