Ask the Community

Hi, I am trying to find a way to find the value that is the second to the max value of multiple linked record using rollup. I can find the max value, but I am still unable to find a way to find the second to max value. So if I have, 21840, 20194, 21664, I need to be able to work with the max(21840) and the second to max(21664). I hope I have explained my situation properly and hopefully someone can help me. Thanks in advance!

Could someone share the correct way to update a multiple select field using a script?I have one table where I receive data from form submissions. When a submission is received, I use data from the submission to update a multiple select field in a record in another table. When I manually type my field update, as below, the script accepts the value: await table.updateRecordAsync(id,{ 'Multiple Select Field': [{ name:example1 }, { name: example2 }] })However, when I use JSON.parse() to create an array of objects with name keys and values using my submission data I receive a 'cannot accept provided value' error://My raw data is brought into an automation script as an input. Here is an example of the format: let rawData = ["example1", "example2"] //Here, I convert my rawData into objects with keys and values let data = rawData.map(datum => JSON.parse(JSON.parse('{ "name":"'+datum+'" }')); //Here, I attempt to update my table us

We are a Civil Contracting company and just started using airtable for some simple data tracking.  What we are trying to do is build a simple "app" that can house some forms for our drivers to fill out thru out the day, ie material load info and refueling info.I have built some forms that use a sharable link, it works but is cumbersome when there are several different forms for the drivers to use.  I was hoping to figure out a way to either set permissions in airtable so the driver can only view and utilize the forms or have an "app" that hosts the forms in one spot.  These are truck drivers and not all of them are tech friendly so I need to keep it as simple as possible.Thank you in advance for any ideas on how to tackle this issue.

A few years back I set up a base for one of our clients who was new to Airtable. I invited them as a collaborator to the base to start to familiarize them with the system. Since then we have been paying for both us and them as a collaborator on the base. The time has come that we want to transfer owernship of the base to them completely so they will both be managing and paying for the base. How do I go about doing that? Do I invite them as an owner and then delete them as a collaborator? How do I remove myself as an owner for the base? How do we get them set up to be billed for the base?

Hi - I am building a base that serves as a marketing tech stack document. I am listing software titles in the first column, and then have columns for "Features in use" and "Features available but not in use" etc.  Each of those columns have multiple selection options.  My goal is to be able to create a view that will group all the software options by the individual features.  So one example use is that I want to be able to see all our software that has the Available Feature to do SMS texting in one group. Did I set this up right to do that? 

Hello,I'm moving into the List View Interface, and I am loving the "Prefix" field which allows me to use visual indicators to quickly see the status of records. My current roadblock is this, I haven't been able to figure out:How can I have a Single Select Field automatically assigned based on a formula?As shown in the screenshots below I have:1) Created a Single Select field that has a "Stoplight Anaylsis" of a record's status as Red, Yellow, or Green.2) I added this Single Select field as the "Prefix" in my List View Interface3) Now I want to know how to automatically assign the status based on other fields. Specifically:GREEN if {Leader} and {Client} are filledYELLOW if {Leader} AND/OR {Client} are emptyRED if {Leader} AND/OR {Client} are empty AND the date is in the Past.It's not a difficult concept, just trying to see how to implement it in Airtable.Quick

Hi,I would like to trigger an automation with a button in a list interface. That's not possible, but how then to handle the following?The listing groups all records (projects) into several buckets. The user can choose which bucket to list with a dropdown filter element. After finding the right selection, I'd like for the user to trigger an automation for that selection. The automation will (loop and) send out an e-mail to and update some fields for all the listed projects.Is there some clever workaround that could be used?Rgds,Björn

There's an AT script called "find & replace."  That's great - but how about if instead I find a string of text in a field, copy what follows up until a find another string of text (/BeginAddress Name, Street, City, Zip /EndAddress), then paste that stuff into a different field?  The point is to take an email before forwarding it into AT, place /BeginWhatever at the front of what you want to copy, place /EndWhatever at the end of it, then when the new record is created in AT, have an automation run that script to grab what's between the "markers," and paste it into another field in that or a different table - like "Address" for example.  So, for example, I can mark an address anywhere in an email chain, forward it into AT, and have the script extract what I really want from it and put it where I want it to go.  And then maybe delete that forwarded email.I want to think that the "find &am

There are times when I need a data field to be "Required".   Otherwise, data quality issues are introduced. When this is needed, usually the data field must always be "Required" (Use Case #1).  There are also times when a data field needs to be "Required" only conditionally (Use Case #2), based on a value present in another data field within the record.  What I have observed:Airtable supports Use Case #1 during data creation via the Interface Creation Form, but not during a data update.  I can delete the data in a "required" data field, subsequently in the same interface.Airtable doesn't support Use Case #1 at the table/view level.  It can't be specified when defining a column.Regarding Use Case #2, "Conditionally Required" enforcement is not supported, either at the table/view level or within an interface.  Am I

I’m new to Airtable, and have been browsing the help center and playing around with the features. One thing I didn’t see mentioned anywhere was input validation. For instance, for a numeric field requiring the value to be less than, greater than, or between values-- as an age field which must be 21 or greater. Or a date field which must not be a future date. Or a currency field limited to 10000. An so on. How would these be done in Airtable ?

Is there a way to put edit-checks or validations on a field? I’d like to restrict the range of numeric values that can be input to a numeric field.

Hi, I have some scripts that do data-validation over all the records in a view before moving them into a new view. Would it be possible to display a progress bar in the scripting app to indicate how long a process should take. Thanks in advance :slightly_smiling_face:

I posted in the ideas about my desire to have Page Designer integrated with the Interface Designer. I would like the employees at my company to be able to work within the Interface and generate letters for our clients through PDFs that are exported to the desktop.I know there are so many third party solutions to document generation, but I was wondering if it is possible to create a script that would be activated by a button in the interface to generate a letter that will save to the users desktop using one of the third party solutions.A click to download letter button.   

I’m doing a deep software selection and i’ll evaulated a lot of other software like airtable, and i have to say that Airtable is what i can say the best in class if we consider the 90% of the use cases our company needs. What it seems to lack, but i cannot realize it clearly (it seems to me so fool) that its not possible to do data validation. Let’s say a simply use case: I want my collegues to fill in the hours spent on various task (not in real time with the time track app, but simply at end of the day or of the week). In airtable is simple: new grid, i add a column TIME SPENT of type INTERVAL and i’m lost? i can i force to insert only an x number 0 < x < 8 ? i dont want to let them fill in a WRONG record and with automations try to send email, rewrite numbers or other thing: simply to forbid a wrong insert if it does not respect the restriction rule. I’m not sure it is not possible, but i’ve invested a lot of days of study and i only found workarounds. It looks

If I have fields in a table with specific types why doesn’t the form validate those types before submitting the data? There seems little point in specifying a field type of email if someone can enter whatever they like into the form. I realize that client-side form validation is non-trivial but there at least some native browser validations that could be implemented fairly easily.

Hey Community! Here’s my problem: I have users adding phone numbers to records. Problem is, the way the are inputting records doesn’t allow me to have Data validation. I need the number they input in a specific format, and I was hoping there might be a formula that could do this. Format we need: 1 (XXX) XXX-XXXX Inputs we might get (because users make mistakes) = 1 xxx xxx xxxx xxx xxx xxxx xxxxxxxxxx 1 (xxx) xxx xxxx (xxx) xxx xxxx What is important for us is there is the area code, aka, a “1” at the front of every number. I was thinking about creating a formula that adds a “1” at the start, but in the circumstances where a user does what we want, and adds a “1”, I don’t want to add it as it’d break it. Does anyone know how to put a formula together that’ll do this? PS, Bonus points if you can ensure it looks “pretty” by formatting it in this wa

Is there a way to enforce data validation on a field? For example, if I want to enforce users to enter a name under 20 characters or less, can I do that?

Hello,I'm using the Map & Data Validator extensions, which allow me to view and validate my fields respectively. I'm also developing an interface so that I can share the application without users having to use the database directly, and so that I don't have to show all the records.My first question is: Is it possible to include the map extension display in my interface? If so, how? I've seen on other forums that this wasn't possible, but perhaps a feature for this has now been added?My second question is about the Data Validator extension, which only validates data when it's added from the record creator form available from the extension window. Is it possible, for example, to validate data entered from forms in my interface?

Hello!I am trying to create a way to track our recruitment conversion rates (for a large program where participants apply to be part of). I know it should be possible, but not sure how to configure it all. Here are the key elements:We have an existing airtable base where all prospective program participants apply via a form. A required field as part of the application form is "how did you hear about our program." There is a drop down list of options they can select from.Once an application comes into the view, we review and have new fields that we complete, such as: application ranking (single select), checkbox to offer interview, application status (interview offered, contract signed etc).I want to then be able to understand from each source (eg. newsletter, job fair, referral etc.), which applicants went on the following:Number of applicantsNumber of interviewsNumber of offersNumber compl

Hi,I have a table of tasks.I have a table of action items.In the third table, we have various information items (records).Several tasks can be assigned to an information item.Tasks can have multiple action items.Each action item has a single Owner.I want to show only the current action items related to an information item record.Please recommend the best practice for implementing it.

Hoping someone smarter than me can helpI am looking to update a dropdown menu (to show a quote is accepted) on Airtable when a user approves a quote on our quoting software (Quotient)I am using a quoting software called Quotient, works with Zapier, I am successfully done the 'trigger > find record > but I cannot find how to update a dropdown.The record is found based on the same unique text in Quotient which marries up to the unique customer reference in Airtable.I've added some screenshots which may help to understand

Hi guys,I'm creating a escape room form, so the group can select the room and time they want to play.There are 3 rooms (each one with 5 different times to play).When a group select the room/time (example: Room 1 - 20h) this room can't appear on the form anymore.How can I do that?I read in other message here to create a new table with all the possibilities (I already did that), and created a link to another record in the main table (which is used to create the form).I tested it but it didn't work.If anyone could help me, I appreciate it! Thanks

Want to:- Store a database of suppliers and their training records- Log their training and assessments- Create certificates- Create external views for assessors to update training records

Hi all!My team and I are exploring using Airtable as a tool for our Software QA team. We are looking to use Airtable to hold our QA tests and testers' results. Has anyone used Airtable for this before? Do you have any templates you would recommend? Any input would be appreciated. Thanks! 

I have some equipment inspection checklists that I am trying to move from paper to Airtable, and I was wondering if there was a way that I could convert it into a fillable PDF and put it in an Airtable form. The employees fill out these checklists when they’re at worksites, and the office is out of their way, so the forms don’t get dropped off as soon as we’d like. What I am hoping to do is have the employees fill out the PDF in the form, then have the PDF saved to the base as an attachment so that we get the forms as soon as they’re finished, and it’s easier for everyone at the worksites. I already tried converting the checklists to Airtable forms, but there are just too many checkboxes that would each need their own field, and it would just end up being too inconvenient to fill out and sort through. I also tried using the attachment field in a form, but this would require the PDF to be filled out in a different app (or scanned), then saved, and then submitted through the fo