Ask the Community

Hello,I would like to share a base with collaborators in read only or comment only, but I would like them to be able to edite view, specially the filtering field to be able to search throu records more efficiently.So far i'm only able to share in editor mode for them to have acces to the filtering button, but then they can chage the data 😞

Hi all,I'm creating an automation to retrieve data from an endpoint then update a record in Airtable.The api call works, the data is formatted into a string, and correctly passed into the `updateRecord` function.However I'm getting the following error when testing the automation:Error: Request parameters failed validation.Here is the code:  let inputConfig = input.config(); let table = base.getTable('Orders'); let record = inputConfig.recordId; fetch(`https://api.myEndpoint/${record}`, { method: "GET", withCredentials: true, headers: { "Authorization": inputConfig.apiKey, "Content-Type": "application/json" } }).then((response) => { return response.json().then((data) => { updateRecord(data) return data }) }) const updateRecord = async (data) => { let status = data.status await tabl

I cannot decide if I'm better off with an automation or else I'm just not meant to do if else formulas. I need to first check if a date field is not blank. If it is not blank, then I want to compare it with another date field. If it's later than other date field I want to show 'launch date moved out'. I know this formula is not comparing but it's what I ended up with (and it's not working)IF({Original Launch Date} & "-"THEN {Launch Date}>{Original Launch Date},'Launch Delayed') 

How do I change the name of a table's "noun"; the noun is listed in a row's context menu: In this case, the noun is "vehicle".

Hi all! I have a base in which we create and track educational programs that we put together. I have a date and time field that shows when the program starts, and a date field that shows when the program ends. Some of our programs are mutli session or span throughout a long period of weeks. For example, a program may have 3 sessions on non-consecutive days, let's say 9/22, 9/25 and 9/27 (9/27 being the end date) and each runs from 9am-2pm. Sometimes the times are different for each of the sessions too.I want to show that each one of those sessions are from 9am-2pm but the start date field will only show 9am. I can't use the end date field to show that it ends at 2pm if the time is different for each session. Is there a way to easily show a range of time? (i.e 9/22 from 9am-2pm)

I have tried to build an automation from instantly to Airtable. I want to make dashboards for campaign data. My problem is:I want the fields in the (Data_Handling) table to update automatically, when data is updated via an API in the Instantly combined table. I have created the record IDs because i thought it would make it like working in excel in a way. But i vant seem to figure out why i cant make the update record function work in the automation. I have attached pictures. Let me know if someone can help solve my problem, and if you need additional information 🙂 Best;Christian

Hi Everyone! On the screenshot, a colleague (who left the company) was able to set up a notif that shows:Number of records updated View of the records updatedBefore leaving, she said it was done via Airtable Automations. Until now, I can't figure it out. Was anyone else successful at doing it? 

Hi,I am trying to create an automation where:If "Adviser 1 ranking" column has been updated as "Outstanding", then the "Adviser 1 rating" column will automatically have 5 stars appearing. Same goes to any update on "Adviser 2 Ranking" will update the "Adviser 2 rating", "Adviser 3 Ranking" with "Adviser 3 rating". In all 3 single select Adviser ranking fields, I have "Outstanding" (i.e. 5 stars), "Very good" (i.e., 4), "Good" (i.e.,3), "Poor" (i.e.,2), "Try Again" (i.e.,1).Could anyone please help out?Thanks! 🙂

Hi Airtable Community, I'm trying to understand the cost structure for Airtable licenses. Specifically, can a "read-only" user still submit product feedback through an integration? For example, a Customer Experience Agent who has a "read-only" set of permissions still submit product feedback through Zendesk to Airtable without being billed?

Hello everybody,I'm trying to automate sending an individualized email to people in my database who match criteria.ex :trigger when creating a new record (announcement with location A criteria, type of mission 1),I ask this airtable in the face of the action to find records corresponding to the criteria: location 1 and mission 1 (people)then I ask him to send an e-mail and there I get an error message that I can't fix"Invalid email address in the "bcc" field: <span style="display:inline-block;height:1px;width:100%;background-color:#999"> </span><br/><span style ="display:inline-block;height:1px;width:100%;background-color:#999"> </span><br/><span style="display:inline-block;height:1px;width: 100%;background-color:#999"> </span> "Has this ever happened to anyone can you help me?

Hello,I would like to achieve the following.My trigger is "When record is created" and I would like to send a message to my Slack channel once a new record is recorded in my Airtable base. I’m tracking three variables for example Category, Price, Date. I want to be able to see the specific amount of times a specific category was created, for example, if G99 appeared in the Airtable base it would count 1, if G88 appeared it would count 1, if G99 appeared it would now count 2 and so on. However, I want the count to reset daily meaning everything would return to 0 after a 24h period.  I want the Slack display message to look something like this…“A sale was madeCategory: G99Price: 999.00Date: 9/19/2023Sales for current category: XX (with dynamically updating count)” Is it possible to configure a dynamically updating channel message to Slack? I’m also not sure if it’s entirely possible to have dy

Using the "created_at" field, I need a new date field (due_date) that takes created_at and adds x number of days. It's easy to do this with a formula field, and I have that set up already.However, I also need the flexibility of being able to manually overwrite the due_date if necessary. Forumla fields can not be edited. How can I benefit from the efficiency of auto-calculating a due date + the flexibility of manually adjusting if necessary?Thanks!

Recently, we found that Date field has "Time Zone" option. Therefore, we set the time zone as "Asia/Seoul" of the date field and we got rid of another converted time field since it is not necessary any more. However, the problem occurs when we send an automated email using this date field. In the Airtable field, we put this value: 2023-01-10 10:00 KSTWhen we send an automation, the mail shows this: 2023-01-10 01:00 UTCDo we need to make another field which has the converted time to show correct time in Automation, or is there a way to show a correct time in Automation with the specified time zone in the field?

Context:I've encountered an issue in Airtable where an automation I've set up to group records in one table within a linked field of another table works correctly for records with unique primary field values (the leftmost field). However, for records with the same primary field value, it only groups and links the most recent record while unlinking the preexisting records with the same value. This poses a problem for what I'm trying to achieve.Goal:My goal is for the automation to link all records in one table to the field in other table, as long as they meet the conditions of my automation, regardless of whether or not their primary field value is the same.Path:Triggers:- When an updated cell is detected in Table 1, the following actions occur:Action 1:- It creates a new record in Table 2.- This record contains two fields:- One for the updated cell's value (placed as

Here it goes...I have an email campaign table that I import email lists to from various led gen.I have a client intake table that I use to track when a client submits a proposal request and eventual becomes a client.Email is the unique client identifier across all tables.I need to search my client intake table to see if any of the 'email' field matches an 'email' in my campaign table.If it does I need to grab the 'status' from the client intake table and update the 'status' on my email campaign table.The reason I do not want to link the tables is I have a ton of records that do not need to be brought over from one table to the other. I just need to know if a client engages or status changes after I email them.

Hello everyone!I was curious about how I can go about autopopulating another table when a single select drop down item is selected. For example, I own a roofing company. My tables go from CLIENT to PROPOSALS to JOBS. Client is initial meeting (phone, e-mail, in-person etc.). Proposals are to create then send to said Client. And Jobs is after a job is won.What I would like to do is in my OPPORTUNITY column, when I choose CONTRACT SIGNED in the drop down menu, I would like it to autopopulate my JOBS table. Any help is appreciated!

Is it possible to limit the number of records syncing from one table to another?For example "Table A" has 15000 records and I want records 1-100 to populate "Table B", 100-200 in "Table C" etc.

Hello!  I've been working with Airtable for a year and have built lots of automations and formulas. I'm stuck though and hope someone can point me in the right direction! I've got a base with Table A and Table B. Table A is a list of todos which are linked to clients who are listed in Table B, so each client has multiple todos linked.Table B also has drop-down list of all of the stages that the client goes through.Table B's primary field is their unique client number. Table A therefore has a linked field with that identical number in it. Table A also has another field with the same unique client number.I am trying to write an automation which will do this:- When a record in Table A is marked "done" (or other trigger depending on the type of todo)- The drop down for that client in Table B is updated. This seems like it should be simple...- Create the trigger in Table A's Todo recor

Hello,tldr: does anyone know if there is an article which defines the meaning of all the tokens available for automations? If I had a clearer idea I don't think I would have the following problem.Can anyone give advice on the following please?I have two tables with a many:many relationship (Materials and Storage Locations). I have a third table to document individual relationships between Materials and Storage Locations i.e. material x is stored in 2 different locations and I need to display the info of the quantity of material x in each location.I have an automation which is successful and creates a record in the Table 3. However, if the material is already stored in one location and I need to record that it is now also stored in an

I am using the following script for when a new record is added that will provide a running total. // Hard-coded table and view nameslet tableName = 'Invoices'; let viewName = 'Grid view'; let table = base.getTable(tableName);let view = table.getView(viewName);let result = await view.selectRecordsAsync({ fields: ['Amount'] });let runningTotal = 0;for (let record of result.records) {// Hard-coded field nameslet amount = record.getCellValue('Amount');runningTotal += amount;// Hard-coded field name for updating the recordawait table.updateRecordAsync(record, {'Running Total': runningTotal,});}Runs well and little too well. 😂When I add a record it runs the script before I'm able to add the amount and a new blank must be added for the correct calculation to appear. Is there some sort of delay that I could add or am I taking the wrong approach?

Hi everyone, I am wondering if it's possible to create radar charts using Airtable Extensions. I would prefer a way that allows me to create one with minimal code, but I am open to other methods as well.Thanks!

I know that there is already an automation that allows for Airtable to send SMS to Twilio, however I am looking to put together something more advanced. I want to use Twilio Studio to create a flow that would remind clients of their appointments (the client's information comes from AirTable, the date/time, and numbers come for a table) I want it to call landlines or text cell numbers to ask if they want to meet remotely, in-person, or reschedule. then i want the responses to be recorded back into AirTable under the client. How can I set this up?

Over the past few weeks we made changes to our data. We have a main reference base where we link a number of tables from and after changing and deleting some information from that base, Airtable has been reallocating records (wrong ones) in every single linked table. Can anyone let me know how to resolve this? We have a table that has a list of organisation names that is synced to various tables. After we cleaned out that list, we realised that where Airtable would usually leave a linked record blank when something was deleted in the main reference list, it is replacing the deleted data with its own data (organisation names on the list 

 Hi, i don’t understand… maybe API KEYS BUGGED ?   

Hi everyone! Just a simple question (so simple that the bot did not manage to answer to it) from a real dummy. I just use Airtable to store personal data (no shared base, no third apps use): will the API keys deprecating affect the availability of my datas? Will it prevent me from sign in into my bases? Thanks a lot to anyone who will solve my douts.