
Sean_O_Shea

6 - Interface Innovator
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
โFeb 01, 2018
08:14 AM
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:
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.