Ask the Community

Good day We are looking to incorporate our finance weekly tasks and monthly tasks in airtable for the 52 weeks of the year. Every day there are deliverables. We report our meetings weekly on our output. How do we go about incorporating this into Airtable? I have tried the project management tool available but the problem is once the month is finished I need to edit the deliverable dates every month. 

Hi!I just created a form using the newer form builder for the staff to use to submit expense reports, reimbursement requests, etc. All staff have editor permission on our "Expenses" base, where the form populates to. When the staff opens the form, there are buttons along the top of the form that allows them to navigate home, edit the form, or view the data (see picture attached).Is it possible to remove these buttons without changing the staff permission levels? They still need to have editor-level permissions so they can engage with the base in other contexts, but I don't want people to be able to easily or unintentionally change the form or edit the data.

Hi!Really need help, tech support didn't help me.When I click "create record" and want to enter data that I don't have in another table, I want to see a button to create a new record, but I don't have it and I don't know how to make it.I think you will understand everything when you see the two screenshots below.In the "base" mode, the button to create a record is there and when the record is already created, the button is there too.

Hi all, I have a csv file with a column that contains the name of the project associated with the client. So I have a csv file with 2 columns: customer email, project name. I have to import this file into the customer table on Airtable where the “merge field” is the email and the project name must be inserted in a multiselect field. The problem is that many customers already have projects in their multiselect field and doing this import is all overwritten and only the last imported project remains. So the question is how is it possible to import (add) new values in “multiselect field” without overwriting the already existing values? Thanks so much everyone for the help

Hello everyone, I have been greatly enjoying Interfaces, what a wonderful tool, thank you ! However, I don’t understand if and how I can delete a record from inside an interface. For example, I have an interface that is a record list. Above that record list I put a button/link to a form associated with the table from the record list, so that I can create new records. But I don’t understand how I could delete records from inside the interface. For now, I’m going back to my base with grid view, I have to find the record, right click and delete. Not the most efficient. Is is possible to delete a record from inside an interface? If not, did any of you find a decent workaround? Thank you, Ray

Is there currently a way to change the order of forms in the "Form" section of an Airtable Base? Similar to how you can move and group views, automations, and interfaces in their respective sections. Currently it appears that forms are just listed in the order of creation with no ability to group or reorder for ease of viewing on the back end.

The map app works when I am working at table level.When using share or Interface, changes to the Filter do not update the map.Suggestions?

Hello everybody,I am experiencing issues running an automation script. Basically, I have created an automation that sends information to a webhook link. My issue arises during the step where the information is sent to the webhook link—I am encountering challenges here. I created one variable, which I then implemented in the code using the configuration provided by Airtable, but it does not work as expected.What happens is that if I run the same script without the variable, it works, eventhood i use thes same script for the variables (see attached photo). To sum up: it’s the same script in both scenarios. When the variable is present in the left column, the script does not work. However, when the variable is not present, the script functions correctly.

Hi there,I'm documenting a base I'm building. So I'm wondering which identifier quoting characters to consistently use to refer to bases, tables, and fields.I'm hesitating between backticks ``and curly brackets {}for fields, and I'm at a loss on what to choose for bases and tables.Any idea?Thanks.

Hi guys, We're building an internal app on Airtable. We would like to know whether we could white-label the app, namely can we change the domain name used in the app URL? Thanks.

Hi there,I need to create 3 forms that are pretty much exactly the same, but the link for each is inserted into a different flyer which is going to three different groups of people - each form is then linked to an automation which will catagorise the respondent for us so we know which form they have filled out. The problem is the 3 forms need to have exactly the same display name, but I want to differentiate them by name in my base view, which I am unable to do at present. Does anyone have a solution?Thanks!

Hello there is some way to totalize an entire column in another column or in a cell. Thank you very much

How do i create a field or metric that shows the time it took to complete a project. for example, tracking the difference from the start date to the date when the project was marked as complete or from in progress to complete. I want to ignore all the other statuses e.g. not started, blocked etc.Is this possible? Reason i ask is to track this in a dashboard for average project completion time.

I would like to get parameter from URL?Is it possible to get with script or automation?

I have a base that has multiple tables for planning our annual conference. We collected proposals using a form view (Call for Proposals table), which includes fields for speakers (Speaker 1 Name, Speaker 1 Email, Speaker 2 Name, Speaker 2 Email, etc).    I am using FillOut for outside folks to update their submission. I am trying to pull the data for all speakers (Name and Email) into one streamlined table (Speaker Management). So how do I get Amy, Jessica, Miranda, Kristy all in one field with their email in another in a new table called Speaker Management? It should automatically update if changes are made to the original fields in Call for Proposals. This was there is always an up to date list of who our speaker contacts are. I tried Sync - but it won't let me do it on the same base. I am trying linked records, but that is still pulling the data into individual lists (Speaker 1, Speaker 2, etc). Help! 

It would be nice if you could make an item on a calendar appear taller/larger like how you can with rows in a grid. Is there already a way to do this?Example below, would be more readable if the items were larger especially if toggled in the week or day settings 

I've created an interface for my team that displays a Gallery of active projects from our Projects table.  I want them to add/remove projects from that interface without having to go the the data.  The option to "Allow users to add/delete records inline" sounds great, except for:The popup looks like a form, but there is no submit and the new record is already created.  Confusing.Where do I go to delete the record?The pop-up only shows the fields I chose to display in the Gallery, I really want all fields.  Otherwise, the user has to create a new record with a few fields and then re-edit it to see all of the fields.I've hacked my way around #2 by adding a Button to the detail page that deletes the record.  Not great, but OK.My hack for #1 and #3 is to replace the option with another button that has a hard link to a Form I created.  That form then has a hard link to redirect back to the interface after waiting a minute.  VERY CLUNKY.Is there a better wa

I can't seem to get labels to appear on my scatter plot even when hovering over the points. I am trying to plot leaf length and head weight for varieties, I'd like to be able to label the points with what variety they represent.

Hi guys, I'm building a CRM on Airtable. That CRM has a form to add new contacts. This form boasts 2 linked record fields: a `Contacts` field and a `Main Contact` field. I would like the `Main Contact` field to be dynamically filtered so that it displays only the contacts that were previously added by the user in the `Contacts` field. I've been trying to get this, but with no luck. I don't think that's possible as of yet in Airtable. Do you confirm this? I know I could execute this with Fillout, but I'm trying to stay within Airtable as much as possible.Thanks.  

I want to link Apollo to Airtable so I can people search from within my base.I got the Apollo organization data working with the code below to fetch company details:let apiToken = 'API KEY HERE'; let table = base.getTable('TABLE NAME HERE'); let { records } = await table.selectRecordsAsync(); console.log(records); for (let record of records) { let domain = record.getCellValue('Domain'); let response = await remoteFetchAsync(`https://api.apollo.io/v1/organizations/enrich?domain=${domain}`, { method: 'GET', headers: { 'Content-Type': 'application/json', 'Cache-Control': 'no-cache', 'X-Api-Key': apiToken } }); let data = await response.json(); let organization = data.organization; await table.updateRecordAsync(record.id, { 'Company Name': organization.name, 'Linkedin URL': organization.linkedin_url, 'Address': organization.street_address, 'City': organization.city,

Hi guys, I don’t know if the title is clear. So here’s some context. I am currently using Airtable as a CRM. Thus, I have 3 important Tables : Leads, Unpaid Leads and Clients. As of now, people can pre-subscribe to my service (not open yet). When filling the form, they will go to “Leads”. Once the service will open, I will manually validate them to send them a form for Subscription. If they fill the form, they will go to “Unpaid Leads”. If they do not, they will stay in Leads and receive a followup at D+3. If they do fill the subscription form, I’d like to erase them from “Leads” in order not to follow up with them if not needed. Do you know if there is a script for that ? Or anyway to work around it ? If there isn’t, is there a script that can help me update the status in the 1st Table when a form is submitted in the 2nd one ? PS: FI, I first wanted to keep everything in the same Table ‘Leads’ until they became clients but I need more info between pre-sub. and sub. and I couldn’t fin

I am building for the following scenario and need help to understand a few things1. I have a master table that has the main data (Name, Email id, etc) 2. There is another table with a field (Name) that is linked to the name field in the master table.3. I designed an interface to delete a record from the master table. 4. Now when I see the linked field in the second table, it has disappeared as it should be. However, the entire record does not get deleted. 5. So currently I have added a check column in the second table to check if the Name field is present or missing and am running an automation through Make to delete the entire record for the second table.I wanted to know if this is possible through airtable automation itself instead of creating an automation through another tool. Also if this is possible to run the automation through an interface. Thanks

Hi. Thanks in advance for any help.I am importing a  CSV file out of another application that exports a field in a currency format. ($X,XXX.XX). I've created a currency field in Airtable to import it into, but AT always ignores it.So, I ended up exporting to Excel, changing that field to a number without a dollar sign and that allowed me to import it into the AT currency field.  However, I'd like to avoid this step and go directly from the exported CSV into AT without messing with Excel.I assumed this meant that Airtable wasn't recognizing it as a currency or number and wouldn't move it into the currency field. So, I thought I'd create a text field to import it into, then create a formula field to make it what I need it to be, but it won't import it into a text file either.Not sure why this is so difficult for me.  Any ideas welcome. Thanks again.

Hello all, I created a form, and one of the field values needs to be "1" as the default value. However, I need that hidden so that when someone goes to submit data, they don't have to fill that field in as "1".Now this is what I have:I tried hiding this field from the form options listed, but when I go to submit this form - it doesn't display a "1" in the field value on the table view. I also tried this method on the table view:When I go to create a record on the table view - it does default the value to "1", but on form submission - it does not. Any idea what it is that I'm doing wrong?Thanks. 

Any way to clear all records or delete a table through script?This don't work:do{let table = base.tables.pop();console.log(`Goodbye, ${table.name}!`);}while(base.tables.length>0)