The show and tell space is a place to showcase your work and have conversations about what you’ve been creating in Airtable.
Recently active
If you're looking for a powerful alternative to Airtable interfaces, check out On2Air Forms.https://on2air.com/formsWith On2Air Forms, you can create custom interfaces and dashboards connected to your Airtable data for anyone on your team or outside your organization. See the live form here - https://on2air.com/form/6DTFnF/recHTlxteFAkkiICI**What do our customers use On2Air Forms for?*** Allow others to update their own information in Airtable (without seeing anything else)* Creating or editing linked records in a single form/interface (subforms)* Powerful logic and in-form automation for showing/hiding fields or adding data* Share landing pages with anyone* Mobile/Tablet friendly and useful for on-the-go or in the office* Custom fields like editing and viewing Google Files, Embed any other website, Formulas, and more* Front-end display for any data👉FREE and PAID Plans availableSign up at https://app.on2air.com/auth/sign-up
Please tell me why the static images disappear in the Page designer application and the error message "Failed to load image" appears. It has been working great for two years now, and for the last twenty days the images are visible on the document for a day or two and then disappear. I connect everything again and it takes another day or two and so on from the beginning
I’ve developed a Project Management Application and published it to the Airtable Universe. At this point only a few people have kicked the tires and taken it out for a spin. I’m posting this message here because I value the opinion of the folks in this community believe you guys can make it a better application. I’d love to get your feedback on bugs and suggested improvements.Here’s the Universe Link: https://www.airtable.com/universe/expsOlufQjxD1sTap/airplan-an-airtable-based-project-managerHere’s the base’s Universe Description:Airplan is a ‘traditional’ Project Management application implemented in Airtable.Airplan schedules the tasks in a project based on each task’s estimated work and the estimated end dates of the other tasks it depends on.Airplan takes weekends, holidays, and vacation into account when calculating the end date of a task.Airplan produces a schedule from minimal information about each task and refines the schedule as you refine the project plan. The minimum
Hey Airtable community! We use Stacker internally to build some customer-facing software as well as internal tools. I’m sure there are many of you who have built Stacker apps on top of Airtable.If your company or product wants to connect your Stacker app to a database like Postgres, MongoDB, Firebase, etc. then you may run into some roadblocks.Stacker does have a Postgres connector, but it has it’s limitations.You can only use it on the enterprise plan, so needless to say it’ll get priceyYou can only import data into Airtable from Postgres. If you want to sync data from Airtable to Postgres, that currently isn’t possibleThe only database Stacker supports is Postgres. If you use Firebase, MongoDB, Snowflake, MySQL or literally anything else then you’re out of luck. Bracket released it's Stacker connection. It syncs Airtable with your database or data warehouse in either direction. With automatic 2-way syncs between these tools, Bracket enables business teams to read & writ
Hi there!I have built this AI feature so that Airtable team doesn't have to spend time building it 😁.Type what you want the formula to do, press the "Hint GPT" button and get the formula suggestion - directly inside the Formula field: How did the additional button show up there? It is a Chrome Extension (you can download it here) which uses at the back (obviously) ChatGPT API, with some prompt engineering to get you just the Airtable formula.It seems to be doing pretty decent job for use cases like "Calculate number of days between now and Deadline field" or event more advanced like "Check if emails in Email field have correct format using REGEX_MATCH() function." I have been testing it for a few days and even being well versed in formulas - a few times it was for me to ask "extract ID from the end of the URL" than to start brain up to think of formula 🤣. The ChatGPT formula hints also SPECTACULARLY FAIL on some attempts or produce complete g
I have been advising Banana Republic for the past few months in connection with digital assets (product photography) for their newly launched Home line, which is quite different than their main apparel business because of the sheer volume of product involved. We are using Airtable to manage the capture and post production for a large volume of digital assets // 5,000+SKUs // 15,000+ digital assets. We are using Airtable as a single asset repository and workflow to unify and streamline digital capture, creative review, and post-production (retouching) workflows. The end result of this project will end up in a custom-designed, enterprise-level Shopify storefront. As with many large organizations, the main challenge we face is organizational fracture and data siloing, resulting from the use of multiple specialized database solutions across various parts of the organization. It's all very nice to streamline our digital asset process within
Hello everyone,Is it possible to define for a Kanban view that f.e. if a card is moved to "done" you cannot move it back to "in progress"? If yes, how does it work?Thank you very much in advance.Cheers,Alex
We're making our automated Airtable documents app, On2Air Docs, active again! We paused accepting new registrations for it temporarily to focus on On2Air Forms and On2Air Backups development and improvements. But the demand for it never slowed down, so we're ready to open it back up! With On2Air Docs, you can automatically generate any kind of document using your Airtable data. You create a document template in Google Docs, Slides, or Sheets, we auto-fill it with Airtable data, turn it into a PDF, and send it back to an Attachment field and/or a Google URL. Sign Up for Access Use Cases: ✔ Invoices ✔ Quotes ✔ Form Entries ✔ Contracts ✔ Presentations ✔ Reports ✔ Brochures ✔ And more You can even combine On2Air Docs with the ability to edit or view Google files in On2Air Forms. 🤩
Editor Access Collaborators no longer have access to add records.
I am trying to use rollup on a linked field which is a formula. Is that possible?
Hi all, thought I’d let everyone know about a new WordPress plugin I’ve just published to improve my content workflow process which is built around Airtable. Useful for bloggers, content publishers, etc. who publish on WordPress and use Airtable to manage their content workflow. The plugin can be downloaded from the WordPress Plugin Directory. Article on how to set it all up in Airtable is on my blog. The plugin sends key post and page data when you publish or delete a post/page to your 3rd party URL. Although I built it to work with my Airtable setup, it will work with any webhook-capable system (Make, Zapier, Pabbly etc.) Details sent – On publish: Author display name Post ID Post title Post date Post modified date Post GUID Post slug Post permalink Post type Post status Post categories Post tags Post word count Details sent – On delete/trash: Post ID Post modified date Post GUID Post status Hope people find it useful.
I’ve written about CoPilots before, and here’s an example of one I built some time ago and found quite helpful.What if you could highlight a block of code in the Airtable editor, and with a single keyboard shortcut, it could instantly examine the code to reveal:What its purpose is, and how it works.The most likely ways it might fail.The technical debt that it carries and the estimated cost of that debt.The [Paste] button inserts this content as a comment above the examined code.This is pretty cool, and I use it a lot, partly because I’m lazy; I don’t want to examine my own code, let alone code written by others.I have used this when reading code examples in various communities; it is designed to work everywhere you are looking at code and includes ignoring statements like output.Markdown().I used a script from @Oglesbeard above as an example to see how well it would compare with his excellent documentation of the function. Snipity-Do did alright.In my practice, this
I've just worked on my first script for Airtable and got it how I want it for now, before taking it any further.This script runs on a Table named "Travel" and takes two UK postcodes, in fields labelled P1 and P2, passes them to the Bing Maps API, and returns the distance between them, in miles, to a field labelled Distance. Check the API documentation re: call limits and pricing plans to gauge suitability/affordability for your use-case.In its current form, the script is triggered by an Airtable button field on each record/row; I'm looking to develop this further to run from a "when record enters a view" automation to trigger a slightly modified script. let apiKey = 'INSERT_BING_MAPS_API_KEY_HERE'; // Replace with your actual Bing Maps API keylet baseId = 'BASE_ID'; // Replace with your actual base IDlet tableName = 'Travel'; // Replace with your actual table namelet p1Field = 'P1'; // Field name for the P1 postcodelet p2Field = 'P2'; // Field name for the P2 postcodelet distanceF
In this video, I demonstrate how to use my Airtable Template "CareTable" to combine the power of AI with Tarot Cards to speak with deities. With the help of Interface Designer and ChatGPT, I show you how to easily pull Tarot Cards and receive insights from powerful deities to help you navigate life's challenges. Whether you're new to Airtable or a seasoned user, this tutorial will help you harness the power of AI and spirituality to stay organized, productive, and connected with the divine. Join me on this exciting journey and discover how to unleash the power of AI and spirituality in your life today! You can see this and build it hands on at DareTable 2023! Or you can sign up for the release of full CareTable
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 tests we've put in place.Looking forward to have your
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, ...)https://docsautomator.co/Cheers,Rupert
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 separate table based
(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 unlock the power of no-code. https://mattnocode.com/posts/mvp-airtable-aipromptbuilder-released/. Don't forget to watch the video — https://www.youtube.com/watch?v=PDRN5aKf0RE&t=1s #NoCodePower #AutomationFew l
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 = { "prompt": record.getCellValue("Text") + "\n\nTl;dr", "temperature": 0.7, "max_tokens": 60, "top_p"
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:Drag and Drop Form Designer - We're working on making it much easier to build your form and move form fields around with a new drag and drop designer.Multiple Field Variation on a single and multiple rows - With the new Designer, you'll soon be able to add multiple fields or single fields on any row i
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 TypeScript support - automatically maintained types custom to your Airtable bases (BONUS) Patched airtable.js type fixes - https://github.com/airwalker-io/airtable.js Give it a go and let me know what you think!Join the free beta
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.