Hi I'm a Plus plan subscriber so starting to explore AT more in depth. I have a built a base with a JOBS table that lists jobs by job number, and using various currency, numerical and formula fields, delivers a profit per hour figure for each job. It...
I've abandoned this after realising I can have fields filter for last 7 days / 30 days / 90 days / 365 days. This enough granularity for me. Thanks though.
So for example, in this screen in Xero, I can select a date range and it will bring up all items in that date range. I can do this for the previous x amount of days by having fields in the staff members table that roll up fields from the time logging...
Thanks for your response Adam, I got some advice yesterday which solved this for me, and the base is exactly as you have laid out, so that is reassuring. I'm stuck with how to dynamically filter for date periods though. How would you do this?
