Joanna_Parker - profile

Joanna_Parker · Jan 10, 2023

So, I have some columns in one of my bases that are complex formulas working something out based on year. These particular formulas are necessary as there is no quick workaround via rollups etc., it's not pretty - and there is something better involv...

Joanna_Parker · Dec 06, 2022

Question as in the title I've been doing a lot of work fixing structural errors, and the Manage Fields has been super helpful. However, I did notice it didn't update in real time.Not an urgent issue, just out of curiosity: does anyone know when it r...

Joanna_Parker · Nov 22, 2022

Hi everyone, Hitting a bit of a wall with some formulas and wondering if anyone has a more elegant solution to this… I’m working on a new base that records start and end dates of some work that we do. I then have a datetimediff that calculates the nu...

Joanna_Parker · Oct 06, 2022

Hi guys, I’m having a slight issue with a synced table. It has added 6 blank records that don’t exist on the source table and that weren’t there after the destination table was created/before the sync. There’s definitely nothing to delete (first thou...

Joanna_Parker · Jul 28, 2022

Hi All, I use the API to pull our data into Excel for automated reporting, and it does the job quite nicely :slightly_smiling_face: However, I’ve added a new column to collect a bit more information, but that column doesn’t seem to be available to ...

Joanna_Parker · Jan 17, 2023

Woohoo, it worked! Had to find all of the "" that I had done.. but is doing the job now. Thanks so much 

Joanna_Parker · Jan 12, 2023

So weird! Are you able to paste your modified formula please?I think I may just have to chalk this up to a random error... motivation to get the other solution up and running pronto!

Joanna_Parker · Jan 10, 2023

The formula columns are using the formula I mentioned in this post here: Solved: Conditional DATETIMEDIFF - Airtable CommunityIn terms of formatting, they all show this:The available columns to select show all of the previous four years except the mo...

Joanna_Parker · Dec 06, 2022

Just adding our use case and +1. We have bases split by project/department, with syncs set up where they interact, so the team only access the bases/data they need. But our comms team regularly use data points from all departments. An interface that ...

Joanna_Parker · Nov 23, 2022

Think I may have found a solution to this that addresses the issue. Leaving some working here in case it comes in handy for anybody else. The best solution seems to be having a column per year. The below formula is based on the thinking that every pr...

User Statistics

User Activity

Interface Number Element - Field Summary Not Available

Does anyone know the frequency that Manage Fields refreshes?

Conditional DATETIMEDIFF

Blank Records in Synced Table

Power Query Missing Columns

Re: Interface Number Element - Field Summary Not Available

Re: Interface Number Element - Field Summary Not Available

Re: Interface Number Element - Field Summary Not Available

Re: Request: Allow Interface Designer to pick Data from Multiple Bases

Re: Conditional DATETIMEDIFF