Skip to main content
Question

Field to populate data from previous year

  • August 12, 2019
  • 0 replies
  • 10 views
I have a table where I am trying to track my freight data.  Ideally what I want is to show are two fields that show a data for this year and last year.  I can manually add this but ideally would like the field to autopopulate so that last years data is already showing.

I am currenlty just creating this, so for now this is not an issue.  But looking at the future, I don't want to have to keep adding LY data manually.
      This topic has been closed for replies.

      If you are storing the freight data from last year in a related table you could make LY a summary field in the relationship. You just need to filter the summary like this. I used Date Created for an example.


      If that doesn't work with your setup I would need more details on how the app is setup to give a better answer.
      Terms & ConditionsAccessibility statement