Ask the Community

Hi everyone!I have a schema of 252 records to apply to some client in a standardized order. This is the script I made (deleted different lines because of number of characters:   let duplicaTable = base.getTable("Duplica_Form") let tyrecords = await duplicaTable.selectRecordsAsync({fields: ["Dashboard Clienti"]}) let cliente = tyrecords.records.filter(item => item.getCellValue("Dashboard Clienti")) //console.log(cliente) let arrayTypeform = [] cliente.forEach(item => { arrayTypeform.push( {fields: {"order": 1, "typeform":[{id:"recg1yUeuxfjKfn0t"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 2, "typeform":[{id:"rec0TnCthwKaCsBcF"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 3, "typeform":[{id:"recg9NPL21ZWduc5g"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 4, "typeform":[{id:"reck4nzT8lp9Us5Nx"}],"duplica_form": [{id: item.id}]}}, {fields: {"order": 5, "typeform":[{id:"recPSIR9XZUw6wvNX"}],"duplica_form

Hi there ! I used to have automations running with an outlook connected email being a shared mail box. These kind of mail box doesn't have an outlook account (no password).Since a year now, my automations are no longer working, I have to change every account connected with an exchange account with log in + password. So I tricked here and put a standard email address as connected account (mine) and use the option "send as" and there I put the shared mail box I work with.... still, I have an error message in all my automations saying I don't have the right to send on behalf of...but checking the exchange tenant, I do have these rights....can somebody help ??? How can we used shared mail boxes to send email automation from airtable ???

I have a column in the first table with dollar amounts like this: $20 $20 $20 etc I would like the second table (in the same view) to total these amounts. How would I go about doing that? Thanks

Hello! We were previously using this formula to calculate a recurring date in the future: DATEADD("Publish Date", 7, "days")  However, we're now getting an #Error Message in our base.  I did some searching and found this blog from Airtable.  I tried using their exact formula in that blog as: DATEADD({Publish Date},7,‘days’) but it is telling me "Sorry there was a problem saving this field. Invalid formula. Please check your formula text"  Can anyone help me with what the correct formula is now? I am so lost....

The "Link to" field shows the fields in the edit/detail form. In fact, in the example you can see the title. When editing the Add task form it is not possible to show the fields, thus making selection difficult.The two forms should have the same possibilities, I believe they are not aligned.Form edit/detail:Form Add task: 

I currently have a Node.js application that makes requests to the Airtable API, which I have been using as usual. However, from yesterday to today, I am encountering this problem:[Nest] 31452 - 02/02/2024, 9:32:17 AM ERROR [ExceptionsHandler] connect ETIMEDOUT 18.214.64.4:443 Error: connect ETIMEDOUT 18.214.64.4:443Has there been any change to the API?

Hi everyone, Does anyone know of an extension that allows you to mind map ideas/projects? Kind of like an XMind or Miro?I'm trying to keep as much inside Airtable as possible. Thank you!

Hi Team,I would like ask for your assistance on this matter please.Whenever our clients would want to submit an inquiry to Softr, this error is always appearing. Thanks 

Looking for help with my base. I want to automate importing a csv on a schedule into Airtable. Currently, I have to delete all of the records in my table, export and import a new csv from NetSuite, and then the rest of the base does the work. How do I automate this? My goal is to have this run 3-4 times daily.

Can someone assist me with writing this formula? I'd like to basically have a column in which the staff or faculty nominee column is combined with the value. For example: Cameron, Ali - Innovative SpiritI'm running into an issue were if the staff column is not populated the staff one is, and I need the names to pull from either or both- I tried using and "if" statement but am not having any success. Additionally, if there are multiple names linked, I'd like to separate them by a comma. Screenshot attached for reference of the table!

I just saw the final deprecation email a few days ago (my work email has so much junk I rarely check it unless I already have a thread going). I'm trying to update a touch screen experience I built 2 years ago. This is the first and only project connecting an app I made in unreal to airtable so hopefully I'm just rusty and it's an easy fix.I'm able to see the records using web.postman.co so I know the personal auth token is working, but retrieving and sorting them in unreal (using the VA rest plugin) is more complex.here's a comparison of the old API key method VS one of many things I've tried so far for the API call. they're identical except for the third line.I also tried removing the 2nd line with the sorting but that's not working either. like this-https://api.airtable.com/v0/appWrAePyRvMx3CVf/tblZxE2HTTGaYbVEl-H "Authorization: Bearer pat##############etchere's one of the unreal engine blueprints. this populates one of many pages in the app where I'm getting many images from

Help! We are a Charity that trains Assistance Dogs for Autistic Families. I have a table with ALL the people that have ever had to do with thecontact/dealings with charity at some point... however, this is my dilemma:Mr X is currently a 'Volunteer' and a 'Subscriber' but he used to be a 'Fostererer' so his Contact Type is currently a multiple select field where all three are listed. BUT it doesn't tell me which Type is active and I have been asked to show who's doing what currently and not previously. What do I need to do to my base to identify that Mr X has 'Active' status on both Volunteer and Subscriber but 'Inactive' status for Fostererer.

Hello ! So i have a base and i want to delete all records that are on the table every sunday (weekly). i heard that it’s possible to do it with a script, but i don’t know how. Can you help me please? Thanks

I'm looking for a bit of assistance. I've created an automation that sends a message to a specific MS Teams channel when a record enters a view.However - the message is sent from myself, which means that when the automation triggers, I don't actually get any notification on my PC or my phone (since technically it's "me" who's sending the message).Is there any way to bypass this so that I actually receive a notification? I could use Zapier, but I'd like to avoid that if possible.

Hi everyone,I would like to create 1 automation that starts when a record is created in airtable and that creates an event on google calendar. I used the "when recordmatches conditions" trigger specifying the conditions to make it activate (for example the date field must not be empty). I then inserted my Dynamic "Date" field as "Start date" and "End date", which is made up of both the date and the time. The problem is that when I go to create a record and choose the date, the time is automatically filled in, the automation starts and creates the event at the wrong time. Does anyone know how I could solve it?any help is precious!

Hello,I was elated at the ability to prefill forms in interfaces just like you can do with the standard forms. However, I'm not able to prefill a linked record in an interface form.I was successfully able to prefill other field types with the interface form, just not the linked record.In addition, I tested the same prefill string on both a regular form and an interface form and even "hardcoded" the string with the Field ID and Record ID (?prefill_fldXXX=recXXX). It worked as expected on the regular form but not on the interface form.Is this functionality not yet possible (other posts on here suggest it should be)? Is this a bug?Thanks!

Hello,We are one of many Homeshare programs in California, that operate out of different agencies with different tracking systems etc. but we try to collaborate across programs with the understanding that we all are working towards the same end goal.Another program showed us how they use Airtable to track their participants, and their workflow is very similar to ours. They built the database themselves, with much research, tutorials etc.Would it be possible to import the structure of their database to use it on our end, without any of their clients' info? How would that work?Thank you for any insights!Julie

Hi,Is it possible to manually reorder rows in an Interface Grid Element? If a grid is not sorted or grouped, the "dot" handle on the left does not appear. If a grid is not sorted but is grouped, the "dot" handle appears, but grabbing it and moving the row does nothing. The row stays where it was.In both scenarios, when inserting a new row, the row automatically filters to the bottom regardless of where it is insertedI'm setting up interfaces to introduce new users in our organization to airtable. This automatic row behavior is frustrating them because they're used to things like (unsorted/unfiltered) google sheets, and want to drag and drop rows into their preferred order.Is there a way to configure the Interface grid element so the row behavior is the same as an unsorted grid view?Thanks!

Hi-We love the synched Airtable base option which is able to show us (for example) what work is in progress, by employee for up to 10 airtables. The one gripe we have is it would be really nice to see this all in one tab. I've tried fiddling around with creating a "Master" tab in the base by using a "linked" column in hopes to have the master tab contains all the linked views but am not getting anything to work. Is there any combination of AI/Automations available that might achieve this goal? We currently have the TEAM paid plan. Please and thank you for any information.

hello, i’am trying to create google web app and connect my base to it. but the problem is i need dependency to link the base. anyone who try a similar process? or any easy way to integrate airtable to google app script? thanks in advanced.

Hi fellow AT users. Please forgive this long post, but if you have the patience to read through it, I know there is a super smart person out there who has a creative solution. My boss wants to share an org chart link with other people in the company without them having to login to AT. I know how to do that. I also know that I can find the URL to the org chart so it can be shareable. I have learned I can also share the base publicly with a passcode - so far all is good. However, as you know, you can click off the link and view the entire base contents which is what we do not want.We cannot afford the Softr Business plan each month (non profit - even with their 30% discount) so we have to manually find a creative solution.We thought we could sync a limited view to another base and create the org chart there but with one way sync, it doesnt allow the links and the org chart cannot be created as such.Here is where automation comes in. We had the idea of exporting the base views w

Hi there - I am looking to create a column that will essentially lookup the field values of columns Q1 - Q4 and output the latest number.We input quarterly projections and want to be able to identify the most recent number by looking at 1 field ("latest projections"). *Note - not all fields will have data from Q1 - Q4.I tried using the IF function but that only seems to work with 2 different fields max. ( IF(Q2> " ", Q2, Q1) )If I have data entered in Q1 field and then in Q3 enter in new data in the respective Q3 field, I want the "Latest projections" column to display that Q3 field since it its the most up to date #.I hope this makes sense. I will attach a screenshot for reference where I manually updated the "Latest Projection" field. 

Hi, I'm really new to scripting and despite a bit of ChatGPT help, I haven't got anything to work yet. I'm hoping that with a basic bit of help here that I can get going with my relatively limited coding knowledge...I am doing a "when a record matches conditions..." trigger, and then hoping to find at records that have a start time of 00:00, update it to 09:00. this is because I'm hoping to drag/drop bookings onto a timeline and they default to 00:00 to 00:00 which doesn't work for our bookings system. I've found the field, and I can see in the record info, the {start} field shows (eg) 24-01-31T00:00:00.000Z.I figured the easiest thing is to add 9 hours to that, so I'd started with this:// Retrieve the start date-time from the input variableslet startDateTime = input.config().startDateTime; // 'startDateTime' matches the name given in step setup// Check if startDateTime is providedif (startDateTime) {// Parse the start date-time string to a Date objectlet startDate = new Date(star

Hi friends, I am having a problem when pressing buttons from the app in an interface that I made, it throws an 'Invalid permissions' error. Does anyone know why this might be or how to solve it? Thank you very much!

I have a table in airtable with a field called 'Logos' which is of type: Attachment. I am using Make integromat to pull the logo urls which get populated in the Mailchimp Create Campaign module (that uses HTML layout). When I see the campaign being created , I see the logos but after a few hours I see that the same campaign does not show the images. Is there a reason for this? Please let me know if there is a resolution to this.  Thanks in advance!