Can you add to a different table on form save?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a table that keeps up with our equipment, I want to have another table that logs the changes with the equipment. Essentially just a basic changelog, so when a form is save with a check in date, the changelog table will have a new record with certain fields from the equipment table along with a formula which would state what was changed.

I'm not sure how to do this, can I get some help?

Photo of Christopher

Christopher

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
What I suggest is to have a Parent Child Relationship.

The Parent will be Equipment and the child will be Equipment updates.  You will make all updates and even the initial entries in the update table.  So that will give you a complete log of all changes.

Then to get the fields from the most recent update to the Parent Equipment table, you will make a reverse lookup.

Do a summary field on that relationship to get the Maximum Record ID#.   Name the field to be called [Record ID# of the most recent update]

 Then make a "reverse relationship" where One Equipment Update has Many Equipments and on the right side of the relationship, just use that summary field which you just created.  Then after the relationship is built and saved initially pull "down" as many fields as you like fomr the most recent update to the Equipment.

If you have a lot of equipment record nows, you can do a one time table to table copy and map the field for [Record ID3] of the Equipment into the field [Related Equipment].  You would then end up deleting the fields on the Parent Equipment table which used to be the data entry fields as that info will now all come form the most recent update record.