Show and Tell

Can I hide a table view from the editors? I only want the creator to be able to view that table. Is it possible?How can i do it?Thank you!

Hello Airtable Community,I've set up a table with a significant amount of information and data. In a second table, I’m pulling in information from the first using linked records/LookUp. However, I’ve noticed that the same item is being repeated within the same record in this second table.Has anyone else encountered this issue? Any suggestions on how to prevent these duplicates and ensure that each item only appears once in a record would be greatly appreciated!Thanks in advance for your help!

Here's a quick guide on how to use a Make Webhook to trigger updates in Airtable!  Here's a link to the base where it's set up, and I've also included the JSON for the scenario at the end of this post in case anyone would like to just import the scenario directly into their Make account instead!One thing to keep in mind with this method is that it will open a new tab for the user, so it's important to close these tabs once they've been used. I've seen a rare case where webhook tabs opened on an iPad weren't closed right away. A week later, closing these tabs refreshed the page and unexpectedly triggered the webhooks again; that was...interesting to troubleshoot Here we append the webhook URL with "?record_id=" to indicate that we're passing a value named "record_id" to Make, allowing us to use it in the Make Scenario:  https://hook.us1.make.com/38jqh9w2gh123ava12y44hfp37o9c1m?record_id=" & RECORD_ID()  After this, we click the button to load up the URL once

hi, this seems to be a rather trivial matter but i haven't found anything in the community so i'd appreciate a hand immensely:i've got a list of sales records that includes among other things the revenue of a sale as well as a formula field that assigns a month-tag based on the date-field of the record. i'd now like to create a clean, automated list (in an interfaces or wherever) that shows the sum of all values in the field revenue from records tagged january in one line, february the next line and so on and so forth. i tried a workaround by creating a view in my interface that is grouped by month and hiding all irrelevant fields and collapsing all groups but it's still very bulky and i have to collapse every time. does anybody have an idea how i can go about this? i've attatched a photo of my current view and of how i'd like my list to be ideally.thanks heaps!

I have already entered the data for Plant Client 1 into Excel and imported it into Airtable. Now, I want to input new data for Plant Client 2 and Plant Client 3. How can I integrate all this data into a single database without overlapping the tables?

I have an interface publicly opened and I want to update it by filtering with the URL (this is doable with the shareable views).For example this interface :https://airtable.com/embed/appE1Q6NEEScM3NhW/shrznzikatF5FzmKW...becomes...https://airtable.com/embed/appE1Q6NEEScM3NhW/shrznzikatF5FzmKW?filterContains_variable=Xand it will only display the records matching the variable X?Is it possible (it is possible with shareable views).

Summary People sometimes ask whether it’s possible to use an Airtable form to edit an existing record. Technically the answer is “no” because Airtable forms always create new records. However, a base can be set up so that records created by a form end up affecting records in another “mirror" table. As with my first show-and-tell submission, this was inspired by a solution that I created in another thread. Long story short, the key to that solution was using two tables: one for collecting form data, and another that looks up that form data and fills out a parallel set of fields. Extending that to allow data from subsequent form-generated records to effectively replace older data in the “mirror” table only took a few more steps. Table Setup To build this system, the first table to make will be the [Data Entry] table. This is where the form data will end up. After deleting the default records, change the primary field to the Autonumber type, then set up the remaining fields for the data y

Hi Airtable folk! I've been working on a tool to integrate Airtable data on popular site builders. I built this becuase so many times I was storing things like my FAQ's, chaneglogs and directories in Airtable but wanted a way to start integrating them into my site with a more custo looking view that matched my brand. It seems like most of the competitors out there are focussed on Internal tool & building apps & being quite complex large scale apps with a hefty pricing. So I set out around 8 months ago to build a cheaper, more light weight modular solution where the sole focus is to enable creating truly custom embed designs / views. Pricing is around 70% cheaper than other solutions starting at $10 per month for unlimited views and embeds.I'd love if any here had any thoughts?App is called https://basefront.app here are some snaps of a view of the templates you can connect your base too:

Export your Airtable data to CSV, Excel, JSON and more using our handy tool CSV Getter.Our tool lets you create an Export URL which is great for automatically syncing Airtable with Excel, Google Sheets, Dropbox, and many, many more.This is perfect for backups and automatic analysis. Try our sandbox demo here:https://www.csvgetter.com/export-airtable

🔉✨Airtable PowerSave with AI support is released.The integration grabs the current page and instructs the AI to extract and categorize what you see into your Airtable table, no matter what your table structure is like.It works generally well for me although there's definitely space for improvement.One benefit of PowerSave is that you can freely save data to all of your bases and tables.I'm finding this genuinely useful myself and I'm learning to save more content than before: social media posts, learning resources, competitor / inspirational websites, contacts, businesses, customers...So far PowerSave is a product I like using and also building - so fingers crossed others will like it too so I can keep pushing it and turn it into the best quick saving tool out there 🤞

Hey productivity enthusiasts!I'm excited to share some awesome news about the Airtable Web Clipper. We've just rolled out several new clip actions that are going to make your web clipping experience smoother than ever!One of the standout features is our new Twitter post clipping action. Now you can capture tweets and their details directly into your Airtable base with just a few taps. It's a game-changer for social media managers, researchers, and anyone who loves to collect and organize online content.But that's not all – we've got more clip actions up our sleeve, and we want to hear from you! If you have ideas for other web clipping actions that would make your life easier, please submit them through our form. Your input helps us create tools that truly serve your needs.For those of you rocking an iPhone, you can start using same function as Web clipper chrome extension. Just head over to https://dub.sh/0lYZkfh to get the Airtable iOS Shortcuts Library and supercharge your produ

Hello Airtable Community,I'm in the process of transitioning from Google Sheets to Airtable to manage a dance school, with the aim of creating a more robust and streamlined system. I've successfully set up tables for students, classes, venues, staff, and periods (e.g., May 2024, June 2024). However, I'm encountering challenges with the attendance tracking system.In our previous system on Google Sheets, attendance was tracked in a simple and user-friendly matrix format as follows for each month:| May | 7/5 | 12/5 | 19/5 | 26/5 ||------|----|-----|-----|-----|| Student 1 | x | x | o | x || Student 2 | x | x | x | o || Student 3 | x | o | o | o |For each subsequent month, we would simply copy the layout and update the dates, which were calculated automatically. This format allowed for easy visual and editing access to attendance.In Airtable, I'm trying to normalize this data to improve the system's scalability and integrity. A normalized approach would ideally have records for each indivi

I have to share my AIRTABLE TO POWER BI THAT WAS SUCCESSFULL TOO BUT THE SOME OF THE DATA FIELDS SPECIALLY THE LINKED FIELD IS IN FORM OF LIST SO BECAUSE OF THAT I AM NOT ABLE TO CREATE MY POWER BI REPORTS . SO PLEASE HELP ME IN THIS

Schedules Example Base This is my first post to forum; hope I get the mechanics right. You may find this base handy if you need to schedule recurring events. I work for a community radio station and wanted to be able to offer users the ability to schedule our on-air broadcasts and various meetings as recurring events. I wanted to give users the same flexibility they have in Google Calendar and Outlook. I’ve encapsulated recurring date calculation logic in a single table: “Schedules”. I’ve seeded the table with example rows and the primary field’s default formula describes each row using the user-entered fields. The Schedules calendar view shows a set of example recurring dates, with the primary field documenting each recurring pattern. Check out the calendar view to get a quick idea of scheduling features. Since all recurring dates are calculated off of the value of the built-in Airtable TODAY() function, the calendar is always automatically up to date. Recurring dates that slip into

Hi, we're long-time users of Airtable, but we've found that the iOS application has a long loading time. To bridge that gap, we've created a Comprehensive Library of Airtable Siri Shortcuts.To give you a better idea of how these Airtable Siri Shortcuts can ease your mobile data management, we've created a short demonstration video. Watch the video below to see how easy it is to create records in a base using Siri and open a specific Airtable table using Siri. Create records in base using Siri– With just a voice command, you can directly create a new record in your Airtable base without even launching the Airtable app. This shortcut streamlines your workflow and saves valuable time. Open a specific Airtable table using Siri– Simply ask Siri to open a specific table in your Airtable base, and it will be done instantly. No more navigating through the app to find the table you need. Customize data organization – Specify the target table and field names for each shortcut, ens

I use a single base (Contuity) as my relationship manager, task manager, journal, brainstorming tool, invoice generator, and more. Scenario: Journaling is good for you I was using voice memos to record a 10 minute audio journal entry every day and I didn’t want my audio journals to be seperate from my written journal entries (in Airtable). I set up a single click mobile “start recording” program that saves the audio as an attachment. Here’s how Workflow: Tap icon Desktop icon opens “Shortcuts” Shortcut begins recording audio Tap to stop recording Email is generated with audio attached (.m4a), subject is populated with “Audio” “To” is populated with “trigger@applet.ifttt.com” “From” is populated with my email IFTTT captures email and creates a new record with audio as the attachment and the subject and any text in the notes field. What’s been great is discovering how frequently I use it. People suggest we record a part of a conversation to bring up later so we don’t need to take notes.

Hello 👋With this chrome extension you can save data to any Airtable base and table with AI. Extract, categorize info, and autofill fields like URLs, images, and descriptions. Create new tables with AI, manage content for websites like Softr, take screenshots, set up custom keyboard shortcuts, and quickly add or update Airtable records right from your browser.The extension is available in the chrome web store. Comments, feature ideas are very welcome 🙏https://powersave.pro/https://chromewebstore.google.com/detail/airtable-powersave/haenikbhamhcofblbialbabhlimabade 

Hi As long-time users of Airtable, we've noticed that the official Airtable Web Clipper doesn't function on mobile devices. Plus, the iOS Airtable app often has lengthy loading times. To address this gap, we've developed several iOS shortcuts specifically for Airtable Web Clipper.Shortcuts Library Link: https://dub.sh/0lYZkfhVideo Demo: We've created a short demonstration video to illustrate how these iOS Shortcuts can simplify your mobile data management in relation to Airtable Web Clipper. This video showcases how simple it is to capture web content, save images, and input text using our Airtable iOS Shortcuts.Capture web content with ease – When browsing the web in Safari, you can activate our Airtable shortcut to save the page's URL, title, and selected text to your designated table and fields, essentially replicating the Airtable Web Clipper experience on iOS!  Save images on the go – You can promptly add images from your photo library or camera to your Airtabl

Hello Airtable Community,We are thrilled to share an exciting new resource that we've been working on: the Airtable Scripts Mind Map. This interactive tool is designed to help you streamline your scripting process and make the most out of Airtable's powerful capabilities.What is the Airtable Scripts Mind Map?The Airtable Scripts Mind Map is a comprehensive visual guide that organizes the most common scripting methods used in Airtable. Whether you're a beginner looking to get started or an experienced user aiming to optimize your workflow, this mind map has something for everyone.Key Features:Interactive Navigation: Easily explore different scripting methods and their applications.Code Snippets: Directly copy and paste code snippets from the mind map into your Airtable scripts.User-Friendly Design: Intuitive layout that makes finding the information you need quick and easy.How to Access the Mind MapYou can access the Airtable Scripts Mind Map through the following link: Airtable Scripts

Hey Airtable community! Wanted to share this project that has helped us make Airtable a more effective tool for a bunch of companies. Bracket just released a Snowflake connector. If your company & product relies on Snowflake to house all data, but you still want to use Airtable to manage your data and operations, now you can do both 😊Bracket turns Airtable into a UI for Snowflake so that you can read data from Snowflake, write data to Snowflake, or both at the same time without ever leaving Airtable.Why did we build this? Because we know that Snowflake has its place for a company and for engineering teams, but business teams love ❤️ Airtable to run their team & processes and are often excluded from accessing Snowflake and the data that lives inside.How do you get started?Create an empty Airtable or empty Snowflake table with field names but no data (only one of them has to be empty to start)Go to https://app.usebracket.comEnter the connection details

Hey folks,I've put together a guide to Airtable scripting based on a scripting 'cheatsheet' notebook I've built up over time.  It includes a mix of info from the official scripting docs and places like Google (and this forum) when the docs didn't have the answers.Figured this info might be useful for others, so I turned it into a blog post:https://simplescraper.io/blog/complete-guide-airtable-scriptingIt covers the basics but also dives into some more advanced techniques. The idea is to have all this info in one place for quick reference.Hope you find it helpful. Feel free to share any feedback or additional tips ✌️

Hello !I am using Airtable for invoicing. Very soon, I will have to increase prices. Is there a simple way to implement the new prices without affecting the already existing invoices?

Hi, my wonderful Airtablers!And another one! I've just launched Data Extraction extension built for Airtable!https://airtable.com/marketplace/blkiQT71Vaz7uwi5j/data-extractionExport selected data to formats like JSON, XML, CSV, SQL insert queries, or ASCII tables directly from your base. I got inspiration from the database extraction tools incorporated into IntelliJ Datagrip that I have always loved using. I wanted to see something like that on Airtable as well, plus it's sheer joy to build! There's a lot of feature potential, but I am going to be very community-led with it in terms of the feature set.It's completely free to use, but later on if there is a demand for hosted results (essentially you'd have your own custom API to Airtable), then this would make sense to offer under a paid tier.Drop me a line with your feedback or any features you'd like to see!

Hey Airtable Community,I wanted to share a neat trick I discovered for those of us who use Firefox as our primary browser. As many of you might know, the Airtable Web Clipper extension doesn’t support Firefox. This was a bit of a setback for me since I rely heavily on Airtable for organizing my web content. But, I found a workaround using iOS Shortcuts that mimics the Web Clipper functionality perfectly!I’ve created a detailed video tutorial to walk you through the entire process. You can watch it here:  Here’s what I did:Setting Up the Shortcut:First, I created a custom shortcut on my iPhone/iPad that allows me to clip webpages directly into Airtable. This involves selecting the page, sharing it, and then triggering the shortcut.Using the Shortcut:When I’m on a webpage I want to clip, I simply hit the share button, choose my shortcut, and it prompts me to select the Airtable table where I want to save the webpage. For instance, I have a table for articles, and it saves the title

A simple page to show how to use CSV Getter to query your Airtable data. Great for MVP app building.https://www.csvgetter.com/sql-query-airtableI'm looking for feedback 🙂