Ask the Community

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 }).base(baseId);base(tableName).select({}).eachPage(function page(records, fetchNextPage) {records.forEach(function (record) {console.log("Retrieved", record);});fetchNextPage();},function done(err) {if (err) {console.error(err);return;}console.log("Finished fetching records");});```and this approach:```const fetchAirtableData = async (baseId, tableName, personalAccessToken) => {const url = `https://api.airtable.com/v0/${baseId}/${tableName}`;try {const response = await fetch(url, {headers: {Authorization: `Bearer $

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,  Have a nice day,  Arthur

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 that you will find the line having the issue.  Here is o

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 in the first table to 'True' if there is a record in the second table that has a matching Make/Model/Line combination.I created an automation that works (sort of) in testing mode. It actually saves one of the values in to the Exists? field as I haven't worked out how to make it say 'True'.But I can't work out how to run the automation on demand. I have tried having a checkbox field in the first table and watching that field, but that doesn't seem to trigger the automation. I would ideally have a button field on each record - sort of 'Check this' - or a button that would check all the fields in the first table.How should I attack this ?

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 referencing in the existing formula that generates the campaign name in the "Campaign Name" table?

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.