Builders Board

Possibly of interest to some, the following is an implementation of Soundex pseudo-homophone encoding. As there are variations of the algorithm, care should be taken if using its output to search externally encoded databases. (I think this conforms to U.S. Census encoding, but I’ve found contradicting statements.) To use, copy and paste the following into the formula configuration window of a formula field. It expects to use an existing field in the table named {Word} as input, so adjust field names accordingly. (There are two instances of the field name {Word} in the formula.) Yes, it’s far from a perfect algorithm; yes, it’s rooted somewhat intractably in American English; yes, there are alternative encodings that may be more appropriate for many uses: Feel free to modify, enhance, and improve as you see fit — preferably releasing your improvements to the community afterwards. LEFT( SUBSTITUTE( SUBSTITUTE(

I am looking for someone to create a simple Wordpress plugin. I need to pull Airtable records using the API and put them into an HTML formatted table, all wrapped in a custom [shortcode] that can then drop that table into any Wordpress page/post. I’ve been able to mess with a php function that pulls the specific records I want, however, moving forward to the table and shortcode are outside the scope of my ability. Key to this is the ability to filter records by a formula where {Field} = Wordpress Post Title. I have my database set for a particular field to match the specific titles of Wordpress custom post types. This should all be contained within a Wordpress plugin that also creates the shortcode. Contact me here and let me know if you think you could do this. This would be a one-time project.

Seeking support for an existing install of Airtable employing Zapier. This is a paid position, can work remote if skills/experience align

We’ve got our bases loaded and need your help to get the most from our AirTable set-up. You are a Seattle-based consultant or company with a proven track record of working with multiple teams to deliver a sophisticated, efficient and easily manageable AirTable base. Advanced understanding of system architecture, integrations and automations is needed, as is comprehensive knowledge of formulas, scripts and other mechanisms that make our system as smart as possible. You will be our North Star, guiding our internal teams through the development, training and implementation processes through tech-free speak and your comprehensive understanding of how AirTable works best. Using your stellar project management super powers, you will balance the wants and needs of multiple internal groups while staying true to the overall vision. What we are looking for… A self-starter who knows how to create and run a project plan that gets results, fast

Hello! We’re helping a client build their marketing site, and we also want to help release an MVP using Airtable (I think). Overview: The app will match a “teacher” with “student”. Each party will receive an email introducing them, and encouraging the next steps. Everyone will register through the site; this is an easy part— to connect Typeform to Airtable to collect all the data. (2 forms: teacher form + student form) On the admin backend, the “matching” of the teacher and student will be done manually. The admin will manually select both parties from a list and click to send both parties the same HTML email that contains connection instructions. (one email send to both parties) So here are the que

Hi all, I run a judo club and use Airtable to all store all membership information. Currently, taking the register can be a bit of an ordeal so I am looking to automate the process by letting members “check in” when they enter the club. Details: We have a REGISTER table which pulls in active members from the MEMBERS table. Each class is a separate column (e.g. Tue 21/09) which gets checked if the student is present. The goal is to have an iPad at the entrance to the club where students can “check in” by searching for their name on a web app. This would then update the relevant record in the REGISTER table. I’d also be keen to explore issuing membership cards which the students scan to check in, but this is not MVP. Please get in touch if you’re keen to find out more. Stuart.

Very simple project. We need someone to build formulas for our Software Development Board table - specifically to create a formula that sums up the different ‘variables’ (1) for each task, and outputs a ‘score’ (2) to help prioritize each task. Here’s an example of the structure we look to create: The current input variables are: Urgency (+) Very Urgent (10) Urgent (5) Normal (2.5) Not Urgent (0) Business Value (+) Very High Value (10) High Value (7) Normal Value (5) Low Value (3) Very Low Value (0) Potential User Value (+) Very High Value (10) High Value (7) Normal Value (5) Low Value (3) Very Low Value (0) Effort Required (-) <1 hour (0) 1-3 hours (-1) 3-5 hours (-2) 5-10 hours (-3) 10-20 hours (-5)

Hello, I am looking for someone for a quick estimate and what I think is a fairly easy task to integrate two sheets within a base. The fields are ideally going to link from a central Client information to subsequent sheets where I only need to pull over very few fields. Right now, my clients have to duplicate their entry which I know they shouldn’t have to do. Thanks! alexa

Hi all, I’m looking to have an attendee check-in system made. I began playing with things and just hit a huge brick wall on everything, so I’m interested in help. Details: We run a convention. Attendees pre-register using Eventbrite. They can also pre-purchase merchandise as an add-on to their tickets. We export the Attendee List from Eventbrite as a CSV file. Due to how Eventbrite works, we also export a completely separate CSV file for merchandise. The Attendee List is pretty straightforward and self-explanatory. The Merchandise List lists every item as a separate entry with a quantity. (So for example, if Jane Doe bought 1 Large Shirt, 2 Medium Shirts, and a Lanyard, there would be 3 row entries for Jane Doe with identical order numbers, one row listing Large Shirt with a Quantity of 1, one row listing Medium Shirt with a Quantity of 2, and one row listing Lanyard with a Quantity of 1. Ideally we’d combine these 3 rows into 1 row while keeping t

Hello, I need help with airtable. inventory database i buy the same products at different prices and i want the profit to calculate for each of orders. can you contact me for hire? thanks, freddie

I am an attorney, and I have started an Airtable Base to track my clients, cases, hearings, and tasks. I have about 2000 open cases at any one time, and about 10 employees that need to be assigned tasks, so the Base, once complete, will be fairly large. Here are a few things I would like to be able to do with Airtable: Create “If this, then that” Logic for various functions in Airtable. Here are a few examples of things I would like to be able to do: If the “type of case” is a “credit card lawsuit,” then the user gets a certain set of fields to fill in. If the “type of case” is a “divorce,” then the user gets a different set of fields to fill in. If the “hearing result” (what happened at the hearing) is “reset for a later date,” then a certain set of tasks is generated. If the “hearing result” is “we won the case,” then a different set of tasks is generated. Integrate with some other program to generate form letters and ema

Hi! I’m the Founder of DivaDance, and we currently are operating in the stone age of Google Docs. Support needed building out scalable Airtables for a few components of our business. Ideally would also link with Asana, Skipio, and our website (Wordpress). We also use Pike13 for client scheduling so if you can figure out how to link Airtable with that, you’re officially my new hero. Let’s slay this together! Thank you ! Jami jami@divadancecompany.com

Very new to airtable so not sure if it is possible, but i was wondering if airtable could be used for consolidating uniform orders. eg we list available items in the uniform into a table eg polo shirt, jacket, business shirt etc and pictures and the available sizes. Then individual users can select the size and qty for each item type and airtable will consolidate the order. Am not sure on creating logins for dozens of different people in an organisation and restricting what they can see. i thought i saw something somewhere about sending an email from airtable and it allows them to just enter data in 1 line but i cant find it now in the overview of features (maybe i’m getting mixed up with another system). I’d be happy to pay for someone to set this up or show me a base template that does a a similar function. Al

Looking for someone who can help build out our AirTable. It is already built out and functioning, but we need improvement with data entry, functionality, and simplification of our UI. We would also like to integrate it with QuickBooks online (or desktop). We are very knowledgable of it’s functionality, but we just don’t have the manpower to do the work! If you are interested, leave contact details or message me. Thank you! Amanda

I need assistance with putting together a process our staff can use daily to add 100-300 images to Airtable via URL. Please provide your rate and email me for additional details. Thanks for considering -Brandon Wealth@InvestHypothetical.com

I’m looking for someone with in depth knowledge of Airtable that can help me redesign my main shared spreadsheet for my business. I run a transport business with over 50 lorries out daily, currently we’re split over multiple spreadsheets & asana but I’d like to simplify our workflow by bringing the administration department & sales into our main global programme. I’ve got as far as my knowledge of excel lets me and would like to see if Airtable could provide a solution. I think what I’m trying to achieve would be fairly straightforward but would be happy to go over exactly what I’d like to do via Skype/your prefered voice chat app or even a phone call if you’re oldschool like myself! :slightly_smiling_face: Happy to pay however required, could pay via Upwork/Fiver or similar platform, or via invoice if prefered.

Looking for some contractor help ASAP. Please send me an email at dadau@yahoo.com if anyone has time and experience with this. Thanks. Uzair

This may be obvious to many, but it eluded me until today… It is a HELL OF A LOT easier to code (and debug) formulas in Textedit (or the text editor of your choice), inserting returns between segments (B). When you paste your code into Airtable, it’ll smartly remove those returns and create the code block we’re used to seeing (A). A IF({Auto-Status} = “Awaiting Review”, “ :mag: ”,IF({Auto-Status} = “Complete”, “ :checkered_flag: ”,IF({Auto-Status} = “Design”, “ :art: ”,IF({Auto-Status} = “Released to Supplier”, “ :rocket: ”,IF({Auto-Status} = “On Our Radar”, “ :satellite: ”,IF({Auto-Status} = “Production”, “ :triangular_ruler: ”,IF({Auto-Status} = “Cancelled”, “ :skull: ”,IF({Auto-Status} = “On Hold”, “ :zzz: ”,IF({Auto-Status} = “Design Queue”, “ :art: :soon: ”,IF({Auto-Status} = “Content Needed”, “ :question: ”,IF({Auto-Status} = “Unassigned”, “ :busts_in_silhouette: ”,IF({Auto-Status} = “Design Route”, “ :art: :arrows_clockwise:

Hi I have a base that records appointments we obtain for our clients. It pulls linked data and sends out zapier emails and records calendar events plus sets up followup draft emails - and it works fairly well. I’d like to improve the functionality of the forms and organize the relational tables a bit better. Basically, clean it up and iron out a system that’s bug-free and easy to maintain. This a fun little job in a really neat industry, Would love to get this done asap. And look for more automation opportunities too! Ryan Thomson Refinery Artist Management / Velocity EP

Looking to build a Company Register with the following data: Company details Company Directors Company Assigned to internal resources for follow up Contracts with the companies Activity with the Companies Timesheets Create role based views for the internal staff and dedicated workspaces. We can discuss the requirements in more details for implementation. Thanks, Shankar

Hi we have used Airtable extensively to manage our website content but now we want to build a simple transaction management and reporting tool. I have built a prototype but encountered some problems so looking for a consultant who is good with Airtable and databases. Financial Services area.

Looking for pro-bono or freelance help on a non-profit project using Airtable called “The Dream Machine” it is an armchair scientist strategy system to improve the future. I want to get feedback on how we have organized in Airtable and also get the prototype integrated into a website so we can manipulate the data much more easily and more flexibly. The project is large and we are just starting and don’t have funds yet but we are looking for an estimate/expert in Airtable to help with ideas/architecture/integration. http://zenka.org/the-dream-machine You can email me at hello@zenka.org for further information.

I would like to contract for one hour of screen-to-screen consultation to better understand how Airtable works and optimize a relatively simple table I am working on.

Our business is considering moving from FileMaker to Airtable. We are a digital media production business, with many (hundreds) contractors, clients, and jobs in many different diciplines. I’d like to a - Move over the data from Filemaker to Airtable b - Remake the current FileMaker system with Airtable, with new features. There’s quite a lot to this, so I need to do a feasibility study to assertain whether everything we want to do is possible in Airtable. Please message me with your offers. All questions and enquiries are welcome, but suitable candidate must be an expert in Airtable database creation and be able to understand how digital production workplaces generally function. This is probably a week’s worth of work (feasibility stage). If it progresses, we may offer you the job to create the Airtable database.

Hi, I’m a newish member of a six-person communication and marketing team, and we are interested in using Airtable for project management. I have used Airtable in the past and am fairly comfortable with it—the rest of my team does not have experience with it—but we are hoping to reduce the burden on any one staff person by working with an experienced outside consultant to get a comprehensive workspace set up. If we go this route, we’d first want to talk first about our needs and project goals (we’re based in Ann Arbor if there’s anyone local to us here), and get some help on the conceptual end before moving forward. Right now most of our stuff is housed in a bunch of different, unwieldy Google docs (and some sheets), and that works for just about no one. I do have a sample base that I think shows a fairly decent micro version of what we’re going for … If this makes sense and you’re interested in talking with us, please drop me a line with your rates and anything