Ask the Community

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?

Hi, I am having trouble creating an automation to update a record in a table. When I try to set up the "Find Record" step, I'm getting an error that "cannot assign list of string to string" and I don't know how to proceed or how to fix my data set up in order for the automation to work.The issue (I think) is that in the table I'm trying to update has a linked field which is the unique identifier I need for the automation to find the value I want to add to the table I am updating.  I'll try to explain the data structure and what I'm trying to do. Table 1: ContractsTable 2: Contract Items (this is a list of "products" th

Hi Some of my team are having trouble clearly viewing what days / weeks the records are in within the TIMELINE view as it feels like there should be gridlines or at least column lines, not just the blue 'today' vertical line.Is there a way to toggle these lines on or off does anyone know, or would anyone want this feature too?TIACharlie

Is it possible to delay an action from happening? I really like Slack notifications for new records, but I’d like the action to wait say, 1 minute after the record is created so that I can finish adding all of the fields. Is that possible?

I've searched on the community for solutions to combining one field that contains a date and another field with a duration to create a datetime field, but haven't come across any solutions to solve it. I'm using the DATEADD() formula but Airtable is not returning a correct results. What am I missing?

I’m trying to expand a base we use as a booking system for photography sessions but feeling stuck. In our current system, users fill out an Airtable form with their contact info and select a time slot (field linked to a table of time slots, filtered by what’s still available). That info generates records in the main Appointments table. This system has worked well so far, as we’ve only been offering slots with one photographer at one location. We’ve been offering 30 slots per day and about 3 different dates at a time, so at most the user sees 90 options, which is more than ideal but has worked ok. Now we’d like to offer 5 dates, but more critically, we want to add a second photo station in a different location on the same dates. That means the user will now be selecting a time slot from a field with 300 options, and there will be two slots for each date and time (eg 10A Monday @ Location A vs. 10A Monday @ Location B). The biggest limitation I’m hitting is

Hi everyone!I created a base for employees in our company with the table where are all information about every employee. I also created a form to update those information if necessary. I prefill all the fields and create a button field so that i can quickly open the form. But somehow that button doesn't work with some of the employee. they were added after I created this button. I attached some photos for you so that you can see what I'm talking about.Does anyone know what is the problem here?

Assume you have a total of 100 items and a multi-select field that allows you to select from a set of values. You want to find out what percentage of the total is represented by the selected values.

I have a date field that contains "2020-11-26" and another field of type selection. I would like to put the date "2020-11-26" in the selection field by transforming it into "26/11/2024". How can I do this?

Hello, I am really thrilled with exploring the features of this new and game-changing Airtable functionality. I think it would be super useful to my team which deals with hundreds of social media posts per month created and edited by several of our departments. To give this a go, I started by creating an interface which would help our education department organize their programs and link social media requests to records another table - I already have all that setup. Where I am stuck on, is on the ability of creating a new record from the interface itself (i.e. create a new upcoming program from the interface where I am browsing the programs). I cannot find an element such as “add new record” or for that matter “delete record”. Do we have to go back to the regular grid-views to add or delete records? That sounds a bit convoluted… I am loving the new feature and I understand that it is in Beta, but I really want to use it to its fullest and would love any suggesti