Skip to main content
Question

Change Logs

  • May 22, 2024
  • 0 replies
  • 253 views
Forum|alt.badge.img+8

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 setting up the pipeline to pull in all fields at the same time regardless if all of them have a change...I attempted to also use the formula given in this training to color code the fields that have changes and it does not work. 

And I also referenced this material https://community.quickbase.com/discussions/quickbase-discussions/creating-data-change-logs-using-pipelines/84044

 

 

This topic has been closed for replies.

Forum|alt.badge.img+20
  • MikeTamoush
  • Registered
  • May 22, 2024

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:

  1. What relationship do you have currently with your main table and log table? 
  2. 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'.

Forum|alt.badge.img+20
  • MikeTamoush
  • Registered
  • May 23, 2024

So is the setup this:

In the change log table you have for example:
[Field A Old], [Field A New], [Field B Old], [Field B New], etc?

and each time there is a change, the old an new are supposed to fill in, but if the old and new are the same value, only the new fills in? Is that the current issue?

Terms & ConditionsAccessibility statement