Emily_McLain - profile

Emily_McLain · Nov 19, 2024

I'm using a simple formula to calculate the due date difference between today and the project due date:WORKDAY_DIFF(TODAY(), {Due Date})-1Which works for anything due today and in the future, but does not calculate properly for past due things. If to...

Emily_McLain · Oct 27, 2023

I have a multipart task that I think can surely be accomplished with a few formulas. I looked around the forums for a while and I think I have an idea but I haven't been able to put it all together yet! Basically I have lookup field collating all the...

Emily_McLain · Feb 23, 2023

Hello! I'm sure there is a very easy solution for this but I am having trouble figuring it out! I have an "Ad Record" field that may or may not have a date at the start (ex. "1/2/23 | Company | Product"). This formula parses out the date for me easil...

Emily_McLain · Jan 30, 2023

Hello!I have a large amount of sales records that I need to automatically transfer from an "Ad Chart" tab to another "Production" tab, to be assigned to various designers. I want to be able to check first if a record already exists on the Production ...

Emily_McLain · Nov 09, 2022

I want to parse text date entries from a single record into calendar date entries so that a calendar view can be used to visualize the dates. We have our sales records entered by product, so each individual product gets a separate entry, with multipl...

Emily_McLain · Oct 30, 2023

Hi Arthur,Thanks for the reply! Our system is set up where the initial dates are records on a separate Calendar table so thats where I was getting the string of dates from, but they do eventually get translated into date field entries on another tabl...

Emily_McLain · Feb 24, 2023

That worked! I knew it would be something simple.Thank you so much!

Emily_McLain · Feb 03, 2023

Hi Adam, That's what I set up initially in the testing phase and it does work:However, it doesn't work at scale, there are simply too many records for it to check. From what I read, Airtable limits the Find Records action to 100 records and I need it...

Emily_McLain · Feb 02, 2023

Hi Adam, Thanks for the feedback!Without going into the data, we have a couple dozen products, for 100+ companies, across 3 publications on this "Ad Chart" table, so it makes sense for us to keep that as the central calendar and funnel projects out ...

Emily_McLain · Jan 30, 2023

Hi Jody, Thank you for the suggestion. I've looked into those and they do look useful in removing duplicates after they occur. However I'm hoping to have something that will check before a duplicate is made. That way I can set up my automation to run...

User Statistics

User Activity

Calculating work date differences for due dates

Extract the first date from a string of dates

Parse a date if exists, otherwise blank

Script to check for an existing record before creating a new one

Convert multiple text date entries from 1 record into multiple calendar date records

Re: Extract the first date from a string of dates

Re: Parse a date if exists, otherwise blank

Re: Script to check for an existing record before creating a new one

Re: Script to check for an existing record before creating a new one

Re: Script to check for an existing record before creating a new one