Show and Tell

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

Something sooooo wierd is happening to me that is driving me crazyI am trying to compare a date with today. Easy task aparently. (anyway working on dates is never easy to me)Look what is going on:Two date fields createdDate 1 is TODAYDate 2, the date of a free class at my schoolNow i created two testing formulasAnd testing 2. Just substituting Date 1 field by today() So both formulas are supposed to give the same output, but....OMG!!! no idea about what is happening! Any help please! 

The new "Record Review" interface layout is very useful and simple to use, but on fullscreen mode components does not expand to occupy all available screen space. It´s also not possible to change "grid" or "timeline" components height.  

HelloI imported a excel doc where I prioritize items based on a 1-4 scale for sorting. I also use "Z" to sort items to the bottom that no longer need a priority. After I imported to airtable, its only letting me sort my priority column "First - Last" or "Last - First" which I am not familiar with. So i changed the "z" items to "999" thinking airtable might only recognize numbers. Didn't help. The "1" priority is still not sorting to the top.In short, I get that airtable wont sort as if it was a spreadsheet but i need to know how to label my prioities so they sort.Right now, I am using 1 - Ultra High2 - High3 - Medium4 - Low999 - Unavailable or ScreenedHelp?

Hello AT FamilyTable: Properties (is our base table with all of our info)Table: Mortgagehas all mortgage info pertaining to each property in Properties TableThe main statuses in this table is "Yes, No, Refinancing"Note: some properties in this table have had two mortgages, which means to two lenders at one point, which means two status, "Yes and No"Table: InsuranceI need ONLY the lenders from the "Yes" status in the Mortgage Table to be looked up in this tableThe problem I'm having is it's pulling the both lenders with "Yes and No" status.How do I make it only pull the Yes lenders?When I filter to show ONLY Yes, it doesn't show anything because the property may have a Yes and No status.

Hello Airtable communityI've been diligently working on a time-tracking solution in Airtable for a nonprofit organization. Inspired by a YouTube video from Dan Lehman, I aimed to craft a system where volunteers could easily log their hours during a program. The base setup was straightforward, but I've hit a roadblock when integrating custom buttons within the Airtable Interface.Base Setup:Table: "Time Logs".Fields: Volunteer full name, VITA site (with options: El pueblo and Quincie), Certifications (with options: Basica and Advanced), Time In, Time Out, and Duration.Functionality:I implemented two button fields:"Start Time Tracking": Populates the "Time In" field with the current time."End Time Tracking": Populates the "Time Out" field and calculates the duration.Both buttons are linked to custom scripts to automate the time-tracking process.Issue: Transitioning to the Airtable Interface to provide a streamlined experience, I've found a challenge. I added a List element to display reco

Access dynamic interface url tokens within automations!You can now access interface URLs! This allows you to guide users to specific interface views and specific records within those interfaces.Providing YOU the power to organize and restrict the data the end user sees.Learn how below - in under 4 minutes!

I built https://www.nocodechart.xyz/ to let you create and add interactive charts to your website with live data from Airtable. You will be able to create a chart, design and add it to your website within minutes.Start by connecting to Airtable as a data source, customize your chart by changing chart type and colors to match your website. Copy iframe and paste it on your website.If you need help, message me!

The "revision history" of records is great, but it has its limitations.  If you're using the free version of Airtable for example, you only get 2 weeks' worth of revision history.  It also logs absolutely every change made to a record by anyone, which can become difficult to sift through if your base is complicated and has multiple collabators.As a workaround for this, I've started using automations to log particular changes I want to monitor, by simply using the NOW() function as a datestamp that's pasted into a long text field each time the actions I want to log are taken.  The automation takes the contents of the {Change log} field and copies it back into itself each time along with the new datestamp and notes of actions taken.  So what you're left with is a running tally of certain actions within each field.Another advantage of this is that, because the change log is actually a field within a base, which the revision history is not, you can display it in an inte

Is there an easy way (like a shortcut) to navigate to the first column of the current row in a grid view?

Hi, Airtable community! I'm developing a custom solution for a small gynecology clinic in Barcelona but I don't understand very well Airtable's pricing. Hope you can help me out!In terms of users and permissions, I’ll need 5 editors and 6 commenters. I think it is covered in the free plan but If I want to upgrade to the plus plan to benefit from more records per table, how much I’ll need to pay?Let’s say I have a module called Patients where I have records about their personal info, visits, clinical history, etc. I’d like that user called receptionists to be able to record and modify patients' info but not able to change/modify module configuration. In that case, which plan I’ll need?Any help will be appreciated!

Hi Im trying to Compress multiple fields with one script, I tried searching for a solution but I haven't came across to anything.I was able to find one but i'm only able to compress one field but not multiple fields // Modify these to your own values.let tinyPngApiKey = 'xxxxxxxxxx';let airtableAttachmentSource = 'Instructor Sample Artwork #1';let airtableAttachmentDestination = 'Optimized Artwork 1';let airtableColumnToLog = 'Optimized Artwork 1';// Don't change these unless you know what you're doing.let table = base.getTable(cursor.activeTableId);let view = table.getView(cursor.activeViewId);let queryResult = await view.selectRecordsAsync();for (let record of queryResult.records) {let recordAttachmentUrl = record.getCellValue(airtableAttachmentSource)[0]['url'];console.log('Compressing ' + record.getCellValue(airtableColumnToLog)) let request = await remoteFetchAsync('https://api.tinify.com/shrink', {body: JSON.stringify({'source': {'url': recordAttachmentUrl}}),headers: {

Using Airtable and Zapier, I am trying to link uploaded photos in an email.For example, we are using Airtable as our backend system and once a job is complete we upload photos of the completed job, is there a way to link this attachment field to use in an outbound email?I assumed I could use this link in the Zapier / Email automation:  However this link doesn't work: Any help would be appreciated. Currently we have sent the files from AirTable to Google Drive and using the shared link from there, however Google Drive uploads all of AirTables attachments in a zip folder so it shares it as a zip.   

Hi everyone,I made a Trip Planner for tracking some of my trips a while ago. It helps keeping my trip and activities organized. I figured I would share this basic base version in case anyone would want a trip planner starter. Feel free to copy and update the base in any form.I also has a more comprehensive version allows me to do more thorough planning, reviewing and budgeting etc, since l love traveling a lot! It also comes with interfaces, which looks nice and handy. It's available here (https://plannerhq.gumroad.com/l/tripplanner) with more information 😁If you got any questions, reply or emailing me!Thanks!