Builders Board

when adding a new record manually, I can hit enter as many times as I want to add new lines in a text field. if i go back and edit that text field, I cannot add new lines. Ctrl-Enter, Alt-Enter, Sh-enter all fail to add a new line and just complete the edit. is there a secret or is this not supported?

I’ve had to do this quite a few times… my old solution was: Rollup with ARRAYUNIQUE(values) Remove any trailing ','s in another column Count the remaining commas, +1 Now I do it all inside the rollup with the following snippet: gist.github.com https://gist.github.com/RussellBishop/153d70be56ec5d8983439b6d9cf1279f airtable-count-unique-array-rollup IF((values), LEN( IF( FIND(",", ARRAYJOIN(ARRAYUNIQUE(values), ",")&"") = 1, SUBSTITUTE(ARRAYJOIN(ARRAYUNIQUE(values), ",")&"", ",", "", 1), IF( FIND(",",

Hey guys, how are you? Since I was looking for this and couldn’t find any solution to it… I decide to create a custom script that get the user score of a field and calculates the ranking position based on this score. I´ll try to explain how it works in detail below! You gotta have a field in your table that has the user score. Create an automation to run a script everytime this field gets update. On the script code, you should do as follows: // Get your Table let table = base.getTable("table_name"); // Get the score field of your table let queryScore = await table.selectRecordsAsync({"score_field"]}); // Save these records in a variable let records = queryScore.records; //Define an array of Records let rankItems = []; // Define the score variable let score //Set score variable as a number score = Number(score) //Set the initial position to 0 since its the first position of the array let position = 0

👋 Here's an Alfred workflow to open any base and table from anywhere. I've been using it for some time and I finally took the time to polish it a bit and publish to Github.Github | Demo 

Hi,We are a small business dealing with furniture and deal with multiple suppliers and customers, small and large projects.We are looking for an expert to set up an Airtable Base for our business.  We are already working on a CRM database (on Airtable) and have most of the data in terms of project workflow we want added to Airtable but want to ensure this is all set up/linked in the best way possible for our business.  We also use Xero for our accounting and Spark for our emails which will also need to be integrated if possible.I look forward to hearing from you.Angela

We've created this guide which showcases 3 ways of exporting Airtable to Google Sheets. We look at the classic manual method as well as more involved automations. Check it out below:https://www.csvgetter.com/blog/export-airtable-to-google-sheets 

List all fields in this table that are empty or contain errors.

A Quick guide to exporting Airtable to Excel in an easy and secure way. Great for backing up and analysing data.https://www.csvgetter.com/blog/export-airtable-to-excel

Can I hide a table view from the editors? I only want the creator to be able to view that table. Is it possible?How can i do it?Thank you!

Hello Airtable Community,I've set up a table with a significant amount of information and data. In a second table, I’m pulling in information from the first using linked records/LookUp. However, I’ve noticed that the same item is being repeated within the same record in this second table.Has anyone else encountered this issue? Any suggestions on how to prevent these duplicates and ensure that each item only appears once in a record would be greatly appreciated!Thanks in advance for your help!

hi, this seems to be a rather trivial matter but i haven't found anything in the community so i'd appreciate a hand immensely:i've got a list of sales records that includes among other things the revenue of a sale as well as a formula field that assigns a month-tag based on the date-field of the record. i'd now like to create a clean, automated list (in an interfaces or wherever) that shows the sum of all values in the field revenue from records tagged january in one line, february the next line and so on and so forth. i tried a workaround by creating a view in my interface that is grouped by month and hiding all irrelevant fields and collapsing all groups but it's still very bulky and i have to collapse every time. does anybody have an idea how i can go about this? i've attatched a photo of my current view and of how i'd like my list to be ideal

I have already entered the data for Plant Client 1 into Excel and imported it into Airtable. Now, I want to input new data for Plant Client 2 and Plant Client 3. How can I integrate all this data into a single database without overlapping the tables?

This is Hari from Goldstar group and I am the manager for operations team. We are a long term rental company in Thailand www.monthstayzthailand.comWe have been using Airtable extensively and are looking for digital marketers with no code experience. We are looking for someone who can help us in posting contents on our marketing channels - X, Telegram, **bleep**, Email marketing on a regular basis. If anybody is interested please send a mail with your resume to hari@monthstayzthailand.com

I have an interface publicly opened and I want to update it by filtering with the URL (this is doable with the shareable views).For example this interface :https://airtable.com/embed/appE1Q6NEEScM3NhW/shrznzikatF5FzmKW...becomes...https://airtable.com/embed/appE1Q6NEEScM3NhW/shrznzikatF5FzmKW?filterContains_variable=Xand it will only display the records matching the variable X?Is it possible (it is possible with shareable views).

Summary People sometimes ask whether it’s possible to use an Airtable form to edit an existing record. Technically the answer is “no” because Airtable forms always create new records. However, a base can be set up so that records created by a form end up affecting records in another “mirror" table. As with my first show-and-tell submission, this was inspired by a solution that I created in another thread. Long story short, the key to that solution was using two tables: one for collecting form data, and another that looks up that form data and fills out a parallel set of fields. Extending that to allow data from subsequent form-generated records to effectively replace older data in the “mirror” table only took a few more steps. Table Setup To build this system, the first table to make will be the [Data Entry]

I need an expert able to create a Work Environment to facilitate our office work flow.I need 1 database with the following characteristics:FUND REQUEST PLATFORMThis platform should have a form that allows:the entry of a descriptive partthe instantiation of the Budget with the calculation of the final sumThe beckend should give:the possibility of reviewing the request by a committeethe evaluation of each member of the committeethe final result if approved or rejected or otherthe possibility of Report for printing each request snola and by typethe possibility of exporting to excelI need to know your cost and timing.

Hi Airtable folk! I've been working on a tool to integrate Airtable data on popular site builders. I built this becuase so many times I was storing things like my FAQ's, chaneglogs and directories in Airtable but wanted a way to start integrating them into my site with a more custo looking view that matched my brand. It seems like most of the competitors out there are focussed on Internal tool & building apps & being quite complex large scale apps with a hefty pricing. So I set out around 8 months ago to build a cheaper, more light weight modular solution where the sole focus is to enable creating truly custom embed designs / views. Pricing is around 70% cheaper than other solutions starting at $10 per month for unlimited views and embeds.I'd love if any here had any thoughts?App is called https://basefront.app here are some snaps of a view of the te

Export your Airtable data to CSV, Excel, JSON and more using our handy tool CSV Getter.Our tool lets you create an Export URL which is great for automatically syncing Airtable with Excel, Google Sheets, Dropbox, and many, many more.This is perfect for backups and automatic analysis. Try our sandbox demo here:https://www.csvgetter.com/export-airtable

🔉✨Airtable PowerSave with AI support is released.The integration grabs the current page and instructs the AI to extract and categorize what you see into your Airtable table, no matter what your table structure is like.It works generally well for me although there's definitely space for improvement.One benefit of PowerSave is that you can freely save data to all of your bases and tables.I'm finding this genuinely useful myself and I'm learning to save more content than before: social media posts, learning resources, competitor / inspirational websites, contacts, businesses, customers...So far PowerSave is a product I like using and also building - so fingers crossed others will like it too so I can keep pus

Hey productivity enthusiasts!I'm excited to share some awesome news about the Airtable Web Clipper. We've just rolled out several new clip actions that are going to make your web clipping experience smoother than ever!One of the standout features is our new Twitter post clipping action. Now you can capture tweets and their details directly into your Airtable base with just a few taps. It's a game-changer for social media managers, researchers, and anyone who loves to collect and organize online content.But that's not all – we've got more clip actions up our sleeve, and we want to hear from you! If you have ideas for other web clipping actions that would make your life easier, please submit them through our form. Your input helps us create tools that tr

Hello Airtable Community,I'm in the process of transitioning from Google Sheets to Airtable to manage a dance school, with the aim of creating a more robust and streamlined system. I've successfully set up tables for students, classes, venues, staff, and periods (e.g., May 2024, June 2024). However, I'm encountering challenges with the attendance tracking system.In our previous system on Google Sheets, attendance was tracked in a simple and user-friendly matrix format as follows for each month:| May | 7/5 | 12/5 | 19/5 | 26/5 ||------|----|-----|-----|-----|| Student 1 | x | x | o | x || Student 2 | x | x | x | o || Student 3 | x | o | o | o |For each subsequent month, we would simply copy the layout and update the dates, which were calculated automatically. This format allowed for easy visual and editing access to atte

I have to share my AIRTABLE TO POWER BI THAT WAS SUCCESSFULL TOO BUT THE SOME OF THE DATA FIELDS SPECIALLY THE LINKED FIELD IS IN FORM OF LIST SO BECAUSE OF THAT I AM NOT ABLE TO CREATE MY POWER BI REPORTS . SO PLEASE HELP ME IN THIS

Schedules Example Base This is my first post to forum; hope I get the mechanics right. You may find this base handy if you need to schedule recurring events. I work for a community radio station and wanted to be able to offer users the ability to schedule our on-air broadcasts and various meetings as recurring events. I wanted to give users the same flexibility they have in Google Calendar and Outlook. I’ve encapsulated recurring date calculation logic in a single table: “Schedules”. I’ve seeded the table with example rows and the primary field’s default formula describes each row using the user-entered fields. The Schedules calendar view shows

Hi there! I am looking for someone to build a comprehensive airtable inventory that can track orders/ sales and product. We sell products at two different price points as part of a subscription and through an online store. Looking for someone who can help build the inventory system through using forms to input purchase orders/ and customer orders. If it can link to WIX stores that would be incredibly helpful. 

Hi, we're long-time users of Airtable, but we've found that the iOS application has a long loading time. To bridge that gap, we've created a Comprehensive Library of Airtable Siri Shortcuts.To give you a better idea of how these Airtable Siri Shortcuts can ease your mobile data management, we've created a short demonstration video. Watch the video below to see how easy it is to create records in a base using Siri and open a specific Airtable table using Siri. Create records in base using Siri– With just a voice command, you can directly create a new record in your Airtable base without even launching the Airtable app. This shortcut streamlines your workflow and saves valuable time. Open a specific Airtable table using Siri– Simply ask Siri to open a specific table in your Airtable base, and it will be done instantly. N