Solved

Hello!I am trying to create a formula that categorises ships by type, then size category, and if they meet both of those criteria they are assigned a value that is annual fuel consumption appropriate for the vessel's size category. If not, the IF test continues through all size categories and finally ends on "NA" if nothing it true. I would have thought I would be able to nest like the below example, but for some reason it only generates the correct answer for the first two size categories, then everything higher in size gets the same second highest fuel value:IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}<=1000),"XX Fuel consumption value",IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}>=1000<=1999),"XX Fuel consumption value",IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}>=2000<=2999),"XX Fuel consumption value","NA")))Below is the actual formula if that helps anyone understand. I also hoped to be able to have all vessel types an

I have an interface in a list form.  I added a button to the interface. I want the user to be able to select multiple records from the list and click on submit. However I see that the button is disabled and it does not detect the source. I tried adding a dummy record picker element at the top and I could then see the button. But my question is I should not have to add that dummy element because I just don't need it on my interface page. It just creates a lot of confusion for the user to see that dropdown. Is there a resolution for this? Do automations only run when there are record pickers in the interface? Because that is pretty weird according to me. 

I am learning automations and I have hit an error I cannot figure out.There are two tables involved in this automation:People table where the client master data residesClient Funding table where clients' stipends and grants get recordedHere is the logic I am trying to make happen:When Client Funding Indicator field changes to "MicroGrant Invited", do two thingsCreate a new Client Funding record for the client <-- This step works correctlyReset the Client Funding Indicator field to "Funding Not Specified" <-- This step gives me the error "Received invalid inputs."Thank you!!!

I have a automated email that goes out to a group of non-collaborators when a form is filled out.  The emails contain an inserted grid with designated information from that form including any attachments that were submitted.  These attachments are, however, not viewable by the non-collaborators.  Share and sync is turned on.  Is there a setting I am missing?  Is it not possible for non-collaborators to view the attachments?  Is there a workaround that doesn't involve giving the non-collaborators access to the base?Thanks for the help!

I'm experiencing something weird - I have a formula field ("Cheque 2 amount") set up to subtract different currency fields. All fields, including Cheque 2 amount are set to currency format with 2 decimal places.  Everything looks normal in Airtable:However, I have a "send email" automation set up that uses the Cheque 2 Amount as a token, and some of those emails are displaying this token with 14 or so extra decimal places (here is the email generated from that same record above): Seems to be happening to maybe a quarter of the 160 or so records I was working with this morning. I can't see anything different about the ones that are experiencing this glitch. My best guess is it has something to do with the Cheque 1 Amount field, which is a formula that calculates a percentage (SUM(.75*{Approved budget})) - however it is also set to currency format with 2 decimal places, along with all the other fields. Anyone have any ideas???  

Hello ,I am trying to link a row to another row via an automation script , how can I get the url link to a cell because when I do a for(let  record of tableQuery.records) i can only get the record.id or record.name isn't their a way to get the record.urlLink ? Thanks for the help 

I found this formula in the community. However I want to include a timestamp aswell. Since {date 1}, {date 2}, {date 3} may occur on the same day. I tried adding a format specifier but it wont work... The formula sets the time to a default 12:00am instead of the actual time that is showing on the datefields.IF( OR({Date 1}, {Date 2}, {Date 3}), DATETIME_PARSE( MAX( IF({Date 1}, VALUE(DATETIME_FORMAT({Date 1}, 'YYYYMMDD'))), IF({Date 2}, VALUE(DATETIME_FORMAT({Date 2}, 'YYYYMMDD'))), IF({Date 3}, VALUE(DATETIME_FORMAT({Date 3}, 'YYYYMMDD'))) ), 'YYYYMMDD' ) ) 

Hi everyone,I need to upload Adobe Acrobat Documents to my base.  They vary in size between 155-175 KB. '"This file is smaller than the allowed size of 1 B"Why am I getting this message?  Does anyone have a workaround?Thank you for your time and wisdom.  Much appreciated!S 

I’m really excited about the new interface designer features. Airtable has given us the tools to build functional apps without getting people too deep into the database side. Unfortunately I can’t quite fully embrace it yet – it seems like the interfaces don’t work at all on iPhones. Moreover the degradation is pretty un-graceful, users just get a message to login or use the app with little or no explanation of what went wrong and how they could fix it. Our folks – especially some key stakeholders – are on iPhones more than any other platform, making this an important thing to solve for here. Does anyone have any ideas about how to deal with this? Does anyone know what Airtable’s roadmap is? Would love to leverage the features if I can figure out how to manage this challenge.

Apologies for the confusing title. To not confuse things further, I'll minimise the story/context. I'm developing a crop planning and record keeping system for our farm.For this issue, I have 3 tables in question. 1) Crops (basic info about all our crops)2) Crop Plan (for planning)3) Field (what actually happens in the field, as plans are never followed 100%).More than one Crop is added to the crop plan via a linked record. An automation creates a record for each crop with a "planned" status in Field. The planning info and dates are dynamically updated between tables. So there are two linked records in the Crop Plan table - Crop and Field. The Field table also have a linked record to Crops. This is automatically filled when the Crop field in the Crop Planner is filled.So if you add the crop "Beetroot" and "Radish" to the crop plan table to plant on 01/01/24, 1 record is created in t

In Airtable, a normal one-to-many relationship between two tables is bi-directional. When I create a link-to-record field in the parent table, Airtable automatically creates a mirroring link-to-record field in the child table. But if I create a link-to-record field that links to the same table – a self-join – that mirroring field does not get created. I was trying (as an experiment) to create a one-table to-do list, but I wanted a task to be able to have sub-tasks. So I defined the link-to-record field linking the Tasks table to itself, and called that field (that relationship) “Subtasks”. I created a task like “Prepare for vacation” and then added subtasks to it by clicking into the “Subtasks” column’s + button. And then Prepare for vacation [Subtasks: Get gas in car, Pack, File vacation form…] Get gas in car Pack File vacation form at post office etc. That works fine. But now what I’d like to do is filter out the subtasks and show only the parent-record tasks. Problem is, I can’t s

What’s the best way for someone to use my base? Lots of people will need to use it and add/edit records but they should not see each other’s information. They are individuals and not in the same company or organization. Can they copy my base and then use it freely? What is the best way to share so they’ll have the base to be able to add, edit, update and delete records?

How can I do a negative filter? Let's say I have a multiple select field with letters A-E. I can easily filter to show all records that contain all of D, E, and F. But I want to filter OUT all records that contain all of D, E, and F. Just D is fine, D and E is fine, etc. Thanks for your help!

Hello everyone, I use airtable to manage shopify orders, and i need to print a delivery order that contains all the details (each record has one item from the order, if i have one order with 3 deferent items I will have 3 records), I already designed one with airtable page designer but i cant do deferent records in one page

Hello!Does anyone know how to delete records from a List View? When I select a record and right click I do not have the option to delete like I would from the Grid View.Is anyone else having the same experience?

Currently, formula fields support numeric, date and text output only. Are there any plans to extend formula field to work with other types of output (such as the single select field)? A bit of context: I have 3 single select fields (let’s call them A, B, and C) which represent the status of a task. Statuses may have one of the following options: Todo, Doing, Paused, and Done. For example, given some task, it could have the A field as Doing, B as Paused, and C as Todo. With that in mind, I’d like to have a field D that automatically selects its value based on fields A, B, and C. Let’s say D is a formula field that does some least common denominator logic to figure its value out. The problem I’m facing is that the output type of D is text, and I’d like it to be a single select field’s value type. Also, is there a dedicated place to ask Airtable for feature implementations?

Hey, there! 🤗I have a column named "Time" that has the time a test was taken based on military time.  I'm trying to get the the column "Time of Day" to be able to populate automatically either "morning," "afternoon," or "evening."I believe I need an IF statement.If score time is:0-11:59: morning12-16:59: afternoon16:59-24:00: eveningMy formatting is probably way off 🤣 I am very new at formulas.  This was based off my research in other forums.Thanks! Here's what I tried: IF( {Risk Score} < 0, "error, value too low", IF( {Time} < 12:00, "morning", IF( {Time} < 17:00, "afternoon", IF( {Time} <= 24:00, "evening", IF( {Time} > 24:00, "error, value too high" ) ) ) ) ) 

Many times we wish to have a single select or multi select field automatically choose an output based on other fields. Automations are useful for this, but are limited and become convoluted as a separate module, especially when you have many of these use cases in one table.It would be very useful to have a single select or multi select field with an inbuilt formula box, where the select output could be determined by the formula. You could then introduce another option to lock formula mapping (ie no ability to edit), or freeze mapping, where an Auto value output would generate unless the field was manually overwritten.The workaround at present is to create three Fields, 1 select field for manual input, 1 formula field for automated input and one last official formula field to take the most relevant of the two previous outputs. This generates clunky database design, similar to when there was no today() function.

Hi, I have a Single Select field that has the options “This week”, “This month”, “This quarter”. I’d like these to be automatically chosen and updated based on a Date field. The purpose of this is to use a Matrix block to display records by a “Event Type” Single Select on the Y axis and in relative date categories “This week” etc on the X axis. Is this possible, or can anyone suggest a better solution?

I created an "upgraded" form and gave users commenter access to the base and workspace. However, when they try to upload a file (images to be specific), they get an "invalid permissions" error. Is there a setting that I am missing? I tried out this setup with the old forms and it seemed to work. 

I appreciate your help!I have one main table of English learners who register for classes - name, contact info, etc. Let's call is the Main Student table.There are two other tables that get data related to each student. (One table gets data from Stripe if the student is able to pay anything. Another table shows teacher comments about the student from the prior year.)In the past, we set up links between the tables. Then, for each student, we manually linked the individual records and had "lookup" fields for the fee & comments in the main Student table. But we had 750 learners register with us last year!How can we automate this? I'm thinking that an automation would need to:1. Find matches between the Main Student table and the other tables (based on one or more of name / email / phone)2. Update the record on the Main Student table with the data for that student in the other tables.I have searched for examples (found one relevant one but from 2019) and tried some combinations of "fin

Many thanks for considering my request.I have a Table A. I chose the "When a record is updated" option in the Automation trigger with multiple field selections, and the Next step is Scriptwriting, In the script, I need to track which field has been updated recently (i.e. which updated field triggers this automation).Eg: Table AField 1 | Field 2 | Field 3 | Field 4These four fields are selected in the "When a record is updated" option of the Automation trigger.If Field 1 has been updated recently, we need to track that Field 1 has been updated recently.If Field 2 is updated recently, we need to track that Field 2 is updated recently.Based on the Field update I have to write logic.

Hi AT CommunityI have a Google Sheet which has cell values (text/currency) which I would like to bring into Airtable. Along with those values I need the user to answer some questions. I would like to prefill form fields with the cell values from the Google Sheet, hide the fields, leaving visible only the questions which I need answering. Any suggestions on how I could go about this please? It needs to be a one step from Google Sheet to Form. I have looked into prefilling a Google Form from Google Sheet, this then populates Google Sheet (form response Google Sheet), when a row is added it creates a record in Airtable Base. I don't think you can hide Google form fields which isn't a huge problem, but not my preference. Any other thoughts or suggestions. THANK YOU.

Hi,I have a field with created dates. I would like to be able to create a chart that shows this data, grouping by the month of the created date. However I want the year to be irrelevant. For example, March 2024 and March 2022 to be shown in the same group within the chart.I have created a new field with a formula to show the month only which works perfectly. But then when I create a chart on the interface, they are in alphabetical order and not date order which is not want we want.Can't think of a way to make the chart display the months in date order, or another way for this all to work. Any help is appreciated!

Hello Everyone,I want to copy the whole Table including Column Names (headers), is that possible ?I don't want to type by hand all column names each time I copy/paste the whole table in a spreadsheet for example.Thank you for your help