Hi all,I'm working on building a base for my team, and am having an issue with automating a copy-and-paste function.I have a formula which calculates the due date for tasks based on a set number of workdays from the start date. However, sometimes we ...
Hi everyone,It appears that I cannot use the "Find records" action with a condition on a date field "is within" "this calendar month".It is fine if I choose any other "is within", such as "the past month". But it won't work if i choose "this calendar...
I have email automations that are sent out when a record matches conditions. When a date is one day ago an email is sent. Overnight this has not worked, emails have sent even though the field date that triggers the email was not one day ago. What cou...
I use Airtable to track and schedule vaccinations for the animals in my calf barn. Using the birthdate of the calf, I have formulas in the due date fields to calculate the appropriate date to give each vaccine to each animal. Then I have a field with...
Hi all,I'm using the 'Find Records' automation to get a grid of records to email to other people. Though my table is sorted by date, the records are being returned in a completely random order (see attached, specifically the Overtime Worked Date colu...
Hi All, I'm trying to use a linked record to pull up the TRT of an asset that's listed out as a full timecode, extract just the hours and minutes and put that into a duration field. I've gotten so far as to pull the hours and minutes but when I set t...
Hey all!I run the backend of a small newspaper, and one thing we do is make a list of "happenings" that we publish each month. I had set up a back-end system via Airtable collection form, and the listings were then compiled into a Google doc via auto...
Hello,I am reaching out to see if anyone else has had this problem and knows how to fix this.We use a form that is to file reports at the end of a shift, which includes the time stamp of when the form is being filled out. This form is then sent out t...
Hello everyone,I need to insert the current date in a filed when a second field is updated (Yes or no) in the record updated.My need is that the first field is a "Date" because it could be modified inserting a different date in the case of any modifi...
I want to have my status column auto fill a date in the Actual RFP Date when the status is set to RFP. But then there are more status changes that will happen after that, and I don't want the Actual RFP Date to disappear once the status is change to ...
