I have a larger base (for Airtable), about 30,000 rows and want to change one field with about 60 options to single select, to help prevent human error in the future when adding new items to this base. When I attempt to change this field from short line text to single select, it times out and asks me to refresh the page, and the change is not saved after several attempts. I’ve tried to turn off the “color” feature to make it easier to process, and still no luck. Is there a limit to this feature? What am I missing?
Airtable Times out when Trying to Convert a large field to Single Select
Best answer by Bill_French
Yep - this is a challenge because you’re asking Airtable to perform an in-place transformation across 30,000+ items.
In cases like this, you have to rope the cow, flip it on its back, and tie its legs before injecting the medicine. I have no idea why I used this metaphor. I’ve never [ever] roped a cow.
Onward…
Setting aside my roping skills, I have had to do this on a 50,000 record set and it required a script process that used a new field [single-select] that was populated with the values from the original field. Once the transformation process was complete, I renamed the original field (the client wanted to keep that data) and then renamed the new field to take its place.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.