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
Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :gear: Editing Table Blocks In addition to our recently released ability to edit List Details and List Blocks, starting from today you can now allow editing of Table Blocks :control_knobs: Conditional Chart Filters This new functionality allows you to apply specific conditions to your chart blocks. For example, say you want to show specific data in a chart block to a particular role you have defined within your application, allowing some users to see one set of data and the other another set. :yellow_square: New Blocks We are continuing to bring you more functionality and design layouts to take your Softr application to the next level. • Today we have launched a stunning new mosaic image blocks allow you to show multiple images in a beautiful new staggered layout. • Full-width image block which will take the entire width of th
With the upcoming upgrade tomorrow, now is a good time to think about your Airtable Backups Strategy. Of course, we all hope and expect the upgrade to go smoothly, but having a backup of your data outside of Airtable is always an Industry Best Practice. It’s an insurance piece of mind to know your have an external backup of your data in case of outages, accidental (or intentional) deletion of data/attachments, etc. Don’t worry if you’re not performing backups - you’re not alone! But today is the day to start. On2Air has you covered if you’re ready to start! For the fist 20 signups to our Backups solution, you can get a 20% off your initial subscription period (bigger savings on annual plan!) Check out the service: https://on2air.com/on2air-backups and on checkout use promo code: BACKUPNOW Oh and don’t forget to turn off any external automations (zapier, integromat, on2air, etc) you have running to avoid the error messages that will come while the Airtable database is down tomorrow!
Disclaimer: self promotion Hi folks! We’re looking for users for the upcoming beta launch for Shoptable, a Shopify <> Airtable integration. Shoptable brings the power of the Airtable platform to Shopify merchants by creating a live, bidirectional sync between Airtable and Shopify. Using Airtable to run your shop means you can leverage custom tailored views, automations, and reporting tools to run your shop, all within Airtable. There are almost 2 million Shopify merchants and they all use the same Shopify Admin interface. We’re going to fix that. You can check us out and get on our waitlist here: https://shoptable.app/ Feel free to comment below if you have any questions.
Formula: IF( LEN(TODO_REPLACE_WITH_IBAN) > 0, IF( REGEX_MATCH( SUBSTITUTE(TODO_REPLACE_WITH_IBAN, ' ', ''), '^(?:((?:IT|SM)\d{2}[A-Z]{1}\d{22})|(NL\d{2}[A-Z]{4}\d{10})|(LV\d{2}[A-Z]{4}\d{13})|((?:BG|GB|IE)\d{2}[A-Z]{4}\d{14})|(GI\d{2}[A-Z]{4}\d{15})|(RO\d{2}[A-Z]{4}\d{16})|(MT\d{2}[A-Z]{4}\d{23})|(NO\d{13})|((?:DK|FI)\d{16})|((?:SI)\d{17})|((?:AT|EE|LU|LT)\d{18})|((?:HR|LI|CH)\d{19})|((?:DE|VA)\d{20})|((?:AD|CZ|ES|MD|SK|SE)\d{22})|(PT\d{23})|((?:IS)\d{24})|((?:BE)\d{14})|((?:FR|MC|GR)\d{25})|((?:PL|HU|CY)\d{26}))$' ), 1, -1 ), 0 ) Documentation: This formula checks if the structure of TODO_REPLACE_WITH_IBAN is correct (each country has its own specification). It only considers countries that are within the SEPA area. Specifications: IBAN Examples, Structure and Length SEPA countries and IBAN length - Google Sheets Google Sheet based on the above data structure, easier to work with Outputs: 1: Has a valid SEPA IBAN structure 0: Is empty -1
Hey there!Do you use both Airtable and Google Drive?Yep, every single dayEh, sometimesNopeI wanted to show you how you can automatically create invoices (or any document) in Google Docs using data from your Airtable base.https://www.youtube.com/watch?v=lg_h6kDAak0 This uses the On2Air Docs. It allows you to automatically generate documents in Docs from any data you have in Airtable.Copy the free Invoice Google Docs template and the Sales Base Airtable templateSet up the automation in On2Air Docs using the settings from the article/video (you only have to do this part 1 time)Click Generate Invoice in your baseView your newly created invoice in Google Drive and a PDF version in your attachments field in your Airtable base! Automated Invoice Templates in Google Docs and Airtable (+Free Template) |...In this guide, we’ll show you how to generate invoices using Google Docs plus how your can use your customer data in Airtable to automatically generate an invoice in Google Docs.&nbs
Coming from the Salesforce world, I am used to the concept of converting a lead to an account/contact/opportunity record. I’ve been blogging about creating a CRM in Airtable and I just blogged about implementing a Lead Conversion process behind a Button field. Let me know what you think. Scott Hemmeter – 30 Sep 21 Airtable: Creating a CRM (Part 4) – Convert the Web Lead This is part of a multi-part series on creating a CRM in Airtable. In our previous posts in this series, we started our base with a data model of Organizations, Contacts, and Interactions, then fol…
Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. Timeline Block With the new timeline block you can create a slick-looking vertical list with a timeline, complete with large image tiles, title, description, tag and filtering with your Airtable base. Perfect for creating changelogs and what’s new pages, portfolios and much more. Small List Block Introducing the new list block mini. No, it’s not a new iPhone but instead, a slimmed-down version of the list block. Perfect for when you want to fit more in a row or have a large number of items to list. Editing List Block In addition to our recently released List Details block edit functionality, starting from today you can now edit List Blocks. To put it simply, it allows users of your application to update list detail records directly via your Softr application. It’s a game changer. Passwordless sign-in/sign-up Using this sign-in block, y
I know I fell off the board lately, but it was for [I hope] a worthy cause. Data Deduplication v3.0 The third iteration of my deduplication routines for Airtable, totally rewritten, with additional features and functionality. Standard Airtable functionality Works on Free and Plus subscriptions Optional use of Pro features (record color, Blocks) Does not require 3rd-party SaaS integration Includes 3 “modules” Duplicate identification Suppression of false positives Merging of true duplicates Supports persistent tagging of false positives No need repeatedly to vet the same flagged dupes Suppressed dupes still evaluated against new records Color coding indicates past, new matches Supports real-time deduplication Each new record checked at time of data entry This version of the routines has been tested against bases as large as 25,000 records while proving to maintain an acceptable response time for duplicate detection and false positive functionality.¹ Three demonstration bas
Note: I finally found (and finished) the quick little project I started back in March — right before all my teeth exploded. :winking_face: Here’s another niche application: Code to generate random[ish] unique numbers in an arbitrary range — say, from 1 to 10000[ish]. What it does Generates a unique output number for every input number within the range. The relationship between the two numbers is not immediately obvious — and is difficult (although far from impossible) to discern, even if a user manages to see several numbers output in sequence. Why you might want to do it If all you need is a unique, random identifier, you’re in luck: That’s what RECORD_ID() is.¹ The downside is that something like recdalXVhg9AkUMG9 can be unwieldy; at times you may need to generate, say, a 4- to 6-digit value that is (a) unique, (b) random, and (c) not impossible to hold easily in short-term memory. (Think of the temporary authorization codes or PINs one is sent via SMS or email when trying to vali
Hey there, We’ve recently been looking for a way to evade the limits we face with Airtable API. Now, we’re happy to share a migration tool to move Airtable data to PostgreSQL with you. All you need to do is connect your Airtable data and your Postgres database, and click “Move”. As a result, you get a flexible solution with all your Airtable data migrated. Your credentials are safe – we do not store anything.The tool is totally FREE, and you’re more than welcome to tell us what you think about it and ask any questions! We’re willing to further improve the tool based on your feedback.
Is any tips/hint for exchange from one currency to another ? example is a sale of the same product in more currency around the world like $ (dollar) € (eur) £ (sterlin). I like show the product value in only € (euro) and imput in table the product value sale around world with the sale currency ? ( like sho : on sale cookbook 25€ | but my input is : store in london 20£ | store in newyork is 22$ etc…etc…) thankyou
I tried adapting the template for “Product Catalog & Ordering” but it breaks if you need for, say, User A to buy multiples of an item. What I need to do is to track orders for multiple people of items (Jersey in Small, Jersey in Medium, Shorts in Medium, Shorts in Large, etc.) and some people may order multiples of a single item – and I need to track and pass along the unit price * number to customer purchase total. Help?
HI. My name is Stepan. I work in the field of process automation, and often use Airtable as a database for my clients. Want to start a video blog about some tricks how to make Airtable automations. I’m here to ask, what kind of integrations/automation would be the most interesting for you? Feel free to make your suggestions here. Thank you!
Indeed, views provide a very powerful way to scope and optimize access to data. However, they cannot be dynamically altered to achieve what I consider hyper-performant script processes. Here’s an example… Imagine a table (a) with a view and when a record enters that view, search another table (b) that has 45,000 records in it for a single matching key so that a linkage can be established in (a) to (b). I’m not an expert in all manners of Airtable scripting, but I think the only way to do this is to iterate across the 45000 records in table (b) to locate the record ID such that the linkage can be updated in table (a). Ironically, searching for discussions about this place me in the commentary mix here. And even then, I’m not sure I expressed the issues succinctly. Two ideas come to mind when presented with this quandary - Ideally, there should be a searchRecordsAsync() method that uses the internal search capabilities to return a record (or record collection) given a field or record
I’m really proud to have worked on this and I hope that it brings some of you the joy it has brought me. So if your Labour Day resolution was to stop spending so much time pressing ctrl+c and ctrl+v migrating Google Sheets and Notion files into Airtable then you might want to check out Unito, our new 2-way integrations were designed specifically to save you time so you can seamlessly connect to all the other apps where work happens. Unito.io
Hey Airtable community, Today we officially launched our new Chart blocks on Softr. The new chart blocks work seamlessly with Airtable, allowing you to turn a table of records into stunning, interactive charts which can be created in a matter of minutes. To provide you with a quick example of what can be done with the new Chart Blocks check out this example of a building in public page to share your metrics. This template is now available to use today. We are continuing to iterate the new chart functionality and will be releasing a number of further improvements in the coming days. You can learn more about Charts in today’s update found here. We can’t wait to see what the Airtable community will use this new functionality for.
Hello, I just made my first Script app writing my own custom code :tada: and wanted to share :blush: Context: I am working with a base that has gone through several iterations of development and am trying to resolve some contradictory data sets. Specifically, for a directory of people who get assigned a “level.” There are five different fields to compare and resolve so as to make a single source of truth for each person. My fiirst step is to identify where there are mismatches across the five fields (a rollup, two lookups, and two single-select fields). My first thought was to use a nested IF() ƒormula, but I found it difficult to construct the matching logic for the fields values and for when any them are without values (i.e. blank). My next thought was to use an array formula to make an ARRAYUNIQUE() out of an ARRAYCOMPACT() values (i.e. remove the blank values, then look for unique values). To my surprise, the Array functions are only applicable in Rollups or when the field
Hi, sometimes button format is not convenient, when you have to assign scripts, related to table, not records. i think that buttons needs at least be possible to show/hide in different records. And change label. And color. And script assig… okay, that could be done by “Switch” in single script :grinning: Well, I’m not with a complain or proposition, just want to share example of using Singleselect for UI. Triggered by automation, returns to default state “CHOOSE ACTION” (other records default is ‘inactive’)
If you find yourself collaborating with your team in the same base, it can be helpful to see the latest updates and when things were modified to make sure everyone’s on the same page. In this video, Airtable’s Becky Mak jumps into a base to show you how you can surface those updates. Additional resources: Support article: Last modified time field Support article: Use automations to timestamp status updates Support article: Record-level revision history overview Support article: Last modified by field If you know of other resources that come to mind, drop them in the comments below! We want to see your favorite Airtable tips! What’s your favorite Airtable feature? We want to know - share your videos on social and use the hashtag #AirtableAnswers so we can share them with the Airtable Community. (There might be swag involved… :eyes: )
Hey everyone! It’s Luannie from Pory. We’re super excited to kick off our how to build series using our favourite tool Airtable! Our first tutorial is on creating a members portal where I’ll be covering how to: :hammer_and_wrench: Navigate Pory (we’ve given it a lot of love) :electric_plug: Connect and manage users via Airtable :love_letter: Generate invitation links to existing members Let us know what you think and what you would like to see next!
Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled up a number of new features this week we would love to share with you. New Templates Firstly, we have two stunning new templates. The first one is an inventory tracking template created by our partner agency VisualMakers.de. This template is perfect for a small business to track and manage all your products, orders, manufacturers and purchase orders. Next up is our out of the box community template. This template is packed with advanced functionality and is perfect for anyone looking to create an online community. It includes a modern, minimal design aesthetic, community directory, a list of events and spaces and the members attending each event + loads more. Transfer Ownership You can now transfer ownership of a Softr application from your dashboard. This is something a number of agencies and creators have asked for. Now you can create Softr apps and transfer them to new owners in a matter of seconds. Th
Need to build a CRUD app on top of the Airtable database? UI Bakery handles it. Development takes minutes. Check it out https://uibakery.io/airtable-crud-builder
Looking to dial up your executive summary email process? In this video Airtable’s Head of Content, Margaret Jones, showcases how you can create send off emails summarizing all the content that’s shipping in the following week. Margaret uses this email to let stakeholders know about what’s coming in the pipeline (and share the amazing work her team is accomplishing)! Additional resources: Support Article: How to create email digests with automations Template: Content Calendar From the Community: Airtable Automation: How to Automate Email in Your Base & Save Time Support article: How to automatically send approval emails without leaving your base We want to see your favorite Airtable tips! What’s your favorite Airtable feature? We want to know - share your videos on social and use the hashtag #AirtableAnswers so we can share them with the Airtable Community. (There might be swag involved…)
Hey Airtable community, We have a major update on Softr to share with you today which i think you will love! You can now allow your users to edit Airtable data from with your Softr application. You can set up this ability in a matter of seconds starting today. The new editing functionality opens up an infinite amount of new possibilities with Softr and we can’t wait to see what you come up with. To give you a quick overview of this new functionality we have put together two short tutorial videos which you can check out below. We will be continuing to roll out the edit functionality to other block elements on Softr over the coming weeks so keep an eye out for future updates. • Softr editing Airtable records (all logged-in users) • Softr editing Airtable records (One user group can edit, the other can’t) Lastly, the edit permissions functionality is currently available on Softr’s Professional and Business plan members. However, we think everyone should have the opportunity to try this ne
-moved- to Products Suggestions.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.