Ask the Community

I’m trying to rollup a text field within an AT interface. I’ve created a Lookup field which is correctly showing duplicate results. However, I want to rollup the duplicates so the result only shows once.Results of my look up are the following:Transactions Policy PolicyThe two “Policy” records are identical and I’d like to roll those up. I’ve tried the rollup up functions, but they seem to only work on values rather than text. 

Hi everyone,I'm encountering a data integrity issue when transferring a large set of records from Google Sheets into Airtable, and I’d really appreciate any advice. **Scenario:**  I maintain an a list in Google Sheets. The "Source URL" column contains rich-text hyperlinks — for example, display text like `Narrative Enneagram Resources` linking to `https://www.narrativeenneagram.org/resources/`.**Issue:**  When I click the link, it shows an error because the URL has become http://narrative%20enneagram%20resources/ instead of the correct URL When I try to bring this data into Airtable, the URLs get misconverted. No matter the method I use:- **Copy-pasting** a multi-row range directly into a URL field,  - **Importing** via _Add base ▸ Import data ▸ Google Sheets_, or  - **Exporting as CSV** and importing into Airtable,   **Question:**  Is there any way to preserve the original hyperlinks (i.e., the actual `href` URLs)? Thank you so much for any help! 

I am using Documint to generate PDF from data stored in Airtable (via link). It was working without problems for more that a year but I recently have trobles to build PDF on first try. Still some data are missing. I checked with documint and all is fine on their site. While the situation is getting worse, I am adding one more field to generated document to dump all data received from Airtable - so I see, that lot of data is missing so Documint has not enough inputs to generate PDF. It usually take several tries to get what I need, but tonight even 50 is not enought. I asked Airtable support on 15Jun but no reply  - still (OK 3 emails that they are busy, but no solution). Is there any way to make Airtable properly prepare all data and send it to Documint? What is the problem after one year?

Hello, I have an airtable to track travel & accommodation requests for our company. I need to export information from a record into an editable template document to send travel information for approval, preferably in an excel template. I have been working on creating a document using the ‘documint’ extension but I’d prefer the flexibility to add additional information once it has been exported from airtable. Is there a way to export from airtable to an excel template? Or word, or another similar program?

I would like to take data from airtable to put on pdf template or a template to be emailed out eventually via zapier outlook intergration Which 3rd party company is the best to integrate with zapier and airtable.  Documint, Formstak, PDF Monkey etc? 

Hello to all, I have created a form to receive data, and when I submit the form, I redirect it to a documint url to generate a pdf file. (more info Document Generation Link - documint) All good so far, but I have not been able to pass a dynamic image to form the pdf, in the template variables in documint. Greetings and thanks

Bonjour,J'arrive bien à récupérer des données AIRTABLE d'une première tables ainsi que les champs d'une table liée à la première, mais le niveau au-dessous semble ne pas fonctionner.Comme indiqué dans la documentation et la vidéo explicative sur DOCUMINT, comme pour la première Table liée, je crée un champ Fx nommé "Lien_Table3 Table_Id" avec la valeur "TableID".Sur DOCUMINT, j'indique bien le Repeat / Loop sur chaque enregistrements de "Lien_Table3".Sur le lien de génération du PDF, j'indique bien "...expand=2..".Mais aucun affichage du champ souhaité.Qu'est-ce qui pourrait bloquer ?A-t-on une limitation de niveau avec la version gratuite de Documint ?Merci pour votre aide !Stéphane Suite à mon achat de la formation "Générer des documents avec Documint", j'ai pu avancer sur de l'automatisation de génération de document. En revanche, la récupération d'objets dans les champs liés (à plus d'1 niveau), n'a pas l'air de fonctionner. Je crée pourtant bien un champ fonction "Champ_

Hi, I'm trying to create a custom document, using Documint, but each time I'm put the "create buttom" the emerge page showed up the follow message: "Error while fetching Airtable data: You are not authorized to perform this operation"Can you help me?Thanks

Hello,I'm able to retrieve AIRTABLE data from a first table as well as fields from a table linked to the first one, but the level below doesn't seem to work.As indicated in the documentation and the explanatory video on DOCUMINT, as for the first linked table, I create an Fx field named “Lien_Table3 Table_Id” with the value “TableID”.On DOCUMINT, I indicate the Repeat / Loop on each “Lien_Table3” record.On the PDF generation link, I indicate “...expand=2...”.But no display of the desired field.What could be wrong?Is there a level limitation with the free version of Documint?Thanks for your help!Translated with DeepL.com (free version)

I have noticed that the PDFs I have created with Page Designer (by clicking the little printer icon) do not contain selectable text. It seems to be a giant image. Not how a PDF is supposed to work. This is especially relevant when you include a URL field and want this to be clickable. Strangely enough some of my URL fields are clickable in the little preview pane in Airtable. But only some of them. Of course when I print and save them as PDFs none of them are clickable, because it is not text. There is an answer to a previous question that suggests using Long Text fields to avoid that problem but that does not work for me (and how should it, since my output is not text?): Some links not clickable in output PDFs from page designer - #6 by ScottWorld

Thank you so much and look forward to hearing back!

Heya community!I have a main table of tasks (source) which is two-way synced out to a few different bases depending on their category/who’s responsible (long story short).In this source table, I’d love a way to have a button open up the record from within one of the specific synced tables. I have a sad feeling this isn’t possible, but would love any help figuring this one out!I know from the synced table I can do this very easily back to the source, but I’d love a way to do it the other way.I really hoped that the record ID would stay the same in both places so I could create a URL that combined the new base/table with the existing record ID, but alas :(

I haven’t used up my automation runs for the month, but all of my automations have stopped working suddenly. They worked yesterday, but today, they aren’t. Each step when tested runs well, but if I try to edit the conditions or create another automation, I get this ‘Sorry your request conflicted with another change’ message.Can anyone help please? 

I added an automation to a task management base that is intended to send a reminder email every month to each staff that has tasks on their list that are not marked as a completed status by the time the email is triggered.This month there were 104 incomplete tasks that about 5 staff are responsible for. The email was triggered and each staff received one email, but in the cc’d line were 104 email addresses so i obviously set it up wrong. See the screenshots of how it is set up- what am i missing?#1 #2 

We built a WordPress Plugin for Airtable that does not use embed or syncing (copying).This means the info from your bases will be displayed in real-time alongside your webpage, matching the same theme and styling, and it will look great on any screen size.I'm curious to see if you have a use case for this at your organization.Since we're still adding more features, I'll set up the first 50 organizations for free (WordPress users only). Just send me a message or add a comment here or . Please be patient till we get to you 🙂The plugin connects using Airtables API, currently it will let youCreate Unlimited pages with Cards, Tables, Calendars Layouts using Airtable dataCreate WordPress based Airtable logins and Portal pagesReal-time Info from Airtable. No EmbedsUpdate and Create Airtable records from WordPresshttps://sfplugin.com/airtable

Before maybe a month ago, when I clicked to add new fields, I can just type the name and then select the type. Now I have to select the field type first and then enter a name. My brain is wired the other way. Is there anyway to go back to the old way?

Hello,When I confirm an appointment by email with the date and time, the times indicated in the email are off by minus 2 hours.For example: I sent an automatic confirmation email with an appointment for Saturday, May 17th, between 9:00 AM and 10:00 AM.The email sent by automation indicates the time indicated as 7:00 AM and 9:00 AM.Can you explain what is causing a 2-hour difference between the email I sent and the data in my database?The appointments in my diary are correctly positioned at the right time. Thank you in advance.Sincerely,I live in France

Hey guys, I’m using the “Insert Record As Grid” feature in Airtable (screenshot below). When I choose this, it lets me choose the columns I want included in the grid.The columns of the grid appear in the order of the dropdown list that appears.Where does Airtable take the order of the dropdowns? From a specific view?I want to order the columns differently but it does not work. I have lots of different views, so I don’t know which view determines the order of the columns. Would really appreciate the help! :) Thanks so much in advance!  

Can we *please* get an Airtable API that supports native stats operations?  I’m tired of having to ship data *outside* of Airtable in order to get this information.

We are getting close to determining of going with Zapier or Make. I know very well the feedback about Make vs Zapier. However, the decision is more than just me. Either way, our team has a question on how to best judge how many actions or operations is enough?At minimum we’re quoted around 300k-500k runs. I can understand there is a number of variables at play.Some considerations:From an Airtable perspective on an Enterprise account with over 20 apps used across the organization for about 150 editors Considerations to connect Airtable with ServiceNow, MS products, and other financial tools Starting out with about 5 developers using the API solution Definitely be capitalizing on the AI offerings either hasIf anyone has insights on how to determine what is needed love to hear about it.

Okay, so it's 2023. Is it possible to update information in a record via a form and not delete data if the form field is left blank yet? I wish to allow users to update database information via a form, but I do not want the existing data in a field to be deleted if the user leaves a form field blank.Is there a way to achieve this in the Airtable UI and not third-party apps?Is it possible to add to the photos via this form submission instead of replacing all the photos with the update form? For example, photos 1, 2, and 3 already exist in the data. A user used the update form and uploads image 4. So it would update the data to have photos 1, 2, 3, and 4. As it is not, it replaces photos 1, 2, and 3 with just photo 4.Thanks for reading!

I have a table where there are potentially multiple images available:Two columns linking to other records, then One Lookup column for each of those to look up the image attachment, and then finally, One more column where I paste a screenshot, used for cases where neither of the other links are present.So there are potentially 3 columns which could contain an image attachment. If I were to try to build a sensible gallery or an app, I’d only want one image for many of the views, so I’d like to make a Best Image column.The rules are more or less:Does Source 1 exist? If so, use Source 1 If not, does Source 2 exist? If so, use Source 2 If not, use Screenshot  If I try to do this using a Formula column, I end up with what looks like a URL to the image on dl.airtable.com, instead of it displaying the image. The docs do say that attachments can’t be returned from formulae. The thing it does return may be usable for a webapp still; I haven’t yet tried. At the very least, it isn’t viewable

I am creating a new module of airtable in make.com. However every time I try its uses the name of the earlier connection. I want to have a new connection with a fresh name. why is this happening?

Hello All, I have some fields in my database that are mandatory at different stage. I want to do a form with the first fields for the first time, and then send another form prefill and update the record. I do not see how to update. Is there a way to do it ? thanks

In order to compute a change in a value between a prior record and a newly inserted record, is there a way to get the most recent prior value for a field in a table?Assume table is sorted (e.g., by DateTime).Ideally with a formula something like the pseudocode below where the “Prior_Value” and “Current_Value” are a number, such as: an amount, a quantity, a weight, a height, a length, et cetera.Delta_Value = [Prior_Value_from_Prior_Record - Current_Value_from_Current_Record]Thank you for any and all suggestions!Rick