Show and Tell

Hi,I am trying to create a table that has one input field - the name of a product. This field is used to look up the article number of the product from another table - the catalogue. I then want to use the article number to look up data from a third table, which will tell me whether this product is in stock or not. I don't want to use a second input field to keep the use of the table as simple as possible.Can you help me out with a solution to my problem?Thank you for your help in advance.

The App ‘Currency Converter’ is now ‘Currency & Crypto Converter’ as we now include historical crypto rates such as BTC and ETH. Hope this is useful! :slightly_smiling_face:

when i'm viewing my tasks i'm not able to see some projects. Probably because the project doesn't have tasks but I'm not able to add task if the project does not show. Anyone knows how I can solve this ?

Hi friends of Airtable! 👋Some of you are already familiar with DocsAutomator — the document / PDF automation tool I’m running and that lots of Airtable customers are using to solve their document / PDF needs. I’ve launched an affiliate program that extends a 30% commission for the entire lifetime of referred clients.Would love if some of you would check it out, consider it for your next projects and tell your audience, colleagues and friends about it 😎Find more info about the affiliate program here: DocsAutomator’s Affiliate Program

HelloNew Airtable user here...I'm using Zapier to populate 3 tables.  The data is added live from our proposal design package into Airtable.The tables are:-CustomerLead HeaderLead DetailThe Primary field for Customer is  - email_addressThe Primary for field for Lead Header is - lead_idThe Primary for field for Lead Header is - lead_idHow would anyone suggest I link the tables so that I can combine the data, and allow Zapier to keep them updating automatically?Thanks Matthew    The customer primary field is "Email Address" which also appears in "Lead Header".Lead Header includes.  

I'm having an issue adding a "new product" under the Emails list. So I went into the "products list" to add one in. I returned back to the "Emails list" and it's not there. I can only change the names of the product under "products list" only. How do I add a "new product" to the Emails list, especially when it won't show up when I add it to the products list? Also, I tried changing the name when I was under the Emails list and it wouldn't let me. 

I am curious if anyone would be interested in an extension for Airtable that would automatically categorize financial transactions. The data could come from any source even if you imported it via a CSV file.We currently have financial planning company that has seen significant benefits form our data pipeline and we are curious if others would benefit as well. Below are a few of the outcomes from the company:Decreased workload by 50%Decreased cost to company by ~$20,000 (eliminated need for part-time help)Allowed them to scale their hyper customized service offeringWould love to hear comments to see if other would benefit from this type of marketplace extension.

I’m proud to announce the public release of Airpress, a plugin for Wordpress.org websites! Airpress gives you access to all your Airtable data, allowing you to create Wordpress websites that are fully integrated with your precious Airtable data. Read more on http://wordpress.org/plugins/airpress Do you think you’ll install the Airpress plugin? Nope. I’m good with Airtable Nope. I don’t have a Wordpress website Sure. I might give it a try sometime Yes! I need to display Airtable data right now! 0 voters WordPress.org Airpress Airpress allows you to use your Airtable data inside WordPress as custom fields, virtual posts, and more!

Hi everydody,I'm getting crazy and I can't believe Airtable haven't previewed this option, but I cannot find the solution to my problem.i'm trying to filter a view from a Date field. Actually, being on the 8th of October, I would like to filter all the IDs from the 1st day of september to the last day September. So, in our case, between the 01/09/2023 and the 30/09/2023. And obviously I want it in dynamic, as if, next month, I will want to filter between the 01/10/2023 and the 31/10/2023.As shown below, When I select the logical choice "Date included in the period" + "Last Month", it selects me, being the 8th of october, between the 08/09/2023 and the 08/10/2023, as if I had asked "the last 30 days".Does anybody can help me, please ?Thanks a lot 

Today, we could not copy-and-paste the external data (like excel, csv, google sheet ...) with multiple rows to Airtable's table properly.When we paste many records and need to expand the rows, nothing happens. Then what I could observed into the browser console log is shown below, yes, it has an error from the Airtable.Please solve this bug, Airtable team, this problem stops our works!!*** The work around for this moment is, we must create empty rows enough before pasting data, then we could survive during the wait for Airtable team to solve this.

Is it possible to embed a two-week calendar view on a website? 

Hey Airtable enthusiasts!I've developed a script called `slackblocks-4-airtable` that might interest those of you looking to step up your Slack notification game from Airtable. This script allows you to craft well-structured and visually appealing messages seamlessly from your Airtable base to Slack. It’s designed to make your notifications more engaging and informative.How it Works:1. Easy Setup:Copy and paste the script into an Airtable script automation.2. Design Your Message:Create an array variable to contain your message, utilizing the `$.{blockType}` syntax to design your message.3. Build and Send:Use `$.build(message)` to assemble your message and send it via your Slack Webhook URL.Example Usage:Here's a snippet of how you can instantiate the `SlackBuilder` class and send a message:// replace 'webhook_url_here' with your webhook URL const $ = new SlackBuilder('webhook_url_here'); const slackMessage = [ $.header("This is a header message"), $.divider(), $.mrkdwn("You can _even_

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 ?