Ask the Community

Hi dear airtable community, I’m using airtable curl API and I want to get the data from the oldest. I believe the go here is the sort parameter passed on as a query, but the createdTime is outside of fields, how can I access that? createdTime has to stay and must stay out of fields for my use case. Current endpoint I’m using, just need to read the createdTime that is outside out fields https://api.airtable.com/v0/{base}/{tableName}?sort%5B0%5D%5Bfield%5D=createdTime

  We are a small design build construction company. We have started using airtable to organize the design details of our projects. These include things like paint colors, cabinets, flooring, etcOur ideal workflow would be: Click a button to create a new project and then be able to import templates based on what is in that project scope (tile work, bathroom, kitchen etc).Pull items from our catalog and other sources to create the selections.Generate a PDF report that we could send to the client to get a signature.Track changes made to the selections.Once the selections are signed, we would move to procurement and use airtable to track purchased items ( when to order, and when they arrive on site).When the project is complete we would present the customer with a printed copy of all

Just need help determining the correct selector and attribute on the Linkedin applicant html page.I first tried Text Content by CSS Selector using the id which worked flawlessly until I realized that the id isn't static. It changes every time I open a different candidate. Now I want to try using the HTML Attribute by CSS Selector but I need help determining which HTML to use. The code is attached.Thank you so much in advance for any help you can provide.

Hi everyone,I have an Airtable view containing filtered records that may change daily.I want to set up an automation to send an email with all the view records as an attachment (CSV/PDF/Excel) or in the email body, every day if the view contains any records. Is it possible with the SendGrid App?What is the best way to achieve this?Thanks in advance for your help!Best regardsRashid

Hello!I would like to figure out how to share a database between two users for personal use. The paid plans that allow for Airtable Sync are a bit too expensive for me to be able to justify for just this use, so I would like to understand what my other options are.To expand on the use case, I would like to set up a career search workspace. In this workspace, two users that are applying to the same companies (and sometimes the same jobs) would be able to track applications, interview, and job offers for various jobs across different companies. I am envisioning a base that contains a "Companies" table and a "Jobs" table. Each job, when entered via a form, would be marked as being applicable to one or both of the users. These jobs would then sync to the applicable user(s)'s unique Application-tracking database. In my mind, splitting Companies/Jobs into one base and Applications/Interviews/Offers into another base (vs. all in one base) would prevent the need to create seve

I have the calendar working and syncing with all my accounts. I am looking for a way to align the appointments in columns based on with email the appointment is made with. Currently all appointments get aligned left and if there is a opening in the schedule, those appointments shift left and are no longer aligned top to bottom.  I only care how it looks on the public shared calendar.

Hi there,I have a table 'users'. Each month, users must pay the breakfast. I need to check, resend the task, count and confirm that all users have payed before the first of the month.I was thinking to create a table 'breakfast' and... I am stuck &#x1f605How are the step to do that pleaseThank you in advance  

My team is in the process of building a master planning base that will require eventual syncing from several different Airtable bases across our company. We've installed the dedupe extension and it works for anything created in our master tab. However, it doesn't work on items in that tab where one or more of the duplicates was synced in from another base (for reference each department currently has its own tab with one way sync enabled into this base, and then we have automations set up to create records with the needed information in our master tab whenever something is added to a dept tab).  Is it because some records are being created in our master tab using an automation? Any help would be appreciated, thanks! 

I am trying to build a functioning workout log for this new workout plan I am planning to start.  I want to be able to create it on interface designer and be able to update it on my phone as I am in the gym.The workout is divided into 12 weeks with 4 workouts a week, each workout day is divided into two sections.Here is an example: Each week there is a slight progression and every three weeks the plan updates with new exercises, but overall stays within the same model of 3 days of Strength work and specialization, and one day with special workouts.I would love to be able to easily add in the weight of each set I perform as

i have a field that is a text field, i am trying to set up an automation to copy the contents of the text field to a linked field, is that possible?

Im trying to filter the next api request: https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=assignee%3D+9650 but instead of the assignee being 9650 i need to filter it by names like "Nick Smith", how could i do it?The error i get when i try to put a string instead of a number like:https://api.airtable.com/v0/appn8Dg5iLM042oZh/tblDamHA046rqdTJF?fields%5B%5D=client_address_(from_deal_id)&fields%5B%5D=client_name_(from_deal_id)&filterByFormula=assignee%3D+samantha is: "error": {        "type": "INVALID_FILTER_BY_FORMULA"

Hey all, I am trying to create a solution to reduce the image sizes in one of our bases, that is wildly over limits due to being populated with MASSIVE cell phone photos uploaded via a form.Currently I have setup an automation to trigger a miniextensions webhook that compresses the image and places the resulting smaller file into a new field.What I would like to do now is create an automation to run at a specific time to delete the contents of the original field automatically.The update record function does not support deleting field data (why?).Can someone assist? Thanks! 

Hi I am an Airtable user on a Team plan ($24 a month). I want to invite a collaborator to see their own tasks and update their status eg. ‘to do’ to ‘ done’ and add a comment. I am going to have lots of task owners – but to invite them all is going to cost $24 each a month for essentially a very simple limited use of Airtable from their part? I need my table to be in the ‘Team’ space for the additional color and formatting although my ‘task editors’ don’t need to be in that space. Is there a cost effective way of setting up the above? Kind regardsAndrew

Here's the story:A few years ago I set up a base to capture birthday information for school applicants. Users would fill out a form (everyone using it was on EST), and enter a birthday (date only, no time).A year or so ago I started getting reports that some dates shown in our dashboard interface were off by 1 day. E.g. if the entered birthday was Dec 10, the interface would show Dec 9. (This may have correlated with when Airtable made some changes to the way they handled dates/timezones internally?)I'd like to fix this "correctly", so I'd really like to understand what is happening behind the scenes.When users submit a date with a form, does the user locale or browser timezone have any influence on the submitted date? Did the behavior of form-submitted dates change when Airtable made date handling changes?Are dates still stores as ISO strings (with timestamps) even if we don't want/have any time information?How can I correctly render a date

this is the formula field in the record -  This is the formula -  Formula FormattingThe email in the automation -  The actual email received, the "EC Formula" has way to many decimals, it should only show 2 like in the actual record - How can we fix this? Thanks!    

When a person joins our company I record their actual start date. However, their annual contract renewal date always starts the 1st day of the following month.I want to be able to record their start date and then have a column showing their next annual renewal date (the first of whatever the following month is) that updates as years go on.Example) Someone starts on 11/15/2023. I want the renewal column to show 12/1/2024.  Once the present date is past 12/1/2024, I would want that to automatically update to 12/1/2025.

I need to add up the total days of sick leave, as well as the total vacation leave. This way I can track if they have reached the maximum # of leaves. Can someone assist me?

Hello the community,I work with airtable since acuple of year and it is great. But now, i can't level up my base because i don't have enaugh knowledge and programming skills. So i'm looking for someone that can upgrade my base with my actual needs. I need a pro service and i'am ready to pay for that. It can be in a remote loaction or whereever. But it should be in french (best) or at least in english.Thank's in advance, best regards.Thierry

Let's say I have a table of Invoices and then a table of payments. Each invoice is an aggregate of payments i.e. one invoice can have multiple payments. How can I get the index of each payment in the list of the invoice?

Hi, I've put together a few Interface pages that I'm very happy with. Dashboard pages allow you to add various elements together in the same page, but for any other page type this option disappears.Is it possible to add an element to, for instance, a List page?My use case is to add critical information/instructions at the top of the page, or a button to submit feedback specifically on that page. I would simply put my List in a Dashboard page, however doing that removes the ability to use filter tabs, which I need. (Yes, I'm aware of the ability to filter lists in a different way in the Dashboard, but I specifically need the tabs, and the option to "Collapse all by default"...neither of which are available in the List element in Dashboard pages.)

I have an production website using softr and I have a database with about 3000 records.I notice that when I initially go onto a page with the softr site, the load time of the data take 4-5 seconds.  However when I come back to that page in say 10-20 minutes and refresh the speed is very quick. If I come back to that same page say 1-2 hours later, again the initial load time is very slow. There is no caching enabled  by softr  and I disabled all browser caching, so I am thinking the slow initial loads their must be a from a db connection timeout and the slowness is by the system needing to create a new connection with the DB and running the query.So I was wondering what is that db connection time out?Knowing that will allow me with a Curl script to load a page every "X" minutes, so the end users don't experience any slowness.Thanks,Jeff

I would like to create a user portal where our Board Members can login and read displayed information from a base and respond some basic questions (Yes/No, Check mark, comments) that would become linked records. I've found a way to add the reviews inline while viewing a Record View, but ideally, the option to add would be at the top of the field (and possibly hiding the other reviews written, or displaying them in another place), and it would automatically capture the User Name. Moreover, I would like it to be able to show which of the records that person has not yet reviewed. Is there a better way to do this? Possibly via integrations/extensions, or better yet...free forms!I feel like I don't know the terminology well enough to find what I'm looking for, but surely it exists! 

I want to get the creation date of my records and I can't figure out what the variable is.Is there way I can get it, like I can get the record ID (record.getId()). I have tried record.getDate(), record.createdDate()). Here is what I have:return new Promise((resolve, reject) => {base('Resource').select({sort: [{ field: 'Type', direction: 'asc' }],filterByFormula: 'AND({Type} = "'+type+'")'}).eachPage(function page(records, fetchNextPage) {records.forEach(function(record) {console.log(record.getId());co

Hello Community,My email automation that I use to send out reports has failed 3 times in a row and does not give me any information besides it has "failed". I went to the automation itself, tested it, and it said everything was fine. So I am not sure what the issue is. I am attaching a photo of the email I keep receiving. Hopefully I can get this figured out soon. (This is also just the normal email automation, not the gmail specific one.)

I am trying to insert a formula field for a "friendly name" into an automated email.The formula just looks to see if a person has a nickname and then either uses the first name or the nickname.IF({Nickname},{Nickname},IF({First Name},{First Name}))I keep getting this error message:""Message" could not be converted to a string."What the heck does that mean?Thanks,~Lisa