Solved

I have a single line text field as a primary key “name” field. if it is blank when I save the record, I would like to automatically fill in the name as a concatenation of three other fields that are in the record. How can I do this?

Perhaps I’m missing it, but how do I generate random numbers? I am missing “randbetween” and “rnd” from Excel. Thanks for any and all help.

I’m curious if there are any plans to add conditionally shown fields to Interfaces, similar to what is possible in form view? For example, if you’re tracking network outages you might use one field to specify that the cause is a power outage, in which case you would want other fields to appear that let you specify when the power outage started and ended (so you can track UPS runtime when the power goes out, and site recovery time when it comes back.)

I’ve been trying to delete a published interface but can’t find where to delete it. I opened the interface and looked for a delete button but couldn’t find one. I exited the interface and went to my workspace to see all of the bases and interfaces I have, but I couldn’t find an option to delete it there. Thank you in advance.

Hi, I'm playing with the interfaces and I have a question. Is there any way I can share an interface with a person that hasn't an Airtable account?I don't want to add them as collaborators, because they should see only that interface (not the base) and I don't want to ask them to create an Airtable account just to see my interface. My final goal is sharing the interface link with an automation through email. Is there any way? Thank you!

Hi all! I thought I would share some things I wish I could do on Airtable right now, manifesting that they may be future features.1. In a long text field, I wish I could use bullets and hyper links. This would help display cleaner for the field in interfaces2. I wish I could save a record as a PDF from an interface - from the record selector and single record layouts. I know this can be done in Page designer extension but - to my knowledge - page designer does not dynamically space. And its not nearly as easy to customized as an interface.

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?