Builders Board

I took a bit of a break from a custom PIM mvp that I’m building for work to make a personal photo album for my girlfriend and myself to collaborate on together. I don’t use any social media, so this is a good bridge between the gap of trying to show someone more than just a photo, and refusing to suffer the noise that comes from an endless scroll app. Plus, my girlfriend and I are both kind of big nerds, and she absolutely loves that I built something like this for us that she can show off to her girlfriends from her phone :slightly_smiling_face:

Hello everyone! I created a 2-way Google Calendar realtime sync Airtable app for myself and thought that this might be helpful for others as well. Let me know if you would be interested in using it - happy to share.

Hello there, We are looking to build a custom app, and we need help, a developer who could do that for us? We collect medical responses from patients online. They simply answer questions and upload images. We store everything in Airtable. It has many columns 100+, some are empty because Airtable shows all columns, but clients get only specific ones, based on their problem. So there are both empty and non-empty columns. We simply need a nice preview of data in iframe. To see only fields with values (Empty fields would not be displayed in iframe preview) V1 We want to click on a record and see a full preview of that record in the iframe on the right (or this can be a button in a column or simply a click on a record, e.g. like URL preview app) It must show values for one record only (the selected record, you could scroll vertically to view all the data of that record) Display field names as new line, with a bold fond (Showing only columns and fields which are non-empty) Display fields v

Looking for a consultant to build out : Dashboard that presents strategic Partnerships with columns such as : Priority, Customer Count, Investment amount, estimated revenue, order count. Need to add Stages: Prospecting, Discovery, Negotiation, Agreement Signed, Onboarding Partner, Closed Won, Nurturing, Closed Lost. For Each partner, I need list sub partners under the parent partner. Need opportunity dashboard and for it to link to the areas in the first dashboard presenting the strategic partners. Need the ability to integrate to salesforce and Partnerstack. Lets have a call and discuss. Should be a fairly quick project for you all, I just dont have the time to build out.

I would like to see added a new condition that would allow an automation to stop at a certain point if conditions are met. Currently, I feel like I need to create a script to do that. Unless there is another method that I don’t see?

When an automation kicks in and creates records in a linked table, it seems as if the linked records in the interface doesn’t get refreshed. Am I the only one seeing this happen?

Hi, tried to script “show size of all attachments in all base”, and after debugging with “check null”, “check empty array”…“check array of nulls” still get unexpected result. Investigation discovered rare bug ( I checked several huge tables with tens thousands of attachments, and that’s just in one record) I suppose it’s an interupted upload result, but I surprised it exists there. Can’t be downloaded, guided to other storage. Link is not working. No problem, just to inform. I discovered that script is useless. Airtable detects similar docs and store once, with linking the same. Btw, it’s an answer to @itoldusoandso post https://community.airtable.com/t/if-same-attached-document-image-in-two-tables-within-the-base-does-it-double-the-size-of-the-base/33770?u=alexey_gusev I’m gonna to rewrite my script using Map data type, with url as key, so it will display correct total size. Sadly, it can’t use recursion used in “sum” function In case someone interested, i can put the source here.

You no longer need to understand APIs to use the Data Fetcher app! Simply choose the application you want to import data from and select any options. You can install the latest Data Fetcher here. The following applications are available: Facebook Ads Google Analytics Google Search Console Webflow Adalo Binance Coingecko CoinMarketCap Alpha Vantage Clearbit Microlink (create screenshots, PDFs from URLs) ApiFlash (create screenshots from URLs) exchangerate.host Lots more applications will be added over the next few weeks. You can also request an application.

hey everyone! wanted to share a resource we put together. if anyone here’s thinking about using Airtable as a CMS - here’s how we did it. lmk if you have any questions! :slightly_smiling_face: https://www.whalesync.com/blog/using-airtable-as-a-cms

Does anyone have a super automated process for turning the data in a record into a formatted, multi-page document and then attaching it to the record? Using a button field in the flow would be fine, but I don’t want a new tab created. I don’t mind using Integromat, but want to avoid Google drive modules if possible.

Setting default values on fields has been a long-time request from Airtable users. Set defaults on fields Product Suggestions Simply the ability to set a default on fields other than numeric On a date, the obvious is Today On a string, just set a default value What are default values in fields? When you create new records (or update existing ones), you probably have multiple fields that need to have the same data every time. Default values allow you to add information to your field only 1 time. Then, each time a new record is created, that field automatically fills in with the data. You don’t have to go in and complete every single field that needs information. It’s done for you! :star: We created an easy way to set default values in your Airtable records with On2Air Amplify Here’s how: P.S. Amplify can also set defaults on previously created records! :star: Try it out by adding it to your Airtable base from the marketplace: A

Hello, fellow Airtablers! My company needs a solution for our product and inventory management problems, and we would like to hire one of your bright minds to help make it happen! We are a specialty manufacturer that uses hundreds of individual pieces, parts, and ingredients in the wide range of products we produce. We offer both regular, pre-defined products and custom products to meet customer needs. Many of these products utilize sub-assemblies that are also used in other products. We have some thoughts on how to make something work, but are limited in time and know that one of you will have far more knowledge about Airtable to help us build a solution that works for us now, as well as in the future. Hopeful one of you has the depth of knowledge in Airtable and the breadth of experience in consulting and developing to provide creative solutions to this problem and countless others we haven’t uncovered yet. Thanks! Chris

Hello,I am looking to hire an expert that can help my commercial real estate firm. Below are the notes and scope: I would like to have tables for deal flow of property information, where specific data sets about properties are collected. When the specified data sets are met, they trigger a new record, “transaction/deal” within another table. I would like to have a global view of all transactions and data sets via a dashboard if possible. This would include deals, progress, address, picture of the property via google (if possible). Client facing table that would share only limited data. This would be essentially client investor updates. Table 3: transaction/deal table. This would hold the larger data sets, where it would be toggled by view. I would like to have the ability to follow up with brokers/points of contact via a button, for more “on demand” follow up. Follow Ups: I would like follow-ups to be something I can click a button and follow up with the point-of-contact with either S

So I’m a little bit “paranoid” and I wanted to backup my Airtable data into Google sheets, because… you never know :slightly_smiling_face: . I used Google Script Apps for this. The script allows you to define one or more tables and views to import along with possible attachments. The script is uploaded on GitHub: GitHub - robiningelbrecht/airtable-google-sheets-backup: This script allows you to backup your Airtable data to Google sheets.

Hi community, I have a table and I want to do the following: Allow users to visit a website and Search the table for an item an Choose to either view reviews or Post their own 1 to 5 star review and Sign up for alerts Any ideas? I’m new to Airtable but I think the design could be multipurpose. Thanks in advance

Interfaces is an amazing Airtable feature! But, you’ve probably run into some limitations with permissions or other limitations. With On2Air Forms, you can build and share interactive forms, dashboards, and pages for your company to update or create Airtable data instantly. Get started free - https://on2air.com/forms/   On2Air Forms Features:Update existing Airtable recordsCreate new Airtable recordsCreate linked recordsEdit linked recordsView linked recordsDisplay data from your basePre-populate form fields with dataAdd SubForms inside of your form to update multiple tables and linked records from 1 formAllow editing and viewing of data even if not a User on your Airtable account (no need to purchase more Users)Create custom Dashboard/Portal pages for clients and your team with unique URLs (Login Options on long-term roadmap)Use basic and dynamic filters to limit record viewedUse URL prefills to display specific recordsAdd default values to fields per userDisplay, Hide,

Hi everyone, I have asked support for some guidance, perhaps some examples or white papers on how to deal with Purchase Orders, but so far, no response. So in the meantime, I am hoping to get information from the community. Besides of having couple (or more tables) to store the Purchase Orders and its PO Lines, I need to create the Input form to enter a PO and of course, a print out. I have played with Forms, but I don’t see how to display the master-slave tables so the user can enter as many items as they want. Is this possible in Airtable or does it need to done outside of the environment? Thanks in advance. Robert

Hello, An interesting use case for Airtable can be curating data for others and selling access to it. Curating data can save time for someone, and it might be valuable if the data serves a business goal such as lead generation. There are untapped niches in every kind of data that are still good ideas to pursue, if you make it focused on a specific audience. Airtable makes it very easy to curate and update such data with bases and views. An example to the above is this one, built with Airtable, and made specifically for agencies to find new clients. We’re not affiliated but found this to be a great example to the thesis. If you don’t have coding skills or access to developers, we’ve added a nocode embed capability to our tool SaaSBox, to launch such a curated data service as the above. Airtable does have some limitations for protecting data through a paywall, such that when you share an Airtable base, all the data in it are accessible. We solved this problem by creating views with diffe

Hey all :wave: , we’re really thrilled to be able to share this with you - we’ve just raised our 1st funding round at Codemap! We want to say a huge THANK YOU to the Airtable community for all the support over the past year since our launch - what a journey this has been! Our story so far is just another proof of how game-changing no-code is - keep on building! :raised_hands: With 2021 soon coming to an end, we also wanted to share a helpful resource and a showcase of what our community on Codemap has been working on over the past year and beyond - last week we released the largest curated database of 800+ no-code projects built by experts & teams on Codemap. The builds are categorized by types, stacks, and many more others key parameters, so you can discover what others are building with Airtable and how! Check out the showcase here to get ideas for your current or next build! Don’t hesitate to share any thoughts or feedback with us. Wishing everyone a great remainder of the y

Hello! I’m looking for some help with a simple script I’m trying to edit. Thank you! Diane

Hey Airtable community :wave: It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :new: Improved Airtable Formatting We are always keeping a close eye on any new updates to Airtable’s API to bring Softr customers the best experience. Thankfully Airtable recently provided a number of formatting improvements so we jumped at the opportunity to bring you these changes asap. These improvements include: • Improved date and time formatting • Support for currency symbols and decimal places • Display of linked records without the need for lookup fields :page_facing_up: Reorder Pages Previously when adding new pages we stacked them in alphabetical order. However, over time, with larger applications, organising and navigating to your pages in the studio could become cumbersome. Starting from today you can now reorder your pages. It’s the small things in life that make a difference and this is no exception Simply gr

Hi there! We would like to show a Page Designer clone called Cumulo Docs. It’s awesome but we are biased. Here are the main features: :smiling_face_with_sunglasses: Drag and Drop editor for creating stunning layouts for your Airtable data :sparkles: Multiple Records supported in a single page :books: Multiple Pages supported too :confetti_ball: API support for PDF Creation :zap: Works with Free Airtable accounts also (because Cumulo Docs uses your API key) It’s available at https://www.cumulodocs.com Here’s a screenshot of an Invoice created by CumuloDocs: Prefer a video? Here’s a short video (~5 mins) where I create the same invoice from scratch. https://www.youtube.com/watch?v=ZeJR9n3JW0M Do check it out and leave us know your comments and feature requests. Cheers!

Hi, I’m an entrepreneur for a growing small business in freight logistics (around $6M in annual revenue) and looking for help implementing airtable in my business. Are there any consultants that work with smaller budgets and businesses that don’t fully have an idea of everything they want set up yet and may need ongoing support?

Hi, I am looking to hire someone who could help me build a few tables for my venture capital firm. I’d also like the person to explain the tables they built, how they built them, etc… so I can have a better understanding of building more advanced tables in Airtable. Here’s what I’m looking to have built: I’d like to have a table that is basically a fully detailed overview of our venture portfolio. This would include, all deals we have invested in, their values, investment amount, estimated fair value, current raised value, logo, contact, blurb about what they do, website, investment date, sector, sub sector etc… Our second table would be a “public” facing table that would have some of the info form table one, but the details would be more limited and anything private wouldn’t go here. this table would be sent out to investors in our updates, or allows investors to check on the portfolio whenever they wanted to see new additions. This table would be more complex, or at least I’d t

Hi all, As I’ve noticed on the community forum it’s a common issue so I decided to share with you our solution on “ How to add a card to a filtered Kanban view for staff member ”. We use Airtable as a project management tool that consolidates financial and operational data. It means we work project based and one or more people work on a project. For planning our work we use Kanban views to followup tasks. For management and time-tracking reasons we want to bundle all tasks from all staff in one database. This results in a filtered Kanban view per staff member. Unfortunately, when you simply filter on a staff member (linked to another table) and try to add a card to the Kanban view, the card will disappear because the staff member is not automagically linked to the card when you add it. Solution Instead of filtering on a linked value, filter on a “Created by” field. Because this is an automated field, the card will remain visible in the filtered Kanban view. Hope this helps! Any feedb