Hi David, Yes the principle is simple, you use if statements to “flatten” out the data, so let’s say we want to put revenue into month columns but our input is by date. We would create function (calculated) columns 1-12 for each month, and put the fo...

Alex I’ll share a sample with you, what’s your email. Pierce

One solution is to create a number of calculated fields in your raw data table. Step 1. The first is a simple concatenation of month and year. So MonthYear={month}&"-"&{year} Step 2. Then you have to set up if statements in columns IF(MonthYear=“jun-...

Hi BenLnDallas, You’ll want to use the Airtable API and pull down a JSON object which you can then use to build your table. From there formatting should be straightforward, it sounds like you’re comfortable with HTML/CSS. DM me if you’d like to discu...

Hi Kevin, Airtable is fantastic software and has amazing capabilities. That said, what you’re looking for is out of the sweet spot for Airtable. The application you suggest would require an individual to log in and interact with a custom set of data....