Ask the Community

I'm making a dashboard from an interface, and when I display a number that is the sum or average of a group of fields it always displays the number with two digits after the decimal. Is there a way to round that number to no places after the decimal?Also for some of the numbers, I want to add a dollar sign to the beginning of the number. Is there a way to do that when the number is using a "Number" field?

Hi, does anyone have any tips on how to create a formula that  would calculate the number of days something was in each stage? We track various stage gates for our content: Draft, Proposal, Ready for Production etc. Thanks! 

When I 'get' look-up or select fields using Pyairtable, they're now coming in as list type objects:  'red' is now ['red']'5/11/24' is now ['5/11/24']The previous behavior was WYSIWYG.  This is unexpected and strange and breaks years worth of ETL scripts that I've built.  Anyone else having this problem?     

Hi there!I'm building out a capacity / utilization tracker on Airtable. I'm trying to build a line graph, using either the chart extension or interface tool, comparing utilization per team over a set amount of time.Each of my tasks has an start and end date -- I'm able to see the sum total of utilization per team by end date (i.e., tasks ending in May or June), but I'd like to plot it based off overall duration as I have some tasks that start in one month and end in another.As in, if I have a task that take 15% weekly utilization from May 2nd to June 30th, I'd like it to show up in my team utilization line graph for BOTH May and June, which will help me show total utilization by month.  Ideally, I could do this by week, but I'm assuming month is simpler. Is there any way I could do this? I'm wondering if I can do a date-if formula to splice out the months that my task is in and then use that as my X axis?Thanks in advance!

I have a lookup field in table A that is supposed to retrieve values from a number field on table B.Some of the values on table B are 0. Currently the lookup field on table A is showing blanks for all 0 values.0 is different than blank. For my purposes, blank means missing information and 0 means 0.How do I fix this? I have a feeling that if I changed the table to a text field it would help, but I have some integrations with accounting software and would rather not do that if I don't have to as it may muddy some other things.

Output:Code:   // 7. Extract and Return *Only* Desired Fields const productData = recordsData.records[0].fields; const desiredFields = { "Collection": (productData.Collection && productData.Collection.length > 0) ? productData.Collection[0].fields.Name : null, "Color": (productData.Color && productData.Color.length > 0) ? productData.Color[0] : null, "Font": (productData.Font && productData.Font.length > 0) ? productData.Font[0] : null, "Product": (productData.Product && productData.Product.length > 0) ? productData.Product[0] : null, "Registration Status": productData["Registration Status"] || null, "Registration Date": productData["Registration Date"] || null, "Release Date": productData["

There is a way to embed the google MAP extension view but I can't seem to find instruction on what the embed code looks like. There is a related question that's been open for several months and I sent a support question and I haven't hear back on the answer. They suggested to search here but I can't find any answers to this. Here's an example that does work on some other site but I can't get this embed code for my MAP view 

Hey there. I’d like to alphabetize one set of records in a table but would like to write a formula that would exclude the word “the” at the beginning when alphabetizing. (I rather not just format as Title, The.) Any possible way to do this, or no, because this is essentially a sorting issue, not a formula/record-naming issue?

Does anyone here have experience with using miniExtensions? Couple of their features (like forms and shared editable view - especially this, looks like it could sold quite a few permission problems we could potentially have with default permissions of Airtable) looks like it could really improve and help with a workflow we plan to implement. But since they are not some well-known names (like Zapier or Integormat for example), or at least we haven’t heard of them before researching Aritable specific integrations (and I don’t mean any disrespect by saying this) my company can be a bit reluctant to depend on some software packages or integrations that we don’t know anything about So, if anyone has experience with using their services, it would mean to hear first hand experience, as they have some really good tools (from the information on their site) that could help us a lot and we are seriously thinking about testing them and hopefully using in our workflow if eve

Hi,how can I create default value to an attachment field?

Hello! I'm hoping someone here is great with automations/scripting/something to help. I'm trying to run an automation every Sunday to randomize work tasks for my team and then send an email or Teams message. I want it to refresh the randomization when this runs at it's scheduled time. I have 6 members, and already have their off days input. The Airtable randomize values extension works for what I'm wanting (and avoids the cells that are already filled with "Off"), but I can't run it on an automation and honestly, I don't know enough about JavaScript to change the code. Their code requires inputs from the extension panel with the min/max bounds (mine would be set to 1,1, which is how it avoids the "Off" cells) AND the specific field to update. Here are my data references:Automation should run every Sunday at 3am (before anyone is logged in.. the time is somewhat arbitrary)Randomize each task excluding "Off"6 member

Why is the form interface different than editing an existing record for selected related/lookup fields in another table? The form interface for adding a new record is very minimal and only shows 1 field while editing an existing record shows multiple fields. Ideally, I want the new record form to show more details so I can filter out the best option. Is there any way to get the new form field to show more details?I've attached the screenshots below to show the differences: Adding new record form Editing existing recordBase details: I have a base with multiple tables that use lookup fields. 1 table for Publications1 table for ReferencesThe References table has a lookup to relate to individual Publications.

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 u

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

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 a

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

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 mark

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; //

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