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!
Base design
+1
+13Best 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
+31Hm, 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?
+19Hey 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.
+1Hey 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.
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.
+14This 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.
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
Astrology Calculator on the Airtable Marketplace!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.