Skip to main content
Question

Add Child record when clicking save if any record fields are edits

  • January 22, 2021
  • 0 replies
  • 13 views
Hi!

Looking to add a child record (in a historical table) whenever anything on the parent record is edited (and saved) as a way of reporting on historical changes over time. 
*Using log edits doesn't get us there and this can't be specific to a form rule because we would want to utilize this with grid edits as well as single record edits.

Is this something anyone has perfected?

Thank You!
Chris

------------------------------
Chris
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • January 22, 2021
You'll have to setup a series of Automations or Pipelines in order to do something like this. Some users create individual Automations for each field they need to track, but you can also setup a single Automation, with multiple Create Record steps - one for each field. I tend to take the 2nd option and then have another process run that purges out any records where the Old Value and the New Value field are the same.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement