Jan 30, 2023 08:13 AM
Hello all. I'm a total newbie so forgive me for my simple question.
I'm building my TMS for my hotshot trucking business, when I created "expenses" field I can't figure out how to formulate or date or maybe some other way im not aware of, weekly, monthly, quarterly and yearly expenses so my end of quarter and YTD calculations are correct.
Can someone please give me some guidance?
Much appreciated!
Jan 30, 2023 12:55 PM
Best way to find your expenses within any given time frame is by creating table Views or Interfaces.
If you would like some help with this, feel free to schedule some time with me. Here's my Calendly link: https://calendly.com/d/zx6-f64-dkr/30-minute-meeting
Jan 30, 2023 11:25 PM
Hm, could you provide some screenshots of your table now as well as examples of how you'd like the data in the screenshots to eventually be displayed please?
Jan 31, 2023 08:07 PM
Hey Jeannine,
What you'll need to do is create another table, label it Reports, then use a linked record field from your Expenses to your Reports table. This will allow you to summarize every expense record from your Expenses table.
Here's a tutorial on how to create Summary Reports in Airtable.
https://on2air.com/resources/airtablesummaryreport/
Feb 07, 2023 09:09 AM
This looks great but my issue is i dont want to manually input "recurring expenses" and i want it to calculate my expenses by when they are due....weekly, monthly, quarterly ect ect.
This way i have a true calulation of my expenses each quarter.
Feb 09, 2023 09:33 PM
Hi Jeannine, you can do this with an automation. Use a formula field to display the month, quarter or year value of that record, and use the automation to copy that value into a linked field to the appropriate table.
Here is a template that you can use