Help

Capturing data to track history

Topic Labels: Automations Base design
323 1
cancel
Showing results for 
Search instead for 
Did you mean: 
brightler
4 - Data Explorer
4 - Data Explorer

We use AT to manage rental properties. Here is a scenario and then what I am looking to accomplish. 

We list each house as a record in a base. We have a filed for when a house goes vacant to track when the rental turn project start and another for when it ends. I don't want to lose historical data the next time this same house goes vacant and needs a turn project. I would like to keep track of each time these change and create a place where we notate the last time before update the new updates. This will allow us to have a history of how long vacancy lasted and over time and with multiple properties we can get a feel for how long they last on the whole portfolio.

Thank you in advance for your help.

1 Reply 1
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @brightler!

Given your description, I'm assuming you are currently entering all of your data in only one table?
I would suggest structuring your data in at least two different tables:
1. Properties
2. Rentals

Now if you link Rentals to Properties (through linked record field), you can keep historic track of all rentals (and vacancies) for each Property.
Your database architecture will fully depend on your needs, but given your description this is my smart guess!

Please feel free to schedule a brief call using this link, and I'd be happy to show you around some best practices.

Mike, Consultant @ Automatic Nation