Last year, I created a google form to track farm expenses, based on a form I saw on the Beginning Farmers project website of Cornell University. Since then, The farmers with whom I work are using two other google forms to record daily harvest totals and daily farm work activity. It’s nice that the information is captured, on the spot with minimal effort, greatly improving our productivity. Using a simple script, it becomes possible to email each form entry to multiple email accounts, thereby giving everyone whose connected to the project an instant update. Everyone can also view work done by others on their phones through Sheets. Here’s a great youtube video for setting this email delivery all up:
Expense Report
- Contracted Labor
- Machine Expense (tiller, chipper, sod cutter)
- Auto Expenses
- Fuel (for truck and equipment)
- Compost and Soil Amendments
- Seed/Plants
- Pest Control (Soaps, D. Earth, Traps)
- Produce sales supplies (Rubber Bands, Bags)
- Irrigation Supplies
- Infrastructure, Hardware and Tools
- Marketing and Publicity
- Water Bills
- Conferences and Training
- Special Events
- Mileage Reimbursement
- Phone Bill
Never submit passwords through Google Forms.–
|