Show and Tell

Hi There, We are copying / pasting data into a field and there is some code / script appearing above what we have pasted. Does anyone know how  / why this has occurred? And how we fix it?Cheers,

🎉 It's finally here! 🎉The Pro version of Air WP Sync - Airtable To WordPress is now available. After the release of the free version in August, we are now proposing something solid. What can you expect?⚙ Unlimited connections, support for Custom Post Types, Custom Fields, and new Airtable API features such as Access Tokens, Metadata, and Webhooks (we've worked hard to include them since the announcement in December).🛠️ Furthermore, you can also create Custom Post Types AND Custom Fields on the fly AND use them in your preferred Page Builder.🕰️️ This Pro version also allows for total control over synchronization (manual, recurrent or real-time).This version is suitable for both developers and beginners with WordPress thanks to the user interface that we've tried to make user-friendly, the many available documentation in the form of articles and video tutorials, and the user te

Hi There, Can we lock columns in a view? Cheers

Hello AT team, i am trying to create a new field through kodular platform. I hope i have consturcted blocks as per the api documentation but it throws response s INVALID_REQUESTplease guide meReturn responseawaiting for your reply

Hi friends of Airtable,DocsAutomator has been growing quite a lot recently and we have many Airtable users automating their documents with it already 🎉The goal for DocsAutomator was to create the easiest solution to turn Airtable data into documents after having built Airtable solutions for clients for 2 years. It uses Google Docs as its templating tool, so creating templates is super easy. On top of that, it supports line items (also multiple line item tables), currency and date formatting for most regions, you can select to add to or overwrite attachment fields and lots more!Would love if you would check it out and let me know what you think! I'm constantly improving the platform and look forward to your feedback (via this community forum, email, in-app chat, Twitter, ...)

I've created a script that creates child records in a child table linked to parent records in a parent table through a linked field. It creates a set number of child records per parent record, if a set field in the parent record meets the conditions, depending on the number of records in a "count table" with a non-empty value in a designated "count field". It also supports populating a designated "category" field in the child table with the value of the "count field" in the "count table".I originally created this for the translation of texts. The parent table hosts the English text, and when the workflow (designated by a single select field) moves to "Translate", the script checks a table listing the languages to be translated into, and creates a number of child records equal to the number of languages, and categorises the child-records based on the language.It can be used for other systems where a set number of linked records need to be created automatically in a sepa

(this headline was generated by the Airtable AI Prompt Builder Itself.)Hi, this is Matt.I used Airtable Interface and added some automation to integrate it with Make and OpenAI API to create the "Airtable AI Prompt Builder".  And packaged it and published it for free with all the prompts content on the Airtable Universe.  Please check it out (links below), let me know what you think, I am already working on improving the solution based on some initial findings and feedback that I have received from one of my client,  but would love to get some of your feedback if you look at it! Thanks.  OUTPUT SAMPLE (Generated from my solution)Automation made easy! Check out our blog post to learn about our amazing MVP powered by Airtable AI Prompt Builder and unl

Hey all! I made a quick test with OpenAI GPT-3 to summarize text and add the TL;DR to another field. I find it kinda cool, and it was super quick to make, so sharing the example if someone finds it useful. You’ll need to sign up to OpenAI and generate your own API key there. Add a scripting app, and here’s the code (remember to edit your own table and field names, and add your own API key): // Change this to the name of a table in your base let table = base.getTable('Documents'); let openaiUrl = "https://api.openai.com/v1/engines/text-davinci-002/completions"; // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); if (record) { // Construct the body // Change the field name to match yours. let body = {

We just announced several new features in On2Air Forms for Airtable! Plus we're about to launch several more in the next week! Sign up for Free to use it with your Airtable bases.Launched:Use with Softr (dynamic per logged in user!)HTML Editor, Markdown Editor, JSON EditorAdvanced Date and Time Formatting (overcomes Airtable limitations)We're ahead of the game - OAuth Connection that Airtable will require next yearLaunching next week:Google Docs, Sheets, Slides Editor! - You can edit or preview any of these files, then save it BACK to an Airtable field!Embed Custom Field - embed a website or any type of online contentSpacing field - add space anywhere on the formUpcoming in the next month:

I am thrilled to share that I have successfully streamlined my data management process by using Formaloo forms in conjunction with Airtable.  😀 By integrating my Formaloo forms directly into my Airtable base, I have been able to collect and manage all of my data in one central location. This has not only saved me time and effort but has also helped me to maintain accuracy and consistency across all of my data. 😊And here is the article that I want to share with you about how it works:How to create Formaloo forms on Airtable base

Hey all, I'd like to share the beta release of my product Airwalker.Airwalker was created out of my desire for better tooling when creating Airtable API integrations. 🧪 FeaturesBase timeline - a timeline of your base schema changes Logging - history of your requests to Airtable & whether or not they were successful Edit & replay - a user interface for retrying failed requests

Hi community!Leandro here the creator of the Airtable Pack for Coda sharing some news 🙌Integrating Airtable tables with Coda documents opens up a world of possibilities for enhanced collaboration, organization, and automations:1️⃣ Select your Base2️⃣ Select your Table3️⃣ Drag and drop4️⃣ Optionally select a View5️⃣ Airtable in sync with Coda 🔄 If you want to learn more, check the launch on Product Hunt and join the conversation ❤️

Hi, I would like to ask if this is possible. So we have an airtable view that contains all the schools in the Dallas metro area. Under Dallas, there are 58 schools. But we want to get the top 20 schools base on their School score. Is there a way to get the top 20 schools with the biggest "School Score" via the formula field or scripting? Though we can use the "Sort" but we want to have a field that will be updated into "Yes" or maybe "To be uploaded" when their school score is included in the top 20 biggest school scores.   

I want to add/update an existing table with a new CSV file.I used this article: https://support.airtable.com/docs/csv-import-extensionIt was perfect till the point that I had to choose only one field under "Merge with existing records".How can I merge based on two or more fields? 

hello, I have a small but may complicated issue. I have a data table, that lists several items to view over a website. the form for the table works well to populate the fields and add items. what is needed is another "contact form" that a visitor can use, to send inquiry, where the subject field is "prefilled" with the specific item number that the visitor "clicked-on" and expanded. like adding a button field, that will open that form, with the prefilled value from that exact column-row intersection. any ideas?

Hello la communauté !Je viens tout juste de publier la formation Airtable 360°. (formation en Français uniquement, pour l'instant)Cette formation rentre dans le détail des astuces, limites et bonnes pratiques, qui sont vitales à comprendre lorsque tout un business repose dessus !Un condensé de toutes les choses importantes à savoir en une seule formation, en quelque sorte.La communauté Airtable bénéficie d’un tarif très avantageux à l’occasion de cette offre de lancement, profitez-en rapidement !https://nocodable.io/course/decouvrir-airtable-a-360---prix-limites-astuces-secrets-et-bonnes-pratiques

Hello,  If I take the Pro plan and choose to limit editing &permissions for collaborators do they als need a Pro plan to input/change their data?They should'nt be able to adjust eachtohers data. Thanks

A formula field can be used to SWITCH a country name to it's corresponding flag emoji (full formula below)This can be handy to add a visual cue to a country and works nicely when added in record summaries like below/This formula will include your flag emoji and using \n you can list other record attributes with a new line"☑️ " &{SOME_OTHER_FIELD}&"\n"&"☑️ "&{YOUR_COUNTRY_FIELD}&" "&{FLAG} SWITCH for FlagSWITCH( {YOUR_COUNTRY_FIELD}, "Afghanistan", "🇦🇫", "Åland Islands", "🇦🇽", "Albania", "🇦🇱", "Algeria", "🇩🇿", "American Samoa", "🇦🇸", "Andorra", "🇦🇩", "Angola", "🇦🇴", "Anguilla", "🇦🇮", "Antarctica",

In this video tutorial, I have used natural language processing (NLP) to automate tasks in Airtable. We'll be using GPT-3 to do so.Leverage Airtable Automation lets you quickly and intuitively define the “logic” that compels Airtable to do something in the background.Code  

If you're looking for a formula field that translates an employee's start date or birthdate into the current year (for notifications or action items), here's a formula that does that for you.Requirements:Add a date field called DOB (You can change this later if you don't like it)Add a formula field and input the formula below:DATETIME_PARSE(DATETIME_FORMAT(DOB, 'MM') &"/" &DATETIME_FORMAT(DOB, 'DD') &"/" & IF(MONTH(NOW()) = DATETIME_FORMAT(DOB, 'MM'),

I've been using Airtable for a while now, and while it's a fantastic platform for managing and organizing data, I've noticed that the lookup functionality can be quite limited at times. Specifically, I've experienced issues with having to create multiple lookup fields just to perform simple calculations or data lookups across different tables. So, I've started working on a new tool that aims to solve these lookup issues and enhance Airtable's functionality. With this tool, you'll be able to quickly reference data from other tables without having to create linked fields or complex formulas, and easily perform calculations across multiple tables . I'm curious to know if anyone else has experienced these lookup issues and would be interested in trying out my tool. It's still a work in progress, but I'm hoping to release it soon and make it available to the Airtable community. If this s

Hello, Is there a way to make a custom share link for my airtable form? The default one is quite convoluted, consisting of a string of random letters and numbers. Too hard to remember for my end users. D 

Hi everyone!Around two weeks ago I released an Airtable extension that helps you save emails to Airtable. A lot of you were so kind to have tried it out and gave me many valuable feedback, thank you!I started working on snippets and blocks that can be set up in your Airtable base to log emails and act as an CRM like Salesforce does. I wrote an article here to show you some cool features and views you could create with Airtable and emails to use your base as a CRM.I am also in the process of creating a generalised Airtable CRM template and will make it available for free so more people can get started using Airtable as a CRM qui

When I open the calendar workspace on mobile (android) and on days that I have an appointment and a blue dot it does not show the record. I have a message that says "this date has no record" if I click Done and re-open it the appointments are there. This is really frustrating - and happens EVERY SINGLE time on every day.Please help!

 Okay I believe I have finally solved this problem. Using a bunch of nested formulas and heaps of hints from these forums I managed to take the start date(/time) of an event in my table, and calculate the correct payroll date. If you've ever tried this before you may have come across several complications which generally come back to Airtable performing all calculations on a date field without considering the timezone that the displayed date field is in - it sometimes assumes date fields need to be translated back into GMT, and at others it just assumes they are already in GMT when they aren't... etc. Formulas like WEEKNUM() and SET_TIMEZONE() don't seem to work well together... etc.Anyway, I have tested this formula with a bunch of tricky dates around the start/end of a year and the start/end of a pay period and haven't come across any errors in the calculations yet. So my fingers are crossed that this formula is the solution that works for you too. Or, you