Ask the Community

Hi,I'm in the unfortunate situation that I seem to have an automation bug that creates unwanted changes to some records, but not all.Since I cannot on my own find out which automation causes this (mailed support regarding this), I wanted to at least identify all instances. The symptom is I end up having two different contact information for the record. Unfortunately there are no identical fields to make an easy IF (!=) between, only parts of the fields are the same (basically a name, with different stuff before and after).In Sheets/Excel this would be a VLOOKUP case, and in the automations there is 'CONTAINS' that could be used. But how could I build a formula that takes one column (in full, I was able to SUBSTITUTE it down to the exact string) and find records where the other column contains the search string?TIA,Björn

I have a simple linked table. There is a table of CASES with a bunch of fields and then another table called CASE ACTIVITY which has scheduled activities for each CASE, so the tables are linked by CASEID which is the primary field on CASES.That all works fine. Under CASE ACTIVITY each row is a dated activity, so :CASEIDScheduled actionDate65Sent for review10/10/202465Publish findings12/10/2024I would like to have a formula field in CASES that shows the date when the next activity occurs. And I started with a formula field that simply said "MIN(

Hi guys. I have a workspace through which we manage our business, an academy. I have just two users, one for the owners and creators, and another for the teachers. Our problem is that we need the teachers to access to some bases and some interfaces of the main data base, but no to all the administration and managers info, and till now i havent found a way to restrain the access just to the bases and interfaces that they need. Is there anyway to manage the permissions or block access through passwords???? Thanks a lot for your time. 

I am very excited about this new Public Interface option and want to share an interface with a client through an embedded code in an outside website. But I am having trouble because I have an Interface with Linked Records and when I select one of the linked records I get a spinning circle in the field box for the linked record. I am assuming this is a viewing permissions issue because I have no trouble seeing the linked record when I am working inside Airtable. The linked record is connected to the "Contact Table" and that is also has shared public permissions in the Interface. What else can I do to make these linked records also viewable?

I would like to be able to select data from a list of choices on softr. However, by linking the dropdown option to a linked data column on airtable, the data of another user also appears and I would like to avoid it. So I tried to use dynamic filters, but it does not work.  AS 

Hi everyone.I am looking for a solution where I have an interface created and I want to automate the process of sending the interface data via Automation or Scripting. I have tried the scripting route, but it asks for installation of node.js libraries. I am not an expert at programming and have recently started learning, so I was unable to proceed with the same.Any help in this regard would be welcome. Thanks!

Hello folks!Total newb here!I have a base with 2 tables. Table 1 is orders that are placed by customers. Table 2 is a list of those products with a corresponding URL to the image.I'm trying to have the Cover Art field in Table 1 populate with the corresponding date from Cover Art URL in Table 2; based on the Product field in Table1 when the customer places the order.Basically when a customer places an order, I want the Cover Art field in Table 1 to pull the appropriate URL from Table 2, based on the Product field in Table 1.  Does that sound utterly confusing?I've attached some screenshots in case it's helpful.I've been spinning around online trying to figure out how to accomplish something I believe is actually simple.With grace,JQ

New to all of this. No coding background; small business owner. I am trying to create a rudimentary inventory system with Airtable. I can't figure out how to get a formula to "count" the number of array entries in a linked record field, and return back a simple integer value. For example, in the photo attached, the "Reserved" field should return the value of "2," since there are two entries in the linked record field. Any ideas? Thanks. 

Hi there, I have 4 tables that are linked - they are as followed: Table 1) People who fills in the form Table 2) Companies (105) Table 3) Research Areas (17) Table 4) Questions (5) I want to create forms that match one company, in one research area, with one question - like; Company 1-105 + Area 1-17 + Question 1-5 - where these variables change, so each form is sent to a person who fills in the form with a specific combination. One person, one combination. So I select the combination (best if it’s automated) and the form only makes it possible to answer the question with predefined options. So the first fields are pre-filled by me - hope it makes sense. I’m new to Airtable. Best, Eva

Hi, is there a way to have a field prefilled in a form AND hide the field at the same time? IMO it should be standard option since most of the time when you prefill a field for users, you don’t want them to even see the field and have the ability to mess with it.

I have been reading for hours through the help forum and documentation, but ARRAYSLICE doesn't want to work for me.I want to achieve the following: Show me the first value of an array. My formula is: ARRAYSLICE(verticals_from_contact, 1, 1) but it doesn't show me the first value of the array. Instead, the field shows me the whole array. If I change it to: ARRAYSLICE(verticals_from_contact, 2, 2) nothing is shown anymore.  I tried the formula on lookup fields, linked records, and multi-select fields, and nothing worked (see image). Does anyone have an idea what's wrong?

We are trying to setup a notification when a new file is uploaded to a record in a specific table. We have created a new Slack channel to receive these notifications. When connecting with Slack, only a subset of our team’s Slack channels appear. The new channel we just created doesn’t show up. Is this integration working currently? What are we missing? We’ve logged in/out of each app several times and retried but no luck. The new channel never appears.

A few of us have been using the Free plan.  I created a workspace. My colleague created a workspace. We added a few other colleagues.Got to a point where it made sense for us to upgrade so one of us purchased the Team plan, for a total of 8 users. So now all of my colleagues are part of my paid plan.After upgrading, I can confirm that I have 8 licensed users. When I log in, the workspace that I created now shows as being part of the 'team' plan, but our other two workspaces still show as 'free'. Why? Those workspaces were created by one of my colleagues that I just upgraded to the Team plan.The pricing is whacked, and having to upgrade my subscription (again) to the higher plan which is more than DOUBLE what I just paid, just to get the admin console, is ridiculous.I also find it very difficult to get in touch with anyone at Airtable. The chat bubble just prompts you to enter your info and it took 2 days for someone to send me a canned response that

As someone in the shapewear and waist trainer industry, managing inventory efficiently is crucial for maintaining a successful business. I’m currently exploring Airtable to streamline this process and am interested in learning about different strategies and templates that others have found effective.Here are a few specific points I’m looking for insights on:Tracking Sizes and Styles:What fields do you recommend for tracking different sizes and styles of shapewear and waist trainers? I’m considering creating fields for size, color, and style type. Are there any specific layouts or formats that have worked well for you?Automating Inventory Updates:Have you implemented any automation in Airtable to update inventory levels automatically? I’d love to hear about any scripts or workflows that help keep track of stock levels in real time, especially when ite

Hey there! I've got a cool idea to streamline our database for easier use. Here's a Video Demo: Database Automation for Content Publishing 🤖 | LoomCurrently, I have a content database filled with records from a form, and I've set up automation to fill out most of the fields. I'm exploring ways to automatically assign a publish date based on a rolling schedule I can pre-set. I'm looking to avoid manually setting dates and want the system to add content to the schedule automatically. I'm not sure if I need to create a formula for this or another table to reference back to. Let me know your thoughts Airtable community!

I’m not sure if this would be a script, but I have a table full of URLs and I want to query the ‘page title’ for that URL and return it to populate in another field ‘Page title’. Does anyone know if this is possible and if so what script I should run? Thanks

Hello.Very new to Airtable. I am a designer working with a marketer for an events org. We are using Aritable to manage all our projects. I need a unique number for all the projects and am wondering if it's possible to auto number across multiple tables in a base, as that is how she is going to organize (tab for brochures, tab for print ads, etc.)I also would like an alpha prefix because we will have another base for another events org that we work on simultaneously.Ideally, I would like to have all projects in both bases just be auto assigned a unique number, but I don't know if that is possible either.Thanks for any help!

Hello,I would like to create an automation where I enter the working hours of the respective month and employee from "Table A" into the column of the respective month and employee in "Table B". (January, February, ...) the whole thing should be done once a month.

I have four (4) columns that are number data fields titled {Trip 1 Miles}, {Trip 2 Miles}, {Trip 3 Miles}, and {Trip 4 Miles}. The settings to the number data fields include decimal places and a screenshot of the settings are attached.Column five (5) is titled {Total Miles Traveled} which is a formula data field that SUMS the total of the number data fields listed above. THE PROBLEM TO SOLVE: I am unable to get the formula in {Total Miles Traveled} to include decimal points in the SUM total. A screenshot is attached. The formula is totaling [26.70 + 26.70 + 9.10 + 9.10] and is rounding the answer to [72] instead of the desired answer with decimal points as [71.60].

Request - Please don't show the drop down arrow for records that have no child items!Thank you!

I have a form where every month the team leader enters the hours of the employees as follows: Employee 1: "35 hours"Employee 2: “48 hours”. up to 15 employees per team leader. Table A shows me all the hours entered by each employee in each month. All employees are listed in “Table B”. In this table I would like to add up all the hours worked so far. how do I get this done. Employee A can be listed under "Employee 1" in month 1 and under "Employee 4" in month 2. Theoretically, every employee could be entered in the 1st - 15th position. So I would have to add up all the hours of each employee, regardless of whether, for example: the employee is under “Miztarbeiter 1” or “Employee 12” and so on. you would have to tie the hours to the names or something.

To set Button visibility it seems I need to upgrade, it a Team plan enough?

I working on a formula that will provide me with 4 different outcomes depending on a products Variance from our target cost of product/FOB. Any products that have a variance less than -5% need to output "Red -5% or More Variance", products with a variance between -1% and -4.99% need to output "Orange -1% to -4.99% Variance", products with a variance greater than -0.99% need to output "Green - Meeting or Exceeding Target", and any products that have an empty value need to return an empty value. I have figured out how to return most of these responses, but I'm hung up on how to return the empty value. Any help will be greatly appreciated! IF({P1 FOB % Variance From Target}<= -.05, "Red -5% or More Variance",IF(AND({P1 FOB % Variance From Target}>= -.0499

Hi there, I was wondering if and how I can make a (prefilled) field in a form read-only. I am basically creating a form to answer a question. The form should be generic, but the question should change. But it should not be changed by the user themselves. I know the field wouldn’t “really” be read only since the user could modify the query string parameter, but that would be good in my usecase to prevent unwanted changes to one of the fields. Thanks!

I have three columns: Email Sent (Yes/No) Date (Sent) I would like to add a fourth col to display the number of days since the email was sent (i.e. Current Date - Date Sent, displayed as Days). How can I write a formula for that?