HI cvoith,

You can use templates to create new records in a linked table by "Configuring tasks (sub-records) to be created"

Already aware of this. This pops up for the field in green but since there's no "Link to new record" on the field in red that doesn't work. 

I am having the same issue...interested if anyone has a solution.

Hi leisterbrau,

Can you describe the issue you are having? When I look at the description left by cvoith above, I am unclear on the issue they are having. cvoith describes not seeing a ""Link to new record" for the field highlighted in red. Yet when I check the image I see the field in red showing this option, labelled as "Link a new asset". 

In a table called invoice categories, I have a field "project line items" that links to another table called "invoice line items".

I have tried to create a template for invoice categories that creates several new invoice line items.  Within the template, it gives me the option to link an existing invoice line item.  But the plus button to create a new invoice line item is grayed out.    Within this template, it only has a button to add a line item, which only seems to allow linking to an existing line item.  In other templates, there are 2 buttons, one for linking to an existing item and another to link to a new item. 

That is odd. I have not been able to reproduce this behaviour. Did you check the permissions on the linked record field? Even then, you should see a warning that you don't have sufficient permissions rather than, not seeing the new record button. 

I can only suggest contacting Airtable support. There may be some restrictions I am not aware if here.

​@cvoith did you ever get to the bottom of this? I am running into the exact same issue - Have checked all imaginable permissions and nothing resolves. I’ve tested a bunch of different tables in my base and it seems to be an issue in some of the tables that have more linked relationships, could be a coincidence - but curious if you found out that there are perhaps some limitations that aren’t published?

1 year later, I am still working on this….if anyone has any ideas...sent another request into airtable support

After 12 days of back and forth with airtable support, I think that I have uncovered the issue with this.  Per airtable support, “record creation isn’t supported when a record template spans more than three related tables.   The 3 table relationship limit spans all templates.”    

Assume we have linked tables: A, B, C, D

Scenario 1: New records not supported for templates on table D

• template 1: A→ B→ C
• template 2: C→ D

Scenario 2: New records supported for templates on table D

• template 1: A (1 table) 
• template: 2:  B→ C→ D (only 1 template which spans 3 tables)

When I restructured my record templates this way, I was able to get this to work.  In scenario 2, they suggested using an automation to trigger template 2 when a template 1 record is created.  Also, they acknowledged the issue and said this in their development queue.