Hi everyone,
I’m working on a budgeting setup in Airtable and would really appreciate some community insight.
We currently have a well-structured “CostComponents Employees NL” table, where we define specific account-level budgets per employee. These accounts all roll up under OPEX, and more specifically under the top-level group account “610000 – Staff Costs”. Some of these accounts belong to the group accounts:
- 611000 – Direct Staff Costs
- 612000 – Other Personnel Costs
- 613000 – Car Costs
Now here’s the situation:
- Certain accounts are budgeted at the employee level only and should not be editable elsewhere.
- Certain staff related accounts are budgeted at high-over level (not on employee level,
- Other OPEX accounts (not staff-related, Operational Costs) need to be budgeted at account level, under the following group accounts:
- Housing Costs
- Office Costs
- IT Costs
- Marketing and Travel Costs
- General Costs
We are looking to build a unified “Chart of Accounts Budgeting Table”, where:
- All relevant accounts are listed (including grouped totals like 610000, 611000, etc.).
- Staff-related accounts pull their values from the “CostComponents Employees NL” table, and are read-only in this table.
- Staff-related accounts which are not defined in the “CostComponents Employees NL” tabel, can be entered directly in this table (they are editable).
- Operational Cost accounts can be entered directly in this table (they are editable).
- Group accounts (like 610000, 620000 etc.) are automatically calculated sums of the underlying accounts.
- The columns represent months, and for each row and month, we’d like the ability to control which months are editable (e.g. freeze certain months).
⸻
My key questions:
- What’s the best Airtable structure to bring this together? Two tables with synced fields? Linked records with rollups? Interfaces?
- Can we enforce column-level permissions or freezing on specific rows/months? (based on roles perhaps)
- Are there creative interface-level workarounds for making part of a record read-only?
⸻
Any advice or examples are very welcome!
Thanks so much in advance
Have a great day,
Youri