Ask the Community

I’m trying to create a SWITCH formula checking for specific text within a field. For instance, if there is a field with a bunch of random numbers and then a name, I want to check for the name in that field, not match the entirety of the text in the field.

I am trying to make a graph that will demonstrate clients that are coming to these mandatory briefings, however I have to use two date fields to represent their attendance since each client has two opportunities to attend one of their mandatory briefings. The fields are:ISSUANCE BRIEFING (1st ATTEMPT)ISSUANCE BRIEFING (2nd ATTEMPT)and there isIB1 Attended <-- Single Select field that is for selecting Attended or not Attended for the first briefingIB2 Attended <-- Single Select field that is for selecting Attended or not Attended for the second briefing. Due to AirTable limitations, I cannot easily show in a bar graph where it has a combination of all people attending each briefing, and can be grouped by attended and not attended and/or distinguish how many people in this meeting are going to their first attempt or second.AirTable forces only one X value. So I am looking for automations or ways to visually represent this data. Drew

I'm super new to airtable and I've been searching for the answer to this and I can't seem to find what I am looking for- likely because I don't know the right terminology but I have a table in my base and I want the primary field to auto populate each new record with a number and the year the record was created so that if there are multiple years I can filter them easily later.I figure it's some sort of formula because I know how to make the field auto number, but I can't figure out the formula to do it. Thanks in advance Amy 

Hi all,I want to create an automation which creates a new record in Table B (=record B) upon the creation of a record in Table A (= record A).The title of the automatically created record(s) B should be coming from a multi select field in the record A BUT if multiple (n) things are chosen in record A then I want also n records and the titles should contain only one of the selected option.So as an example:I can choose "Red", "Blue" and "Yellow" in record A. The automation then should create 3 records in Table B: One titled "Red" one titled "Blue" one titled "Yellow" and NOT 1 record saying "Red, Blue, Yellow".Is this even possible? 

When I don’t truncate fields in a grid in an Email Digest, the column widths are randomly set, often times wasting a ton of space: Everything auto-fits if I “Truncate text,” but I still want my last column to show all the information — any way to have the auto-fit of truncated but wrap text for rich text fields?

How can I ascertain how large (MB) my base is? Grazie!

Hi there! I want to create two tables that create "matches" based on certain criteria's between the two tables. The one is for houses, the other for people who are looking for a certain house. As soon as a match is found, a signal needs to be send to a third party tool that sends the specific house to a person. The script that sends this signal to the other tool is already in place.Whenever a new profile is created or a new house is created/updated, the matching criteria needs to run (we primarly match on price, m2 and location).My initial thoughts are to run three separate automations based on the create/update triggers with a script that searches through the database.Is this the most effective approach or would there be a smarter way?

Hi there,I have two tables : "Meetings" and "People".Each meeting is of a certain Type (Single Select)Each meeting can contain multiple People. Some People are team members, some are not.I want to create an interface chart to display the total number of meetings per People, aggregated by Type, but only for certain People (team members).Unfortunately, when add as a condition that the displayed Meetings have to contain People that are team members, the graph also shows other People that are part of these meetings, but that are not team members. It makes sense so far.But what I would like to do is to filter the People displayed on the x-axis only. Is there a simple way to do so ?Thank you for your help !Jean

Hi all,I'm trying to set up a form which has a dynamic appearance depending on the time of day/day of the week.During our working hours I'd like users to be able to submit details through the form in order to receive an urgent response from our clinic team.  Out of hours, I'd like to divert the user to emergency contact details and a link which allows them to book a routine appointment with our team.Any thought on how this could be achieved?Thanks in advance,Laurence

Hello,Apologies if this has already been posted somewhere, but I'm trying to create an automation that updates a linked record field without overriding the existing data. I have two tables:Table A - Contains document recordsTable B - Contains a list of role records I have a linked record field called "Role(s)" in Table A that I'm using to associate documents to their appropriate roles from Table B.I want to create an automation that automatically assigns certain records from Table B to the linked record field in Table A without overriding any existing data (only adding to it).Example: I link the "Inventory Associate" and "Production Associate" records to the Role(s) field. I want to automatically link their supervisory roles ("Inventory Supervisor" and "Production Supervisor") as well without affecting other data that may be present in that cell.I set up a test automation with the following triggers and actions: Trigger: When a record matches conditions: Role(s) is any o

Hi, I don't have much experience with API requests. I am trying to understand how it all works. I am currently using Node-RED (visual Node.js) to process the requests. I was able to complete a GET request and i'm now trying to do a PATCH request to update data in Airtable.I get the following error message when trying:type: "INVALID_REQUEST_MISSING_FIELDS"message: "Could not find field "fields" in the request body" Here is the schema in question:I am unsure where the API is expecting the request body.Here is my test JSON:{    "fields": {        "CCISF": 5,        "CORAMH": 5,        "RJCCQ": 5    },    "typecast": true} Do I have to include all fields present in the table or only those i wish to update with the PATCH request? Thank you.

I'm using my airtable to attached keywords images. I have one big keywords table with multiple categories of different keywords. Then i have multiple linked columns to the different categories. However some of the keywords overlap into different categories.So I thought I could rollup all my linked columns and do something like this:  ARRAYUNIQUE(ARRAYJOIN(ARRAYJOIN({RollUp1}) & IF({RollUp2}, ',' & ARRAYJOIN({RollUp2})) & IF({RollUp3}, ',' & ARRAYJOIN({RollUp3})))) However I still have duplicates of keywords in my final array. Does anyone know how I can join my rollups and then filter out all the duplicates? 

Hi all!Pretty new to this, but I'm trying to write a script similar to Airtable's child-record script. The script should: For parentTable (defined in config), when a record's value in a field (singleSelect defined in config) matches conditions (defined in config), then it should assign this record as parentRecord, and create a link child-record in a childTable (defined in config) and populate this record's primary field with the value from the parentRecord's primary field. I am having some issues with the config, and wondered if anyone knew how to fetch the options of a field specified in input.config.field so it appears as the options in a input.config.select dropdown list. I want to avoid hard-coding it, but it is an easy workaround if it's impossible.Here's the code I have for the config. const config = input.config({ title: `Conditional Parent-child record creation`, description: `For records in a parent table with a matching value of a designated field, t

I have an automation set up that loads Google Calendar meeting info into my database, including attendee email addresses. What I want to do is extract the emails of only the people who are not internal employees. That is to say, extract all emails in the “Attendees” field that do not end in “@company.com”. External participants could have any number of email domains and I want to be able to extract any and all email addresses of Google meeting attendees who are not from our own company. I hope that was clear. Thank you!

i'm wanting to get employee data from Workday such as when a new hire happens, employee terms, or just an update to employee record. I'm using the HR workday connector from Workday and I believe that I configured the connector correctly, but i'm still getting a 500 error. Are there any suggestions to get my connection working?

Hi Everyone,I am sure this is a common question, but I can't seem to find it... When staff join they have a 3 month/6month and 9 month review. They then have their Annual review (which is always 1 year after their 3 month review). They then have a mid term review and an annual review. My question is...Is there a script/formula that takes the last date entry in Person A's row and creates a date that is 6 months after it so I can then run an email automation 2 weeks prior to that date to remind Person A  their review is coming up. In my example below (DATE FORMAT IS EUROPEAN) As you can see Person B has been employed longer so they are further down the chain they have just had their Y2 annual review and so their Y2 mid term would be 6 months from then (ie 22/7/2024).Person A's however is still in Y1 and has just had their mid term so they are due their Annual review on 6/5/2024.So each row will be a different person who will have different dates as they will be at differen

We've recently published Airtable Sync Figma plugin and we're using it internally but it's surprising to see that there is no much interest from users.As designers and developers, working with real data in our mockups is essential to ensure accuracy and avoid unexpected issues during development. We expected that this plugin would provide great value to both Airtable and Figma community.We would love to hear your thoughts, feedback, and use-case scenarios to better understand the demand for such functionality. Let's discuss and help us improve this plugin to better serve the needs of the Airtable community.

Hello, we duplicated one table from a base to a new base and a field that originally contained images got converted into a text field that contains the file name of the pictures and a URL. Is there a way to do duplicate the table without this happening? 

When I link table entries to another table I get these boring gray boxes with the linked record. It gives me no information other than the name. It would be great if I could, in the formatting tab of that link, choose a view from which it should get the color information. Example: When I have tasks with a complete field in another table and I link these tasks in my project. I could create a color coding in my tasks table: Done tasks are green. In Progress tasks are yellow. Not started tasks are red. Now in the project table, in the link column, I would say: Take the colors of this one view that has the colors. Now the grey boxes would be green, yellow and red, depending on their color in the other table and I would have a huge informational boost at a glance. See this mockup.

Hi guys, I was wondering if it is possible to change the linked fields inputs in different colours like they are shown in the original table (that had the field type “Multiple selection”). It is a shame that the linked field inputs are all grey. If you can help me out with this one, would really appreciate it.

Hello,There's a user in my client's workspace who has already been invited as an interface collaborator with Editor permissions for some interfaces I created. The problem is, the user is not being able to create a record in one of those interfaces that already has the Editor permissions. When the user tries to create a record this message appears: "You are not permitted to perform this operation". Could you help me solve this problem please? The weird thing is, a few days ago the user was able to create records and didn't have this problem. I don't understand what happened because I didn't make changes to the user permissions.  I already made sure the user has Editor Permissions to that interface, and that table has the permissions that Editors and up can create records. 

Hello,we would like to find a formula to count down 24 hours and end at 0 or if possible marked "canceled".if anyone can help us i will be really gratefulthanks in advance

HiI have a base with a column for User.I want to build a formula that extracts the user email of the User assigned and shows it in a new column.How can I make it?

https://api.airtable.com/v0/appv33ENPkh3E1ocj/Opportunities?filterByFormula=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fappv33ENPkh3E1ocj%2FOpportunities%3FfilterByFormula%3DAND(Email%3D'%7B%7BemailInput%7D%7D'%2C+OR(Stage%3D'Needs+Underwriting'%2C+Stage%3D'Make+Listing+Price+Proposal'%2C+Stage%3D'Due+Diligence+Items'%2C+Stage%3D'Appointment+Set'%2C+Stage%3D'Final+Underwriting+Review'%2C+Stage%3D'Follow+Up'%2C+Stage%3D'Long+Term+Follow+Up'%2C+Stage%3D'Negotiation'%2C+Stage%3D'Retail'%2C+Stage%3D'Closed+Lost'%2C+Stage%3D'Closed+Won')%2C+Record+Type%3D'Seller+Opportunity') Trying to use this request. Any advice to my logic? 

Hello Everyone, I am trying to create an automation that sends draft social media posts for approval. The problem I am running in to is being able to reply to these actionable messages in Slack with text that will update an airtable field. So basically here is how the work flow goes. When a new post is created and is in draft it will send an actionable message to a slack channel with two buttons. The first button is "Approve" and the 2nd button is "comment". If the comment button is clicked I would like the slack user to be able to enter some text that will then update a field in airtable. I have been able to get the approve button to work but when the comment button is selected I do not get the option in slack to enter text. How can I solve this problem. I would appreciate your input. Thank You