How do I...?

Timestamped record changes

Can I set up Trackvia to record changes in records (timestamp) and run reports to compare current data with the same data at different periods.

e.g. Property was empty last week, now occupied. Want to run a report as at last week and as at today. The report would show data held in trackvia at an historic point in time.

Occupancy Field might show NO at Dec 2016, YES at Jan 2016

2 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Charisse commented  ·   ·  Flag as inappropriate

    I am looking to track the timestamp of checkboxes. These checkboxes are currently used to move a request to the next department, and I would like to calculate both workdays and non-workdays for each department.

  • Witte commented  ·   ·  Flag as inappropriate

    Hello,

    It would be possible to create a separate table that could be used for historical data. You could then use custom app scripts to record those changes as new timestamped records on your new table. If you would like advice specific to your account, please feel free to call our Support Team at 800-673-3302 at your convenience to discuss this further!

    Regards,

    Witte

Feedback and Knowledge Base