Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Best way to keep edited by records? Can you display information from another base?

Topic Labels: Base design Data
1174 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Anxious
7 - App Architect
7 - App Architect

I have a database that allows users to fill out a form to add information to it. They can also update information via a form as well. While "Created by" is one field, the "Edited by" may have several users and times. Is there a way to store this information in a different base and display it in another?

I am limited on the number of rows I can have.

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
3 Replies 3
Shaynaza
4 - Data Explorer
4 - Data Explorer

Hello,

To track "Edited by" information separately from the main form submissions in a database, create two tables: one for initial form submissions with the "Created by" field and another for updates with "Edited by" and timestamp. Establish a relationship between the tables using a unique identifier. Use queries or joins to display the "Edited by" information alongside the original form submissions. This approach ensures data consistency, reduces redundancy, and provides a structured way to manage user edits in the database.

I figured as much. I can't do that though as I can't add any more rows to my base. That's why I was wondering if I could add information from one base to another.

Airtable Account: Free Plan
Records: 1,200/1,200 1000/1000 (I might have to find a different solution soon)
Automation Runs: ??/100
Extensions: 1/1 (TinyPNG Compression Script, looking for free alternatives)
benrich
4 - Data Explorer
4 - Data Explorer

Instead of storing multiple "Edited by" entries directly in the main table, create a separate table named "Edits" or "Change History". Each time a user edits an entry, insert a new record into this table with fields such as Editor Name, Timestamp, and a reference to the main entry. Utilize Airtable's linked record feature to associate each edit record in the "Edits" table with the corresponding entry in your main table. This approach allows you to maintain a clear history of edits without duplicating information in the main entries. To display this information, create a view in Airtable that shows the latest edit details alongside each main entry, using filtering and grouping options as needed.   Safeway Survey