Solved

Organize everything with view sections Once you start building out an Airtable base, the number of views (like the new Gantt view ) can quickly multiply. To help better organize all of your views we’ve created view sections to enable base creators to organize views into collapsible sections. This provides a new way to manage your views - especially for bases that take advantage of all the different view types, including collaborative, personal, and locked views. Utilizing view sections will allow you to easily find and take action on your views while keeping your view experience organized. Learn more about view sections in this support article Hi, All “Organize everything with view sections” Tools disappeared from my UI ! On each and every Base, even after hard resetting my computer ! Am I the only one to know this issue, both in Firefox, Chrome and on two different MAC OS & Devices ? Thx, olπ

Hello community, I’m trying to average geographic coordinates. First I split the coordinate into lat & lon fields, for example: 41.3310413 and 19.7828039 In Google Sheets I’m using average() with correct result In Airtable the rollup with average() fails with NaN Does anyone know another way of averaging coordinates? PS: Also tried to remove the dot with SUBSTITUTE(Lat,".","",1) but am getting an error.

How do I use the REST API to delete ten records at a time using axios? I can successfully delete one record at a time, but due to the API design, I am having a problem constructing the URL to delete ten at a time. Here is what works with one record at a time: I am using a library in Node.js called axios to do HTTP method calls, and here is the call that works: await axios.delete(url, {params: params, headers: headers}) .then(async function(response) { console.log('DELETED:', response.status, response.statusText); }); I define params this way (I have a method call that returns the params to send to axios) params = await getParams(rec); // rec is the Airtable record identifier like: `rec async function getDelParams(rec) { const params = { 'records[]': rec // rec is like: rec5GWL8xCpofFKFC }; return params } In this key/value pair, I can only have one entry of : records[] , no more, I need ten. The REST API requires multiple recor

Hi! I saw an article that discuss my problem, but didn’t have the solution. I’m trying to create an automatization that runs a script to copy a field (formula that puts year and month together like this 2021-12) to a liked to field whenever a record is created ou updated. So I found here this solution that requires you to put the field you want to copy as a primary field let dateT = base.getTable('Dates'); let dateQ = await dateT.selectRecordsAsync(); for (let rec of dateQ.records) { let dateFieldID = rec.id await dateT.updateRecordAsync(rec, { 'Date Link': [{id: dateFieldID}] }) } But I can’t make this because I use my primary field to make a resume for my Calendar view title record. Here is a simple example how my table looks like Does anyone solve this or could help me ? (sorry if my English is not so clear. I’m an Brazilian who is trying his best here)

Hello, I have a table where every record has a time field. I would like to check a checkbox when the time is today at the specified time. Using automations I managed to check the box when the date is today but the time is not considered. Is it possible to check the box at the exact time? For example, I have a record that says 12/11/2021 1:00pm. The checkbox should be checked only after 1pm and not at any time of the day. Thanks

Hello, I have a table where all records have the created time field. I would like to add a view with only one record, the latest record created. It needs to update every time a new record is created being always up-to-date. Is it possible? Thanks

Hello, I’d like to count repetitive information only 1 unit and not all time it appears. For example in this image attached. I have 2 REIs and not 16.

I came up with the following formula. IF({Registration date}=BLANK(), ‘’, SWITCH({PLAN}, ‘A’, SWITCH({TYPE}, ‘1’,DATEADD({Registration date},30, “days”), ‘2’,DATEADD({Registration date},30, “days”), ‘3’,DATEADD({Registration date},30, “days”) ), ‘B’, SWITCH({TYPE}, ‘2’,DATEADD({Registration date},30, “days”)), ‘3’,DATEADD({Registration date},30, “days”), ‘5’,DATEADD({Registration date},30, “days”) ) ) ) Depending on the PLAN and TYPE, we want to return the value of {Registration date} plus the number of days. And if {Registration date} is blank, I want the value of the formula to be blank as well (to avoid #ERROR). However, the returned value is not recognized as a date and is displayed as follows 2021-12-17t00:00:0.000z If I remove the IF statement at the beginning, it is recognized as a date format. Is there any way to resolve this?

Hi Currently, I have 3-columns Due date (date field) Overdue (formula) IF(IS_BEFORE({Due Date},TODAY()),“ :rotating_light: OVERDUE :rotating_light: ”,"") Due Now (formula) IF(IS_SAME({Due Date},TODAY()),“ :gift: NOW :gift: ”,"") I would love to see both results/formulas in the OVERDUE column. Then it is not necessary for both columns. That said, I am not finding the right way of merging these two formulas in one field/column. Any help will be much appreciated. Thank you

Hello! I’m trying to find a way to link 1 table to multiple rows in another table within the same base. For example – The first table in the base lists all of our customers (one per row). Another table in the base includes all of the action items that should be done for each customer (they are all the same). Is there a way to link the action items table to each customer, and further, allow for items to be checked off as they are done for each individual customer, without impacting those of another customer? Thanks in advance!

Hi all, I have a requirement for a form to allow a user to input (draw) via touch/pen. This doesn’t have to be a legally binding e-signature so I’m hoping to avoid complex 3rd party integrations. Is there a canvas widget/app that allows a field to capture touch drawing as an image/svg etc? Microsoft Power Apps has a built in “pen input” control - I’m hoping there’s something similar. Thanks in advance! Sub

Hi all, I have a table where I want to have a “Cleared?” formula box that looks up if the current record also exists in a view, “Outstanding items” In plain language, if an employee in “Pre-service” view also exists in the “Outstanding Items” view, place an :x: . Otherwise, if they don’t exist in the Outstanding Items view, place a :white_check_mark: I am thinking the RECORD_ID() formula might work (catching an exception) but I can’t quite wrap my head around how to use it with a specific view.

Hello! I have two tables: “Projects” and “Tasks”. I’m wanting to create an automation to do the following: Trigger: When a record is created in “Projects” table Action: Create value {Record Name} in X field in “Tasks” table Basically, the name of the record in the project table should update a field in the Tasks table. I would like the automation to create a new field value within a dropdown field and the value name should be taken from the trigger record name (i.e. the project name). From what I could see, the only way to achieve this is to have the action be to update a field within an existing record, so I created a dummy record. This is what I’ve created: When I run the test, it shows the field in the dummy record is updated with the project name as expected. But when I go and create a new project record, the automation shows as running successfully, but the field in the dummy record is empty. Am I overcomplicating this/approaching this wrong? Appreciate any help!

Hi All, Relatively new to airtable but learning fast. I have a map app that shows my different types of accounts color coded by type. What i was hoping to do is code a button for each record to go to that specific location on the map app, rather than having to manually search the entire map (US only). is this possible? I’d assume so via possibly scripting or a custom app, but i dont have a lot of experience in this. Any suggestions or even alternative ideas welcome! Thanks!

Hi Everyone! Thanks for you time beforehand and apologies if this case was already resolved in another topic (altough I couldn’t find any similar). I am pretty new to airtable scripting and I hit a roadblock in one of my codes. I need to iterate and create multiple linked records into a table, but my code is throwing me the following error “j: Can’t create records: invalid cell value for field ‘Property’. Cell value has invalid format: .0.0 must be an object. Linked records field value must be an array of objects with property ‘id’ corresponding to linked record id.” I assume this is because I have to put some sort of id in the createRecordAsync function, but I am not sure how the syntax for that should be. Full code: let importTable = base.getTable('Master List'); let importView = importTable.getView('Active'); let importQuery = await importTable.selectRecordsAsync(); let newTable = base.getTable('New Table'); for (let record of importQuery.records) { let recordName = record.getC

For example, say I have a directory with all the employees an multiple levels of managers. Employees report to a first level manager. A first-level manager reports to a second-level manager, who reports to a director. I create a column for who each person reports to as a “parent” column. I want to create a column to shows all the people that report to a person that is linked to the original parent relationship. Is that possible? The purpose I have is different that my example but the concept is the same. Would appreciate the help! -Liz

Hi, Our team has a base with records that include a status field. We have a form for people outside our team to submit job requests. Is there a way to filter a view that only shows records submitted through the form? I was thinking perhaps assign the status “Under Review” by default when the form is submitted and then filter on that, but assigning defaults doesn’t seem to be an option. Is there another way to do this? Thank you and let me know if you need further information from my end. Ed

My goal is to have a DOB field concatenate with a name and calculated age field. Currently the concatenate works fine with CONCATENATE(Child_First,", “,Gender,”, ",Age) = Rohnan, Boy, 10M When I add DOB field I get Rohnan, Boy, 10M, 2020-12-15T00:00:00.000Z How do I get rid of the T00:00:00.000Z at the end? When I use the Date_time format I get gibberish. CONCATENATE(Child_First,", “,Gender,”, “,Age,”, ",DATETIME_FORMAT(DOB,‘dd-mmm-yyyy’)) = Rohnan Boy 10M Tu-000-yyyy What I want to see is: Rohnan Boy 10M 15-Dec-2020

I changed a field view from a normal input cell to a formula cell and all of the data was erased. I need to know how to go back and just undo that change as I worked for several hours on other tasks and I don’t want to undo all of that work just to get that data back. How can I do this please?

Hi all, I have base a certain table with fields “Production method” and “number” as per attachment. (The numbers are imported testdata) The goal/ each production type should get an (auto) number. each production should get the highest number available +1in the field from a certain range. eg. "production-type 1 should get the highest number + 1 available from field "Number. The highest number available must lie in range 30000 to 40000 eg. "production-type 2 should get the highest number + 1 available from field "Number. The highest number available must lie in range 20000 to 30000 When a production method changes value, a new number must be calculated in another specific range. Business wise this should not occur, but might be needed to catch user mistakes I was planning on doing this via Automations. “When record is updated” Or “When a record matches conditions” → “Run script” But I have not much coding experience. Very, very basic. Can this be done via script? Can I get some pointe

I’m trying to put together a form for screening, however I cannot figure out a way to create a formula that would enable me to give an automatic output based on the form response. In short, if someone writes a symptom I want the last column to output a false, or a fail message. I have tried doing this but haven’t been able to. Here you can find a look into the form: And a formula I put together to try to get an automatic output:

Hello everyone, I’m very new to Airtable and also a non-coder. I’m trying to launch a script as an automation’s action, which is pretty straightforward. However, the script I’m trying to launch needs settings to be populated before each launch, ask for a confirmation before launch and therefore the script needs to be run manually. However, those settings are now fixed in my base so i would amend the script code directly to reflect those. I don’t know how to proceed. This script is part of this function : https://www.airtable.com/universe/expK9hEwh5d1IGkH3/splitting-multiple-selectlinks-into-individual-records Here is the code : let settings = input.config({ title: "Create junction table (keep multiselect)", description: `Running this script will populate a junction table that contains every possible combination of linked records from two tables. Both tables must contain a linked field to the junction table being populated.`, items: [ input.config.table("table1", {

is there any way to access a single record via airtable API without using recordID? tried SEARCH() filterbyformula but not working since it is a number field. need to access records based on the SerialNumber. thanks in advance

This ought to be easy. I want to display records on a calendar by a single date field, but the date field for display is calculated: It’s the DueDate if there is one entered, otherwise it’s CreatedDate. IF( DueDate=BLANK(), CreatedDate, DueDate ) Dates in, dates out, right? Nope. A formula field using the above formula cannot be used in the calendar, apparently because the result of the formula is not recognized as a date. Now the following DOES work: DATETIME_PARSE( DATETIME_FORMAT( IF(DueDate=BLANK(),CreatedDate,DueDate),"MM/DD/YYYY" ),"MM/DD/YYYY" ) Seriously? Is there not an easier way to do this?

I’m using a button with “Gmail” & ENCODE_URL_COMPONENT({Email}) & “&su=” & ENCODE_URL_COMPONENT({Subject}) & “&body=” & ENCODE_URL_COMPONENT({Body}) to send an email through Gmail it it works great, but how do I attach a file from an attachment field on the record? I really like the control of a button. I’d rather not use an automation. Thanks in advance!