Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 01, 2023 02:14 PM
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.
Aug 02, 2023 02:01 AM
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.
Aug 02, 2023 03:15 AM
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.
Jun 24, 2024 04:05 AM
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