Ask the Community

Hello,We are having problems with some of our clients where they can't add records via the mobile app.The "+" button works once and then it becomes not clickable unless you exit the base and re-enter it.My clients are using Samsung Galaxy S9 and A (something).

Hello all,New to Airtable and I'm trying to build a product costing and BOM system.I have worked out from searching for posts on this forum that I can split a Lookup cell based on text using the following IF( FIND(",", {Product Costings}), LEFT({Product Costings}, FIND(",", {Product Costings})-1 ), {Product Costings} ) But when I try to use this same formula to split the cost cells it doesn't seem to work.I basically have a 'Total Cost' column which is currently filled with £0.70, £1.00 and £0.11I want to split these into separate cells as I want to specify quantity for each value. For some reason the above script will not work for numericals, and it just lists the full 0.70, 1.00, 0.11Is there something I need to change to make this work? Or are there any other alternatives?What I want is -Kit Row - Combined Individual products that make up the kit - Number of each individual product needed to create the kit - Price of each individual item - Total price of each ind

Hi community, I have set up a trigger that loads a record and passes on linked records values to a script supposed to order those by date from earliest to latest. I'm struggling to get this to work, can anyone advise? Thanks!const inputConfig = input.config() const linkedRecords = inputConfig.linkedRecords linkedRecords.sort(function(a,b) { var c= new Date(a.date).getTime(); var d= new Date(b.name).getTime(); return c-d; }) output.set("linkedRecords", linkedRecords) 

HiI am busy making an airtable for a logistics business. I think the user interface (with nested lists) and overall simplicity is really great and we can see ourself using this as our primary toolHowever I am worried about the record limits. We estimate to have around 500-1000 orders per month when we are fully up and running. Each order contains several shipments (on average 1,5) and each shipment contains at least 2 shipment jobs (pickup and delivery). So we will have to plan to add around 6000-8000 records per month. After a couple of years we will reach our limits.  My idea to handle this is to mirror the airtable base to an sql database or possibly firebase (but I am not a developer and have no experience with object databases. Have some basic knowledge about SQL though). So then we will have customer portals and an admin for looking long back in history directly linked to the SQL base and the internal app for operations within Airtable inte

Hi,  I am trying to clean up info from online forms we receive from another company. I need to extract the mobile numbers so that I can automate the contact process as CRM.Anyway, I have a reference column with the name "message". In there is text as follows: Gender: maleFirstname: BrianLastname: DawsonEmail: brian@valuesystems.com.auStreet: Albert DrNumber: 73ZIP: 2071City: SydneyCountry: AUPhonenumber: +61418212496OR AS FOLLOWS:Street: Ponderosa paradeNumber: 8/13ZIP: 2102City: WarriewoodCountry: AUPhonenumber: 0450294193All i want to do is generate a result of a standard australian mobile number to look as follows: All australian mobile numbers are 10 digits... So i would need to convert the +61 prefix to 0 as well...0450294193Please help... I have tried this all day and get close, but not reliably so! Current formula: (MID(message,FIND("04",message,1),10)) Thanks!

Hello, I am stuck.I have a table that I upload a csv from my databaseThe table has records (all records have a unique GuestID) that are either the parent record (field name GuestAccountOwner is equal to true)Or a child account where GuestAccountOwner is equal to false and GuestAccountID is equal to the GuestID of the parent record.I am trying to output in a new table on one record for each parent, but combining data from both parent and child. So the record would have the ParentName, Parent Email, ParentPhone but on the same record there would be Child1Name, Child1DOB, Child2Name, Child2DOB. Based on the DOB of each child there would also be a Child1BirthMonth and Child1BirthYear, etc for each child as well.Basically the automation has to go through and find the parent records, count the chidren and put it all on one line, I can either have all the fields ready with that naming convention or it can be added on the fly.Is this possible?

I'm trying to update a Google Sheets script that syncs an Airtable Base to Google Sheets. The script uses an API Key and I need to update it to use the Access Token.Anyone know how to update this code to use the Access Token instead of the API Key? Thanks! var api_key = "API KEY";var baseID = "BASE ID"; var tablesToSync_fromSheetRange = "A14:B16";////////// add items to UI menu ///////////function onOpen(e) {   SpreadsheetApp.getUi()       .createMenu('Airtable to google sheets sync')       .addItem('Manually sync all data', 'syncData')       .addToUi(); }////////// function to trigger the entire data syncing operation ///////////function syncData(){  //fetch table names from the control panel of the spreadsheet  var ss = SpreadsheetApp.getActiveSpreadsheet();  var tablesToSync = ss.getSheetByName("Control panel").getRange(tablesToSync_fromSheetRange).getValues();      //sync e

Hello,I'm trying to design a database that can accomplish the following:Aggregate data across several different entities (for example, cities).Aggregate data for each entity across different time periods (for example, years).Aggregate data for each entity and time period across multiple metrics (for example, (a) population; (b) property taxes collected; (c) median home value).I want to be able to use the Interface feature to design a table to review city-level metrics (rows = population, taxes, home value, etc., columns = 2020, 2021, 2022, etc.) with a drop-down chooser for selecting the appropriate city (New York, San Francisco, Chicago, etc.)Is this possible with Airtable? It's the time series element that I'm having trouble figuring out when constructing my base. Any help much appreciated.Thanks 

Hi there,I'm looking for some help with improvement of a "Work on Today" field.The field we have currently is a checkbox for each colleague--each person has their own "Work on Today" checkbox with their name marking their field. In a view of my tasks on the base, I have it grouped so that when I check my "Work on Today" box, it will automatically then show that task (along with any others I have marked) at the top of my view.It works great as it is, however, we have more colleagues now and it would be great to have a single field for all colleagues that had the same function as the above one. However, I cannot get one to work in the same way because of groupings/filters.Initially, I thought a "Work on Today" multiple choice field would work as each person could select their own name when they were working on a task that day. The issue with a field like is that the view can't function in the same way. If a task a colleague and I are both working on is marked by that colleague as "Work o

Hi, i’m looking for a script or automation of airtable to put my table into a csv file. How can i do it? i found this. how can i download it? // display app title output.markdown('# Export to CSV'); // set the table name let sourceTableName = "Search"; // identify the fields to be exported let aFieldList = ["Name","Surname","Linkedin Link"]; // get the source data let sourceTable = base.getTable(sourceTableName); // get the data set for 2018/2019 let result = await sourceTable.selectRecordsAsync(); // set a counter for testing let count = 0; // iterate across all the records let csvFile = ""; let csvRow = ""; let csvItemCount = 0; for (let record of result.records) { // build the current csv row csvRow = ""; for (var i in aFieldList) { csvRow += record.getCellValueAsString(aFieldList[i]) + ((i < aFieldList.length - 1) ? "," : ""); } // add the row to the file csvFile += csvRow + "\r\n"; csvItemCount += 1; // increment the row coun

I have a field that contains people’s heights in centimeters. I’d like to create an additional field that converts those heights to feet and inches, specifically using the format #’#". The conversion part is easy; to get from centimeters to inches, you simply divide by 2.54, after which I’d want to round to the nearest inch. It’s the formatting part that I’m hung up on. For example, 175 centimeters converts to 69 inches, rounded to the nearest inch. But how do I force 69 inches to display instead as 5’9"? Thanks in advance for any help here!

I use Airtable for my property managers to update all of their respective property statuses. i would like an easy way to see when the last time they have updated their tables (should be every day). what’s the best way to accomplish this?

Hi there!Hope everyone is doing great! Remind to drink water 🙂 I'm working on a project to connect two different users (not the same table).I want to set up an automation to match records by using two records, geographical area and interests.Let's first try by doing matches with one field.I have two different users :Our client : they want to meet people from France, USA, Italy, Brasil (for example).Our Partners : usually from one country.Both of the country fields have same naming convention and are both a Multiple Select.I have created a specific table "Matching Table". On an interface which is a little CRM for our clients, I created a button to create a record on the Matching Table.Once the record created in the matching Table (here is the automation I try to create) I want to add Partners records (Link to DB Partners) to the record created for the client.The problem is that the matching doesn't works, looks it stop every time he doesn't find a record to match with.Can s

I am designing a base for tracking participation in a weekly Food Box.I am trying to organize the data in such a way that I can track the number of people who've selected a certain type of produce for any given Food Box Day.  Ultimately, I'd like to be able to create a pivot table in my dashboard interface along the following lines:Produce5/1/245/10/24Basil20Cilantro11Cucumbers11Celery01I have a table for Food Box Days which includes a record for each date.  Separately, I have a Food Box Participation table, which includes a record for each person signed up for each day.  In the Food Box Participation table, I am using a multi-select to record each person's produce preferences for each Food Box Day.  The table looks like this:IDPerson NameFood Box Day (linked)Produce Preferences (Multiselect)1Bob5/1/24Basil; Cilantro; Cucumbers2Judy5/1/24Basil3Jane5/10/24Cilantro; Cucumbers4David5/10/24CeleryI've tried creating an intermediary Produce Preferences Table, which h

Hi, I have two dates in my base, one is manually inputted, the second is linked from another tab. The date pulled from another tab is the most recent date and we need this date to replace the manually inputted date so we can track most recent updates. I've tried creating a new column that merges these dates but that isn't working. I don't know what I am missing.I attached that it looks like not sure if anyone can help. Thanks in advance for reading this!Sam

Hello. I've been studying airtable lately.I'm trying to express a sheet in Excel with an airtable, but I want to create a cumulative balance field, but I don't know how.Is there any way to find the balance of this row after adding or subtracting this row's income or expenses from the previous row's balance? Please advise.

Hello,I have a very simple request.I simply need to generate a formula to compute the first and last name of my contacts.However, as simple it is, I do not have the text format in the formatting bar. Only Number, Currency, Percent and Duration.Then it is impossible for me to create the basic field {First Name} & {Last Name}Is it possible to allow the text format anywhere?Thank you very much for your help.Franck

I'm trying to show the graduation rate  and drop out rate of program participants in a dashboard. We used to track both in separate fields to using the percent filled under summary type, but both fields were recently combined into one. I tried to find a way to show an accurate percent of graduates and non graduates with both being under the same field, and have been unable to do so. Is there a way to do it? If so, what is it?I'm trying to show this as a straight up number, and not in graph form. 

How can I make it so someone can add drop down items to a field but not be able to delete,rename,access specific views? Seems like this permission system needs to be more complex bc I’m finding that I have to give up a lot of control to simply manage a table/view or add new rows. I feel like there should be minimum one more level where I can create a user to manage rows and specific fields but not delete/rename views. am I missing something? 

Hello All, I am new to Airtable & have searched but could not find a solution to my query. My table has the following fields (and a couple of more). 5 days before the due date, I send myself a reminder mail. And, this seems to be fine (preview tells me it is fine). The issue is the format of the due date. I want the format to be 22-Jul-2022 but the email shows 2022-07-22 I used the formula in the email, but it is treated as text in the email. I created another field (column) with my kind of format and the column shows the format, but when I reference this column in my email, the content is blank. Can you please help me? Best, Vikas

Hi,I have paid for the team plan because I need the automations.And I have questions:1. If I want to add employee to the workspace, I need to pay for his user aswell?2. If I want to hide from the employee certain tables, views and dashboards, is it something possible to do with airtable? Thanks.

I am trying to set up a basic template for managing about 20 small construction projects. I have a table with records for each project and a separate table for all the various tasks that could apply to each project. I can't figure out how to link the various tasks to MULTIPLE projects while also tracking the status of the task within each separate project. Below is a simple example (in reality I have a list of ~50 tasks) of the way I'd like to be able to track tasks in EACH project. Project A tasks:-solicit bids (complete)-draft contract (in process)-hire sub (on hold)Project B tasks: -solicit bids (in process)-draft contract (on hold)-hire sub (on hold)Thanks in advance!

Hi there,So interfaces seem really helpful, but I essentially can't use *any* of them, because it appears they consume from the 5 request/second per base rate limit that currently causes *all* interfaces to fail.  This is because we have many automations already accessing the base, accordingly.Can someone from the Airtable team comment on whether this is intentional?  I was hoping the interface designer used a different API rate limit quota than for my backend automations, but it seems that's not the case.Thanks!

I have a form for inputting contact and basic account information for new sales (form 1) - when the form is submitted, it sends a survey that the customer needs to fill out (form 2).Depending on one of the fields from form 1, form 2 can be one of five different form views (specific questions and information are pertinent to specific account types).I currently have a nested IF function and hardcoded URLs for the five different forms - is there a way to make this connection dynamic instead?  Concern would be something like, if a sixth account type was created it breaks the workflow.

We track inventory and want to be able to show our inventory based on where it is located geographically.