Travis_Groom1 - profile

Travis_Groom1 · Jun 17, 2024

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...

Travis_Groom1 · Jun 03, 2024

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...

Travis_Groom1 · Jul 19, 2021

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...

Travis_Groom1 · Jul 15, 2020

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,...

Travis_Groom1 · Jun 15, 2020

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...

Travis_Groom1 · Jun 17, 2024

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.

Travis_Groom1 · Jun 05, 2024

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...

Travis_Groom1 · Jun 05, 2024

The Single Select could be an option actually - just the single select is going to be REALLY long. Good idea though!

Travis_Groom1 · Jul 20, 2021

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.

Travis_Groom1 · Jul 16, 2020

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!

User Statistics

User Activity

Lookup in Forms Based on Data other than Primary Field

Lookup or Formula Field in a Form

Nesting Multiple IF statements in a formula

Lookup between two sheets

Linking a record based on view

Re: Lookup in Forms Based on Data other than Primary Field

Re: Lookup or Formula Field in a Form

Re: Lookup or Formula Field in a Form

Re: Nesting Multiple IF statements in a formula

Re: Lookup between two sheets