Ask the Community

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 "Pro

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'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 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

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'Follo

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 

Here is my base I am developing to track VFX shots for a film.Table "SHOTS" is the shot in the film. "Submissions" is the version I get from a vendorhttps://airtable.com/appfa9Uq0xYTTe5oK/shrH1DETOqdRkJUjT/tbl299qf49ykQMspW/viwjFl7u86veCddkU?blocks=hide Ideally I would like to be able to load all the versions in to an array then return the latest comment when I am reviewing the latest version. The array should be sorted alpha numerically. I have been trying with little success to use ARRAYSLICE(ARRAYCOMPACT(values)), -1) Can you do this with the formula, rollup field or do you need to script this?

I am looking to get the user ID from the person who interacted with a Slack Actionable Message. From the Automation Run History, I see the User ID is saved, but for an audit trail I would like to automatically assign that user to the record they acted on.

Hi, does anyone know how to copy fields of a form to another form? This in order to avoid adding the fields  manually

I am creating an automation that sets a single select field from empty to "Date Changed" when my date record is updated.At the moment it works, but the automation is running when both a preexisting date is changed AND when the empty date field is first populated.I would like to the automation to only run when the date field has a value, and the value is changed. I do not want the automation to run when the date field is empty, and then a date is added.Is there a way to set this up using basic Airtable automations, or will this rely on a script.Side note: the goal of this automation is eventually to send a weekly email showing all rows that had a date changed within the past week. If I am approaching this the wrong way I am also happy to pivot, but the date changed status combined with a last edited time seems like the best way to put this together.

Should be a simple automation so I'm certain it's user error but I can't find my mistake.I have a date value. When that date value is updated I want a single-select record to automatically update to "Date Changed"Use case is to generate a weekly email via a separate automation that shows all rows that had a changed date in a given week.My error is "Received invalid inputs."Please let me know if you need more details/context and thank you in advance. 

Does anyone have a solution for a script to run AND a URL to open when a button is pressed? I need actions within the base to be performed, but I also would like to redirect the user to a confirmation page once the button is pressed. I also have a near-identical use-case where I need to guide users to open a URL via a button to edit details on a record in another base, but I’d like to be able to know that they clicked it. Is there any clever way to additionally trigger an automation when the button is pressed (along with having the url open)? Thank you!