Ask the Community

We keep our org chart in Airtable. It includes who Person A reports (as a link to another record) to as well as their contact info and photo.The automation I'm trying to set up would remove the manager that Person A reports to when the manager leaves our organization. We have a status that is "No longer employed", so I'd like the automation to be triggered by that and then remove the manager from any employees they're assigned to.I can get to a certain point, but I keep setting it up in a way that would just update the manager record rather than the folks they manage.TIA for the help!

hi there!A newcomer to Airtable and really excited to explore and see how I can build a robust system for my use cases. I manage a construction company and am trying to build a robust PM interface to handle the various activities that happen during pre-construction, in-construction and post-construction. There's a lot there but one important aspect is the idea of automating a status report to share with the top management.Currently I build this manually in email and share with the team. This includes a genera summary of activities during the week, any red items (tasks that have been delayed) and then a list of open items and their last activity.Assuming all these items are logged in a table with their activity logs in comments (unless there's a better way), is there some way to automate this report to be generated and emailed end of each week?Thanks very much for your help and advice!

Hi all,I have formulated columns Apple, Orange, Banana, and the formula produces "Y" or "N" values. I want to create another column that will return the name of the column if their value is "Y". Is there any way to do this?I have tried nested IF formula, like IF(Apple="Y", "Apple", Orange="Y", "Orange"...), but the problem is they just return one value, but I want all the columns as long as their value is "Y".Thanks in advance!

Hi everyone I am trying to create a hash of a record using md5. I am fairly new to script but I am willing to learn. does anyone have an idea of how to do that? Thank you

Does anyone have an issue with emails being rejected from an airtable automation? There was a migration from a different hosting service we used our mail servers on I have disconnected and cleared the cache and reconnected the account but the same issue is happening as the email was the same but the hosting changed I am not getting this issue it seems like from other 3rd parties I was using. This was not doing this before there was no issues sending emails from outlook in connection in airtable so I have no idea what is happening   

Creating a CRM and I was hoping to create a master interface to act as a management dashboard and draw from multiple different bases. Is this possible? or does all the information have to be in one base under different tables?

Hi. I am creating a version of an automation that I didn't create. I have duplicated it, added a trigger and updated some copy in the code but I have a configuration error. I can't figure out how to get the custom script into the message. Screen grab one is the error. Screen grab two is how it should look.Any help is appreciated.Deb

Hey AirTable Community! I am having trouble with Automations. I have my trigger (When a new record is created). When selecting my Action (send an email), I select all the fields I want to display on the email, but when I test it, it’s only pulling certain values, but most of them are left blank, even though the cell has actual information on it (linked from another record & tab) Any solutions to solve this? Thanks!

the one thing that is missing for me from Airtable which I thought the new Interface designer and feature will solve, is that it will actually save the exact state of my table when I’m sharing… for example: I have a table grouped by a column that has 7 values, and I’d like the table to start with all of them collapsed for viewers, so that they can see a summary of the key value. 2nd, the width of each column. I figured that if I change a column’s width while in edit mode, it should stay that width when viewers see the table… and currently it does not. with these 2 things not supported, I don’t see much value in this whole feature… are there any plans to add this?

Hi, I’m getting an error when I try to use create a Javascript FormData object in preparation for posting to an API. I would have thought FormData would have been well supported. console.log(`Hello, ${base.name}!`); const endPoint = new URL('https://myserver.com/jsonAPI/'); const formData = new FormData(); formData.append("user", 'tom'); const response = await fetch(endPoint.toString(), { method: "POST", body: formData, }); console.log(response) Getting an error saying that FormData is not defined

Hi there I’m not even sure I’m asking the right question here because I know nothing about coding and I’m aware I’m going to need a script here. I have a table with data in it that I want to use to populate a Contract Proforma in Google Docs that I’ve created through Integromat. I’ve managed to get it working through the Created Trigger that comes automatically in Integromat but I’d now like to be able to make it happen by clicking a button in the Record in Airtable. I think this is done via Webhooks. I’ve generated the Webhook in Integromat but I don’t know the code to use to get the correct data sent across. Thanks in advance

I am currently using the Team plan for my workspace, and I have a few questions regarding the pricing structure and seat allocations.1. Regarding Editors:If I share the workspace with two people as editors, would there be an additional cost incurred? If so, could you please clarify how much the additional charge would be?2. Regarding Readers:Similarly, if I share the workspace with two people as readers, would there be an additional cost? Kindly provide details on how this might affect the pricing.3. Sharing Workspace Databases:Suppose I share four workspace databases with three people. One person receives access to two databases while the other two individuals each get access to one database, and all are set as editors. Would there be a change in the pricing structure due to this arrangement? If so, could you provide information on th

Hi all,I am planning on transferring a base on a new workspace.I'd like to know the impacts: especially, will my form url change?Txs

Hi guys, I'm new to web development and i'm trying to use a serverless function to fetch data from airtable. The fetch function works fine before, but this morning when I check my application it shows `isAxiosError.js:10GET http://localhost:8888/api/products 500 (Internal Server Error).`I used API Key before for the authentication but I have already changed the API key to personal token. However, it still not working for my project. Can anyone help me to solve this problem? Thanks in advance.

Hello guys,our client has this issue from a couple of days. He has (a lot, I know) of unread notifications but whenever he tries to click on the notifications' button he keeps getting en error which I've attached below.We've already tried to delete cache and cookies, nothing happened. Tried on a different pc, same error.Anybody can help us?Thanks

Hi,I am having an issue to match the airtable-content-mac from the header with the one I computed following the instructions from the documentation .

I have 2 different bases, extensions and 10 day. I want in the 10 day base to have a field that can check and see if that record also exsists in the extensions base. If it does it says exsists or doesn’t exsist. ‘is this at all possible?is there an easier way to achieve this?

I'm using pre-filled forms in an automation to update a value in the Main table. (The form of course creates a new record in the Updates table.) The update form that works is updating a Single Line text field in the Main table, with a value coming from a Single Line text field in the Updates table.Where I'm have trouble is when the fields to update in the Main table are either a Date field or a Single select field. In those instances, the target field in the Main table does not get updated, and is now empty.I guess there's a compatibility problem with differing field types. I tried making the field type in the Update table Date fields or Single select fields (with the selectable items in its drop-down.)I get this error in the automation:H

I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?

I'm setting up an interface that will serve as a dashboard to show my time overall client financial info. I used rollups so all the data would be in one table which will allow people viewing the dashboard to only use on filter to filter by client. The only problem I'm running in to is I would like to have the interface say "The client was last invoiced on RECENT DATE" I tried using a max() formula in a rollup column. The problem I'm having is that it's returning 2/29 as the most recent date when I have dates from this week, first week of March. How can I make sure it's actually showing the most recent date?

If there are options in a drop down menu (example Quiz or Test), start dates are entered by user, can I add a new column with a formula that detects the word 'quiz' or 'test' in the previous column and add an end date automatically based on the word? A quiz is 3 days after start date and a test is 6 days after start date for example. Appreciate any insight.

Hi, I am having trouble connecting to the Airtable Library from Google App Script. Google App Script is asking me for a Script ID but I don't seem to be able to find one. I am also confused by the replacement of the Airtable API with PAT which I equally am unsure how to use. Any help would be very useful. I am a bit of a novice. Sorry.Ultimately, I simply want to copy some data from a Google Sheet into one of my tables.

Hi there! I'm fairly new to Airtable, so sorry if I'm asking something that is too obvious.I'm thinking about building a prototype for a tool where I use Airtable to store Data via forms, the idea is that the users can "create" a color by giving the values for RGB or HEX, they get a preview of the color and after they commit, the color is stored with the record. It should be a DB of materials for Architectural Visualization, so these colors are the base to configure a material.Is it possible to do something like this with Airtable or I'm in the wrong place here?

Hello,I have an automation set up to remind salespersons that an incoming job is scheduled and ready. Everything works except when I try to send the automated email the Salesperson field is not inputting their email and the configuration is not allowing me to select email. Please see attached. As you can see.. in the Account field I have a valid email  

Hello,I am trying to set up an automation where if the invoice number column of a record in the "Payments received" table matches the invoice number column of a record in the "Invoice" table, it will update the "Invoice" table record with a checkbox.