Ask the Community

The question is the following:If we receive predicted emails inside a folder within our email account.How to manage automatic clicks as it is time-consuming to click manually?The link is called all the time Always with the same name: Verify Request

Hi! looking for help using Integromat - i’ve been trying to use Gmail Watch function and extract the attachment to Airtable but couldn’t get it working. What should I choose ? just click “choose” and select the attachment doesn’t seem to work. If I click Map and then add item, what should I select in the file URL? I selecting the attachment but it doesn’t work either. Thank you for any advice!

Hi there,I have a multi-sync table that collects tasks from different bases.More precisely: I have Team A Base and their tasks, Team B Base and their tasks and Team C Base and their tasks and collect all tasks from both teams in multi-sync base "All tasks" (for cross-functional teams that work with all 3 teams). Now I know I can sync back edits to each base with two-way sync.What I would like to achieve though is that I see all tasks from all teams in all task tables (Team A, Team B, Team C and All tasks). That way, every team can continue working in their own base with increased transparency and without missing a tasks (e.g., I am part of Team A, but team B assigns a task to me --> I would miss this task if I don't check out Team B Base or All Tasks).Does anybody have more insights here?Thanks and best, Steffi

Hi, there!! I need an automation to do exactly what the subject of the topic says. We’ll fill the e-mail field in Table 2 from a csv import. Then we need the automation to lookup that email on Table 1, get the Name value corresponding and then fill the field Aluno in table 2. I found a script in another post that I adapted to what I need but I’m still learning to code so I need help to fix my script. Can anyone pleeeease give me a help? About the script: I added 2 variables - tho I don’t actually need record ID - but I followed the instructions on the other post. Variable 1 is recordID and the value is Airtable record ID Variable 2 is email and the value is email Both variables are being pulled from Table 2 let config = input.config(); let table1 = base.getTable("Base de Alunos"); let table2 = base.getTable("Entregas Plataforma"); let query = await table1.selectRecordsAsync({fields: table1.fields}); let found = query.recor

When I change a status in my record I want to check my data entry. If this check fail I want to stamp a warning in a popup message or similar because I want that the user knows this. Somebody can help me? It was more simple in vb but I didnt find nothing about. Thanks

Hi all, apologies if this question has been asked and answered already. [EDIT: attached a screenshot since the embedding images don't seem to work.]I am creating a table of contacts for relationship management. For each person, I have the fields "Introduced by" (whoever introduced me to them) and "Introduced me to" (whoever they've suggested I talk to). I want these fields to mutually autopopulate. For example, if John Doe suggests I talk to Johnny Day and Jane Smith, and I've put Johnny and Jane in John's "Introduced me to" field, I want "John Doe" to automatically appear in their "Introduced by" fields, instead of having to do it manually:Ideally, it should work the other way around as well. If I put "John Doe" in Jane and Johnny's "Introduced by" field, their names should automatically appear in John Doe's "Introduced me to" field. The logic is

I want to know when an approved campaign goes back in to revisions so that I can review it again. I have multiple other reasons to want to know when a campaign status changes and what the previous status was; e.g., trigger subtasks for team members, notify leadership etc.I use the following statuses: planning, assigned, in progress, completed, approved, scheduled and launched.and two nonsequential values (revisions, missing inputs) that can be used at any point in the process.What I currently set up:The status field is a single-selectAn automation that captures every change in campaign status and populates another tableThat status tracker table is linked to the campaigns tableThe status tracker table has a 'status field' last modified date fieldWhat I want is a way to compare the previous status field to the current status field so I can trigger actions based off of the new status. What I cannot figure out is how to connect the most

I am trying to figure out the formula to populate the date of a specific day in relation to a designated date.Below are some examples of what I mean.I have a date field titled EVENT DATE. I want the column titled PAYMENT DUE to populate the date of five Fridays prior to the event's date aka EVENT DATE.It seems like this should be so simple and/or already a question asked. But I am having a hard time finding a question similar to this.

I want to set a Date field to the current date time in an automation. I tried using a formula field (with NOW()) from a previous step in the automation to set this Date field but the automation fails with the error;Field "Date" cannot accept the provided value: Could not convert string to date.No amount of formatting of the formula field is helping. 

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