Bulk Create (Formula) Fields


#1

I’m building a time tracking and project reporting base, and I often find myself needing to use conditional rollups to create meaningful reports. This means I need to create a ton of IF formula fields on one table to rollup on another table.

It would save substantial amount of time if Airtable had a bulk formula field creation feature. This could be an option in the field dropdown menu:

58%20AM

Selecting this option would allow users to upload a .csv file containing each forumla:

IF({Person} = "Anne",   {Hours}, 0);
IF({Person} = "Clyde",  {Hours}, 0);
IF({Person} = "Daisy",  {Hours}, 0);
IF({Person} = "Elle",   {Hours}, 0);
IF({Person} = "Gordon", {Hours}, 0);
IF({Person} = "Hilda",  {Hours}, 0);
IF({Person} = "Ken",    {Hours}, 0);
IF({Person} = "Julia",  {Hours}, 0);
...

And a formula field would be created for each value.

This would save countless hours and make Airtable even easier to use.