Other Questions

Hello!Do you know of any advanced (email) marketing automation tools (such as Active Campaign) that support API integration using authentication methods such as OAuth or Personal Access Tokens?Ultimately, I am left with integration via an integrator like Zapier or Make, but due to the complex database and integration options, I am particularly keen on some kind of direct connection.The business falls into the wellness category - appointment making, reminders, loyalisation etc.Thanks in advance for your guidance!Monika

Hello everyone,I have a specific need that I can't seem to solve. Basically, my database includes training dates with multiple participants. At the end of the module, we ask the trainer to evaluate each participant on at least 5 criteria.So, for each training, there are 5 or more associated criteria. And each registration is linked to an evaluation form to which each criterion is attached, which are rated on 5 stars at three points in time: "beginning of the training," "middle of the training," and "end of the training."I need to send a form that groups all the evaluation forms of the session as a linked record. And then I need to be able to click on these evaluation forms and then on each criterion on which I can add a rating at the beginning, a rating in the middle, and a rating at the end (3 columns in the rating format). I tried using fillout, but it seems it's not possible to update a linked record, which is very restrictive. I'm coming from miniextensions, and this problem w

Hello all I’m a reporter who uses Airtable to keep track of big developments on the subjects I cover. When I find a relevant article, I use the clipper to pull the page title, URL and whatever text I’ve highlighted in the story into a table. It’s a nice system. But what I can’t work out is a way to easily log the date of an article’s publication. It doesn’t seem possible to add a date field into the clipper, so at the moment, I’m writing the date manually into a short text field. That’s fine - though if I want to arrange the articles by date, or generate a timeline infographic, I’ll run into problems. How might I work around this? Dave

Hi. I'm just getting started on airtable and I want information on my form builder in my dropdown menu to show on the actual form. When in the form builder it shows the first and last name plus other info such as status and email addresses but on the actual form when I click on the same field it only shows me the first name. Is there a way to change this? I'm trying to change it from the second photo to the first photo on the actual form. 

Hi, I have a very quick question. When filling out a form, when selecting a record in a linked field, you see [pic1.jpg].Is it possible to change it so that it looks like [pic2.jpg], in the form view itself.This way you are able to see more information about the record you are selecting. Thanks,Nareg

I am creating an automation to bring into AirTable records from a Google sheet that is being populated by Google forms. One of the fields is a Date-Timestamp field. However, even though the formatting is the same in both the spreadsheet and AirTable (namely, Date-Timestamp with the same formatting parameters), the Test Run yields an error that says, “Field ‘Date-Time’ cannot accept the provided value: Could not convert string to date.” Shouldn’t an AirTable automation designed to bring in a variety of fields from Google Sheets be able to bring in Date-Timestamp data without converting strings to dates? Is this a bug? Or am I doing something wrong? Thanks. Mike

Hi all together!I work with an organization with an airtable enterprise account and we are currently having the problem, that a table is limited to 10.000 rows (can this be?).My question is, if there is any limit for rows in a table for airtable enterprise accounts?Online I read about 100.000, but it seems ours is different.

I cannot get DATETIME_FORMAT to work in a Rollup Field. There are multiple dates present in the Rollup Field, and each displays correctly when NOT using the DATETIME_FORMAT I am attempting: DATETIME_FORMAT(ARRAYJOIN(values, “\n”), “M/DD/YYYY”) But that results in an #ERROR! when there are multiple dates present in the Rollup. It works correctly when there is only one date present in the Rollup Field. I’ve found a couple topics on this same issue, but no resolutions. Thank you!

The little grammarly bubble keeps showing on top of what I'm typing. It's specially bad and annoying when I'm working on formula fields and I can't see my formula. How do I turn it off? Toggling the extension off on chrome didn't seem to work. Cheers,

Can Forms be customized outside of just adding the fields in the table? Can I add labels or pictures that don’t add anything to the table but improve the look of the form?

Hi there - I’m looking to set up a formula to determine fiscal year and can’t figure it out. Help appreciated I tried setting up an IF function (i.e., if the date in the “Engagement End Date” column is on or after 7/1/2018, then the fiscal year is 2019, and if the date in the “Engagement End Date” is on or after 7/1/2019, then fiscal year is 2020.) Also - is there a formula in Airtable comparable to IFERROR? I don’t quite think ERROR and ISERROR formulas are what I’m looking for. Thanks! Thanks!

Hi All,Hopefully, there's more help here haha.My automations have stopped working, I've checked the run count and its around 15k well below the max. During my search for support I found my next invoice has changed from $54 to $257.20!!!!! Now I definitely did not permit this change and I don't know whats changed since my last payment. I've tried getting in contact with Airtable support via the chat but its been 30mins with no response. If you have any potential answers I would be very grateful to hear them.

Hello!Is it possible to enable the revision history to show exact dates (instead of "1w ago, 3y ago," etc.?I continue to run into this--where I am trying to find out when a change was made and I get these approximations. Hoping there is a fix for this or maybe it can be requested on future updates.

It doesn’t look like searching in a table searches the comments. Can you help or is this a feature you are adding? Definitely need full text search across everything

I have a form embedded on a wordpress/elementor page, and it is loading extremely slow. On some devices it takes up to 15 seconds to load. This is impacting my conversions.I already reached out to support, but while I wait for them to get back to me, has anyone dealt with this and found a solution? 

Once a week I want to email a report from Airtable to stakeholders (who don’t have Airtable logins). This report is based on rows created in a particular table in the last 7 days. Basically a filtered view of the table. The report could be as text, PDF, Excel or HTML. I have managed to use Zapier to send some data on a schedule. But the ‘Find record’ zap only seems to be able to find a single record. Ideally I want to be able to send a whole view or block. Any ideas? This seems like a fairly basic use case.

Let’s say I have the price of several items in column A, and I plan to add more items periodically. How do I create a field that automatically tallies the total of column A as I add each item? Thanks for your help!

I am building an inventory table for a company that I am integrating into their duda website to display their products. On the main inventory page, the "main" image connects to the gallery widget with no issue. On the dynamic page that showcases each individual product, I'd like to highlight the 6-8 additional product images that I've uploaded into a field in Airtable titled "product images". When I connect a gallery widget to this field, nothing appears. Is it possible to connect a widget to a group of images? If not, how can I showcase all images without creating a separate field in airtable for each on and then connecting those fields to individual widgets on the site? Image attached of my setup. 

I have an automation that sends an email. Now to my question, when sending a message, there is always the sender's email address at the top and then the following (see attachment). Is it possible to remove the text highlighted in red?

I have a table that syncs from emailed data from CSV attachments. I need to be able to delete some individual records. (The data is not valid, and it's messing with roll-up calculations.) When I try to delete a record in the main record UI it's grayed out and says "To delete this new record, update this table's sync configuration so that records are deleted when deleted or hidden in the source." But I don't know how to get to the source since it's an emailed CSV? Can anyone advise on how I can get some records deleted from the synced table? Either through accessing the source data (how?) or through a script or API override of sorts? Open to any suggestions. TIA!

Is it possible to prefill and hide fields within forms in Interface Designer?Example... Hide and preselect project type based on where the user is coming from within the Interface DesignerYou can do that with forms outside the Interface Designer https://support.airtable.com/docs/prefilling-a-form 

Hello,I would like to know how to hide some options from a field in an airtable form.For example, my grid has a column that offers the following choices: "Office", "workshop" and "housing".In the form, I would like to display only "Office" or "Workshop".The reason for this is that this form is intended for people who are not supposed to be looking for "housing". On the other hand, in my overall grid, i would still like to see which actors are involved in "housing".How can i do that?Thanks a lot for your help,Pierre@Jeremy_Oglesby 

Hi! Is it possible to add a new record to a synced table but it not be added to the original synced source? If it is possible, can you tell me how to do this? Thank you!

Hello --I have a base that I have created that my coworkers use in Kanban view. I would like to assign keyboard shortcuts to the various "Add Record" buttons for each column in the view. Is there a way to do this? It would vastly accelerate our ability to use the table when additional detail beyond category is not needed for each record.

Hello All,I am creating a form to compile completed project data from a small architectural firm.  One field in the form links directly to an existing table of consultants.  When that field is selected, the list of consultants is visible and selectable but once an actual consultant is selected the box never seems to populate and the 'thinking' circle just spins.Does anyone have any ideas how to resolve this?Thanks!