Ask the Community

HelloMy company builds complex machines with many parts. A lot of these parts, I need to buy and keep track of delivery dates and whether or not the item has been deliverd.What is the best way to set up an airtable to show all the delivery dates for all items across all my projects?If possible in one interface?Lets say I have three projects running. I need to be able to quickly manually add products to any of these projects and see all delivery dates in one calender so I have an overview. But I also need to see each project seperatly Do I create seperate tables for all these projects? (this may lead to many tables)Best practises here?

Hi All,I'm working with an Interface displaying crew scheduling data and have hit a roadblock.Current Setup:I have a button in the Interface.When clicked, it triggers an Automation that identifies crew with new/updated schedules.It then emails these crew members a grid of their updated schedules.Desired Feature:I've been asked to make the emailing department-specific. In other words, when the button is pressed, emails should be sent only to crew members from selected departments.Challenge:I thought about adding filters to the Interface to narrow down which records are to be emailed. However, from my understanding, Airtable automations allow only one record to be passed via a button click. This would mean sending each record individually with every button press.An alternative I considered was creating an Interface form. The user could define their parameters on this form, and upon submission, the automation would recognize and act based on these parameters. However, this would entail th

Back in 2020, during the throes of the COVID-19 pandemic, Airtable decided to launch a relief program for organizations that were helping with relief efforts, providing a free Pro account. I applied for our organization and we were accepted. When I asked how long we would have the benefit, I was told by the staff that contacted me that there would be "no time limit". But last week I received the following email:We’ve made some updates to our Airtable plans and will be rolling the changes out over the next few weeks. As a part of these plan changes, our Pro plan is becoming the Team plan, built for teams creating custom applications to support their shared workflows.You are currently on a free Pro plan as a part of our COVID relief program, which we put in place in 2020 to help businesses stay connected through the changes brought on by the COVID-19 pandemic. While we are so glad to have been able to provide this offer over the last three years, the time has come to retire our COVID rel

My automation runs when a form is submitted. This form includes two pre-filled fields: Asset Name and URL Location that are located in the Assets tableThe form resides in the Updates table, and when the form is submitted, whatever value has been added to the URL Location on the form successfully updates that value in the URL Location field in the Assets table.Now, I want to modify the automation so that when the form is submitted, it will also update the Asset Name field in the Assets table. But I am unable to fiddle with the pre-filled Asset Name value in the form, like I can with the URL Location value. I think this is because the Asset Name field in the Assets table is the primary field. I can easily change the name directly in the table itself but can't figure out how to do this through the form.Any ideas are most welcome.

As part of my workflow, I have a view in my base where I put in all my tasks for the day, which the populates my calendar. To make this work, I have "Date Start" and a "Date End" fields with the date and the start/end time of the record so that it'll be placed correctly on my calendar. This works great but has caused an issue with creating another view that I need, a daily summary.I want to have a view that groups my records by date so that I can see how much I earned that day, how much I worked, and other stats. I can filter my records to show me this information for a single date without any issue. But I'd like to have a view that shows all my days work grouped together to be able to build a few extensions around the resulting data. The problem is that AT will group based on the entire field information, so including the time, and not just the date (see attached screenshot).The only "workaround" I can think of is to have a third date field with just the date, but this feels redundant

Hi,After the great deployment of interfaces for iPhone I have created an interface that I use with my iPhone.I'm finding problems when completing numeric fields, when I want to introduce a number for example 15.25 after I introduce the first number the field autocompletes super fast as 1.00 and I have to be racing agaisnts the time here.Am I the only one having this problem? 

Hi, I have invited a read-only user to an Interface. There are many read-only users added to it and ideally they would not know what other users have access to it.If a read-only user navigates to the lower left corner while being on the Interface there's the Share button which can take you to the Manage Access tab and it provides an overview of all users.I have the workspace sharing setting 'Restrict adding new collaborators to this workspace, its bases, and its interfaces' on. 'Restrict Interface Sharing' is also turned on in the Interface settings.I have the 'Team' plan for the Workspace. Is there a way that I prevent read-only users from sharing the Interface and seeing the users?Thanks!

Hey, I have a problem with a repeating group, it does not accept my script as input source. // Load and filter table const table = base.getTable("Contact List"); table.selectRecordsAsync({ fields: ["First Name", "Last Name", "Title", "Email", "Phone Number", "Organization", "Address", "City", "Region", "Country", "Zip Code", "Marketing Consent", "Tags"] }) .then(queryResult => { const queryRecords = queryResult.records.filter(record => ( record.getCellValueAsString("Marketing Consent") === "true" && (record.getCellValueAsString("Tags") === "Fliese des Monats") )); const dataArray = queryRecords.map(record => ({ "firstName": record.getCellValueAsString("First Name"), "lastName": record.getCellValueAsString("Last Name"), "title": record.getCellValueAsString("Title"), "email": record.getCellValueAsString("Email"), "phoneNumber": record.getCellValueAsS

I would like to gain a better understanding of how the integration with Outlook works, specifically the aspect concerning the creation of new records upon receiving emails in the "Task" folder.I've set up an "Integration" that generates a new Task when an email is received in the "Task" folder. The integration seems to be functioning correctly, but I'm a bit puzzled about one thing. It appears that when I move a very recent email from the Inbox to the Task folder, the integration is triggered. However, if I move an email that's a few hours old from the Inbox to the Task folder, the integration seems to ignore it.Could someone explain the circumstances under which the integration is triggered? What specific conditions need to be met for the trigger to activate? This clarification would greatly assist me in using this feature effectively.Thank you for your assistance and support.

Our client uses Trybooking for their attendees when the purchase promotional material. There is currently no way to export the data CSV to Airtable except for downloading it manually. We have over 500 records that are going to come through - so manually downloading the CSV in Trybooking, and uploading the data into Airtable daily, is too time consuming.I have the API for the Trybooking event and it says it's able to be used to "extract your data to external sources.". Is there any way to get the data to be sent automatically to Airtable? Unfortunately, Zapier isn't an option. I'm a complete programming newbie. Any help would be appreciated.Thank you!

Work with print media plans and I have an Excel workbook I've used for years to calculate costs. There are many variables with cost calculations and I will stay with this workbook however I'd like to export the final costs for each publication at each page size for import to Airtable to automatically calculate the costs based on each buy. Most buys consist of two components. A full page ad and a small page that accompanies the ad for legalese. Attached is screen capture of my media planning table and costs table with how I am trying to map costs. Is what I'm trying to achieve possible and/or is there a better way? I tried searching for a solution first and could not locate a similar request so if you know of link to send me to that would be great. Thank you in advance. 

We are a land surveying firm with records for each project.  Each record contains latitude and longitude information so we can map the records for logistical purposes.  It would help us to know when we take a new job if we have done a previous job within a 1/2 mile or 2640 feet of the new record.  We could build off of our previous work.  Does any know of a solution for a problem like this using a zap or other app in conjunction with Airtable?  I have seen several posts about converting addresses into lat/longs or vice versa, but that does not solve my issue.  Appreciate any wisdom or guidance someone might provide.

Hey Everyone, Can anyone spot where I'm going wrong here?!I am trying to add multiple values to a multiple-choice field:const YesVotes = ["Adam", "Bob", "Charlie"]; const YesArray = []; for (var i = 0; i < YesVotes.length; i++) { YesArray.push('{name: ' + YesVotes[i] + '}'); } console.log(YesArray);So the console log is giving me what I think I want:["{name: Adam}", "{name: Bob}", "{name: Charlie}"]But the function output.set('YES Votes', YesArray);Is not making the change to the YES Votes column of my table.

What does it mean if a dependency is categorized as "Fields" (as opposed to View configurations, etc.)? What triggers that type of dependency?

Hi,When I right-click on a row and select "Send record," can I format the resulting email?Do I have any control over the content shared?Thank you

Hello community I am having issues with a table of mine. I run a trucking company and have a table to calculate my estimated expenses down to a per mile bases. So I assign expenses and revenue to certain cells and it help generate my CPM. Although I am have an issue that is making things more time consuming. When I assign and revenue or expense to a cell it does not remove the item from the selected field of available expenses or revenue. Any suggestions on how to solve this issue? 

Hello, i am trying to create users on Softr solution with their api script, i tried to put in a script on airtable but it show me an error. I need to integrate records data (name, email etc.) here is the code : curl --request POST 'https://studio-api.softr.io/v1/api/users' \ --header 'Softr-Api-Key: F00xq00gpZf8TLCFYsbsSa7CzRO' \ --header 'Softr-Domain: app.softr.app' \ --header 'Content-Type: application/json' \ --data-raw '{ "full_name": "NAME-FIELD", "email": "EMAIL-FIELD", "password": "12345678", "generate_magic_link":true }'```

1. Get webhook link from Zapier2. Add input variables you want to push to Zapier3. Check the code to incorporate variableslet url = "https://hooks.zapier.com/hooks/catch/10801604/3u5d4q0/?projectID="; let config = input.config(); await fetch(url + config.projectID + "&recordID=" + config.recordID + "&lat1=" + config.lat1 + "&lon1=" + config.lon1);​ 

Hi there,I'm working on an overview to determine the workload/capacity of my online marketing team. In Airtable I have 3 different tables:A table with our clients. This consists of multiple columns of data, but for this question only the client name is relevant.A table with all the individual tasks made up as rows. A task consists of a link to the table with the client names, the service we provide (SEO, SEA, Meta, CRO etc.), the amount of hours we have for each task, a link to a different table that contains our individual team members so we can link each row/task of data to a specific person, a multi select column containing each month of the year since some tasks run for 1-3 months while others apply to the entire year, and a multi select column indicating if it's a monthly recurring or a one-time task.  A table with our team members. This table has the name of our team members as rows, a column with a formula that pulls in the sum of the total amount of hours from recurri

Hello. Currently I am using Airtable free version with Softr free version to run an webapplication. Now with the new pricing plan of Airtable, will I still be able to connect my Airtable base with my Softr application if I stay on the Airtable free version?

I am aware there is no way to "overwrite" data but I'm trying to figure out how else I might accomplish what I need.I have a very basic 2-table base.  Table 1 is "Call Log" and Table 2 is "Users".  I want to set up a default set of fields (location, type, job) that apply to specific people.  For example, "Bob" might default to Ohio, Office, Data Entry, whereas "Linda" might default to Kentucky, Warehouse, Stocking.  But as I do the weekly logs, their job scopes and locations might change.  If everything is added to the Call Log table from lookups (pulling the defaults) I know I can't directly edit them.  What would be a best-approach (I'm not against some scripting or automations either!) on handling when I maybe want to track that Bob is in Indiana and Linda is in Ohio.Thanks!

Hi All - I'm struggling with creating calculations on the base shown below. What I'm trying to do is calculate the % change in total enrollment growth by 1YR, 5YR and 10YR between Fall Years for each university (it would be a changing calculation with each new Fall Year record added for each university).While this is easy to do with a vlookup in Excel (i.e. matching University, Fall Year and Total Enrollment with Fall Year-1, Fall Year-5, Fall Year-10), I'm struggling with a finding solution here in Airtable.I'm feeling like it might require a linked Lookup table (or adding another field) to make it work. But just not sure how to go about it. Or, if it's even possible between records in Airtable. The numbers shown below for the % growth fields were imported from Excel. Any help would be greatly appreciated!Thanks! 

Hello, I have created a sign-up form in Airtable for our nonprofit. When the form is submitted, I would like to have that email, first name/last name contact record added directly to a Google Group. Is there a way to do this directly from Airtable?I have found work arounds with Zapier and Make, but would prefer to do it directly. 

Hello Airtable Community,Please, we have a problem when an automatic email is generated while reading the records from Table/Base. The numbers in the body of the email are returning differently from what they are placed in the Base. It looks like a bug during conversion since the screen preview is correct !!! Happens with date format and also values.I ask for help.Thanks in advance.

How many new records can airtable handle at once.Submissions from Gravity Forms to Airtable