Builders Board

Hello, we run a mid-sized publishing company and we need help building out our AirTable for our company. We are looking to add all of our clients, processes, and systems into AirTable so we can have everything in one location.

Greetings. I’m seeking an Airtable consultant to assist with building out our workspace. I have the base created and would like to increase functionality by setting up the best apps/blocks. My email is katie@steinberginstitute.org.

This is either an awfully clever work-around for Airtable’s limitations on data lookup or an incredibly convoluted method to achieve something that can easily be managed within Airtable itself, had I not overlooked something basic. You tell me… On my current project, my main table tracks items currently within a collection. An item may currently be onsite or in one of several offsite conditions – for instance, on loan, on lease, gifted, sold, lost, out for cleaning, or out for repair. The total number of on- and offsite statuses is fewer than 10. An item may pass through any number of statuses, but it can only be in one status at a time. As I chewed my way through the base design, I quickly realized there was substantial overlap among data required to track offsite status: Who had the item, the date the item went offsite, the date it was due back (if applicable), the date it actually returned, and so on. I created an outRecord table to log each status change for an ite

I have a list of 15 functions/projects that I’ve scoped out as part of my vision to making Airtable do everything we need it to. I’d love to hire someone that can build each of these things in Q4… so that everything is ready to go for 2021. Ping me with your per hour or per project rates if you’re interested.

hi all- I have been in software and technology my whole career, but have hardly used Airtable at all. I understand data modeling, JavaScript, API’s, automation, etc. but I am smart enough to know what I don’t know - and I don’t want to invest time building out an Airtable app without someone watching out for best practices, shortcuts, and helping break through obstacles. I have a client who wants to hire me to build out their system in Airtable. It’s a fairly simple database that will just have a few primary tables/data-types, but there will be a ton of fields to deal with. Once complete, we want to expand the system to use webmerge to produce documentation based on the data. But, that comes next :slightly_smiling_face: For now, I would love to have someone who I can schedule a call with to: Look over my work and provide feedback help out if I get into a jam recommend approaches for getting things done in airtable

I am a Director at a Boston based ed-tech organization, and looking for an Airtable expert to help us build out our Sales CRM and social media Airtable bases. I’d also like to help my team better utilize Airtable and be able to ask specific questions. Most urgently, we need to be able to integrate APIs for Twitter, Facebook, IG, and MailChimp. As mentioned, we also need to develop our Sales CRM (currently using Less Annoying, and wanting to entirely shift to Airtable). Please e-mail me at gabrielle@writetheworld.com if this sounds like a project you can help with. We’d like to get this going by late September 2020 if possible. Thanks in advance.

Here is a demo of a script that I am working on. This script creates a new record and all associated linked records in other tables. Default values are set in a “template” record, not hard coded into the script “Smart” defaults can be calculated values, such as the current date New linked records are created, including multiple levels of links Changing the defaults or linked records requires no editing of code Multiple templates are possible

I’ve built out a base with most of the sections I think we need. I’d like to collaborate with a consultant to come in to finesse it a bit based on the architecture I’ve built out to accomplish our goals. This will include, at least: All Contributions, People, Foundations, Grants, Interactions and a couple other tables. I want to ensure I’ve set it up well, to make as much automated as possible (we’ll be connecting our base to our donation platform, mailchimp, gmail, ideally website/cookies), and that the right information lives in the right place so we can scale. If that sounds like something you’re interested in helping with, please let me know! Thank you!!

Hi! I’m needing to launch my airtable database soon. I’m migrating from FileMaker and have zero database design and found that this is much harder than I was lead to believe. Is anyone here is an airtable consultant who can take over my database migration and help me design the database so that pull out the info needed? We have a budget. We just need to get it done as working between the two databases is no longer a viable option.

I am new to JavaScript, and one of the reasons why I took learning it to use it on airtable. Often I need to sum, count and averages of values in a table and hold the value in a block for a while for others to see. This can be done using existing blocks but one each for sum, count and average - which is tedious. This script makes life easier in such cases. It lets user select the field and table, and even filter conditions before summing, counting and averaging them. I am planning to add error handling. and warnings to this soon. GitHub link is here: https://github.com/indrex/airtablesum

Hello, We recently had to port over an old webapp to Airtable in short order. The structure is there but the next step is to build out a front end that will make data entry to update existing records more user friendly. The users in this case are our internal folks, the app is internal and not publicly facing in any way. I will also have some questions about some complex fields and reports, but the front-end is my priority at the moment. I was hoping the forms view would work but that just allows you to create new records, when I have to be able to update the records. Some Stats on the current base: <100 records 5 Tables 12 Views (currently) Complex Page Designer Block for data presentation (Tear sheets)* *The final front-end product should mimic the layout of the existing and finalized Page Designer Block (Tear Sheet) which might help as a good guide. Finally, at our firm we have a number of possibilities we can use for thi

I am using AT for our CRM and database for our company. So we are able to link financials to the customers and marketing reps commissions. The more I play with AT the more I see it has amazing capabilities. I am a visionary and have some cool ideas on how to use it further but would like to see if there are other users interested in having a ZOOM call or other medium to further explore the idea. We are also in the process of using it for our HR process by using digital forms. Below is a link to a form for those interested in joining the group. https://airtable.com/shrlVF9kevgnyaqrT

Please reference www.highmesallc.com to understand our company. We buy wind cash flows from landowners who have wind turbines on their land. We have been using Airtable but it is beginning to stretch the non-experts, and we are going to need some streamlining and extension of its capabilities. First task is to give criticism/fixes to the existing base/structure, then extension for supporting higher volume of customer contacts. To get a sense of scale: we are currently dealing with 15000 turbines, and 3500 owners. Current important tables are customers/turbines/projects (which are aggregations of turbines)/mailout tracker/deal discussion tracker/family groups. I am sure this can be improved. We need a way of capturing contacts with owners and constant improvement of the dataset (for example - salesperson gets an inbound call from a mailer/email, we need a simple form to correct the phone number for that custom

I’ve recently started using Airtable to cut down on the number of spreadsheets that don’t talk to each other, and loving the improvements we have made so far. One of the struggles was not being able to use a lot of features due to dates and times being in seperate columns in all our other documents, and wasn’t able to find other community posts solving this in a simple way. After a few weeks of messing about, I finally found the DATEADD formula is the simplest: DATEADD({Date},{Start Time},‘seconds’) I use a similar formula to calculate the end times. I can now use all the lovely DATETIME formulas I’ve been excited to try out without having to do manual input, which was the goal all along. Has anyone else had to discover this themselves? Any other workarounds people have created?

EDIT: Updated to incorporate solution for batching more than 50 records Why this script I import transaction records into Airtable from my bank on a regular basis via CSV files. Those transaction records have names that are pretty ugly most of the time (like [Amazon.com*6X6AN17G3]) and often there will be multiple transaction names that actually link back to the same company as a payee. I want to know, for example, how much I paid out to “Fry’s Grocery Store” in total, no matter which Fry’s location I went to. And, I want to view that data in a Chart block, with pretty colors from Single Select options, for example. So I used to manually match transactions with a colored Single Select value: Needless to say, it was a tedious man

SwopItUp is a non profit organisation that works with teens on environmental action in the UK. We’re looking for some pro-bono support with Page Designer. Part of our programme includes our Creator Briefs, and we have been using Airtable for the data. We have been playing around with Page Designer, and think this is an ideal way to present the info back to teens as PDFs. However, our designs are pretty basic, and might not inspire Young People behind the ideas in the way we were hoping. Would you beinterested in helping us to max the way we can present these, in an image rich way, using Airtable, with a view to this becoming a case study you can highlight in your portfolio?

Heya community! Dan (@openside) and the team have been hard at work making our own slew of tools to compliment Airtable. Today I’m excited to announce they are now live! Here’s what we’ve been making: Actions - Advanced connector to integrate Airtable with your other software tools Forms - Sophisticated Airtable forms with extended features Schema - Monitor and be notified when anything in your Airtable schema changes Backups

Gridの日本語入力の1文字目が半角英数字で決定されてしまいます。 このエラーは2015年にも存在していたみたいですが、未だに修正されていないでしょうか？ 日本語入力の1文字目が半角英数字で決定されてしまいます。

Has anyone built a Plug-in for Outlook to pull Base, Table, and Fields information into email while responding or parsing through the email and fill the Airtable fields?

I’m looking for a potential consultant that could help build out an inventory table that connects to a 3rd party platform via API. It seems our need is relatively specific, which means most Warehouse Management Systems would be full of bloat. We have the general format of the table already created. If you bring new ideas to the mix, that’s great, but what we have is relatively solid - maybe we’d do some reformating. Here’s a high-level look of what is needed (I think): List item Sync Airtable data to 3rd party platform via API. List item When inventory is available in the Airtable spreadsheet, the 3rd party platform allows for production to take placed based on that available inventory. List item If the inventory is not available in Airtable, the 3rd party system will not make orders available for production. There maybe be another item or two that pops up along the way from a functionality standpo

I run a small cat sanctuary and we are growing fast. I have been using an iPad app to keep track of my population but I’m needing something a little more involved, but the shelter softwares out there are WAY too much for what I need. I feel like this would be a pretty easy setup for someone who already knows this system. In time, I could learn it and do it myself - I just don’t have the time. I’m running this place by myself and now I need to hire help. If you think you can help, please contact me at blissfulcats09@gmail.com. Btw, I know they have a pet template but it’s far too simple for my needs now.

I’m not sure what details to include, I want to incorporate Airtable into virtually every aspect of my landscaping companies’ business operations, and while I know what outcomes I want, I can’t take the time to learn a whole software platform - I need to delegate this. I’m looking to set up: Inventory System CRM Invoicing Employee CRM Business Accounting System I don’t even know what I could expect to pay for all this, so I’m looking for an idea of what this will run me. Thanks!

Looking for an Airtable Consultant to help with streamlining an existing base. We have a pretty good handle on our workflow, but might need a real guru to help finesse some details. Thanks.

Hello! I have a database that needs some help in organizing and installing blocks for analyzing the data. I believe a quick conversation/screen share will help show the right consultant what I am looking for.

Hey all, I’m looking to speak to a developer to help me level up a couple of fairly large bases we’ve created to help us with project management and budgeting. Specifically, I’m looking for some scripting to help populate large data source tables with the goal of creating future-proof templates, and rolling up final costs based on certain parameters, among other things!