Archiving Paste Equipment Data
Hi all, I'm thinking of archiving all past equipment and just wondering if anybody have any better suggestions as to what i'm thinking. 1. Creating a duplicate App, then setting up automation to...
Forum Discussion
Hi Samuel,
To your question on archiving data effecting things like total operation hours, # of times used, etc. There are a few techniques that can help with that. With your summary field you can also do an archived value field and when you archive data you can adjust that manual entry archive value field to match the total operation hours you archived. Then you can make a formula field to add your current summarized values and the manually entered total value of archived data to get the overall total of live data and archived data if you still need to report off of it. Someone would just need to update those numbers anytime you archive out more records. That or you would want to make sure you pass on that the summarized values only reflect records that are live and not those that are archived.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
To your question on archiving data effecting things like total operation hours, # of times used, etc. There are a few techniques that can help with that. With your summary field you can also do an archived value field and when you archive data you can adjust that manual entry archive value field to match the total operation hours you archived. Then you can make a formula field to add your current summarized values and the manually entered total value of archived data to get the overall total of live data and archived data if you still need to report off of it. Someone would just need to update those numbers anytime you archive out more records. That or you would want to make sure you pass on that the summarized values only reflect records that are live and not those that are archived.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------