Show and Tell

I recently added two new scripts to my Automation Helper Scripts, based on recurring situations that I keep seeing in this community.sumTwoNumbers. This script adds two numbers together and outputs the sum. Use this script to increment a number field without using a formula field that just adds one to an existing field.useAlternativeValue. This script inputs a main value and an alternative value. If the main value is not blank, the script outputs the main value. If the main value is blank, the script outputs the alternative value. This script shines when you want to use an alternative value when the result of a "Find Records" action is blank.If you have already purchased my Automation Helper Scripts, you can get these new scripts by logging into your Gumroad account.These Automation Helper Scripts are fairly short. Most are only a handful of lines of code. They are designed for the following types of people.You just want working code and purchasing these helpers is faster and easier th

Hi Community,Does anyone else experience problems with automations? my all current automations started failing around 7PM Berlin time.I getThere was an unexpected error while executing your script.it also doesn't matter from the script content. when rerun, it stays "In progress" and eventually fails.Regards,Nikolai

 

Hello Airtable Community,I am working on a project where I have three tables in Airtable:Trip Table: Contains all possible trips a participant can go on.Participant Table: Includes a multiple linked record field for trips that a participant is signed up for.Trip Junction Table: Holds individual records showing a participant and the single trip they are on.I am facing a challenge with setting up an automation. My goal is to automatically create a record in the "Trip Junction" table when a participant adds another trip to their account.Here's the scenario:When a participant selects a new trip in the "Participant" table, I want a new record to be created in the "Trip Junction" table that links this participant with the newly selected trip.However, I am unsure how to set up this automation, especially how to identify the newly added trip and trigger the creation of a new record in the "Trip Junction" table.Could anyone provide insights or guidance on how to set up this automation? Any tips

Hi everyoneI’m really pleased with this Airtable system I just built for project and team management. and launched in my store on gumroad today.It works by having two interfaces connected to the same base: one for the project managers, one for the team. The manager enters basic employee data, including their contracted hours, and assigns them to projects. Employees can then see the projects to which they’re assigned in their own interface, interact with each other through the chat, log any expenses their projects have accrued, and submit reports. They can also “clock in” and out again, which timestamps their entries and tracks this data with the time assigned by the manager for each project. When a project has multiple people assigned to it, the time assigned for working on the project is divided equally among them (e.g. a 30 hour project assigns 10 hours to each team member to working on that project). The idea is to encourage collaboration and accountability for teams

Hi everyone,quick announcement that I'm building an Airtable Scripting Course for NoCoders, launching before the end of February.This course will compress what's I've learned from writing 1000s of scripts in Airtable over the years. Please sign up here if you're interested 🙂https://airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3ZbBest,Rupert  

Hi everyone,just wanted to share my latest video featuring how to connect to the ChatGPT API without using third-party automation platforms (Zapier, Make, ...).Hope it brings value and would love to get feedback on it!https://youtu.be/pEbU1geuF8I?si=jTyJ6ryNwPVwjS-mCheers,RupertPS: If you're interested in learning how to write scripts in Airtable, please add your name and email here: https://airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb

Hi all,I have written a guide showcasing a quick and easy way to have a chat with a GPT chat bot (Perplexity) about live Airtable data. Check it out!https://www.csvgetter.com/blog/enable-airtable-ai-analysis-with-perplexityLet me know what you think.

I don't know why I didn't think of this sooner, but Airtable is a perfect platform if you want to set up a simple message board for a team of people. I built this interface to do just that.You can post messages, reply to conversations and edit your own messages. One automation and a few tweaks to the settings and you can allow users to edit or delete their own messages, but only reply to those posted by others. Conversations are added to an ongoing "log" with each message so you can easily keep up with any discussions.

Hi there! If you love to keep track of your plants, landscaping, or gardening, this database might help you out! This base includes all the plants we used to landscape around our home. It includes a gorgeous Gallery view of all your flowers and shrubs. ​I took a picture after each flower and plant was in the ground. The best part was I did it all on my phone using the app. ​Fields included are: Plant Name Season Type Plant Type Plant Picture Area Planted Instructions Image Sun Watering Notes Date Planted Record Created Date Plant Status ​ I’ll be adding more info in blog posts soon. Go to hannahwiginton.com and sign up for my newsletter for updates! Airtable Plant Landscaping Tracker - Airtable Universe This base includes all the plants we used to landscape around our home. It includes a gorgeous Gallery view of all your flowers and shrubs. ​ I took a...

Hello all,I have 2 different bases one for Employees and one for Equipment.  I have synced the Employee table to the Equipment table to assign Employees to different pieces of equipment linked to the sync data.  I see the new fields in the synced table in the Equipment base, but I don't see the Equipment showing up on the Employee base.How do I get it to sync back to the original base? and show in other tables that based is synced to.Thank you in advance for all your help.

Hello, In my Airtable's "PEOPLE" Table, we stored many people's name records—more than 15,500 records. I aimed to identify those name records whose spelling is the same as any particular person's name. I developed the following scripting codes using the Scripting Extension in Airtable. When I tested it with another table with a small number of name records, less than 10, it worked well. However, when testing the code with a table with many people's names, the script's running was not complete. This issue could be related to the large number of records in the Table. Please note the following regarding my "PEOPLE" Table: 1) Table name: PEOPLE, 2. Primary field name: English Name, and 3. "Duplicate Name" is a checkbox field, which means if a tick is created for any name, that name has more than one record. Please see my scripting codes below://Read our tablevar table = base.getTable('PEOPLE');var query = await table.selectRecordsAsync();//Identify duplicates//loop through all of the

Greetings, Airtable Community!Have you ever wished for a quick way to turn a list of birthdays into horoscopes? Well, now you can, right here on Airtable with just a few clicks.🌟Check out this quick demonstration:All you need to do is head over to your Airtable base and search for the "Astrology Calculator" extension. Install it, and it’ll seamlessly convert birthdays into horoscopes. 🥳Feel free to share your experiences or ask any questions right here, and here is a link to the app! https://airtable.com/marketplace/blkEIUSBWaQ0hBB3O/astrology-calculator

Posting this in case this can help anyone solve an issue or in case there is anyone who can think of how to do it better. I was asked to create a corporate event calendar that housed all 5 corporate event calendars in a single base and included 3 specific items:Enforce all event times have a time zone of PSTAllow easy All Day or Continuous All Day MeetingsCreate recurring events that can be created daily, weekly, bi-weekly, monthly, quarterly, semi-annually or annually. Additionally there was a caveat that one calendar type needed to include weekends while the others did notTo solve for this I created a single table called Internal Calendars and included the following fields:Event Occurrence - Single Select that allows the user to pick the type of scheduling for their event(s): All Day, Continuous All Day, Conference Event, Recurring Event and HolidayStart Day - Date field used to select the date an event will start.Start Time - Single Select that has times in 30-minute intervals.&nbsp

Good day Airtable Community,Are we expecting any maintenance issues / downtime during the Christmas season? So that I can set my expectations on what will happen for next week? Thanks

Airtable has just released a popup to allow cookies on all embed views making my app not usable anymore....Each time I refresh the page, the same popup is displayed !How can I get rid of this popup allowing cookie ?Thank you for your help!

Hey there Community, happy December! If you're anything like me, you love a good resource. Anything from my favorite recipe, "how-tos" for my home or tips for my yoga and meditation practice, I love to bookmark and squirrel things away in folders for when I'll need them in the future.  This is especially true for work. I'm constantly saving bookmarks in my browser, categorized into folders according to the platform, app, strategy, etc. And I refer back to them time and time again. This got me thinking... you all probably have Airtable Community threads that you refer back to, and I'd like to open up this space for you all to share! Whether its a solution that you personally sought out by posting a question of your own, or you stumbled upon a discussion from a year ago that helped solve your use case, comment directly to this thread to share it with others! This can also be an Airtable Guide, Article, or Announcement Blog. Feel free to tag others who were involved in the resource s

On the 5th, I’ll be leading a workshop for leaders of international schools. The focus is on developing in-house applications, particularly using platforms like Airtable and Softr, to enhance school operations. I’m reaching out to gather insights on best practices from outside the education sector.Could you share any resources or case studies of companies that have successfully utilized Airtable and Softr to streamline their operations? Examples where these tools have enabled organizations to concentrate more effectively on crucial aspects of their mission, rather than being bogged down by operational inefficiencies, would be extremely valuable. Insights into how these platforms have been adapted to meet specific operational needs, rather than relying on generic, ill-fitting solutions, would be particularly beneficial for my presentation.Your contributions would be greatly appreciated and incredibly helpful in enriching the workshop. Thank you!

We have a grid view generated, which shows us the percentage per column (it is a room occupancy rate).We would like to get a total occupancy rate per time period calculated. But we have no idea, how to approach it.Does anyone has an idea how to do it?   

Hello, i'my trying to compare efficiency of real-time project durations to theoric template durations. Projects are linked to tasks and tasks templates ;-> total duration of a project = sum of the duration of each task-> duration objective (efficiency) of a project = sum of the task duration objectivesIn each project, Im trying to lookup the tasks theoric duration and sum it up to compare it to the actual project duration. I'm doing this this way : - I link projects to tasks- Each task is linked to a ''task template''- I look up the ''theoric duration'' of each task and Sum it up in rollupThe problem is that the sumup calculation is incorrect : see screenshot ->- the first row, lookup values for theoric durations per project are as follow : 10, 10, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8,

Hello 🙂I am creating a scenario in Make(Integromat) to resize images, and compress if they exceed 5MB in size.Bellow is the screenshot of the scenario I have created, but it is not working as expected.   I use HTTP to check the resized image size in MB  From here on, I am no longer sure what I did wrong, but Get multiple variables does not give me the resizes and compressed image. If the scenario received two images, one being resized and other compressed, I get two same compressed images.  I would really appreciate help.Thank you, Pjero 🙂  

Hi everyone,I'm thrilled to share a big news with you here.Building upon our legacy of our WordPress plugin Air WP Sync – Airtable to WordPress, we, WP connect, are on the cusp of revolutionizing how online stores operate with the introduction of Air Woo Sync, our new and innovative integrationWordPress plugin that seamlessly connects WooCommerce with Airtable.Here’s a sneak peek at what will make Air Woo Sync a must-have:Effortless Product Import & Sync: Revolutionize your product management with Air Woo Sync. Import and synchronize your products from Airtable to WooCommerce effortlessly, ensuring your catalog remains current with minimal effort.Real-Time Order Syncing: Stay ahead with instant updates. Every WooCommerce order is automatically reflected in your Airtable base, providing you with up-to-the-minute insights and streamlined order handling.Simplified Inventory Management: Forget inventory hassles. Air Woo Sync brings you seamless synchronization, maintaining ac

Nuttshell began as an internal tool for my team to request AI summaries in a snap. We quickly realized that everyone would love it as much as us, so we scaled it with Airtable. It manages the data, automates each step, and integrates the handful of other services involved.We'd love for members of the Airtable community to be among the first to try it. 

Hello,As a beginner on Airtable, I would like to create a database with 2 tables (at least I think so) in n:n raltion.I have an EMPLOYEES table with several items, made unique by a personnel number.I'd like to create a "training courses attended" table, knowing that :Unique criteria must be validatedEach criterion is uniquely linked to a skillEach skill is uniquely linked to a themeThe aim is to obtain a view on which I can sort the results by employee (validated criteria)or by theme or skill (list of employees who have validated an entire theme or a list of skills).The EMPLOYEE table is easy to create, but I'm stuck on the SKILLS table because of the dependencies between themes, skills and criteria.But also on the method of links to be created with the EMPLOYES table.Or am I making a mistake and needing 3 tables: THEMATICS, SKILLS and CRITERIA?Thanks for your help !Thierry

I’ve setup a number of bases where external people can use forms to submit things like updated contact information by submitting a form as many times as they like, selecting their sponsor company record name as a link field in the form each time. This creates a series of attached entries to their sponsor record. I then setup the sponsor records as a series of Rollup fields on things like “email” etc that rolls up all submitted form entries. However I only want to show people the most up-to-date entries submitted, so I made the following formula that only returns the last linked entry . This is building off this post below: Split First and Last Names That's a little more difficult… At heart, the formula would be something like this: REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," ","~",LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")))),"") That's a little hard to suss out at first glance, so let me break it down, back to front: LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")) gets the d