Allow Linking Automatically To All Records

Summary

When selecting “Link to another record” as a field type, Airtable should allow automatic linking to all records.

UI Change
The current slider that allows linking to single or multiple records, should be changed to a selection menu of the following:

  • Link to single records only
  • Link to multiple records
  • Link to all records automatically

Rationale
This new option would allow scenarios where another field computes its value from the values of another table, easily.

For example, a column that computes the percentage of a value of this record against the total of all records would be simple, as the moving or current sum is automatically computed on the column based on all the records without having to re-link all of them.

One way around this is to group by the link field (in the table containing the records that are all supposed to link to a single record in another table). The group requires that link to be there in order for a record to be part of that group. Because of this requirement, adding a new record to that group automatically adds the link.

Could I have an example of this please?

Welcome to the community, @Mattias_Martens! :smiley: Here’s a simple example. I’ve got two tables: [Main] and [Link]. In the [Link] table, the primary field has a period (.) as the name for the first record.

Screen Shot 2020-07-28 at 11.52.08 AM

Screen Shot 2020-07-28 at 11.52.27 AM

Back in the [Main] table, I’ll add a link field that points to the [Link] table, and link my three records in [Main] to that single record in [Link].

Screen Shot 2020-07-28 at 11.52.50 AM

I’ll group the records in [Main] by that {Link} field.

Screen Shot 2020-07-28 at 11.53.04 AM

Screen Shot 2020-07-28 at 11.53.11 AM

Now I’ll click the bar at the bottom of the group to add a new record. Because that link is required for the record to be in that group, Airtable will make the link for me before I even start typing into the other fields.

Screen Shot 2020-07-28 at 11.53.26 AM

Thanks @Justin_Barrett for the explanation and the quick response! I understand now.