Skip to main content
Solved

Add item to grouped view

  • November 4, 2021
  • 2 replies
  • 89 views

I am revisiting this topic from 2017 (see bottom for reference post)
I have two tables linked: Tasks, and Subtasks. Tasks also has a column called Area (single select).

When I group my data to the linked table Name Field (first column) I can add new entries via the “+”.

However, if I group by the linked table “Area” column, the “+” is not visible for adding new items.

Similarly, if I then add another grouping below Areas, called Tasks, I cannot see the “+” for adding new entries.

Does anyone know how I can group by the last two images, and retain the ability to quickly add entries?

Reference post of similar topic from 2017
Add data to “grouped” view - Ask the community - Airtable Community Forum

Best answer by Kamille_Parks11

This is because {Area (from Task} is a Lookup-type field. When you group a view by a calculated field (which includes lookups, rollups, formulas, etc.) the “add new record” button is removed from the bottom of each group. This is because normally adding a new record directly to a group will fill in whatever field(s) the group is grouped by, but since Lookup fields cannot be edited this functionality cannot be replicated.

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

This is because {Area (from Task} is a Lookup-type field. When you group a view by a calculated field (which includes lookups, rollups, formulas, etc.) the “add new record” button is removed from the bottom of each group. This is because normally adding a new record directly to a group will fill in whatever field(s) the group is grouped by, but since Lookup fields cannot be edited this functionality cannot be replicated.


  • Author
  • New Participant
  • November 5, 2021

Thank you, that makes sense now that you explain it.

If there are any suggestions for how to group in this way please let me know. I tried to add a new function column to the active table (not the lookup table), with this formula “={area (from Task)}” but it yielded the same results.

Thank you, this forum is fantastic