Ask the Community

I would like to set up and automation that "At 9 AM every Monday, Airtable will automatically send a Slack message to a user if a certain condition is met (e.g., "Task1" is set to "Pending Activation"). The Slack message will have an actionable button (e.g., "activated"), and when clicked, it will update a specific field " Task 1" in Airtable (e.g., changing "Pending Activation" to "Activation"). But the test result is negative and showed received invalid inputs.    

Does anybody have a good workaround for delaying email automations for (example) 10 minutes? Our situation: When a project goes over budget, an email is sent to the project manager But: the email will go immediately, which is a problem, because the project manager might simply be in the process of updating the record, and once he’s finished with his updates, the project might not actually be over budget. Therefore, we are getting tons of false notifications. What’s needed: Some sort of pause before the notification is sent out, where Airtable checks to see if the situation is still true for that record, before sending the notification.

Hi! On my table I have three fields, "Start Date", "End Date", and "Week Number". I am trying to make an automation that extrapolates the week number from the date range. I know there is a formula that does this but I'm looking to have the field be a single-select color-coded field. I have an automation that is working out well but I can't figure out how to do the automation so that it would automate multiple weeks if the start and end date spans multiple weeks. Current automation: If start date is 1/1/25 and end date is 1/3/25, return week 1. Where I want to get: If start date is 1/1/25 and end date is 1/9/25, return week 1 and week 2. Is there an easy way to do this? 

Hello dear Community,I am brand-spankin' new to this platform. I am doing a trial interview in a few weeks and the organization that I am interviewing for uses Airtable especially for managing their staff and for their intense travel and organizational schedules. Might anyone have a referral for me either a mentor/tutor or for a program that I can access online? Thank you! 

I am working on a seating chart for an event that has 150 tables of 10 and want to create a base that will help me assign people to tables, track how many open seats I have at a table etc. Any suggestions?

Is anyone else seeing the Apply button in their filter conditions?  It showed up some time this week but it's not in every table.  This is annoying! Is there a way to turn it off?There:Not there: 

Can we please get an option on Air table that is a fixed monthly rate for either unlimited or a large, allocated amounts of users! I need to scale but paying $54 per user per month when we need 20-50 users is an insane amount of money just to be able to tag the correct person i need to assign something to. Does anyone have a workaround for this so I can delegate tasks to people and actually have them get a notification???? 

I have a table <TableA> whose records <TableARecord> have a field <LinkedRecordB> which is linked to records of a second table <TableB>.I am try to use that field <LinkedRecordB> for automations and I don't see how.If I try to use it in a Condition Group, when defining the condition I can only use the record ID and Name.If, as a workaround, I try to find the corresponding record in <TableB> using a "Find records" action with "Find records based on" when trying to defined the condition I am not even able to select that field <LinkedRecordB> and get an error message when hovering stating: "No valid nested options"The only solution I have found is using adding another field of type "Formula" in <TableA> an getting the Name of that linked record <LinkedRecordB> and then using it in the condition in option 2.

Hello. I'm brand new to airtable. Less than 2 days. I'm struggling a lot. I have a table with basic member info in it (member id, first name, last name, email, etc).  Now, I want to create a form, let's call it "sign up for party". I want the results of this form to populate another table, but be linked to the data in the main members table.When I create a linked field in the form, it shows EVERYONE in the table!! That's a huge security issue!! I want people to enter their member id into the form and have that id validated that it exists on form submit. When they submit, the record should be created in the new 'signups' table, linked to the main table.how do I accomplish this? This seems fairly simple/common, yet I've spent 8hrs trying to figure it out.

Greeting ! Attached image explain the question, Thank for your support.

I want to share an interface with my teams (more than 10 users). They just need to edit/update some data on the interface, but when I want to share with them, I need to change to 'Editor'. So, there's more than 10 editors in 1 interface. I'm using Business plan (annually).  I don't understand at the part where I need to pay for each editor, which means the bill is not fixed and it will be added for each 'Editor' I add? Does it actually include in the bill, no extra charge or what? Can't I just share with my teams without extra charges?

Hi Community,  is there any way to use Assignee fields from Airtable in Fillout? BestMirko 

I have a formula field that gives me a date.then I have a normal date field "current". For example, if I enter a date in the "Current" date field, then the formula field should calculate 2 years from this date and give me the date in 2 yearsExample: “current” has the value: October 1st, 2020Formula field calculates 2 years further10/1/2022works quite well so far If the “current” field is empty then the formula field should take the date of “approval” and calculate 3 years from there.Example:“Approval” has the value: October 1st, 2017 then the formula field calculates 3 years further so: October 1st, 2020 also works.but every time this formula is executed, I get a linked tablea new data set is simply created even though this is not what is wanted.here is my formula:  DATETIME_FORMAT(IF({Letzter HU/ AU Termin}, DATEADD({Letzter HU/ AU Termin}, 2, 'years'), DATEADD({Ers

I recently saw that we can create Kanban views using LinkedIn fields and not just single-select options within that table. Question though—how do I change the order of these columns? They seems to be sorted automatically although it's unclear how it's being sorted. For what it's worth, I can't manually change the column order (which is what you could do for the single select fields)...

I want to automate the synchronization between two fields in Make and Airtable. I have a “date” field and a “selection” field that contain the same information. I would like the “selection” field to be automatically updated with the same value as soon as the “date” field is filled. How can I achieve this?

Hello!  Can anyone help me get some more useful info from this chart?I want to be able to show a list of breeds with counts in descending order.  It seems like its still alphabetical in this legend which doesn't help much. I've also  been able to see the counts in a group sort on my member talbe, but I dont see any way to get that info somewhere usefull.I'm open to creating a new table which would create new lists that show the counts of each breed if that's the best way to do it.  Thanks!  

Hi All, I am trying to build a Reminder portal to track some key dates within Airtable and was wondering how in Airtable can I use Formula or if there is any other way to find the date that is due to come from a range of dates (sample data below - I can use the MINIFS function - =MINIFS(A1:D2, A1:D2, ">"&TODAY()) in excel to find the smallest date that is greater than today's date). But how do I achieve this in Airtable ? I couldn't find the Minifs formula function in Airtable  ABCDE1Q1

I would like to set up an automation to send an email when a condition is met...and I'd like it to run every 2 weeks or every xx weeks or xx months. Is this possible?

I need to copy a URL from one field and not just paste it into another field, but paste it into the “Get Image URL” style field … and then UPLOAD IT. If you’ve used the “get image URL” type of field you know you can drop files into it or past a URL into it so that it uploads the file to AIrTable and gives you an AIrTable URL. The difficulty here is that you can’t just paste a URL into that field. You have to (a) CLICK the filed first and a menu appears. (b) Within that menu you must select he URL link icon to make another field appear. (c) Then you past your URL into THAT field (d) Press upload (f) a small image of your uploaded file appears in the field which you can THEN click on and get an AIrTable URL for. **How do I automate this? I’ve created a small loom.com video below to show the stapes in my database I need to automate. ** [

New user here, though I'm getting some great experience so far, especially with help from this community!I come from an ERP background using Peoplesoft so I have a good understanding of traditional relational databases.  One thing that is good about PS is that a field, such as "business_unit" is uniform across all the records on the definition side (though the tables could be built diffrently).A few "nice to have" suggestions I'd put forth regarding the field definitions include:When adding a field to a record, and if that field name matches another table in your base, you should be given the option to replicate the attributes (field type, defaults, etc) from the other table. If more than one table, let me select which one I want to duplicate.On field definition, it would be useful to define a form label and on the form allow a person select an option for field name, field label, or custom. I know we can change the label on the form, but it wo

Hey guys,So I need your urgent help. I created an interface for one of our collaborators with edit access and everything worked fine but now the data can't be shown. If I go in the edit mode as an admin, I see the records and all the filters as before, but when I go on "preview" it says like for the other person that records are not found. I checked filters, permission etc. but it is the same as before. All set correctly. What happened? Please help 🙂Best,Madeleine

Hello, I'm looking for a method to link records with comma seperator like below:Ex: CDA, Fresno Foundation should be linked as CDA, Fresno FoundationBut my current job does the linking separately and creates two distinct linked records as CDA Fresno FoundationIs there a method to accomplish this? Please advise. TIA

If you're working with numbers and formulas are returning different results, rounding differences or precision errors could be the cause.Solution:Ensure that both formulas are using the same precision (number of decimal places).Use the ROUND() function in Excel or SQL to limit precision.

Hello everyone,I have a table in which we record events. Some of these events relate to a media campaign that is also recorded in the same table.I have therefore created a column in which you can link a campaign when creating an event. To do this, I use a view in which only the campaigns are displayed.This works without any problems. However, when I assign an event to a campaign, I would like the assigned events to be displayed in the campaign data record.Does anyone have any idea how I can implement this?Currently, only the selected campaign is displayed in the event record, but not the other way around.I would like to be able to click on the campaign record and see all linked events.Does anyone have any ideas on how I can implement this?Thank you very much and best regardsMirko

Why can’t I save a webpage or anything i suppose to an airtable base using the share module on ios? Notion and other similar products allow it