Troy_Gamble - profile

Troy_Gamble · Jun 01, 2024

Good afternoonStill a newbie to Airtable so I appreciate the help.I have a series of tables that have a "next follow up" column and I'd like to be able to create a table that would show only those with the due date of today. In other words, it would...

Troy_Gamble · May 24, 2024

Working with birthdays where I only know the client's Month/Day and not their Year of birth. So text field is 5/12 for example but I'd like to have an actual date of 5/12 so I can set up reminders 5 days before the actual birthday. I used the follo...

Troy_Gamble · May 14, 2022

Hello! I’m trying to set up an automation where a birthday email goes out on the client’s birthday. I found the solution on changing their DOB to current year (thank you community!) however, I don’t want the emails to go out before 9 AM on the day o...

Troy_Gamble · Mar 08, 2020

Hi there. I’m trying to set up a graph that would only show the transactions that have closed up to the day but within the current month only so MTD. I’d also like to be able to set up a graph that would show Year to Date or YTD for transactions tha...

Troy_Gamble · Sep 18, 2019

Hi there I would like to be able to know how many hours a tasks takes a member on my team so I can be alerted if over 4 hours. The catch is that I want to calculate only business day hours not just straight hours. Example would be if the tasks is s...

Troy_Gamble · Jun 04, 2024

I really appreciate your help. After thinking about it I think I need to restructure my whole base and then use an interface to get me where I need to go. Have a great week!

Troy_Gamble · May 27, 2024

Thanks so much....the time zone was the issue. I really appreciate you taking the time to help me. Cheers

Troy_Gamble · May 25, 2024

Thank you for your reply! I'm a new Airtable user. When I copied and pasted your formula provided, it said it wasn't valid. I made a small adjustment and it was accepted but now it's changing the day by a day. Here's what I input...sure I did some...

Troy_Gamble · May 17, 2022

That fixed it! Thanks so much Adam…really appreciate your help. Have a great day.

Troy_Gamble · May 16, 2022

Thanks Adam. In the base that you sent me, if/when I make a date change to the {Birthday}, the updated results in the {Change birthday to this year} says the year 2021 vs 2022. It’s correct upon original data entry so I can’t figure out what’s happ...

User Statistics

User Activity

Create a table with all tasks with today's date

Converting text to date (M/D) format issues.

Send email automation based on date but at 9 AM only

Month to Date and Year to Date help for graph block

Calculate "business hours" formula help

Re: Create a table with all tasks with today's date

Re: Converting text to date (M/D) format issues.

Re: Converting text to date (M/D) format issues.

Re: Send email automation based on date but at 9 AM only

Re: Send email automation based on date but at 9 AM only