Help

Need help setting up tables for a document revision tracker

1548 1
cancel
Showing results for 
Search instead for 
Did you mean: 
GeorgeCantCode
4 - Data Explorer
4 - Data Explorer

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
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

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