Show and Tell

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

URLs generated with CSV Getter work great with exporting data straight from an Interface UI. Now, if you add ?show_wait_page=true to the end of your URL and select “Open in new tab”, your download will work like shown in the GIF.This is great for User experience if your download takes slightly longer.Find out about handy URL parameters here. 

The way airtable works with base titles is by default it will take the first few letters of your title and use this as the base icon if you haven't selected one of their native icons. In this case it will use the emoji instead if it is the first item in the title.How to do this?1. Go to the "Base Title"2. Go to the beginning of the title3. On Windows: Press Window Key + Full Stop (Win+.) to open the emoji menu.On Mac: crtl+cmd+space4. Type the first few letter of the emoji you want to find.5. Click the emoji to add it to the front of the base title.

Hello there,Recently a client approach me to build a solution that would help to reply to customer emails. The idea was to utilize the internal knowledge they had from past customer questions as well as general product knowledge specific to his business.His idea was to use https://www.pinecone.io/  as the vector database storing the embeddings for internal knowledge base. I have recently built a proof of project like that, but using a full on code approach. I have used Supabase Postgress with pg-vector extension and some custom parsing tools to text/markdown sources.Overall approach above while feasible and fun, involved a lot of code meaning the budget for implementation was also way above what my customer was able to pay. 3 weeks OpenAI releases Assistants API with data retrieval and all of sudden all complexity of dealing with embeddings is just gone.- Use Airtable to setup FAQ and all relevant internal data store- Use Make.com to load data from Airtable as a markdown

Hi Guys, Was frustrated with the lack of integration that is there currently with Airtable to Wix databases for a client. So made a solution which can be tested and checked out. I’ve used the integration features provided by Integromat, but there are certain “rules” to be followed for the integration to work. They’re all listed on the page and airtable sheet given. Let me know if the solution works for you all.

Hello! This tool will allow you to ask a question about any base and will generate results (using AI) and display them on a nice little graph.To use it simply sign up, and connect airtable with a personalAccessToken. I'm the founder so if you have any questions or comments, let me know here or at adam@getmagicdashai.com 🙂Here's a demo:https://www.youtube.com/watch?v=7JOVME3BQd8&ab_channel=AdamGuskyProduct: https://getmagicdashai.com 

hi thereI am relatively new to Airtable. So far I used one base, basically like a spreadsheet. So I started a class. However my starting screen looks nothing like this. I cannot add a base, only create one. Then Airtable jumps straight into the base. It never shows the different steps as suggested by the Start from Scratch wizard. Could someone please adviseRafael  

Hi,I am looking for a way to customize to local language names of months and weekdays in Timeline view, located on the top of the graph. This is also applicable for names of buttons used to pick the time slot of visible part of the timeline. As database designer I am using English as preferable language in the setting of my account but users of Interfaces should see calendar's names in local language. 

Hi! How can I delete all my empty rows at once?I mean I have 8,200 rows but half of them are empty (due to my import format). I don't want to click manually to each of the 4,100 empty rows and click to delete.Do you have a trick to do it faster? With automatisation ? Don't want to use a filter, I really want to remove it. Thanks in advance. 

Hi here’s a workflow I’ve been using for quickly exporting out an airtable base’s table into google spreadsheet. There’s a number of reasons why you would want to do this: You have a file that needs to be analyzed by someone for a one time use. This could be your accountant, purchasing dept, etc. You need a better printout of your airtable data. Airtables printouts right now are okay, I have issues getting a nice printout sometimes. Google spreadsheets has lots of flexibility here You want someone to do data entry for your base but would rather have them enter the data, send it back, so you can double check it before throwing it into your airtable base You want your cells to do anything for a few niche cases - Airtable is great in that it doesn’t allow you to do certain things… but sometimes you might want to have a specialized formula pasted randomly throughout your google spreadsheet. You’d rather not use excel for a number of reasons, possibly because it doesn’t fit your use-c

Hi all, We discovered Airtable as awesome organizational database tool and started to use it extensively. We loved it for the way it’s organized and well-thought. But what we really missed there is “Google Sheets magic”: Being able to do advanced calculations Data blending Filtering Allowing someone to use data from Airtable without even knowing Airtable exists With that in mind, we developed an Google Spreadsheets add-on as a missing link between Airtable and Google Spreadsheets. We made it to solve particular issues within our company and for internal use only. But we thought that this add-on can help other people to make their lives better by combining powers of two great database tools: Airtable and Google Spreadsheets we shared it with other people. So anyone is welcome to give it a try. Webpage: http://railsware.com/case-studies/airtable-importer/ Download: https://chrome.google.com/webstore/detail/airtable-importer-by-rail/kngidnifbonbaembhpnjlpeefhmjpegb Thanks.

Add packing slip tables and automation and integrate with Fillout forms to obtain signatures from shipping and receiving.https://youtu.be/r0uTQ4fg7EE

The question is if it is possible to access to airtable base thorugh powershell module.Thank you

Switched from Twilio to a new platform(Whippy) and it has never been better! We had issues sending mass messages to people but not able to see their Reponses! Received a call from a new texting platform that help us integrate their software with Airtable and we have never looked back. Their extension is in the marketplace and they are a great team to work with.  https://airtable.com/marketplace/blkvsUTFN9QtWcOvm/whippy-ai  

Here is a blogpost I wrote. It shows how, on a schedule, I backup my Airtable data by both exporting to Google sheets, and to my local Mac for offline use.Check it out and let me know what you think: https://airtableexport.com/export-data-from-airtable/

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