Change Logs
Hello, I'm attempting to create a change log to show the previous and new result changes from 3 tables into a "change log" table. I'm missing something with setting up the relationships I think and...
Forum Discussion
Probably best to just work on one table, and once you have it working repeat the steps for the other tables. Also, get the basic steps working first (Relationship correct, and Pipeline firing and filling in fields) first, and then worry about color coding, etc. For the community to help troubleshoot, I would first explain:
- What relationship do you have currently with your main table and log table?
- What exact issue are you running into with your Pipeline (is it even firing? is it not filling out the fields correctly?)?
The more details the better to receive help, as right now all we know is 'it isnt working'.
I've set up and repeated the pipeline steps for each table, but when I run the pipeline it's not pulling in all of the fields in my change log table; for example it's not showing the current info in the Prev fields if there was no changes in that field, it's only showing the new field info. I would like for it to show the current info along with the new and info and highlight only what is new.
I have 3 tables
People (parent table)
Placement (child table)
Update (child table to placement)
The change log table has a many relationship back to those tables