Hello AirTable Community,Here's a fun one that I hope I can pick some brains on. We have a Workday integration that creates an employee directory that feeds quite a few bases. With the Workday integration, we have to use a unique identifier - that b...
Hello AirTable Community!Hoping someone can help me with a solution here. I have a conditional form that depending on the department you choose, you get different prompts - most of this works great. Here's the problem:I have a Lookup field that pro...
Hi everyone,
Trying to write a multiple If statement formula to return in what quarter something took place.
Example:
IF(
AND(
IS_AFTER(
{Training Start Date},
‘2020-03-29’
),
IS_BEFORE(
{Training Start Date},
‘2020-07-04’
)
),
“FY21Q1”
,
This formul...
Hi everyone - maybe this is simple and I am just not getting it, but I could use a little advice.
Table 1 - has name/email address/other data related to user engagement in a learning platform
Table 2 - Workday pull that shows their business unit, ID,...
Hi AirTable Community,
Hoping someone can help me end the madness that is manual verification. Here’s the rundown.
The first tab is a bulk import from Workday. Inside this tab is a view that shows users that are authorized to access a specific progr...
Holy crap Dan - why can't I give you 12,000 Kudos. This is something enterprise support hasn't been able to answer, and even asked someone in person and no solution. Thank you for saving me more nights of frustration and tears.
Actually, I think this is the right callout. It would exist after they picked the form choice - but wouldn't exist prior to that so AirTable likely doesn't allow it since it doesn't technically exist yet.I somewhat solved it using "description" in ea...
Sadly not at super reliable break points. I would have to add each quarter in manually, however if I build it right once, I will likely copy and paste this formula a lot.
However, the nesting correctly seemed to work!
Thanks for the tips.
Kinked records sounds way more fun. I think once I gave up the idea of auto-matching, everything seemed to work fine. Just a bit of manual work for me every time I want to update it.
Thanks for the help folks!
