Ask the Community

I am setting up some automation alerts for records that have incomplete information.I would like to trigger an automation if a new record is created to highlight any records that haven't been correctly filled in.Of course, the newly created record won't have had all the data filled in.I am getting a bit stuck trying to "find records" with a "when record is created" trigger that excludes the record being created.Does anyone have any suggestions?

This is related to a Rollup field. This can allow you to tick 'Only include linked records from the Properties table that meet certain conditions'.Is it possible to do the value of the condition, based on a value in the current record? I want to do the below:   Where (Linked Record) RoomId = (CurrentRow).RoomId.It seems to only take static values, which in this case does not make sense.  If not possible, are there any possible workarounds?

Hi Airtable Community!When I create line charts in Interface designer and group data by some criterion, the values ​​are not visualized the same way as if I did not group the records. (Related chart setting enabled)Please help.

I have a base for supervisors to approve staff requests. I'd like it so supervisors cannot see each others requests or notes. So I have built an interface that is set so they can only see 'Viewers records only,' which is looking at the field: Supervisor, which is a user field. So now I need to add my supervisors to the user field but I cannot see how to do that without adding them to the base itself, which I don't want them to have access to. It will let me add them one by one via their email and it says it won't add them to the base, but I need them in the actual dropdown (for automation purposes). Is there a way to do this? I'm finding it hard to believe that I can shut down access to the base for privacy (by not adding them as collaborators), OR shut down access to the interface for privacy (by using the 'viewers records only' feature), but not both?!

Show me how to make an automation to move a record, its fields and comments from one Airtable base to another Airtable base when it enters a view.

There's an Airtable that's been shared with my account (A) from account (B). I have a personal access token from account A.- The Airtable's restricted to account A's domain- The Airtable is password protectedIs it possible to use the API to fetch the records of the Airtable?I've tried this approach:const Airtable = require("airtable");const PERSONAL_ACCESS_TOKEN = "...";const baseId = "...";const tableName = "...";const base = new Airtable({ apiKey: PERSONAL_ACCESS_TOKEN }).

Hi,I am using the "when a new email is received" from outlook email on Airtable automation to collect the information about the email I receive.However, it is not directly possible to get the attachment (is it coming soon?).I have seen some discussion about using Zapier, but Zapier is very expensive. Make is also a solution, but unfortunately the "Trigger module" Outlook email from Make is not "instant", it means it doesn't trigger everytime an email is received but we have to set up an interval for it to run....Not the most convenient (also does it create problems if then more than 1 new email is detected an imported?). So my question is, do you have any other way? Thank you, Have a nice day, Arthur     

Hi everybody, I am trying to set up a specific automation. I have set up already the importation of emails in Airtable, in the table "my emails". It looks like this :Now, I would like to automate the following steps : - check if in table "Contacts", there is in the field "email" the same address email than in the field "email" from the table "my emails".- if YES, then, in "my emails" in the linked field "Contact", link the existing contact with the same email address.- if NO, then create a new record in the table "Contacts" with all the information of the new contact. Basically the idea is simple : if the email comes from a know person, link the email to the person, if it comes from a new person, create a contact for this person.  Thank you so much,  

TraceShipments makes it easier to track packages from different courier companies by consolidating all tracking information into a single platform. Users can check the status of their shipments without visiting multiple carrier websites. The platform provides real-time updates on package location and status, ensuring users are always informed. Additionally, TraceShipments.com offers analytics and reporting tools to help businesses analyze delivery performance and improve logistics operations. This streamlines the tracking process and enhances efficiency for both individual users and businesses.

I have two tables Tenants and Property so i am creating a new record in a 3rd table called interaction where condition is The tenant's move-in date should not be more than one month later than the property's availability date.How to do this ?

Hey guys,I have noticed an issue recently where "Find Records" from a view is not pulling all records from said view, it's only pulling the first 10. I have maximum record limit set to 1000. The view is definitely pulling more records then that. Anyone else having this bug? And does anyone know a fix?Thanks.

Hi! I am working with a team member to embed a Vega-lite visualization into Softr using data from Airtable, and we have successfully been able to figure out how to embed the visualization in Softr, but we want the visualization to display different data for each project. When users sign into Softr, they create a project so all of their data is attached to it in Airtable, but we can’t figure out how to modify the embed code so that it pulls data related to a specific project. Does anyone have any ideas on how to go about this issue?

I am trying  to connect Google API to access Google Drive and Google Docs inside Airtable automation script.I setup a project with credentials and redirect URI on Google Cloud console and I am able to successfully get authorize code and access token.However I realized that access token might not work in case automation as it expires after 1 hour and I will need refresh token to refresh the access token after it is expired.So i am trying to change my code where I am storing the refresh token, access token and expiry time in a table on Airtable Base. But I seems to have issues while updating records on this table using Airtable Automation Run script Block.I will send my Code at the end of this write up. The problem is highlighted below -In the code search for following comment "// Check if the access token is expired and refresh it if necessary"Next block to t

Greetings-Yesterday while using the Windows desktop app, the horizontal scroll bar just disappeared. I have tried to adjust the view and reinstalled the app to no avail. I am certain the solution is something simple, but I cannot seem to figure out what has happened.Aces!

As ever, something that I think should he simple is proving anything but.I have a table with 4 simple fields:MakeModelLineExists ?DellLatitude2243 HPProbookM123 DellOptiplexC132 I have another table with similar Make, Model, Line fieldsI would like to change the value of Exists

Hi I am a total newbie to airtable so I hope you can bear with me. I am wondering if I could share a link externally with lots of different people without airtable account? This would somehow need to be done through automation because I cannot create all of these different group links as there will be too many. Background: I have data with results of a animal rescue drone search and I need to communicate the progress and results of our searches with the owners of the field. We put this information into a google sheets file. So I need to be able to share the results for one farmer (with multiple fields in spreadsheet rows) via external link. But the farmers should not see each others field but just their own.Could someone help me if I can somehow do this with airtable?Many thanks in advanceJanine

I have a “Campaign Name” table that contains a “Product” field (which uses abbreviations).The “Campaign Name” table has a formula field which uses the “Product” values (along with other fields) to generate a campaign name.Our request form (on the “Campaign Name” table) uses the “Product” field, which shows the abbreviations in a picklist. You can only choose one Product per campaign.I have created a new “Products" table which maps the Product Codes (abbreviations) with full Product Names.For example:Product CodeProduct NameWDGWidgetWhat I would like to do is have the form display the Product Name to the user but still use the Product Code when generating the campaign name. Is this done just with Lookup fields, or is another formula required to do the mapping? And then what product field am I r

I have a database that allows users to fill out a form to add information to it. They can also update information via a form as well. While "Created by" is one field, the "Edited by" may have several users and times. Is there a way to store this information in a different base and display it in another?I am limited on the number of rows I can have.

Hello,My accounts departement need to understand how the billing works exactly in order to renew our subscription.Is the subscription renewed automatically ? Because we went from an Enterprise Scale subscription to a free one. It seems like in March 2024, we switched automatically from our Enterprise Scale subscription to a free one. We hadn't reach the date of renewal at the time (May 2024).What does the quantity refers to ? As you will see in my attachments below, I have a quantity of 3 for May 2023-May 2024 then a quantity of 4 for March-May 2024.Could someone please help me ?Thanks in advance,

There were other posts related to the question. Like: WORKDAYAnd workaround is simple and well-known (WORKDAY(DATEADD(Date,-1,'days'),1))But isn't id a bug, that WORKDAY(StartDate,0) does not work?

I need to ensure no dates in my base land on a weekend or holiday. I’m trying to use the WORKDAY(startDate, numDays, [holidays]) formula to accomplish this. However… issues. I’m using “0” as numDays since I do not want to add any days if the date already lands on a working day. This does not move the date however if it lands on a weekend or holiday. If I change numDays to “1”, then the date automatically moves forward a day, regardless if the original date already lands on a weekday. How can I resolve this? Is there a “if weekday” formula that I can add in? See More

Hi everyone, I want to use the barcode to find the exact record, but somehow it keeps listing relevant records.My barcode formula is TX1, TX2...But when I look up the barcode for TX2, it also shows TX20, TX220Can it be fixed? Thanks in advance

I have a Jira Cloud instance with the typical Epic -> Story structure. I'm wanting to pull those epics into Airtable with a link to their associated issues and rollup their story point total. Example:DEV-1 (Epic) Make a sandwichDEV-2 (Story) Get Ingredentiants - 5ptsDEV-3 (Story) Assemble - 3ptsDEV-4 (Story) Eat - 1ptHow can I sync this data from Jira and assemble the proper links so I can reference DEV-1 and rollup the estimates to get 9 story points total? I've tried syncing my Jira tickets into its own table which has the Epic <-> Tickets reference information but am unable to convert that information into a 'hard link' that Airtable can use. See screenshot, if I edit the 'Epic Link' field to "Link to another record" it technically works but I get a message saying my Jira Sync won't update this field anymore. 

Hello. I've 6 tables, I've carefully counted the records (with no filters), it's 906, and Airtable indicates it's Off-limit. (only 5 records deleted in the past week)I've removed 32 records, My computed total is now 874, but Airtable indicates 983 (now inside limits !). All other bases are below 1000 recordsDo you have an idea of the difference (109 records) explanation ? (I need these 100 records !)I work in a non profit organisation giving information technology training, and showing Airtable experience for other bigger organisations with bigger budgets. We have only volunteers, impossible to buy a PRO Plan.Thank's for your help

Hello, I was wondering how I update my fetch code in observable to use the personal access tokens? Here is the notebook: https://observablehq.com/@datagrazing/fermentation-jar and the code in question: Airtable = (await import("https://cdn.skypack.dev/airtable@0.11.1?min")).defaultfull_data = { data = { const base = new Airtable({ apiKey: API_KEY }).base(BASE); const records = await base("ratios").select({ view: "Grid view" }).all(); return records.map((d) => d.fields); }