Ask the Community

Hi! I'm trying to use a Task Template table & an automation to create Tasks aligned to an Account based on a specific criteria. I've got the automation working with the following set up: When a record matches a condition in the Accounts tableProduct/Service [LinkedRecord to the Product/Service table] is not empty Find Records in Task Template table & create list based on Product/Service dynamically pulling in Product/Service of Airtable ID in triggerCreate Records in the Task List for Accounts table with the relevant fields. Here is the problem: I want the "trigger" to be a multiselect field (IE there could be one or many product/services purchased by an account). I am having trouble figuring out how to change the trigger such that it creates tasks that are linked to multiple Product/Services. (In the Task Template table I've also linked the Tasks to the Product/Service. Some of these tasks can be for all three services). I want to look at ALL of the tags in the&

Is it possible to only show certain fields to certain users?For instance, if someone is logged in and has an email that ends in @whatever.com, we can mark that field only visible to those users.Any other suggestions would be welcomed!

Hello, I'm fairly new to the paid version of Airtable and I've been able to figure out most of the features and automations I need. I'm specifically wondering (especially with the updates that have come out) if there's a way to validate entries and form conditions. Example: students input their e-mail address in a form. If it does not meet the condition of having their .edu e-mail address, there's no way to reset the form or put an error message up. I have tried putting a conditional field that it must include the .edu student address portion, and I made it a "check box" format with an error message. Students do not seem to read this and submit the form with incorrect data or the form not even being filled out. Is there a way to not allow the submission if certain things are incorrect?Also with attachments, is there a way to condition that attachment to only accept certain types of files? Thank you!

Does anyone have any ideas on how to label relationships in this CRM we are building? We have multiple relationships we want to label such as spouses, siblings, advisors, parent-child. We also want it to work in the inverse so it shows that Sally is the child of Tom and Tom is the parent of Sally. 

My table tracks publication start and end dates for various websites, and I need to determine the time between the previous record's end date with the next record's start date.Examples:  Site A's publication will be taken down on May 31, and the new one will go up on June 1.  Site B's publication will be taken down on May 31, and the new one will go up on June 6.These require different processes ("turn this one off, wait some days, then turn the next one on" vs. "replace this one with the next one"), and I need to indicate which process should be followed.Each publication has its own record in the tableSite A / Start Date: May 1 / End Date: May 31Site A / Start Date: June 1 / End Date: June 30Site B / Start Date: May 6 / End Date: May 31Site B / Start Date: June 6 / End Date: June 30How can I check to see if the Site's records are "back-to-back" dates? In this case, Site A records are back-to-back, while Site B has a five-day gap in between.(I'm assuming this is going to have

Hi Folks, I need to find the linked table id of a lookup type column. Airtable metadata api returns this information for record links type field but it does not return for lookup type fields. I share sample response of metadata api for those field types. { "type": "multipleLookupValues", "id": "fldXYZ", "name": "Column 1" }, { "type": "multipleRecordLinks", "options": { "linkedTableId": "tblXYZ", "isReversed": false, "prefersSingleRecordLink": false, "inverseLinkFieldId": "fldYYY" }, "id": "fldAAA", "name": "Column 2" }

Hello, I am building an Airtable integration for my product to use the Airtable API on behalf of users. I would like to use the Official API client which is airtable.jsIn the interactive documentation link given, I had a look at the "Javascript" tab to see code snippet about Authentication, but it is using apiKey.In the airtable.js documentation saying :"OAuth access tokens can also be used." I would like to know how.Do you have any code sample with OAuth or documentation showing how to use OAuth access with airtable.js please ?

I've read through several help topics and I am still having issues, hoping someone can help me. I have a field that is counting the days between the due date and todays date. I need to use these numbers to create a formula to provide an aging report. I'd like the 'Aging' Field to use age count to represent I need to group my table by aging, which I am trying to do by creating a formula based on the age count.if age count has a number between 1-30, aging is 1-30if age count has a number that falls between 31-60, aging is 31-60if age count has a number that falls between 61-90, aging is 61-90 Daysif age count has a number that falls between 91-119, aging is 91-119 Daysif age count has a number that falls between <120, aging is over 120 daysI’ve read through many articles and forum discussions about the nested formulas, but continue to run into errors, as a lot of the examples are not for so many options.Not only am I having trouble with the formula the age count formula

Hi, I don’t know whether this is a bug or something has changed - we have calendars on our outlook account - we did this using ‘sync to external calendar’ links. We noticed the calendar events are no longer showing in our outlook - they previously were. I am unsure when this changed. I have deleted and re-added the link and the calendar is still not syncing. Has anyone else had this problem?

Hi, I’m looking for a way to query the “line number” (based on the current manual sorting of a table) when iterating over the records. I don’t have a table column which reflects the actual sorting so I can’t use a column as sort criteria with selectRecordsAsync(). Please see this simplified example: let table = base.getTable("MyTableName"); let result = await table.selectRecordsAsync(); for (let record of result.records) { // if record matches a certain criteria -> output certain record fields // including the line number according to the current (manual) sorting sequence } Any hints are appreciated! Thanks, Stefan

Hello!I am looking into creating a workspace where my team would manage information in tandem with our vendors. There will be sensitive information within our workspace - is it possible to give access for a workspace to a vendor, and restrict specific columns, tables, rows or custom fields?Any help would be greatly appreciated!Thanks,Harry

I am working on using an Airtable automation to assign topics to writers. Step 1: Trigger Step 2: Find records that meet the right criteria. Step 3: Send an email with values from the found records as a grid. Step 4: Update the records from step 2. I have a single select field “Emailed” that can be true or false. I’d like to update these values to True. Step 4 is where I am having a problem. I do not see the possibility for selecting Record ID’s for the records found in step 2. Is there a workaround to this? Thanks in advance.

Hi, I have a Data table that is structured in the following way:IDValueQuantity101A1101B2102A3Within the data view I have these records grouped by the 'ID' field. However, when attempting to create an interface and including a 'Record Picker', it shows the records individually. E.g., I selected the first instance of ID 101 and it only shows Value A. I would like to have a record picker that when I selected ID 101 that it shows both the records for Value A and Value B. Is this possible? Thank you 

I have a list of people linked to projects in my Airtable base and I’m attempting to have the slack messages from my automation tag the user associated with the record matching the conditions when the automation runs. I’ve tried inputting the slack id as a look-up from the roster table, I’ve made a formula that concatenates it into a string, I’ve tried it both as id (with <@ and > added in message text) and <@id> in the methods above, but none of this results in a proper tag. The only tag I’ve been able to make work is when I hard-code one into the automation message, but that obviously isn’t dynamic. Has anybody had success here? FWIW; whenever I try to include the field with the Slack id into the message, it doesn’t show up in Slack at all, so I know at some point it’s getting filtered out.

Why are elements (groups) in an airtable dashboard non resizable? I added a dashboard interface in airtable with two number groups that show the count of companies and two chart groups. When I click on the expand button on the chart group, I want it to display the pie chart and the list in a descending order with details below. Though this is seen currently, I am not able to resize the charts or increase the size of the list table below. The table is seen as a thin scrollable section at the bottom and it is a very tedious experience for a user to scroll again and again when in fact the page can be otherwise utilized to show a bigger table. (see screenshot below) As a work around, I tried to create a dashboard using a blank interface. However now the number or chart element is not clickable and it is static. This makes me think airtable dashboard is not a very cohesive tool. If one feature is present, it lacks in another feature. Is there a suggestion to show better dashboards

We have an airtable/make.com combination running a help desk/ticketing system. When people reply to their initial ticket, the system assigns a new record. Is there an automation that we could install that would combine the records?

For some unknown reason (i.e. I didn't make any adjustments to the recipients) my weekly emails generated from an automation that has been running smoothly for months now, went out in these configurations 1) to me only in the To and CC lines 2) to me with the typical recipients now appearing in the cc line in addition to me. Has anyone else had an issue with this today (late March 7, 2024)?

Why does a table that takes 2 seconds to load for me in N.America take upwards of 2 minutes to load for my colleague in Malaysia. Is this normal for whatever reasons related to Airtable infrastructure? or is there something on his side that might be a cause?  

Hello Community,I am a beginner in air table configuration/Automation and I am looking for help to automate sending emails the every new email added into the Email field of the tab/chart.Like I have a chart with fields in it such as name, company, offer, phone, and Email. What I want is that whenever I add/write a new email address to the Email field, an Automatic email could sent to that email address. this action repeats with the addition of every new email in the field.I tried many ways but could not figure out and got error and not send email as i want. If anybody can help me out . That will be highly appreciated.Thank you.

Hello! I need to create a formula that pulls records from fields that correspond to answers of multiple-choice questions, like "What language do you speak"? Our multiple-choice questions also have an "Other" field. "Other" fields hold records which are either "no" (i.e. the person didn't select the "Other" response) or they are "yes, + [response e.g. Portuguese]". I want the formula to be able to pull the text from the "Other" fields IF it's a "yes, [response]" record, but to NOT include the "yes, " part, ONLY the response part (e.g. "Portuguese"). Can anyone tell me how to build that into the formula? Essentially, I need this part of the formula to say "IF the "Other" field contains a "yes, [response]" answer, then extract only the [response] text.Thanks!

Hello, I am looking for a solution for my cycling club that would allow me to create categories for outings and whose members could register by looking at the different outings offered in the calendar. People who offer outings would have the right to create outings but those who register could only add their name and remove it if they cancel.Is it possible do this apps with AirtableEnhanced Cycling Club Outing SchedulerKey Features:Categorized Outings: Allow the creation of multiple outing categories (e.g., Road Cycling, Mountain Biking, Leisure Rides). Each category can have different permission settings and details like difficulty levels and expected duration.Interactive Calendar Interface: Utilize an easy-to-navigate calendar interface where outings are displayed. Members can click on a date to see all available outings and their details.Member Registration System: Members can register for outings with a simple click. Upon registration, the member’s name will appear under the outing

Hey all! I’m a bit stuck here and hope that somebody might have an idea to share. Context: I have a table that lists a bunch of SaaS products that I use (such as Airtable!). Many of them have monthly recurring costs on the same date each month. What I’m ultimately trying to do is create an automation that reminds me the day before each subscription is renewed every month, but for the life of me can’t quite work it out. I think I need a date/time column that indicates the day of the month that each subscription gets renewed, and then I guess a formula that will trigger the automation 1 day prior to the renewal? Hopefully that makes sense… thanks in advance for anybody that can assist! :pray:

Table 1: Companies (a list of every company that we do work for. For this example, say we have 10)Table 2: Products (a list of every product we offer. For this example, say we have 12)Table 3: Price list (a list of the price of each product for each company. If there are 10 companies, and 12 products we offer, this list will have 120 items). Each record in this list has a Company column and a Products column that links to a single record in Table 1 and Table 2.Goal: create automation that will automatically create price list records when a new company or new product is added.If a new company is added, I want the automation to automatically create 12 new records on Price List table, automatically linked to the new company and automatically linked to each product listed on the product table.If a new product is added, I want the automation to automatically create 10 new records on Price List table, all automatically linked to the new product, and also linked to every company on the Compan

I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be the formula for the primary field if I wanted it to be Client Last Name, Client First Name & Spouse First Name Spouse Last Name if the marital status field is married?

I have a very simple web page that does an API GET call.  Sometimes it takes several minutes for the information to be updated.  Does Airtable have a caching protocol when fetching results from the table?  Thanks.