About this project: IT-Programming / Web-Development
Need to configure Airtable according to the following specifications:
1. Main Tables: These tables structure the application, connected to maintain clear relationships between all data.
1. Projects: Fields include:
1. Name of the project (text)
2. Project code (autonumeric)
3. Client (link to 'clients')
4. Technical work phone and email
5. Billing address (link to 'billing addresses')
6. Start date (date)
7. Estimated end date (date) – according to contract (execution days)
8. Extension date
9. Status (selectable: active, pending, completed)
10. Material costs (€) (formula: sum of 'project cost' in 'materials by project')
11. Labor costs (€) (formula: sum of costs in 'work hours')
12. General costs (€) (formula: applied according to project type)
13. Total cost (€) (formula: materials + labor + general)
14. Estimated profit (€) (formula: invoicing - total costs)
2. Clients: Fields include:
1. Name of the client (text)
2. CIF/NIF
3. Phone (phone)
4. Email (email)
5. Associated projects (link to 'projects')
6. Billing addresses (link to 'billing addresses')
7. Notes (long text)
3. Billing Addresses: Fields include:
1. Related client (link to 'clients')
2. Address (long text)
3. City (text)
4. Postal code (text)
4. Client Invoices: Fields include:
1. Invoice number (autonumeric)
2. Related project (link to 'projects')
3. Issue date (date)
4. Payment date (date)
5. Total amount (€) (number)
6. Status (selectable: issued, collected, pending)
7. Attachment (file)
5. Budgets: Fields include:
1. Budget number (autonumeric)
2. Related project (link to 'projects')
3. Description (long text)
4. Total amount (€) (formula: sum of costs in 'materials by project' and 'labor')
5. Status (selectable: pending, accepted, rejected)
6. Attachment (file)
6. Materials by Project: Fields include:
1. Related project (link to 'projects')
2. Material (text)
3. Supplier (link to 'suppliers')
4. Quantity (number)
5. Unit of measure (selectable: units, kg, m, etc.)
6. Cost per unit (€) (number)
7. Total cost (€) (formula: quantity x cost per unit)
7. Supplier Invoices: Fields include:
1. Internal number (autonumeric)
2. Supplier (link to 'suppliers')
3. Issue date (date)
4. Due date (date)
5. Status (selectable: pending, paid)
6. Total amount (€) (number)
7. Related projects (link to 'projects')
8. Costs applied by project (formula: calculated by link to 'materials by project')
9. Attachment (file)
8. Suppliers: Fields include:
1. Name of the supplier (text)
2. CIF/NIF
3. Address
4. Payment method
5. Phone (phone)
6. Email (email)
7. Associated invoices (link to 'supplier invoices')
8. Notes (long text)
9. Workers: Fields include:
1. Name of the worker (text)
2. Position (selectable: operator, supervisor, etc.)
3. Cost per hour (€) (number)
4. Monthly salary (€) (number)
5. Delivered PPE (long text)
6. Related projects (link to 'projects')
10. Work Hours: Fields include:
1. Related project (link to 'projects')
2. Worker (link to 'workers')
3. Date (date)
4. Hours worked (number)
5. Cost per hour (€) (lookup from 'workers')
6. Total cost (€) (formula: hours worked x cost per hour)
11. Cash Flows: Fields include:
1. Date (date)
2. Entries (€) (formula: sum of collected client invoices on that date)
3. Exits (€) (formula: sum of paid supplier invoices on that date)
4. Balance (€) (formula: entries - exits)
5. 90-day projection (formula: accumulated balance + forecast of collections and payments)
1. Specific Functionalities:
1. Cost calculation by project.
2. Control of supplier invoices.
3. Management of budgets and orders.
4. Cash flows visualization.
5. Taxes management.
2. Integrations and Extensions:
1. Page designer.
2. Automations.
3. Zapier or Make.
4. Graphs and summaries.
5. Listing invoices.
Project Overview: This is for a small workshop, and with this app we want to manage it.
Category: IT & Programming
Subcategory: Web Development
What is the scope of the project? Medium-sized change
Is this a project or a position? Project
Currently have: Specifications required
Availability: As needed
Roles needed: Developer, Other
Other roles needed: Person who has used Airtable at a deep level
Delivery term: January
Skills needed: JavaScript, MySQL, PHP
Original announcement can be found on Kit Empleo
#J-18808-Ljbffr