Pasting data with row expansion not works!

[siriwat]

Today, we could not copy-and-paste the external data (like excel, csv, google sheet ...) with multiple rows to Airtable's table properly.

When we paste many records and need to expand the rows, nothing happens. Then what I could observed into the browser console log is shown below, yes, it has an error from the Airtable.

Please solve this bug, Airtable team, this problem stops our works!!

*** The work around for this moment is, we must create empty rows enough before pasting data, then we could survive during the wait for Airtable team to solve this.

[Jennifer_Smith]

I have exactly the same issue! Nothing happens when I click the expand table option.

[siriwat · Accepted solution]

One work around is to create number of rows enough before pasting data. Then it would be fine for this moment.

Or

If you could run a script,either extension or automation, you may need to run this script to make empty rows as you may need

let tableName = "Your table name";
let numRow = 20;

let table = base.getTable(tableName);
let newData = new Array(numRow).fill({fields : {}});
await table.createRecordsAsync(newData);

Update: As of 10 OCT, approx 5 days. Airtable fixed this problem already. We need to refresh the browser then continue our works as usual.

[Dora]

Siriwat

That's nice, it works. Thank you so much. You save me. 

Airtable, please fix the bug ASAP.

[clkahl]

I have been having the same issue as OP and your comment saved me from copying and pasting each cell individually. Thank you!

[MillerB]

I'm having the same issue!!!!! 

[17Black]

This is a solid solution. Is there a way to create multiple rows rather than adding one at a time?

[Andrew_Goddard1]

Good to know I am not the only one who has suddenly faced this problem today. Tried refreshing, closing down Airtable and reopening, creating a new table, checked I hadn't reached a record limit of some sort as initially thought it was just refusing to paste. Then realised the problem was the failure to create new rows and creating them manually - a pain as can only see how to do one at a time - allowed me to paste in the data. Very odd that this should suddenly become a problem out of nowhere. Hopefully Airtable can resolve soon and get it back to normal.

[Dora]

Hello 

What I am doing is duplicating the old table with the record and you just "clear" the cell content instead of deleting the row. With this, you will get a table with multiple empty rows. 

[siriwat]

You could run this script (maybe with extension or automation) to create many rows as needs

let tableName = "Your table name";
let numRow = 20;

let table = base.getTable(tableName);
let newData = new Array(numRow).fill({fields : {}});
await table.createRecordsAsync(newData);