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 · Aug 24, 2022

Random suggestion: Global Option SetsWe have many different projects running within our nonprofit. We need to keep them separate, as each project has it’s own data needs.However, there are two drop-downs that are used regularly; Country of Origin and...

Joanna_Parker · May 12, 2023

Hi guys, I've got a similar query where I need to find out how many Saturdays are in the current month. Needs to be a formula as it's going to be a rolling thing that is linked to a monthly automation.I've gone over this thread a few times, and I can...

Joanna_Parker · Apr 17, 2023

Also, even on Enterprise - I've found that even with automations running an action regularly to keep the syncs/base active, the numbers are very frequently out of date. I was hoping to set up a monthly digest type email, but am currently doing it man...

Joanna_Parker · Feb 08, 2023

Seconding this ✋I'm trying to use an automation to prefill a long/rich text field with a numbered list and hitting the same wall...

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!

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

Global Option Sets

Re: Finding the Number of Fridays in a Month

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

Re: Long text field ordered list acting strangely when used in email automation

Re: Interface Number Element - Field Summary Not Available

Re: Interface Number Element - Field Summary Not Available