Ask the Community

Is there a way to know the IP of my airtable account. I want to call an API from airtable using Zapier automation. The third party needs to whitelist my IP so that i can call the API. Any help is appreciated.

yo quiero que poner varias veces "borja" en esa celda

hola necesito saber si puedo cambiar estos datos por otros

I was hoping to put a youtube video in attachment but the URL says it can not be found. Tried a few different videos with different style URLs with the same not found error. Is there a easy way to add video or will I just have to add URL to the video? Which is fine, I just wanted to know if I could embed it without link or downloading, so I thought I would ask.

Hello!I'm new to automation and trying to figure out how to copy data from one field to another when one field is not empty and the other is empty.I have a Tasks Due table and a Reminder field that is a Dateadd formula which calculates a date from data from another linked table. I want to copy that Reminder field and paste it into my Date Due field if the Reminder field is not empty and the Date Due field is empty. Can anyone help? Screenshots of how I currently have it set up. I've tried changing up the conditions, Record ID and field but can't get it to work.Thanks so much for any help you can give!

I am setting up an AirTable to manage incoming event registrations, with an automation to assign people to a particular session in the event, depending on whether that session has met its cap. There are multiple conditional steps; people select first, second and third choice sessions, and the automation has four conditional actions to assign people to the first available session from their choices. I am already running into a "Received invalid inputs" error when testing the conditional actions.I've attached three screenshots of the automation set-up. It seems that the issue is in the conditional action that is set to run IF the "List of names" (pulled from the "Open Sessions" view that is pulled from the "Find Records" action above) CONTAINS the "name" value of a single-select field that is pulled from the record created (which is the automation trigger). The error message says "Received invalid inputs" but I haven't been able to identify the issue.

after delete attachments for 20 days,it also say over limite

I'm working with colleagues to develop an inventory request form.In our base, we have fields and calculations set up to adjust quantity when information is input into an "outgoing" or "incoming" sheet. It all shows in our main inventory sheet along with costs, available quantities (based on the other two sheets), and general product information. To put it as simply as I can, we want them to be able to see a small gallery of the items (where "Quantity Available" is greater than 0) and allow them to input how many of a specific item they want. Is this possible without any upgrades, plug ins, or integrations? If so, how can I get it to work? We want to house all information in Airtable as a hub. Any help is appreciated!! 

Hi all, I am attempting to populate a due date for when corrections on a document are needed to be done by.A regulatory team reviews a submitted file. When it's determined that corrections are needed that team updates a single select field named "Filed by Regulatory" to show as "Corrections Requested" and adds a date/time timestamp in a field named "Reviewed Timestamp". I'd like an additional field, which can include a time or not it doesn't really matter, that will populate when the requested corrections need to be completed by - in this case 2 business days from the date it was reviewed. This is the formula I have so far and it seems to be working to the extent that "N/A" is populating on records that corrections were not needed, but on the records where corrections were requested-i'm not getting a date, instead i'm getting "#ERROR". IF({Filed by Regulatory} = "Corrections Requested",WORKDAY({Reviewed Timestamp}, 2, Holidays),"N/

Hello! I work at a nonprofit that offers technology training to bridge the digital divide. We are transitioning to Airtable and Typeform to manage our classes, partner relations, survey data, and more. We have many different class types that each have their own surveys. We built it out so that each survey has its own table in the same base that gets auto-filled via the Typeform integration. Currently, each survey also has a duplicate copy that is in Spanish. Because question answer choices have to match from Typeform to Airtable, I cannot field map the same Typeform question in an English survey as in the Spanish survey. For instance, I have to have a field for gender in English and a field for gender in Spanish. I was using Automations to automatically "translate" the Spanish fields into English fields that we use for our Interfaces (really just auto-populate what the translated version is into the English field). However, I have run out of Automations.&nb

How can I automatically generate a new record ID in Airtable that continues sequentially from the last number in the existing data?

Hi, how can I change my community name? Can't see how to contact Airtable to do this or where to find it in my settings. Thanks!

I did some searching but wanted to be certain since I’m still relatively new to the scripting block. Does anyone know if there is a way to create new views? My use case is that I currently manually create a suite of views each time I add a new client and/or project. For every project I will have an All view that shows everything about it, then an Open view that only shows stuff that’s currently being worked on, an Invoice view that gives me a summary of the tasks that need to be invoiced to make my invoicing faster, etc. Currently I have template views that I duplicate and update the related filters to have it show the right records. I’d love to automate this with the scripting block, but I don’t see a way to create new views from script. Am I missing something? Anyone else have any ideas? Thanks!

Hello!There are a LOT of posts regarding the popular error of "Received Invalid Input" but in my search I didn't find anything that was specific to the conditional logic of the automation being the area that returned the error.I've created a video to show how the conditional logic works when the list properties length = 1, but if it = 0, then the conditional logic check returns the "Received Invalid Input" error. Any help is appreciated.

It would be nice to be able to control the size of long text fields in interface designer. When I'm typing long notes such as "rapport" notes or "project overview notes" in interface designer, it automatically resizes the box according to the length of the note. So as my notes get longer, everything below the Long Text field gets pushed further down the screen. Having a resizing option and a scroll bar inside of the interface designer text box would solve the issue for me. 

Hello, I am testing Airtable Api, and I see that no matter in which table the record is, the record get, update and delete methods work normally)Example:I have a record just in "movies" table, but even if I write the id or name of another table "blog" in api url, it still returns the record, you can also update and delete.Get https://api.airtable.com/v0/<app_id>/Movies/recY7Ho4bq4RM94XX/Get https://api.airtable.com/v0/<app_id>/Blog/recY7Ho4bq4RM94XX/They return the same elementIs this how it should work, or it is a bug?

Filing this as a bug here because the message support help bot thing is completely uselessI've noticed for a few months now that if you have a bar chart, turned horizontal, with record values turned on then it doesn't display the largest number, which looks kind of rubbish. See pictureI'm sure this is just a bug in the interface designer, but its been there a whileIn the image - the blue bars at the top should display the value (10 and 11) at the end of the bar, like they do for the other coloured bars

The form builder allows the creation of groups of fields which are separated by a horizontal rule on the form.Is there a way to control visibility of the entire group, including the horizontal rule, rather than controlling visibility of individual fields within the group?Assuming the answer is no, is there a way to disable the extraneous horizontal rule when none of the fields in the group are visible?Thanks!

I feel like what I want to do is very simple, but honestly, I'm wasting a lot of time without succeeding. My level of incompetence is quickly reached.So, I have in my Table 1 a Date field and a field that I'll call field N. In my Table 2, there is also a Date field and a Number field.I want AirTable to find the corresponding Date in Table 2 for each record in Table 1, then return the Number field and enter it in the N field of Table 1.I've been searching for the function, but I can't find it. Does anyone know how to do this?"

I made a massive mistake when doing some updates to a base, so I figured I'd restore a snap shot. I created a snapshot copy of the base, and deleted the original. This has just compounded my issue because all my data syncing to other bases is totally messed up. This also impacts several automations i've created to work around the fact that my company wont shell out for two way sync features. What a headache. It seems to me this wouldn't be an issue if I were able change the source link to my sync set up to the snapshot base, but alas I get the following error.HELP!!!!

Hello, I’ve been trying to work this out for hours but I’m afraid my knowledge of airtable formulas is quite nascent. I’ve got this current formula: IF( {Due}="", “”, IF( AND( DATETIME_DIFF({Due},TODAY(),‘hours’) >= 12, DATETIME_DIFF({Due},TODAY(),‘hours’) <= 48 ), “Due Soon”, IF( IS_BEFORE({Due},TODAY()), “Past Due”, IF( IS_SAME({Due},TODAY()), “Due Today”, “Upcoming” ) ) ) ) Which gives me different values depending on how much time is left in the “Due” column. I’m trying to add another variable that says that if checkbox column “Done” is ticked, disregard all the above formula and return value “Complete”. How can I go about doing this please?

Hello,I have a table containing information about clients: surname, first name, end date, etc., as well as the number of hours sold. In another table, I have the tasks for each customer with the number of hours used.I've created an interface that summarises the job information by customer. At the moment, I need to filter by customer to display all the tasks, but I also want to see the number of hours sold directly in this interface.However, to obtain this information, I need to apply two filters:Filter 1 on the Tasks table to select the customer. Filter 2 on the Customers table to retrieve the hours sold. Is there a solution to avoid having to filter twice?

I have been trying to develop a formula to output the amount of work hours between two date/time fields. This is for a base that has Time Off requests for employees.I have a field with a start date like this (9/16/2024 10:00am) and a field with an end date like this (9/28/2024 3:00pm). What is a formula that would calculate the amount of work hours between those two fields, assuming:Work hours are 8am to 5pmExclude 12pm-1pm if the span crosses that time period, since there should only be 8 hours between 8am and 5pmExclude weekendsIdeally, and I realize this is a tall order, it would exclude New Year’s Day, Independence Day, Memorial Day, Labor Day, Thanksgiving Day, and Christmas Day for say, the past 5 years and next 5 years.This has been driving me crazy for a long time, and I cannot come up with a reli

I'm trying to determine from the API whether a table is hidden or shown, but looking at https://airtable.com/developers/web/api/model/table-model there's no obvious field with that information. Is there another API that has it?

Hi everyone,I'm managing class attendance for a dance school using Airtable. Currently, I have an attendance table where I track which students attended each class on specific dates. Each class has a fixed set of students that remain constant throughout the month, and I need to automatically replicate that list of students across each class date in the month without manually copying and pasting.Example Table Structure:Date Class Student Present05/08/2024Ballet Intermediate Adults - Mon & Wed PMAlex Johnson[ ]05/08/2024Ballet Intermediate Adults - Mon & Wed PMSarah Brown[