Solved

Dear All,Im trying to create a formula where if an someone starts before the 15th of the month then return the 1st of that month. If they start on the 15th or after then return the 1st of the following month.I have created the below nested IF statement but only the first IF statement appears to be working. For start date equal to or greater than the 15th it is giving me the 1st of the month and not the first of the next month.Please advise  IF(DATETIME_DIFF({Role Start Date},'days'<15),DATEADD(DATETIME_FORMAT({Role Start Date},'YYYY-MM'),0,'months'),IF(DATETIME_DIFF({Role Start Date},'days'>=15),DATEADD(DATETIME_FORMAT({Role Start Date},'YYYY-MM'),1,'months')))  

Group by field is not showing a "Summary" in the interfaces graphs. Instead, show each individual record. It seems that it is a bug since the last update of Airtable, since before it worked without problems.The correct behavior that I expect is that when hovering the cursor you can see the total grouped by status and not the value of each record.

I am trying to make a linking automation. Our records in Table 1 do not all exactly match records in Table 2. I am using an Long Text field to create a list of other numbers I would like the automation to look for when linking.The problem is that using the Find Records function has the options to find a record that "is"(which wont work because im using a list) or "contains"(which will find records that dont exactly match. EX: 2118-1 will match with 2118-1.1 or 2118-11) Is there any ways around this?  

Hi folks - I have an application review process set up in Airtable and we're using an interface as the review experience and then a series of automations to process the applications based on the scoring from the reviewers. We need a reviewer to be able to batch process multiple applications at once by clicking a button on the interface which then triggers an automation with multiple action steps (see the attached screenshot of the automation). The input for the repeating group is a list of records and when I tested that, it pulls the correct records. But for some reason, when the button on the interface is pressed, it only processes one record at a time and does not repeat the action steps for all records in the list. Any ideas why this isn't working?

HiI am scheduling a festvial, and I need to create a way to "unshare" past events, so the beginning of the week doesn’t pop up on the last day.Is this possible?All the best, Uffe from KlaDa

I have a formula that worked but I decided to go and mess with it.I have a Date field that is the date of the task actionI have a Days to next action field to add to Date field to define next time to attempt the task (normally a callback)I have a Next Task Date formula field that shows the Date for the next task based on Date + Number of Days  - and it was nicely workingThe formula in the Next Task Date field looked like this - DATEADD({Date }, {Days to next action}, 'days')However I don't want the formula to put anything in the Next Task Date if the Numbers of days is blankHere is my current formulaIf ({Days to next action}=BLANK(), DATEADD({Date }, {Days to next action}, 'days'))It's failing and I can't figure out why.Thanks in advance for helping

I don't know if this is possible, but it will save a lot of time if it is. I have a donor database where each donor is known by their full name, ie. "Kate Jacobs". Is there any way that I can add a column with some sort of formula that could just pull the first word from that record? For the purpose of mail merge - I want to be able to do a FName tag, but currently will have to manually go through and rename all the contacts.  

I'm creating an inventory checkout database, based on a sandbox version created by another community member, and am trying to figure out a formula to indicate if items are overdue. Our default check-out time is one business day, and I've managed to create a formula that auto-populates the default due date, and a formula (below) that will indicate if an item is overdue, past that default dateIF(AND({Type}="Checking Out",IS_AFTER(TODAY(),{Due Date})),'OVERDUE') BUT the issue I'm encountering is that sometimes, we extend checkouts in special circumstances. I've created an "Extended Due Date" field, so that staff can manually create an extended due date if needed. However, I'd now like to figure out a formula for this Overdue field that would tell Airtable to first check the Extended Due Date field, and use that if it's populated, and then, if that field is empty, check the Due Date field. How would I do this? Thanks in advance!

Hey everyone,I have a temporary accommodation that people apply to.All of my applicants are stored on my Airtable in tab #1 (Applications) once they apply with form #1, which I use as my CRM.Once an applicant is accepted, I send this person form #2 asking for the exact move in/out dates and other valuable information using another form.Currently, I'm using tab #2 (Residents) within the same base to store that info and I'm wondering whether:there's a way to put all of the info from form #2 into the existing row that was created with row #1 orI should use another alternative, such as using a List view to combine both of these areasThank you very much for your help!Cheers,Marc from Barcelona

 Hello,I'm trying to connect Airtable to make.com and gets records to fill document with Microsoft Word Templates.The problem is returned data by Make.com. I'm getting something like this "recn3V..." instead of value from Airtable that should be a name of company. Thanks in advance 🙂

I can't get this formula to work.My table has 3 fields:Agreement SignedWYNTK SignedIntake FormEach field has a single select option, "Yes" , "n/a" or "In Progress".I have a final field "STATUS" with a formula - should all three fields = "Yes" or "n/a" =  "✅" If any one of the fields = "In Progress" then the STATUS field = "❌"   IF(   AND(     {Agreement Signed}="Yes",     {Agreement Signed}="n/a",     {WYNTK Signed}="Yes"     {WYNTK Signed}="n/a",     {Intake Form}="Yes"     {Intake Form}="n/a"   ),   "✅",   "❌")

Hello all!I am currently trying to make an automation that inputs the date into a cell of the time that is updated. Right now I can only see two options - static and dynamic. The first does not work since the input will not change with every update, and the second can only be based off of different cells. Is there an option I'm missing?Thanks!

Hello! I need some help from this community because I lack the knowledge to develop formulas.  I really appreciate your help.I'm trying to create a view for a database where I only see records where the answer for "Dates Available" is exactly between one month ago and 3 months from now.  How would I go about making this?Many many thanks in advance.

Hello! I wrote a script that creates multiple days worth of events people can book at a time, but it takes into account some settings to determine how long those slots are, when the lunch break is so it wont create a slot then, etc. I'm also making an automation to create a new day's worth of these every day at midnight, so that after we run the manual script once we can leave the rest of it to happen automatically. I'm wondering if there's any way I could grab the settings from the manual script for use in the automation. 

Hello Everybody,  I need some help with formula, so here is what I have, I have a "Multiple Select" field, lets say I have options like these there: Option A, Option B and Option C. Every option has its own price, let's say Option A is $10, Option B is $20 and Option C is $30. I have another field "Price", which is currently set up for "currency" and I manually enter the total there every time. So I want to use a formula to have a total sum of the options that I choose in Multiple Select Filed, any ideas? Thank you in advance

I made the code below to read a row in my Teste3 table, and from that row, generate new rows according to the code. Row generation is correct, but the script is unable to record new rows in the table. Can you help me?    let table = base.getTable('Teste3'); let queryResult = await table.selectRecordsAsync({ fields: ['Valor', 'Vencimento', 'periodo_real', 'parcela_real'], }); let records = queryResult.records; for (let record of records) { let valor = record.getCellValue('Valor'); let vencimento = record.getCellValue('Vencimento'); let periodo = record.getCellValue('periodo_real'); let parcela = record.getCellValue('parcela_real'); if (valor && vencimento && periodo && parcela) { let [currentParcel, totalParcels] = parcela.split('/').map(Number); if (currentParcel < totalParcels) { let newParcels = []; for (let i = currentParcel + 1; i <= totalParcels; i++) {

In advance, thanks for this help. I work at a small company, and I'm a marketer by trade, so please be kind 😛Anyways:I have a base that's for an artist on our team. It currently has three sheetsProjectAsset TypeIndividual AssetAnd are nested together (Project is the main umbrella of any, well, project. Asset Type is [product] Screenshots, [product] videos, etc which serve as the organizational packets of deliverables, and then individual delivered assets live under that). We have very strict content approvals, so I need to get very granular with approval and content revision chains, down to the individual asset. Currently, it's working, but it's a bear with manual data entry when a new record is created. I have two (and a half) goals I'm trying to accomplish:1) If the artist were to open up a Project, and then select "Add Asset Type" (from a linked records to the other sheet), upon clicking this, I'd like to have it auto-pop the records that would nest down well: Due date,

I use the script below to retrieve the latest date from all records in table 'personal expenses', and want to insert this value to all records in table 'personal budget' (this table is in the same base).The script works if I update the records in the same table 'personal expenses', but not when updating the other table 'personal budget'. In that case I receive this error: j: Error: Failed hyperAssert: undefined at main on line 33 Can someone help me with debugging? I'm in script noob and assume there's a missing link between selecting the records in tablePersonalExpenses and updating the records in tablePersonalBudget. Thanks in advance! // Replace "Table Name" with the name of your table let tablePersonalExpenses = base.getTable("personal expenses"); let tablePersonalBudget = base.getTable("personal budget"); console.log(tablePersonalExpenses) console.log(tablePersonalBudget) // Replace "Date" with the name of the date field you want to find the latest date o

Howdy AT Community! Hoping a kind soul can provide some assistance with an automation query. I'm trying to track subscription activations for a University cohort, pulling from a large Uni Cohorts table to update a specific cohort tracker table.  Desired automation flow is as follows:Student submits subscription activation request form > record is auto populated in main Uni cohorts table (first name, last name, email, Uni name) > record 'Status' field is set to 'activated' if approved in main table > student record status field is updated/reflected in cohort activation tracker tableThe list of student names and emails is already populated in the tracker table, purely need to track them in for external onboarding reporting purposes. Struggling to get the update record automation to work between the two tables (unless there's a formula trick I'm missing?)Any assistance greatly appreciated. 

 Hey everyone,I am fairly new to Airtable so I hope it's not too nooby of a question.I am intending to create a fact table with invoices. Now I would simply like to aggregate the value for each client. The only way I found is the "group" feature, however this appears to me as just being a visual filter. In any case I need both the individual table as well as the grouped overview.Also I found that I can link records to each other but the actual grouping column is a formula. As soon as I select it as lookup, that is breaking the formula.How can I possibly achieve that?Kind regards,Marcel

I think I'm really close to figuring this out.  Here's the ideal  scenario:My accounting department hits a "Reminder" button on their interface which triggers an automation to send my Project Managers a reminder email to approve their invoices.  The email contains a grid of that specific project manager's open invoices.My current situation:- My interface button works great.  Best button ever.- My "repeating group" action is where i'm getting twisted up.  I've got a "repeat for every one in the project managers" list going. I've got a "Find Records" action that finds ALL the invoices where the "PM Approved" field is not checked. I want to send Project Manager 'A', a grid of ONLY his invoices that haven't been approved yet.  How do I add a condition in the "Find Records" action that find records for the next project manager on the list?   Edit:  I think I understand now.  The "list" can only be generated from a multiple sel

Hello,I need to calculate a date. Here is an example:Start date of employee is 2023-05-03. The previous Monday, an email should be sent to the employee.How can I calculate the date based on the weekday.I have a formula, but it only works if employee starts on a MondayCheers

Making this note incase anyone else runs into this issue.As is listed on the Airtable website, there is a limit of 50 interfaces per base and 50 pages per interface. However, what is not made clear is what constitutes a "page". One might be mistaken to believe (understandably as I did) that "page" would be a "page" as is listed when you go to EDIT > "add page". (*sarcasm intended here)However, when in one interface I had 22 pages, my "add page" option suddenly greyed out. (see attached screenshot for reference). I tried to work with Airtable support on why this was happening, but they didn't seem to understand the issue and kept giving advice about record limits (which I am only using 3% of my 50,000 record limit and repetively explained to them that was not the issue I was asking about). But I won't comment on the unhelpful support beyond that.To help all of you who may be facing this same frustratingly bizarre problem, I'll explain what I discovered on my own. WHAT

Hi, I'm looking for some help with a rollup that is rolling up start dates and returning the earliest date from a table. The aggregate function seen on the image is not taking into account the filter I'm trying to apply. I'm trying to return the earliest date on a roll up where the Session Name is not Session Zero. I do I do this in the formula ?  

We've added Interface-only users to our AirTable Interface. How can I prevent users from adding them to the full Base?  The Base contains sensitive data that Interface-only users should not have access to.  I've noticed multiple times that Base users have invited Interface-only users to the Base.