bitgiggy - profile

bitgiggy · Mar 31, 2021

Hi everyone I’m relying on using the TODAY() formula to mark fields true or false if a date = today. The trouble is, the formula is not working as I expect. Although I can clearly see the date is today, the formula shows FALSE, and if I change the da...

bitgiggy · Mar 28, 2021

Hi guys I’m trying to build by own CRM/Sales Forecast (akin to Pipedrive) and trying to work out if Airtable is the best solution. I’m currently managing the process in an Excel template with a few other steps tagged on (manual and time-consuming). E...

bitgiggy · Mar 26, 2021

Hi everyone I’m new to Airtable but loving it so far. I’ve set up an automation to send a tweet at a scheduled date and time using the following formula I picked up from another post here. IF(NOW()>{Posting Date},1,0) Essentially, if the result of NO...

bitgiggy · Apr 01, 2021

I did something very similar so I think I can help. Firstly, I added a new column where I inserted the following formula: IF(NOW()>{Posting Date},1,0) This will display a 1 when the current date/time (NOW) is greater than the posting date (or rental ...

bitgiggy · Apr 01, 2021

I had asked something similar earlier in the week as I was also having trouble executing automation based on the TODAY() function. As I understand it, the TODAY() and NOW() functions do not update in real-time, so using these functions to post someth...

bitgiggy · Mar 31, 2021

Thank you! That’s very helpful.

bitgiggy · Mar 26, 2021

Thanks, @ScottWorld, very detailed explanation. I assume the scheduling you refer to is the automation mentioned here? I really love Airtable, but I can’t help thinking I’m only scratching the surface. Do you have any recommendations on where I could...

User Statistics

User Activity

Time Zone Issue with TODAY() Formula

CRM/Sales Forecast Split by Cost Center/Month

Refresh Airtable for NOW() to Update?

Re: Create an automation based on Time is NOW?

Re: Filtering using TODAY() but having trouble with timezones

Re: Time Zone Issue with TODAY() Formula

Re: Refresh Airtable for NOW() to Update?