Copy multiple fields in a form to the same form for revisions

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
  • (Edited)
I have a set of fields in a form that are used to track permit application submissions and when revisions are required I'd like to be able to track the new revision without overwriting the values in the original fields. Ideally, when the "ULA-Status" field (Text - Multiple Choice) is set to "Revision Required" the entire set of fields would duplicate below the originals and have their values set to blank.

Click this image to see an illustration of my current field set.

Photo of Nathan DeCoste

Nathan DeCoste

  • 90 Points 75 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
And keep the existing record as-is? This sounds like a job for Automations...
Photo of Nathan DeCoste

Nathan DeCoste

  • 90 Points 75 badge 2x thumb
Hi Alex, I'm trying to update the record with additional fields and so the original fields would remain.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
Nathan, what you want is possible, but it begs the question, what happens when the revision is revised?  There is another approach to have a child table to tracks the changes to certain fields.
Photo of Nathan DeCoste

Nathan DeCoste

  • 90 Points 75 badge 2x thumb
Hi Coach,

Yes, I should've stated in my first post that I would like to track multiple revisions, sometimes there can be upwards of 5.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
OK, so i would create a child table called Revision History.  The fields would be [Changed by] (a user field)  and then a field called [Field changed] and then fields for old value and new value.

Then i would set up an ACTION to write into those child table when the record is modified and a certain a certain changes.  i sounds like you just have a few fields to log.

The you an show the embedded table of the audit logs in a Tab on your form.