Show and Tell

Inspired by this question: Creating linked tables with user-inputed "fuzzy" data Ask the community I have a donation database: Table 1: Donation Data: donations as they come in online (user inputed information) Table 2: Donors: each donors’ record which is linked to table 1 so you can see all their unique donations Problem: user inputted information sometimes changes (e.g. Meghan Moore, Meghan E Moore, Dr. Meghan Moore), but I want the donation data to link ONLY to one record in the Donor Table (Meghan Moore) I want to find a way to link both so that no matter what the user enters, the do… I thought I would try to use Python to do some fuzzy matching on Airtable data. Not really an Airtable demo (as the data could be stored anywhere), but hopefully some readers find this interesting :slightly_smiling_face: This article: DataCamp Community – 6 Feb 19 Fuzzy String Matching Python: Levenshtein Distance, String Approximate, &

When you try to add long text on description field the things is becoming missy you will be not able to scrolling down to save the data

I run a podcast studio and I track the status of a podcast with names, dates, episode name, guest name, etc.I have a column on recording date, but would like to add a specific time it will be recorded at.so how do I add a specific time to a column?I only see time created and timestamp but no option for specific time? 

Hello,  I would like to sync two separate working bases on Airtable but I don't know how to do and I didn't find any answer to my questions on your FAQ.  Is this possible to do so ?  An example of a use case for which I would need to sync two bases : establish a "lookup" field in a working base based on the data contained in another base.  Thank you in advance for your help.  Have a great week,  Garance Gisserot

Sharing a very basic timer I built in Interface Designer, since you cannot currently use base extensions from interfaces. Pretty easy to set-up and requires no automations - hope others find this helpful! (see attached video)DescriptionThis is a simple stopwatch timer that will not show a running time, but by clicking buttons you can check your time. It offers basic stopwatch functionality - you can start, stop, check, and reset the timer, but you cannot pause the timer and pick it back up. In my base design, time entries are a child record of task records. In the interface, this allows users to select a task and log time to it.Set-UpIn my base, I have my time entries table with 3 checkbox fields. Each of these fields also has a Last Modified Time field that inspects it. I've named these:"Start Timer" & "Start Timer - Last Modified Time""Check Timer" & "Check Timer - Last Modified Time""Stop Timer" & "Stop Timer - Last Modified Time"In my interface, when you open a tim

Hello everyone,I wanted to share with you an updated version of CSV Getter, a no-code solution for data backup and API building for Airtable. I've been working on this tool for over a year now, and I've received some great feedback from this community that has helped me make it even more powerful, agile, and secure.With CSV Getter, you can easily export an Airtable table as a CSV file and generate a permanent URL that can be used to access the full base, among other features. You can create secure export URLs in just a few clicks and generate dynamic, white-label tables or visualizations that can be embedded in your browser or iframe.Check out the demo video on YouTube: https://youtu.be/4EzGF3mUbiA. The video is only 5 minutes long and it will give you a quick overview of the features and capabilities of the tool.You can also check out the product itself for more information: https://csvgetter.com/I would love to hear your thoughts on the updated CSV Getter, and if you have any questio

I've been using the same table for 6 months with no issues.  I had 130 entries, now I only have 59.  They aren't in trash and nobody has made changes.  There is nothing showing in history.  How do I recover the deletions?  They were there 4 days ago.

I have created signin and signup form in google site . now ai want authentication process with airtables. can we integrate google sites and airtable. If yes then how? Please explain step by step

Hi,I'm sharing a private link to a data set (can't share here as it's got user-data). Sometimes when entering the password it works fine. And then other times on an incognito browser, and for other people trying to access it it doesn't work. It comes up with this same message, see photo attached.What could be going on here? I need a fix asap so would really appreciate some help/troubleshooting.

There wasn’t a bulk image uploader with airtable so I just made my own autohotkey macro to do this. There’s a substantial amount of users on this forum requesting a feature such as this, myself included, but for now this macro will do Basically, I have a bunch of imgur.com URL’s already and wanted to reupload it into airtable to get the image thumbnail preview This is what it looks like in action: (I am not pressing any buttons here asides the “Play Button”, this is macro doing all the work) This is how i initialize the macro: This is what the actual macro looks like This is what my actual macro file is Dropbox UploadToAirtableMacro_5_10_2017 10-42-48 AM.mrf Shared with Dropbox This is the program I use (Easy-to-use Applications that runs off AutoHotkey) http://www.mouserecorder.com/ My macro only works for my computer + network settings (Windows 10), so you might not get the same results I wi

Is there an option to only edit a record in expanded view only?I'm getting issues where people are accidentally editing a record by mistake and not knowing about it.I'd like for the main view to be in view/non edit mode only and only allow change in expanded view.

Almost certainly, because that's the rate for spreadsheet defects.Many studies have been conducted to gauge the reliability and accuracy of enterprises' spreadsheets. The data suggests most have defects. Spreadsheets that are designed and built using best practices don’t measure up either, as this study found.JPMorgan Chase lost more than $6 billion in its “London Whale” incident, in part due to Excel spreadsheet errors (including alleged copying and pasting of incorrect information from multiple spreadsheets).The vast majority of spreadsheets are built by no-codeists.What’s the likelihood that your company’s modern no-code systems are defect-free?If no-codeists built them, the odds are not in your favor.https://impertinent.substack.com/p/no-code-solution-defects-88

Hello, I had problems sharing a form. After creating it, I sent it to 4 people, including myself, who managed to open it on Safari. The second person, however, can't open it on Safari or on other browsers in general. The third person tried to open it on her PC but received a 404 error message, in her case I don't know which browser she was using. And the fourth person managed to open it on their Android phone.Can you help me to fix this ?

I often call out bone-headed moves by Airtable, but I want to assure everyone, that I actually like the product. I use it for personal and occasional business work, and I am a paid user who can attest that they do not provide support to simpleton users like me who regularly advise very successful companies.In this call-out, I’m looking at the hidden side of no/low-code SaaS platforms and how this particular vendor managed to create a support crisis and a pile of bad will. Note: This is the first article I’ve penned specifically about the hidden side of no/low-code economics. I’m an armchair economist and self-anointed No-Code Economist. I hope you like it and the many stories I’ve got queueing up for this new category in my Substack. If there are specific stories you’d like me to explore, drop a note in the comments or reach out anytime (bill.french@gmail.com). The realm of no/low-code has a lot of hidden aspects in terms of cost, performance, and adoption. I hope to explore

How can i do it?I've got one base with 3 tables1 for orders from my ERP automation1 for csv import from stripe payment1 for csv import from adyen paymenti need to everytime when i import csv to stripe table, the automation to find in the orders ERP table raw with the same date as the date column in stripe table and then to update stripe table with LOGO from ERP orders table column and invoice number from ERP orders table column.

HI every body, brand new on airtable; I am looking for a guide listing all the functions with details of each arguments. Something like the way we work with excel's functions.When you insert a function u can click on an link to access specific into on the function, its argument plus same exemples. 

Create a custom HR management system. Including the use of integrated FIllout forms, interfaces, and automation.Employee directoryTime off requestsEvaluations/Reviews

https://airtable.com/pricing4 pricings :Free : No big changeTeam : old Pro ---Busiess : old Pro +++ (key feature from enterprise available : 2sync, more records, more storage, invoice...)Entreprise : old Enterprise +++First fellings :I like it a lot.Business is the new PRO (the way to go for SMBs) 

How often have you experienced the dread when a near-perfect no-code solution stops working?Application sustainability is critical for developers, especially those with no/low-code technology solutions. One factor that can significantly compromise the sustainability of cloud service platforms is the absence of point-in-time production snapshots.If you've worked with no/low-code platforms, this is a huge problem that has a relatively simple remedy.Point-in-time production snapshots are simply an application's code and sometimes certain data that are frozen (in time) and made available for sustained production use. A snapshot provides an exact copy of an application's environment, including its dependencies, configuration, and data. This means developers can easily recreate an application's environment, even if the original environment has moved forward and changed significantly.Point-in-time production snapshots are essential for application sustainability. Without them, developers who

Amazon’s new AWS AppFabric offers a smart and seemingly free way to connect software-as-a-service (SaaS) applications, but it may also be the ideal way to free customers from no-code integration platforms with high switching costs. If the switching cost moat evaporates, how will the no-code integration glue factories keep you as customers?No-code and low-code application builders who have unwittingly become glue-sniffing addicts of code-less integration face massive switching costs. Moving from Zapier to Make or custom integrations is a lot of work. AI removes the switching cost friction - soon, it won’t matter.If you can switch to an integration layer that is free (or near-free) by simply describing in your native language what the integration needs to do, would you stay with Make? Zapier? Whatever?  

Hot off the heels of this week’s exciting API auth and documentation updates, I’m excited to show and tell you about a Raycast extension that uses the new OAuth and metadata endpoints. First - What’s Raycast? Raycast is an extendable alternative to Apple’s Spotlight. The new Airtable Raycast extension allows a user to browse the bases, tables, fields, and views they granted the application access to (a part of the Airtable OAuth flow). A GIF of the basic functionality is below and you can follow this link to the Raycast extension store to learn more and install the extension. The extension is open source at https://github.com/Airtable-Labs/raycast-extension and https://github.com/raycast/extensions/tree/main/extensions/airtable Let me know if you have any questions or suggestions. I think there’s a lot that could be improved and would love to hear your ideas too! Special thanks to @SeanKeenan and other teammates for their help! – And lastly, an obligatory legal disclaimer since this i

Hey everyone, I spent some time in the last couple weeks to upgrade my personal habit builder to include some latest features. Just learnt that the progress bar is supported natively. It looks so good! 🤩The habit builder includes:goal gallery: with goal templates, calculated progress (I'm so glad that progress bar is now supported as a native feature. This looks so good!) and status reporting all at glance. Built in automations to auto populate weekly log and reminding off track goals.current week: quick access to log progress, feelings and notes for goals.activity overview: list of goals and activities, with filter, sort, search and moreinsights: analytics on goals and deepdive into activitiesIt uses some of the more advanced Airtable features including formula, rollups, progress bar, interface, automation. The habit builder is particularly beneficial when your goal is to carry out a task daily and steadily advance over time. Check out https://plannerhq.gumroad.com/l/habitbuilde

Data loss in Airtable through accidental error, incorrect automation setups, human-error, or anything else can be devastating. If you’ve just discovered that you’ve lost some data or you fear it will happen to you, this is the source you need.We've created a guide to help you go through various steps and places to look in order to recover your deleted data.In this tutorial, you’ll learn step-by-step what you need to do to find and restore your Airtable data.For additional protection, we created On2Air Backups to automatically back up your Airtable data on a regular basis.Get the guide:⭐A 7 Step Guide to Restoring Deleted Airtable Data

Hi All. More bad news on the Pro to Teams transition. Normally on the Pro plan we had access to a color palette for single and multiple select that gave us 40 different colors.  On the new bases we create today we are choked back down to just 10, telling me to upgrade if I want more colours. This despite the fact that all the pages advertising for "Teams" state that it should still be 40. (See attached screenshot).  I've already watched my storage space cut in half and now the colors are reduced by 75 percent?  What's going on? 

(Updated this post to make the directions more clear and highlight a few caveats)The lack of folders inside workspaces has driven me a bit mad, as I have dozens of bases I'd like to group and organize my own way. This is my workaround using Google Drive. You'll end up with a synced table (preferably in a standalone base) that will function as an index of every base in your Airtable account, which you can group & sort however you please with the use of added fields, and from which you can click into any base. BEFORE YOU STARTYou and anyone that plan to use this index will need to be signed into a Google account and (obviously) an Airtable account from a web browser. The index can be viewed from the Airtable desktop app but will only open new bases in a web browser. (Annoying if you prefer the desktop app.)This workaround is best suited for those working solo or with a small team on non-Enterprise plans. Maintenance can be cumbersome if you're indexing bases across many workspac