is it possible to create a quick base action or a automation for the creating the history record

Question

Considering my situation,I have two tables parent and child and there exists a relationship between themthe records in the parent table are&nbsp;Record_id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; school1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; YThe records in the child table are&nbsp;Record_id&nbsp; &nbsp; parent_id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mark 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mark2&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 802&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 893&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 90&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 984&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;91&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 92Right now if I change any value in parent or child table, i need to create a record in the history table, which has all the columns of parent and child with the old valueIf suppose i&nbsp;change the value of mark&nbsp;2 of child record id --&gt; 1 from 80 to 100 in the child tableThe records in the&nbsp;child table&nbsp;are&nbsp;Record_id&nbsp; &nbsp; parent_id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mark 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mark2&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 (changed from 80 to 100)2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 893&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 90&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 984&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;91&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 92I need a new entry in the history table like belowname&nbsp; &nbsp; &nbsp; &nbsp; mark1&nbsp; &nbsp; mark2&nbsp; &nbsp; &nbsp; child_record_id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; parent_id&nbsp; &nbsp; &nbsp; schoolAA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 80&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XCan you please help in this situation....&nbsp;I m new to quickbase&nbsp;,&nbsp;of possible .. can you please explain in brief.ThanksPushpakumar

pushpakumargna1 · Answer

Hi .. can someone help me on this?Thanks

evanmartinez · Answer

Hi Pushpakumar,It is possible to use an automation or action to help you to track field changes and edits. This can be done by setting up an Action to copy over data from your existing table and have it create a new record for each edit in an Audit table. For example if I wanted to audit my projects table for every time a status is changed and I wanted to capture the changed status, the former status, the user who edited it, and when.&nbsp;I would create a Project Status Audit table with a field for Status after edit, Status before edit, user who edited, date of edit, Project Name, and Record ID. Then I would create an Action on the table I wish to audit from and set it to fire whenever a Project is added or modified and the Project Status changes. Then I select the option to Add a record and select my new Audit table. From there I can choose to write over values from one field to another, and make use of the option to write the old value from the Status field to the Status before edit field and then the value after edit to the Status after edit field. This will give me a nice audit record to track my changes. Then I could set it up to capture the Date Modified and Last Modified By fields into my user and date field I created.The key is just to have a place to copy over your data and build the action to fire off the field you are capturing. I hope this information is helpful Pushpakumar.&nbsp;

erichwehrmann · Answer

Quick Base Automations give you the ability to utilize the old/previous value of a changed record. When you have the Values from Other Records menu up, scroll down to the record from trigger (old values) section to grab the old value of "80" to put into your new record.
------------------------------Erich Wehrmann------------------------------

Forum Discussion

is it possible to create a quick base action or a automation for the creating the history record

3 Replies

Related Content

AI Smart Builder for Creating Apps and Streamlining Pipelines

create pipeline to create new records based on current record

Create child records from Parent List - User field

How to create a pipeline to count records in a table

Pipelines automation to change record owner