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
The latest update (4.1 as of 10/13/20) makes the date field almost unusable.
Now that the Custom Blocks have been publicly announced, I wanted to show a block that I have built. :new_moon_with_face: Name: API Connection It can fetch data from a JSON API and populate your table with the data. :mag: Where is the block? On github - https://github.com/saas-developer/airtable-api-connection :video_camera: Demo :studio_microphone: I also have a course on building custom blocks on Udemy (I hope its not against the rules to post this) :dollar: Hope this inspires your hackathon block and you get the $10,000
# Re; Dynamic reasons to reachout {your social signal} This is first of a series of Airtable Base templates that will make your sales outreach more effective by being relevant at Scale lean more in the Learning Center #1 - Create a simple but very effective reason to reach out , using the {action} ( a comment, a like , sharing post ) in a {Channel} ( Linkedin, FB, Quora, Medium …) and the {Keyword} ( what was it about)
I played around with Apps for the first time today. I built this (alpha) tool https://github.com/UnlyEd/airtable-app-bases-compare which basically prints out a Markdown text about the base configuration (all tables, fields, options, etc.) and can then be used through another Text Diff checker tool to figure out what the differences between two bases are. This is essential to us because we have bases that must be eventually sync (staging > production) and we were getting lost in changes until this. I hope you’ll like it as much as we do. Keep in mind it’s still an alpha version and subject to massive changes, but it does work and might help you today. :slightly_smiling_face:
Hi I am a consultant working in pro sports and am keen to understand more about Airtable. My data/information services can possibly delivered via Airtable, where I am currently using Google Sheets and PDFs currently. Each client would require their own environment (workspace) and I would be refreshing their data daily/weekly (which is another question I will need answering). I have read plenty on here and watched YouTube videos, but I would really like to understand the more about the client UX for when Bases are shared externally, via links. Ideally, my clients will be ‘read only’, for the Bases, and I would be keen to see an example of their User Experience - can someone send me a link or provide a video that would present this? Furthermore, would they be able to manipulate the Kanbans, or would that require a different level of access? Thanks for your help.
It always surprises me when professed experts are unable to truly understand a market’s topology. How is it possible to claim to track the no-code sector with the list of tools and services referenced in this article? Seriously (trends.vc)!?! These are the “no-code players”? I can think of one that’s missing - rhymes with fair-label. :winking_face: Carrd Webflow Bildr Adalo Glide Softr Bubble Sharetribe Buildbox The market is clearly made of some very serious players from Airtable (of course) to Google Tables and waypoints at Microsoft Lists and even Amazon Honeycode. Airtable still dominates this movement but that could change if its technology leadership voice is weak. BuiltOnAir is probably the closest Airtable has to a pronounced and definitive content resource for its no-code thought-leadership. Thoughts? trends.vc Trends #0033 — No-Code
Base -> HTML -> PDF This “show and tell” is based on a project I worked on for the Computer Museum of America (see this post: TimeLine of Computer History). Airtable Pro plans can make use of the Page Designer block, but if you don’t have a Pro plan or want something that is a bit more customisable, then this might work for you. Really, this is about outputting base data into a PDF, but uses HTML as an interim step. The benefit of HTML is that is hugely customisable and, by using CSS, you can pick from a huge range of colours, fonts, layouts and so on. Possible use cases for this might include product catalogues, invoices, brochures, data reports and so on. Or even large format wall displays 100ft long :slightly_smiling_face: The code I used in the CMOA project was very specific to that piece of work, so this is a more generic way to get similar results, with a number of code improvements added along the way. You can find the code in this repo: GitHub jo
Hi Airtable lovers! :rocket: I wanted to share a personal project I’ve been working on :slightly_smiling_face: I started my Youtube channel because I want to help more people build (and more importantly, UNDERSTAND) nocode databases because I know how challenging it can be to get started. The first tutorial series is on building a great CRM. Here’s the channel: https://www.youtube.com/airopsconsulting Here’s the most recent video: https://youtu.be/exIYtS4EdFA This video is great if you want to learn about how to link tables within your base and why using views is so important! Thanks!
Would love to share with the community here a UserStyle that modifies the display of Airtable’s Kanban view to make better use of available space and simplify the cards UI. It also applies thin scrollbars all over airtable.com (this block may be removed) and modifies a collaborator field with the title “Action of”, if it exists. Don’t get me wrong, the Airtable team is doing a great job, but the chrome is a bit on the heavy side with all those borders. Several design choices are “embedded” within the implementation, therefore impossible to modify. See here for the UserStyle and instructions on how to use it: https://github.com/Arty2/userstyles#airtablecom-neat-kanban
So I typically input the data from my excel and copy past it here. But many of my records look weird, and i have to manually fix them. How can I Avoid this problem ? in the scrreen shot only the partial name shows up.
UPDATE 09/05/2020 - The new “updated record” trigger for automations makes this workaround unnecessary (more notes in a comment farther down in this thread), but I’ll leave the thread here anyway. Using Airtable’s new (but still technically in beta for Pro-plan users and up at the time I’m writing this) automation features, how can an automation pick up all changes to a field? It wouldn’t be a new record trigger, and the only other option right now is a new record in a view. If the field in question was simply going from empty to not-empty, the triggering view—and any connected automation—would pick it up after the first few characters, and wouldn’t operate on the full contents because the record would need to leave the view and re-enter it again to re-trigger the automation. So how can a lengthy change to a single field re-trigger an automation multiple times so that its full contents are processed? As with many things, it’s a matter of time. In the early days of Airtable’s automatio
This is either an awfully clever work-around for Airtable’s limitations on data lookup or an incredibly convoluted method to achieve something that can easily be managed within Airtable itself, had I not overlooked something basic. You tell me… On my current project, my main table tracks items currently within a collection. An item may currently be onsite or in one of several offsite conditions – for instance, on loan, on lease, gifted, sold, lost, out for cleaning, or out for repair. The total number of on- and offsite statuses is fewer than 10. An item may pass through any number of statuses, but it can only be in one status at a time. As I chewed my way through the base design, I quickly realized there was substantial overlap among data required to track offsite status: Who had the item, the date the item went offsite, the date it was due back (if applicable), the date it actually returned, and so on. I created an outRecord table to log each status change for an item, with a one-to-
Here is a demo of a script that I am working on. This script creates a new record and all associated linked records in other tables. Default values are set in a “template” record, not hard coded into the script “Smart” defaults can be calculated values, such as the current date New linked records are created, including multiple levels of links Changing the defaults or linked records requires no editing of code Multiple templates are possible Some notes: Initial table/view/template can be hard-coded if desired to speed up data entry. Minor design changes to the base are required for some functionality (mostly creating new formula fields). The script only adds new records; it does not alter any existing records. I am not releasing this script yet, as I still want to tweak some aspects. The script is also extremely long and represents many, many hours of work. I look forward to hearing what people think of this script. If you are interested in
I am new to JavaScript, and one of the reasons why I took learning it to use it on airtable. Often I need to sum, count and averages of values in a table and hold the value in a block for a while for others to see. This can be done using existing blocks but one each for sum, count and average - which is tedious. This script makes life easier in such cases. It lets user select the field and table, and even filter conditions before summing, counting and averaging them. I am planning to add error handling. and warnings to this soon. GitHub link is here: https://github.com/indrex/airtablesum
I am using AT for our CRM and database for our company. So we are able to link financials to the customers and marketing reps commissions. The more I play with AT the more I see it has amazing capabilities. I am a visionary and have some cool ideas on how to use it further but would like to see if there are other users interested in having a ZOOM call or other medium to further explore the idea. We are also in the process of using it for our HR process by using digital forms. Below is a link to a form for those interested in joining the group. https://airtable.com/shrlVF9kevgnyaqrT
I’ve recently started using Airtable to cut down on the number of spreadsheets that don’t talk to each other, and loving the improvements we have made so far. One of the struggles was not being able to use a lot of features due to dates and times being in seperate columns in all our other documents, and wasn’t able to find other community posts solving this in a simple way. After a few weeks of messing about, I finally found the DATEADD formula is the simplest: DATEADD({Date},{Start Time},‘seconds’) I use a similar formula to calculate the end times. I can now use all the lovely DATETIME formulas I’ve been excited to try out without having to do manual input, which was the goal all along. Has anyone else had to discover this themselves? Any other workarounds people have created?
EDIT: Updated to incorporate solution for batching more than 50 records Why this script I import transaction records into Airtable from my bank on a regular basis via CSV files. Those transaction records have names that are pretty ugly most of the time (like [Amazon.com*6X6AN17G3]) and often there will be multiple transaction names that actually link back to the same company as a payee. I want to know, for example, how much I paid out to “Fry’s Grocery Store” in total, no matter which Fry’s location I went to. And, I want to view that data in a Chart block, with pretty colors from Single Select options, for example. So I used to manually match transactions with a colored Single Select value: Needless to say, it was a tedious manual process, and I very frequently encountered the same Import name over and over – so I knew this was something the Scripting block could help me with, at least to some extent. What the script does This script checks all imported transactions that do not ha
Heya community! Dan (@openside) and the team have been hard at work making our own slew of tools to compliment Airtable. Today I’m excited to announce they are now live! Here’s what we’ve been making: Actions - Advanced connector to integrate Airtable with your other software tools Forms - Sophisticated Airtable forms with extended features Schema - Monitor and be notified when anything in your Airtable schema changes Backups - Automated backups for your Airtable bases Scripts - Specialized script manager to integrate with Airtable’s scripting block Storage - Secure storage and proxy for your Airtable script data Our new site just launched where you can go check them all out here. We’d love for you to give them a try with a free trial (link on the site). If it’s a fit, go ahead and use coupon “ON2AIR10” for a discount on any app bundle as a thank you for giving it a try! We really think we’ve made the best tools for Airtable out there, and know it wouldn’t be possible without you
After consulting for the last 2 years, I started this Youtube channel to make Airtable more accessible because I know how difficult it can be to get started. Currently, I’m working on a CRM tutorial series where you can build a simple and fully customized CRM. So many of my past clients disliked their CRM and some still use pen and paper! Even if you are not looking for a CRM right now, I still walk through a ton of concepts in the tutorials that can be helpful across many types of Airtable projects. Here’s the link to the channel: youtube.com/airopsconsulting Here’s the first CRM tutorial https://www.youtube.com/watch?v=1qJZvdOY01g&t Thanks for stopping by!
Sometimes you import some data that looks like this: But you want table data that looks like this: This script does that: let settings = input.config({ title:'Table Optimizer', description: "Converts data that's stored over many fields, into data that's stored in one field with multiple parameters in a new table", items: [ input.config.table('sourceTable',{ label: 'Source Table', description: 'The originating table' }), input.config.text('fieldsConvert',{ label: 'Fields to Convert', description: "Type out the fields you'd like to convert separated by a comma. Example: Field 1,Field 2,Field 3. All convert fields must be of the same type." }), input.config.table('destinationTable',{ label: 'Destination Table', description: 'The desitination table' }), input.config.field('field1',{ label: 'Data Field', parentTable: 'de
I’ve solved for how to use a list of ID numbers to highlight the rows with those ID’s. Search only lets you identify one row, and filters have to be chained together one after the other. When you have a table with 1,000 items, and an external source gives you a list of 50 ID’s that all need the same update how do you select them? My solution requires adding a formula field. By pasting all of your ID values as a string literal to search for that rows ID in you can create a flag that then lets you filter a view. Here is an example of the formula: SEARCH( Identifier, “12345 qwerty 292303 zx11k9i2”) In this case Identifier is the name of your ID field in the table. Each row of your string (you should be able to paste a column from excel) is one of the ID’s you wish to modify. The result of this will be a column with blank rows and arbitrary numbers. The number is the location in your pasted string where the ID was found but that isn’t important. Next you will probably want to create a view
Hey everyone! I wanted to share a guide I wrote today on how to create a Slack reminder todo app. It takes advantage of Airtable’s neat Trello-style Kanban view for management, and as a bonus, you’ll catch a glimpse of the start (and probably end) of my poetry career. You can see all the code as well as fork and deploy your own working version onto Autocode from the link. Would love to hear what you all think! Build a Slack Reminder Todo App (slack/slack-airtable-reminders) · Autocode Build a Slack Reminder Todo App (slack/slack-airtable-reminders) · Autocode View and Fork this Source Code on Autocode
I recently redesigned one of my personal Web sites - an art portfolio - using an Airtable base on the backend. If you’re interested, you can check it out here: http://art.timdietrich.me The site is PHP-based. It pulls all of the artwork (including the information about each piece and the images themselves) from the Airtable base via the Airtable API. It also uses Stripe to handle credit card payments, and saves the orders back to the Airtable base. And for email notifications and receipts, it uses Mandrill. More information is available on my blog: http://timdietrich.me/blog/airtable-based-art-portfolio-site-launched/ Thanks for checking it out - and let me know if you have any questions about it. – Tim
In response to a long-running post about needing a find and replace function here: Would love a find/replace option! Product Suggestions I am adding my own request to this list. Not sure why it is still missing, this is an essential database feature. Here’s a script that does just that: // This is free and unencumbered software released into the public domain. // // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. // IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR // OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, // ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR // OTHER DEALINGS IN THE SOFTWARE. // // AUTHOR: Jonathan Bowen (www.dragondrop.uk) // SCRIPT: Script for Airtable script block to find and replace text // DISCLAIMER: // - T
As you may know, Airtable has direct integration with Slack ‘out of the box’. I have just published an article my blog which discusses how to use this to build an absence approval workflow, starting from an employee’s request through to notifying them of approval (or otherwise) - and with a little help from Zapier along the way. The blog post can be found here: Approval Workflows Article The article uses my KasPer Lite base which is available in theUniverse. I hope you find this useful and look forward to any comments…
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.