I'm pretty sure I'm over thinking this process so I apologize in advance if this is obvious to most.I have a field in Table 1 which when data is entered, I'd like that data to automatically create a new record in the primary column of Table 2.Table 1...
I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Ta...
Hi everyone, I am trying to create a formula that will output what funding year a record falls within. I have a field with the dateStart of the funding and another with the dateEnd of the funding. I also have a program start date which is a static fi...
Hi all,I recently switched my team over to Airtable for project management. There were a few things holding me back, including that we'd have to build the automation for recurring tasks manually. Now that I have that built, I'm curious if I can get a...
Hi everyone,I suppose someone else must have dealt with this before so here my question, hope someone can point me in the right direction!We run a few bars in our property and we connected our POS to Airtable, so every day I get all sales data import...
Dear Community,I am faced with the following problem:I want to pull data from a different table when the status in each table is the same.I am creating a text.Say the status in Table 1 is "First Text" then it should check in Table 2 for the row named...
Hi there, I have a single select field name "Département" and I want to concatene the 2 first letters (later for automation).I have a problem with this formula :IF( OR( {Département} = "75", {Département} = "78", {Département} = "77", ...
Hello!I have created an estimates / intakes base for a client. One of the goals of creating this was to have an automation that sent a confirmation email to the customer once their estimate was scheduled. When I tried to insert the Estimate Date/Time...
Evening! I am trying to create a table with multiple purposes: 1. Share and store meeting notes2. View date for next meeting 3. See who attends each meeting - this is the one I need help with. _______ So I have created this table:Each Record has its ...
Helle everyone! I am trying to make a table where I'll have an overview of different kind of meetings. Let's take meeting A as an example. This meeting happens every 14 days. When the meeting has happened (the date is yesterday) I would like a new Re...
