Builders Board

Hello! My company is looking for someone who knows their way around Airtable to help us redesign our workflow and show us the tools we should be using for our purposes. We pretty much just use it as Data Entry now, but we know Airtable is far more powerful than how we are currently using it. I can set up a time to show anyone how it operates now, please just comment or email me. Kyle@bottlecapps.com Cheers!

You may be in a situation where you have a dataset with a lot of numbers, and you can’t find any meaning in it. (It’s me. I’m in this situation :raising_hand_woman:t5: ) If I could only break those numbers up into smaller groups, maybe I’d be able to better digest and distill some meaning. As a first start, I figured why not group these numbers into a nice set of four quartiles: Low, Below Median, Above Median, and High. That way I can use Airtable’s grouping to get a better sense of what I’m dealing with. I’ll preface by saying that I majored in English and I do not stand behind any mathematical concepts I’m using. If they’re wrong, call me out, I seriously don’t know better. Until recently, the only way you could run calculations on the content of an entire field was through rollups, which was pretty inconvenient and took some mental gymnastics to understand. But, with the scripting block you can do this analysis pretty neatly. I found this

Hi @Jordan_Scott1 & @Rose_K , Some links from the Forum that deserve a little UP because they don’t seem to be often quoted neither by the Askers, nor by some Helpers: Airtable Team : To maintain (in my opinion) because they are sometimes gold mines of finds, quickly found in case of need! Featured Resources One of the best initiatives of AIRTABLE’s Communicants, not to be overshadowed by numerous subjects covered since! Airtable: The Featured Resources category contains collections of resources created by both Community users and Airtable to; answer common ques

Hi there, I usually see people asking “how to share view with edit access” or “how can i share some part of my Airtable base”. Well, long story short, i had the same need for my business so i built a tool internally to solve that. I sync part of my base to clients, let them edit some fields and sync the data back to the master base. I think it’s cool tool and many users would like it, so i’m sharing it here. It’s still in beta, with a small price ( side project ), so if you would like to try it out, write me a message on the chat. Syncing bases with client and partners has been a game changer and i’m now moving almost everything to Airtable. Cheers

Looking to hire an Airtable consultant that understands political campaigning, government, and fundraising.

I chose Airtable as one of my Top Productivity Tools for 2022. Please share if appropriate. Thank you for making such a great tool that is a big part of my success.

In this thread I demoed an API for exporting your base in CSV format. The main issue is that it requires credentials to be passed as visual parameters in the URL. I’ve overcome this by making a new endpoint which accepts a POST request to store the sensitive information securely. A successful POST request will return a link for downloading your base as CSV which does not show any keys in plain sight. This link will only need to be generated once and will always show the latest data of the chosen table when used. It will be great for analysis, scheduled backups, or sharing a specific table with a client who wants access to live data by CSV. Post requests can be done in terminal like so: curl -X POST -F 'base=your_base_id' -F 'apik=your_api_key' -F 'table=your_table_name_or_id' -F 'view=your_view_name_or_id' 'https://csv-getter-for-airtable.ew.r.appspot.com/v2/

Hi everyone. I have built out an endpoint for exporting base to CSV. Documentation can be found here Here is the api. https://csv-getter-for-airtable.ew.r.appspot.com/all-csv?bid=<your_base_id>&apik=<your_api_key>&tname=<your_table_name>&vname=<your_view_name> With the correct parameters it will give the latest version of your base as CSV and will be useful in python scripts etc. Any issues getting it working please check out the docs or reach out. Additionally, any questions or concerns about how keys or data is handled that are not addressed in the docs - i’ll be happy to answer :slightly_smiling_face:

I have done a big update on my app for exporting bases as CSVs via API. You can now visit this website in your browser to easily make secure CSV endpoints for your data. Demo:

Just wanted to share this I just found out about it. Didn’t know about it. There are buttons and menus to create new records but didn’t know there are keyboard shortcuts which quickly made the favorite way to add new records. In particular if you are on the top of the table, there is no new record button (as it is on the bottom) and you had to use the right click menu (too many steps). So this is nice time-saver. To add multiple records quickly, you can use the keyboard shortcut Shift + Enter. Start by clicking the primary field above the place where you want to insert new records. Then, press and hold Shift and then press Enter (holding Enter if you want to quickly add multiple new records).

2021 was a transformational year for Softr. So, we wanted to look back at 2021 and highlight some of the new features and capabilities we made available through our users’ feedback, suggestions and requests. :fire: Softr Got Easier To Use - much easier to build apps with our redesigned studio :boom: Softr Got More Powerful - launched Softr 2.0 and made it one of the most powerful no-code platforms in the market :rocket: Softr Has Evolved - incorporated 27 new templates across different categories and evolved from a simple app building tool to a powerful no-code platform :heart: Community Initiatives - numerous community initiated launched by us and our users Find the complete review here: Softr 2021 Year in Review 🎉

Hello, I’m trying to configure airtable to help with a freelancer identification tool. I’d like someone to submit a need for a freelancer in one form and specify the role they are searching for and job description. I’d then like that role name and job description to appear in a drop down list in a DIFFERENT form where freelancers can apply for the specific role. I’d then be able to match the records easily on the backend (match demand with supply) without doing it manually. The problem is that it’s near impossible to link a record from a submitted form of an applicant to a new project that was submitted by a client. The issue is that we can’t automatically tag one to the other. So to reiterate Is there anyway to link a client form submission to an “open role” field in the applicant form?

Hi all, Had a bit of inspiration from this cool script shared by @Jeremy_Oglesby. My goal was to have an easy solution to categorize the transactions imported from all of my accounts/financial institutions. Here’s the scenario: There will be some frequently occurring transactions like Uber or your preferred supermarket that should have been categorised accordingly so the remaining ones can be categorised manually. Some personal finance apps might do it for you but I always find them lacking in some other areas hence I always built my own solution - previously in spreadsheets and now Airtable. This was surprisingly easy to achieve with a small modification of the script. Here’s how it works. The first table contains all the transact

At the suggestion of the Airtable support team, I am sharing this webinar recording. This is a recording from our “Amazing Things You Can Do With Airtable and PowerPoint” webinar where we explored using Airtable and PowerPoint for real-time dashboards, event promotion, reporting, and more. Happy to answer any questions about our approach and the plugin we used to connect Airtable and PowerPoint in real-time, DataPoint.

We went in-depth on how to turn Airtable into a content marketing pipeline with Hannah Wiginton of On2Air. Hope it’s helpful! whalesync.com

Hey Airtable community, This week we are delighted to introduce our newest block - Maps :world_map: . Simply create a table in Airtable containing latitude and longitude coordinates and connect to Softr and the new map block will allow you to plot your locations in a matter of seconds on an interactive map. We added a number of additional custom options, including: :round_pushpin: Map default views, inc; Roadmap, Hybrid, Terrain and Satellite. :round_pushpin: Define default zoom window :round_pushpin: Customise pin colour :round_pushpin: Add pin details inc title, image and url :pen: Edit Linked Records Starting from today you can now edit linked records from directly within Softr. 🧑‍🏫 Live Workshop | Creating No-Code Apps with Softr & Airtable We would also love to invite you to a live workshop next week (29th September at 5pm CET)’. The webinar will outline the steps to building your own c

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 o

If you’re creating/developing/managing bases for a certain client. Do you create a new workspace for your client under your account and just bill them monthly or do you just help them by accessing their account’s workspace? Thanks.

On Monday I’m launching an Airtable newsletter called Base Notes, where I’ll be sharing Airtable tips, news, and other info every week! Subscribe here if you’re interested: Airtable

Admittedly, an edge case, but in working with the Airpress WordPress-to-Airtable API and plugin, I ran into problems when attempting to display only the first image from an attachment field. After hours spent stepping my way through the plugin, I finally discovered I’d been debugging the wrong module entirely. Discouraged, I took a break, fed the cat, got another cup of coffee – and then wondered if I might not be able to goose Airtable into giving me the data directly. Five minutes later, I had it. The example assumes an Attachment field named ‘images’, but should work with attachments of any type. To extract the URL MID(images,FIND("(",images)+1,(FIND(")",images)-1)-(FIND("(",images))) To extract the file name LEFT(images,FIND(" ",images)-1) This works because Airtable will cast an Attachment field to a comma-delimited string of values when it is acted upon by a text functi

Hello, I’m looking for someone to help set up our nonprofit’s Airtable. We are a nonprofit serving a local homeless population of about 40-60 people. We provide resources and employment for these clients who are experiencing homelessness. We have two employment programs, and need to track payroll based on participant and program worked, and then need to pull data such as how many times has X participant worked X program, gross pay, etc. Additionally, we need a case notes section that will allow us to update case notes per person, and track data points such as referrals, location, housing status, etc. Please contact me at lexi@abundantgracecw.org or reply to my thread here. Thank you! :slightly_smiling_face:

Hey Everyone, We have a lot of exciting updates on Softr we’d like to share with you. See below :point_down: :robot: Zapier & Integromat Apps Softr is now officially available to use on both Zapier and Integromat, unlocking an infinite amount of possibilities with your Softr application. Check out our Zapier and Integromat use cases for more details. :bird: Dynamic Twitter List Block We’ve upgraded our Twitter block to allow you to display a collection of tweets via your Airtable base. You can also add categories or tags in a separate column, so that users are able to filter the list. :construction_worker_man: Table Block Improvements

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