Builders Board

Airtable has worked so well on student side of the school I work for, that I’m making a major leap into using it for our marketing activities. Which activities? All of them: Project Management Publishing Calendar Partner CRM Vendor Contacts Media Hit Database Collateral Management Campaign Results Swipe File and Event Planning It makes sense for all of this to be in one database, not spread across a half dozen applications. There are products that attempt to do this, but they cost $$$ a month and often trade functionality for usability.

I would be interested to know whether there is a possibility to synchronize between two versions of a base. My use-case is as follows: I would like to have a stable RELASE version of a base to which users have access through the API (with a defined API key). At the same time I would like to have the possibility to modify/extend a copy of that RELEASE version (let’s call it WORKING_COPY) and once this copy has reached a certain status it shall again be used as the new RELEASE version with the unchanged API key. I found it easy to duplicate a base in order to e.g. work on that duplicate as the WORKING_COPY but I don’t see a possibility to bring back those changes to the originating base (with the defined API key). Is there a way of achieving this or are there alternate solutions for my use case? Thank you, Stefan

I’m looking for someone to help setup quotes and invoices in Ultradox and other API integrations. -Donald Newlands

If you run a Wordpress website and you want to be able to easily pull data from Airtable into Wordpress, this is for you. Airfields is a Wordpress plugin I’ve built that allows data from Airtable to be accessed using Wordpress’ get_post_meta and get_post_custom functions. There is also a shortcode you can use in the post editor that will output the value of whatever Airtable field you specify. The way it works is that in the Airfields admin settings you will provide (App ID, API Key and) the name of an Airtable table and a field from that table in which either the post slug or the post ID will be stored. Then, any posts that match will have its custom data populated from the fields of the corresponding record from Airtable. This works with pages, posts, and any custom post type and can be used to display any field type Airtable supports. This should be considered a beta. If you’re a Wordpress plugin developer interested in helping develop this plugin, let me know. And if you’re interes

I was playing around with rollups today and couldn’t quite get or to work like I thought it should. Even worse I couldn’t find examples of how others are using it. An examples, real or made up? Thanks!

I write knitting patterns, they had to be tested - if everything is correct or not. So I have tests - for every pattern. I collect data as volunteers, yarn used, if finished, etc. I have testers - because some people joins to more tests. I want to keep their email address here, know in which tests they knitted and how. So I would like to rate them - did the finish in time, sent the survey back, etc. I don’t see, how I should connect all this data together. How it works now: I have a Google doc, one table for all tests, with the data mentioned before. And I have an other table: rows are testers and columns are the tests, I give a “note” for them. I hope this can be understand :slightly_smiling_face:

I’m in search of a consultant to assist me in creating a client management/fulfillment system that fulfills a few unique needs, including project management. Currently have a Google Sheet I’ve been working from, but am looking for something more organized and robust. My attempts with Airtable thus far have failed, as I’m not familiar with formulas.

Many of my tasks have a bunch of quick jobs to tick off. They’re not worthy of being a separate task. So far I’ve resorted to just writing them down in the notes cell as a sort of bulleted list. Is there a way to turn them into a proper checklist? Perhaps zapier or some other work around?

I am seeking a developer who can all or some of the following items from my wishlist: • Assign quantities to each linked record within a list of linked records. • Custom reports with custom layouts • Add Orange Color to Field drop down selection (we use specific colors to define our process and Airtable has all the colors we use except for orange) thanks, Rodney

I’m from Ukraine, so bare with my English.) For some months I develop game-mechanics and for a few weeks I try an implementation on Airtable. And I have some issues and some problems here. So I would be quite grateful for some help. My DB consists of lots of tables, among them are ASPIRATIONS (what I try to achieve by my actions), ACTIONS (list of actions I presume to be potentially helpful if practiced regularly), QUESTS (taking an action for some exact number of repetitions during a period of time), DAYS (every record is a day of game with according events), REPETITIONS (each repetition of each quest must be there), TRANSACTION (each gain or loss of points must be accounted for). For example I add an Aspiration like “Lose 10 kilos of body weight”, then I add Actions wich I see helpful with such a target like “Run a mile a day”, then I may take a Quest with this Action. If I see subjective difficulty of this Action as 3 (of 10), than taking this Action in a Quest for a week will cost

I need to implement more advanced features than I am capable of doing. I give up… Will be happy to pay the right person. We have a small but rapidly growing consulting firm and airtable is an important part of our workflow… This would be an ongoing opportunity and the work needed is available now. If interested, please contact me at mitch@1sixty8.com Thanks, Mitch Schaffer 1sixty8 media

This: http://www.fakenamegenerator.com/order.php Use that free service to seed data into your base. A few uses: Test workflows and Airtable features without mucking up your real data Sell a boss or train a co-worker on Airtable. I find that just showing my people how Airtable works was better than describing its potential Get Airtable support without giving them access to your real data

Would anyone like to share some of their database templates they have created? I am very interested in seeing how others are using airtable especially for customer information tracking and small business records. Thanks!

Hello, I run a cabinet manufacturing company. We currently use printed out spreadsheets for everything. I would like a tidy database that could manage our “jobs”. I’ll try to outline how it would work here: We have multiple projects with multiple builders. Each project has multiple plans (Plan 1, Plan 2, Plan 3) Each plan has multiple options (Door 1, 2, 3, Stain color 1, 2, 3, Optional Bath 3, etc.), each with an individual price, for which the price is split up by “material”, “stain”, “prefab door cost”, installation, delivery, tax, etc. For each phase of a project our sales reps will create a “sequence” which is a list of all the houses or “lots” with the associated plan number and all the associated options that were selected. Also for each phase our reps will turn in a “breakdown” that has a tally of all the units for that phase, and all the options for that phase. I would like a database in which we store all of our option prices by plan and project. Each price will be unique f

I would like to speak to a consultant to help me with an idea I have. I’d like to put a “Check your Order on AirTable” link on my WordPress site which, when checked, would prompt user to log on to AirTable and once that’s accomplished, take the customer to a read only view of their orders we populate by us in AirTable. Not sure it can even be done.

We need a developer to create an API to update my orders planning base. I have created an orders planning Base that does everything I want but updating it is a bit of a pain, copying and pasting from a spreadsheet. Please reply with any recommendations for people who can do this, or introducing yourself. Thanks! Lyndon

“This is the next big thing” That’s what one of our instructors literally said. And her job is to teach database design! My marketing coordinator is raving about it, and my admissions officer is already evangelizing it around the company. The biggest draw so far? The app and how it displays records, and how easy it is to add a new field. As the guy who has to choose which software we adopt, my sole criteria for buying an app is will everyone use it. Adoption is the problem that keeps me up at night. So far Airtable has cleared that bar.

We’re soon going to start planning a project to take our existing work with Airtable to the next level. We’re tracking a big amount of bases and we need to be able to centralize our operation a bit to save time and, most of all, sanity. We still have to sit down and define the scope of the project but would like to start conversations with professional developers with experience working wth Airtable API who would be interested in working on our project. Anybody interested? If so, please send me info on your background and skills and we’ll take it from there. Thanks!

If you are interested just send me a private message.

Hi, I’m interested in hiring an AirTable pro for a few hours of time. I have a major book launch and I’d like to make sure we are leveraging this wonderful platform well. Elizabeth Kanna

For most use cases, Airtable is easy enough to hit the ground running right away. But if you’re interested in building out more complicated workflows or integrations, there are consultants who can help! Please note that Airtable does not currently vet or recommend any particular consultants. It’s up to you to decide who to work with!

Hi everyone. I just posted about a technique that writers who use the popular Scrivener application can use to embed Airtable views directly into their Scrivener binders. It’s a great way for writers to do their research in Airtable and then refer to it without breaking their writing flow. Here’s the blog post: http://timdietrich.me/blog/airtable-views-in-scrivener-binders/ ~ Tim

Hello Airtable Community, I am a technically trained serviceman, who is currently employed as a maintenance guy with a myriad of assets that require on going responsibilities. I have a fuel inside of me to get all the scattered and tacit knowledge shoved into a database so I can have more time to spend on projects I enjoy. The Access relationship picture supplied was a work in progress. I was having a hard time with balancing certain things. I created 3 levels of “assets” Items, Assemblies and Parts. This is because I have equipment that has assemblies that can be replaced or repaired externally (OEM) but can be repaired in-house on a part level. Also, those assemblies can be taken off of one machine, repaired, then put back onto a different machine. The assembly level is also where any prototyping would occur when designing something with my 3d printer and trying it out. So any information about length of time in service would be important for a specific identifiable assembly. Parts l

Check out @Howie’s guest post on InfoWorld. Lots of great thoughts on the history of spreadsheets and databases, among other things: InfoWorld The next generation of spreadsheets will be a database Flexibility and ease of use have made the spreadsheet the popular but unfortunate choice for makeshift databases; we can do better

The show and tell category is used to share knowledge, tips, product suggestions, and cool projects with the community.