Hello! I’m working on a series of budget interfaces for my team members in a university office, and I want them to be able to edit certain fields of their personal budget “dashboards” (not the Airtable Dashboard interface style, just the word they’re using) without editing all of the details...which would open us up to folks potentially messing up other important info by mistake.
Currently we have the dashboards viewable as grids, because they give us the option to have Sums at the bottom of each column, showing folks what their running balance is for each budget category. However, the only way I can seem to get the “edit this column” option is by using a List view, instead of a Grid, which doesn’t calculate the sum automatically. Is there a workaround for this folks have seen? Essentially, I want them to be able to edit some-not-all of the records’ fields, and I want an automatically calculated sum at the bottom of the grid/list/etc. Ideas? (The two images below illustrate what we’ve done in the past and my current test, neither of which are exactly what I’m looking for)
Image 1: Current dashboard example, as a grid view, with the sum calculated at the bottom. None of the fields are currently editable.
Image 2: New dashboard example (for now), with the “Date” and “Notes” fields editable. Date doesn’t appear at the bottom anymore, because it’s a List instead of a Grid.
♂️