Sharon_Visser - profile

Sharon_Visser · Aug 31, 2022

Hi all - I know dates and timezones are complex, and I’ve tried to do my homework but I’m really stumped. My end goal is to identify records created yesterday and send off a notification. To start, I’m attempting to calculate how many days are betwe...

Sharon_Visser · Aug 08, 2022

Hi Airtable Community, I have created new fields and an automation to allow me to automatically send out an email and Teams message 2 days prior to an observed holiday in our Company Calendar table. I have successfully figured out the date when the a...

Sharon_Visser · Jun 23, 2022

Hi Airtable Community, With sample scripts that I found here, I was able to create a script to duplicate a record, and I’ve set up the script to run on a button. [So, thank you for all those how-to scripting posts!!] However, I was hoping to be able ...

Sharon_Visser · Mar 14, 2022

Hi, I am creating an automation that will have several conditional Actions, but I can’t seem to get past the first condition. My trigger is a view, and when I test my trigger I can see the specific field I want to use in my action condition, but whe...

Sharon_Visser · Feb 16, 2022

I’m in the process of creating a form the interested clients can fill out and submit. One of the fields is a Number (Integer) and I wanted to know if there was a way to give a maximum value. We don’t want to accept the entry if the value in this fi...

Sharon_Visser · Sep 01, 2022

@ScottWorld, this works perfectly also! Can I mark 2 responses as the solution, both your’s and the one submitted by @Adam_TheTimeSavingCo? If I can only mark 1 as the solution, I’ll go with Adam’s since he submitted his first. But I definitely lea...

Sharon_Visser · Sep 01, 2022

Thanks @Adam_TheTimeSavingCo - works perfectly!

Sharon_Visser · Aug 31, 2022

@Emily_Sermons - This is a fantastic new feature. I have so many different interface pages for one heavy user group, that I just set up a dashboard with buttons to open the necessary interface page. It looks so much easier for users to navigate!! ...

Sharon_Visser · Aug 08, 2022

Thanks for responding so quickly! If I understand what you are saying, using SET_LOCALE with ‘America/New_York’ will set it to EST at midnight. But, let’s say I wanted the automation to go at a specific time in EST, not midnight but 9:00 AM. Would...

Sharon_Visser · Jun 24, 2022

Thanks, @ScottWorld for this suggestion. It has a lot more moving parts, and I’m trying to do everything within Airtable and not have to purchase other products, at least until I run into a problem that can’t be solved any other way. This certainly...

User Statistics

User Activity

Date calculations to determine "yesterday"

Run an automation on a variable date at a specific time

Permissions on a button

Condition in Conditional Action not working

Number field maximum

Re: Date calculations to determine "yesterday"

Re: Date calculations to determine "yesterday"

Re: New button types in Interface Designer

Re: Run an automation on a variable date at a specific time

Re: Permissions on a button