Skip to main content
Solved

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.

Best answer by siriwat

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.

View original
Did this topic help you find an answer to your question?

24 replies

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

 


siriwat
  • Author
  • Inspiring
  • 18 replies
  • Answer
  • October 6, 2023

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.


  • Participating Frequently
  • 6 replies
  • October 6, 2023

Siriwat

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

Airtable, please fix the bug ASAP.


  • New Participant
  • 1 reply
  • October 6, 2023
siriwat wrote:

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.


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


  • New Participant
  • 1 reply
  • October 6, 2023

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


  • New Participant
  • 1 reply
  • October 6, 2023
siriwat wrote:

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.


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


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.


  • Participating Frequently
  • 6 replies
  • October 7, 2023
17Black wrote:

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


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
  • Author
  • Inspiring
  • 18 replies
  • October 7, 2023
17Black wrote:

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


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);

 

 


  • Participating Frequently
  • 6 replies
  • October 7, 2023
siriwat wrote:

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);

 

 


Hello Siriwat

Would you please say more details about the script?

Where do I need to put the script? How do I use extension or automation? 

if you have a screenshot that would be appreciated. 

 

 


siriwat
  • Author
  • Inspiring
  • 18 replies
  • October 7, 2023
Dora wrote:

Hello Siriwat

Would you please say more details about the script?

Where do I need to put the script? How do I use extension or automation? 

if you have a screenshot that would be appreciated. 

 

 


These steps as following in the picture
1. Add extension
2. Select scripting
3. Paste the code (and modify a bit)
4. Run

However, you will need to modify the code just a bit for your need 

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

...

 

 


siriwat
  • Author
  • Inspiring
  • 18 replies
  • October 7, 2023

Anyone submitted a support ticket to Airtable?

I did, but no response until now, almost 4 days already with multiple seats, Team plan... What's their SLA ahh🥱


  • New Participant
  • 3 replies
  • October 8, 2023

I have the same issue. Please fix airtable.


  • Participating Frequently
  • 6 replies
  • October 8, 2023
siriwat wrote:

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);

 

 


Hello Siriwat

that's cool, I ran a test and it worked, however, when I fixed the row over 50 I got the error message.

Why?

 


  • Participating Frequently
  • 6 replies
  • October 8, 2023
siriwat wrote:

Anyone submitted a support ticket to Airtable?

I did, but no response until now, almost 4 days already with multiple seats, Team plan... What's their SLA ahh🥱


Siriwat,

How to submit a ticket? I only can go to help and ask a virtual assistant and it always leads me to read the article. I can't find any support email address, do you know where i can open a case?

 

 


siriwat
  • Author
  • Inspiring
  • 18 replies
  • October 8, 2023
Dora wrote:

Hello Siriwat

that's cool, I ran a test and it worked, however, when I fixed the row over 50 I got the error message.

Why?

 


Ah, yes, Airtable limitation for adding row, max 50 rows at a time.


siriwat
  • Author
  • Inspiring
  • 18 replies
  • October 8, 2023
Dora wrote:

Siriwat,

How to submit a ticket? I only can go to help and ask a virtual assistant and it always leads me to read the article. I can't find any support email address, do you know where i can open a case?

 

 


Through the chat actually, but in a very deep menu. I may not have a correct instruction for this, but this is  what I message in the chat.

"I have critical problem that block business process." --> Enter
Then you say No to whatever bot suggested you to read for help... Until you found these following menu
"Help with Airtable product" --> Click
"Airtable is not working as expected" --> Click
"Business Critical: Airtable is completely unavailable or a product issue is degrading critical business operations." --> Click
"I still need help" --> Click
"I have the necessary info, open a Support ticket." --> Click

Then you could submit a support ticket.


  • Participating Frequently
  • 6 replies
  • October 8, 2023
siriwat wrote:

Through the chat actually, but in a very deep menu. I may not have a correct instruction for this, but this is  what I message in the chat.

"I have critical problem that block business process." --> Enter
Then you say No to whatever bot suggested you to read for help... Until you found these following menu
"Help with Airtable product" --> Click
"Airtable is not working as expected" --> Click
"Business Critical: Airtable is completely unavailable or a product issue is degrading critical business operations." --> Click
"I still need help" --> Click
"I have the necessary info, open a Support ticket." --> Click

Then you could submit a support ticket.


Siriwat

Thank you, finally I was led to open a ticket and hopefully they can solve it ASAP.

Airtable should pay you as a consultant, you provide a prompt reply and workaround than theirs. 

 


Same problem here!


Same issue here. Will submit a help ticket and refer to this forum. I am able to paste one row at a time, but no more than that. Nervous to run the script--I started to, but I worried I would break my 3500-row table!


  • New Participant
  • 1 reply
  • October 8, 2023

We have the same issue.  We have 2,200 lines to paste in! Airtable, please fix!


  • New Participant
  • 3 replies
  • October 9, 2023

I’ve been using shift + enter and holding enter key on an empty row to mass create rows. It’s not ideal but faster than adding a single row at a time.


ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8711 replies
  • October 9, 2023

Copying and pasting is currently broken in Airtable. I have no idea if or when they are planning on fixing it, so everybody should email support@airtable.com about this major problem.


  • New Participant
  • 3 replies
  • October 9, 2023

The problem has been fixed. Airtable support emailed me to advise they’ve applied the fix and I’ve just tested it with success.  They said to first refresh the browser and if that doesn’t work to clear the cache. Refreshing the browser worked for me.


Reply