Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Need help setting up tables for a document revision tracker

64 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I am trying to set up a document revision tracker in Airtable and I am wondering the best way to go about it. The data I need to include in my tracker are Document Number, Document Name, Revision, and Date of Revision.

Currently, I am working with one document table which has the fields for Document Name, Number, and then I have columns for Rev1, Date1, Rev2, Date2, Rev3, Date3, etc. Each time a document in the row is changed, I've been updating the next available Rev and Date. However, I know there must be a more innovative way to achieve this in Airtable.

I also want to view this data in Bubble.io in some form and be able to view all past revisions.

Can anyone help me with this?

Attached is a crude google sheets version of how I used to track revision. This is the basis of what I'm after

Thank you in advance for your help.

1 Reply 1

Here's how I would approach it:
• Make a table for Documents
• Make a simple table of Revisions (Original, 1, 2, 3, 4, etc.)
• Make a table for Document Revisions
Using linked records and lookup tables, there's a record for each document as a whole, and records for each revision:
Screen Shot 2023-01-13 at 3.48.16 PM.pngScreen Shot 2023-01-13 at 3.50.36 PM.png