Builders Board

Hi Community!We have the employee information on our Airtable.Also, we have some forms that they can submit, for example leave requests or overtime requests.It would be nice that they can see their own records they submitted in the past but it would be anooying to create one interface for each employee.Using the thrid party like Stacker might be the best option but we are wondering if there is any best way that they can see their responses for just their own somehow.We have different bases for Emplyee information and Leave request form/record but they are connected. Thank you,

Hi! We got great feedback from the community a few months ago and decided to go all-in on Airtable. Your can sign up for free, here: https://fillout.com/airtable/Fillout may be for you if want a) modern forms that match your brand  b) a form builder made specifically for Airtable c) advanced functionalityExamples of what you can do with Fillout + Airtable:🔗 Pick linked records (with filters based on form responses)Make multi-page forms (with conditional branching)Update records via a form📩 Make forms with email/phone loginSync single/multi select options from AirtablePre-fill fields

The following video shows you what you can unlock with Airtable and CSV Getter in less than 2 minutes.Check it out!https://www.youtube.com/watch?v=f4AREB8Bcak

I recently came across Airtable. So, I decided to create a tutorial on how to Integrate the Airtable API in an Angular application. I hope this is helpful to anyone trying to utilize the API within an application. Here is the link to the video on how I put everything together to create an Email verification application.

We would appreciate help with this scenario - and we can pay if somebody can help us with it. We have several bases where we have e.g customer info. Sometimes we do a campaign where we send out a link to a form where we want the customer to get back to us with specific info. This works excellently. The design is basically Table #1 Customers Primary key Custom info #1 Custom info #2 Link to CustomerResponses Table #2 CustomerResponses Primary key Link to Customers Custom info #3 Form in Table #2 Link to customers (=shows the +Add button and all customers according to Primary Key) Custom info #3

Hey all,While testing the OpenAI API and looking for use-cases with Airtable I put together this demo which creates a book summary AI for the items in your Amazon wishlist. What it does: - Imports your Amazon wishlist into Airtable (focus is on books for now) via Simplescraper- Summarizes, tags, categorizes and provides quotes for each book using OpenAICombined with an Airtable Interface it's a neat way to 'free' the items from your Amazon wishlist and make them a lot more searchable and organized. For example it's impossible to search for books by tag in Amazon, now it's easy.Here's the full guide and script:  

Update (2022-02-11): The stylesheet is now designed to be used “out of the box” to restore the look of the original expanded record view. (Unfortunately, I’m working off my memory of what it looked like so it may not be an exact replica.) Here’s what it looks like by default: Or, if you prefer the new expanded record view design, you can select the “Current” preset and make some tweaks (below: column layout, zebra stripes, type-based field coloring, compact linked record view, expanded whitespace, variable field width): The code for the expanded record view has been completely overhauled. Due to the number of tweaks, instead of grouping

Good day community,Is it just me or I can't seem to load my Airtable bases? Thank you

Hi all!This has come up in a couple recent threads (and I was PMed on the topic) and I thought writing a summary collating all the information on this topic might be useful for future users.You (yes, you!) can automatically format Airtable data into shareable and saveable .ics files. This isn't sharing a whole calendar, but rather discrete events. It requires a fairly straightforward Make.com automation, a bit of text file editing, and a file hosting platform integrated with Make (I know Google Drive and Dropbox work). Here's the overall Make layoutTo start with you need to understand that a .ics file is just a plain text file formatted in a machine readable way. This blog post

I FOUND SOMEONE - JOB IS CLOSED, THANKS!----I want to create a front end as airtable inteface. The only problem with the airtable interface is we can't share to external people and we have to pay per user.I tried using softr but it doesn't have same look and feel (maybe I don't know how to use it)

Hi you, 💚I had a question - why do Airtable bases need to be this visually unappealing? I know Airtable is loved for its functionality first, but I felt I could so something about it. So I launched Icons just to make it a bit more pretty: https://airtable.com/marketplace/blkQR3ZxqdeVppXgL/icons-silver-tazaThere was a challenge in working around Airtable limitations, but I think I did an OK job navigating these, and ended up with something actually usable. I hope people find it valuable so I can continue adding more icons & visuals.

I had a need to develop various types of Airtable to Google Cloud Firestore syncs. Still need to create more types and fix some issues, but I figured I'd share what I have so far with the community. It's easy to use and works just as advertised for me.https://github.com/antquinonez/Airtable-Firestore-SyncFULL_REFRESH: Deletes all existing data in the Firestore collection and replaces it with the current Airtable data.REPLACE: For each record in Airtable, deletes any existing records with the same primary key in Firestore and inserts the new record.UPSERT_CHECKSUM: Compares each Airtable record with existing Firestore records using a checksum. Updates Firestore if there are changes, or inserts if the record is new.UPSERT_CHECKSUM_WITH_DELETE: Similar to UPSERT_CHECKSUM, but also deletes Firestore records that no longer exist in Airtable.

Hello, dear community. I hope you can help me solve this issue I need to address:I have a table with a list of students and another table with a list of tasks, each with a corresponding status column. I need to create a task list where each student can update the status of each task.The status should not be mixed with the statuses of other students, but rather each student should be able to mark their own status for each task.

Hello Airtable Community Moderators,@MaddieJ, @leah_ackerman @selenawang , @Evan_Purcell @Rosalind_Lutsky ,Recently, we've seen an increase in spam posts across various categories. These posts often disguise themselves as responses to genuine questions or issues, making it challenging for users seeking real help to find the needed information.I want to acknowledge the fantastic work the moderators do to remove these posts promptly. However, this situation can sometimes overshadow genuine queries, causing delays in responses and creating unnecessary doubts among users.To help combat this issue, I suggest implementing additional verifica

Hey everyone!Excited to announce the launch of our newest connector at Whalesync, Copper!Copper is the latest in our collection of deep, two-way sync CRM connectors following Salesforce, HubSpot, Affinity, and Close.You can now 2-way sync People, Opportunities, Companies, and more from Copper with tools like Airtable, Notion, and Postgres.Supported objectsFor the list of Copper objects we support for two-way sync, check out our docs. https://docs.whalesync.com/connectors/copperGet started with a free template packCheck o

Rather long manual formula, but it does the job.I've got a series of fields that output the day of week in number format, like this: VALUE(DATETIME_FORMAT(DATETIME_PARSE(Month_billed_for & 1, "MMMM YYYYD"), "d"))VALUE(DATETIME_FORMAT(DATETIME_PARSE(Month_billed_for & 2, "MMMM YYYYD"), "d")) Then I sum them the fields that are not fridays or saturdays.SUM( 

Help! I cancelled my account last year, yet an huge amount of money has been taken from my account. I can't afford this and don't seem to be able to contact anyone about it. I don't know what to do! I am very stressed. 

Looking for a developer to help with one task - create a new records from a text using only 2-3 fields on information (date/name/customer). If this is possible please comment!  

Hello, we are Two Bit Circus Foundation, a small education nonprofit which teaches STEM skills to underserved students and also trains teachers in hands-on learning techniques. We are looking for a **bleep** integration for our quotes and POs and also to optimize some bases we initially built years ago and have gotten kind of messy, plus don't take advantage of features like sync between bases that could really help us.We are hoping for someone who can offer a nonprofit discount or otherwise help us fit this into our budget.Thank you,Mya StarkDirector of Community LearningTwo Bit Circus Foundation

I've built powersave to be able to add records to Airtable as quickly as possible. That meant creating a browser extension that lets me pick the right table quickly and perhaps extract data from a website I'm currently visiting.But if the table does not exist yet, it's a blocker and that's why the new version of powersave addresses this.1) AI analyzes the website (or relies on custom instructions) and offers a table structure2) You can make additional manual adjustments3) Table is created in your base4) Now you can add a new record to that tableAll thanks to the amazing Airtable API.Quick demo:

Hi everyone!I'm relatively new to Airtable and currently working on a final project for a company I used to work for. I introduced them to Airtable, but they want to keep the overall cost under $35 per month.For the project, I'm trying to create a Timeline View where the first column displays all the apartments from the "Apartments" table, and the other columns represent dates. Additionally, I would like to have a list of bookings on the right-hand side that only shows bookings which haven't been fully assigned yet (those with a "Beds Remaining to Assign" field greater than zero). My goal is to be able to drag and drop these unassigned bookings onto the timeline, matching them to the appropriate apartment.I'm hoping someone in the community might be able to guide me through building this or point me in the right direction. I’m happy to pay for assistance in getting this setup right!Any advice or help would be greatly appr

Hey all! As much as I love Airtable it frustrates me how limited the styling options you have with the embed/share links.I've built a little tool to customize and embed Airtable data on any website. I'd love to get some feedback to see if this tool is useful or not.How it worksChoose one of the provided templates that you can plug your Airtable data into.Use the editor to customize the template to fit your needs.When you're ready, install the iframe into your websiteYou can try it here www.shareables.aiAll feedback appreciated!

Hello everyone,I’m encountering a frustrating issue with Airtable on my company’s PCs, and I’m hoping someone here can help me diagnose it.Account & Plan: I'm using the same Airtable Pro account across all devices.PC 1 (Main): On my main PC, which runs Windows 11, I can upload files to Airtable without any issues. This includes all accepted file formats ranging from a few kilobytes to over 10MB.PC 2 & 3 (Company PCs): However, on two other company PCs running Windows 10, I'm experiencing constant upload errors. These PCs have Microsoft Defender turned off and no antivirus installed.Tried Solutions:I’ve tried using both the standalone Airtable app and various web browsers, but the error persists across all attempts.I’ve cleared the browser cache and checked for any Chrome extensions that might interfere, but found nothing unusual.

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(",",