Project Overview: This project involves configuring Airtable according to the specified requirements.
Main Tables:
1. Projects - Fields:
* Project Name (text)
* Project Code (autonumeric)
* Client (link to "clients")
* Technician Contact (phone and email)
* Billing Address (link to "billing addresses")
* Start Date (date)
* Estimated End Date (date)
* Execution Days (based on contract)
* Extension Date
* Status (selectable: active, pending, completed)
* Material Cost (€) (formula: sum of "project cost" in "materials by project")
* Labor Cost (€) (formula: sum of costs in "hours worked")
* General Costs (€) (formula: applied based on project type)
* Total Cost (€) (formula: materials + labor + general)
* Estimated Profit (€) (formula: invoicing - total costs)
1. Clients - Fields:
* Client Name (text)
* CIF/NIF
* Phone (phone)
* Email (email)
* Associated Projects (link to "projects")
* Billing Addresses (link to "billing addresses")
* Notes (long text)
2. Billing Addresses - Fields:
* Related Client (link to "clients")
* Address (long text)
* City (text)
* Postal Code (text)
3. Client Invoices - Fields:
* Invoice Number (autonumeric)
* Related Project (link to "projects")
* Issue Date (date)
* Payment Date (date)
* Total Amount (€) (number)
* Status (selectable: issued, paid, pending)
* Attachment (file)
4. Budgets - Fields:
* Budget Number (autonumeric)
* Related Project (link to "projects")
* Description (long text)
* Total Amount (€) (formula: sum of costs in "materials by project" and "labor")
* Status (selectable: pending, accepted, rejected)
* Attachment (file)
5. Materials by Project - Fields:
* Related Project (link to "projects")
* Material (text)
* Supplier (link to "suppliers")
* Quantity (number)
* Unit of Measure (selectable: units, kg, m, etc.)
* Cost per Unit (€) (number)
* Total Cost (€) (formula: quantity x cost per unit)
6. Supplier Invoices - Fields:
* Internal Number (autonumeric)
* Supplier (link to "suppliers")
* Issue Date (date)
* Due Date (date)
* Status (selectable: pending, paid)
* Total Amount (€) (number)
* Related Projects (link to "projects")
* Costs Applied by Project (formula: calculated by link to "materials by project")
* Attachment (file)
7. Suppliers - Fields:
* Supplier Name (text)
* CIF/NIF
* Address
* Payment Method
* Phone (phone)
* Email (email)
* Associated Invoices (link to "supplier invoices")
* Notes (long text)
8. Workers - Fields:
* Worker Name (text)
* Position (selectable: operator, supervisor, etc.)
El anuncio original lo puedes encontrar en Kit Empleo:
https://www.kitempleo.es/empleo/138887455/configuracion-airtable-similar-segun-las-freelance-job-web-development-mg-698-madrid/?utm_source=html
#J-18808-Ljbffr