I work as a freelancer and want to create billing information from meeting notes and Design progress notes I create in Obsidian.
The structure is as following
- 23-09-01 Project Meeting
- 23-09-08 Project Meeting
- 23-09-15 Project Meeting
- 23-09-02 Project Design
- 23-09-09 Project Design
- 23-09-16 Project Design
Each note has Properties
start(date), end(date), billed(check), tags(“meeting” or “design”)
in “Billing” i have created some tables
## Not Billed ### Meetings ```dataview TABLE end - start AS duration FROM "project/Meetings" WHERE billed = false ``` ### Design ```dataview TABLE end - start AS duration FROM "project/Design" WHERE billed = false ```
First thing i want to achieve is adding a total hours row at the bottom of each table
Then I’m planning to have property fields in the billing note like “hourly rate meetings” and “hourly rate design” and calculate prices from that.
The final goal would be to have a second note that resembles a bill to the customer, that i can export as a pdf file and to be able to check all the billed items with one click.
I have tried to modify some of the tips here, but i think handling type “duration” is a bit different.