The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Hi there,I'm experiencing a strange situation with a simple formula. Here's what i'm using:WORKDAY_DIFF({Date-test-1}, {Date-test-2})-1 I set date-test-1 to Today's date (Friday). If I set "Date-test-2" to next Monday, the result is correct: 1(Note t...
Dear community.
I need to set up an automation, which should be simple, but i’m new with automations in Airtable.
I have a table of orders. Sometimes, several orders have been made by the same client.I want to be able to send just an email for every ...
Hi there!
I was wondering, is there a way i can extract information from several tables in the same base and see a form (or kanban) view with, table 1 allocated in column 1, table 2 allocated in table 2, etc.
I want to create a “brainstorming” tool, ...
Hi there,This formula doesn't seem to be working when trying to get the number of working days from today to yesterday. It works apparently well in other cases.Being today 20/04/2023, I get -3 instead of -1:Here's the formula, just in case:IF( DATETI...
Hi Rodolfo, thanks for your reply,Unfortunately, that didn't do the job. The error i'm getting is not that i get a positive number that should be negative. The thing is, calculating workdays between today (Friday) and yesterday, i'm getting 3, instea...
Hi! thank you both for your help, i appreciate that!
Yes, in fact, i had this scenario built with integromat, but i preferred to use just Airtable, but with these limitations, i will stick with integromat.
In the near future, if the volume of records...