Forum Discussion

CeceliaMartin's avatar
CeceliaMartin
Qrew Cadet
6 years ago

Field to populate data from previous year

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.
  • JasonJohnson2's avatar
    JasonJohnson2
    Qrew Cadet
    6 years ago
    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.