Builders Board

We are a small book publisher looking for an Airtable expert that we can form an ongoing, long term support/ advice relationship with. We use Airtable to manage our database of staff as well as to track projects and more. We've recently upgraded to Pro and are looking to maximise how we use Airtable and discover what else it could offer to improve our systems and make life easier for all aspects of our business. Ideally we are looking to contract someone we can work with on a regular basis who could take on specific project tasks (to set up new bases/ tables etc) and be available for support as needed.If this sounds like you, please let me know in the comments below and I'll reach out with more information.Thanks!Susie

Hi, anyone can help with a trick to hide a record if one is marked with a tag?Example hereI want the Data Intelligence Intern to be excluded from the form without deleting it from the record Any tips?Cheers! 

Hi,Hope you are all doing well.I need a little help. I have a simple single select column which have different tags and can be updated time to time. I want to calculate the edit history of each tag in other column and wanted to know how many days requiring each tag i.e when it was changed from in progress to shipped. I want to calculate the time and no. of days.I'd really thankful if anyone provide me best solution 🙂Thanky you 

Hi, I’m trying to develop a simple envelope budgeting system for my family. You can read more about the envelope system here, it’s very straight forward: http://www.moneycrashers.com/envelope-budgeting-system/ I created the following table: https://airtable.com/shrwr8HnsXRGdxbgM It works wonderfully for me and my wife but the month is about to end (1oth of march) and in this specific system you need to add to the envelop a new monthly budget in addition to what’s left from last month and I can’t find a way to performing that, Maybe I need to create another month table, I don’t know. I’m willing to pay for a professional to do it, it’s pretty simple but I don’t have the experience. Can someone help me? Best, G

Hi, I have an ecommerce business and I’m looking to organize things using Airtable. Below is the brief of my requirements: Sales Channels: WooCommerce, Etsy, Amazon (Walmart, Ebay and more in the future) Orders comes through one of the sales channels. All important data should be populated in the table Packing list/slip is generated for the factory so for instance if the order is 1 kit, then the packing slip will contain all components needed for the factory. (Checklist format so components can be ticked off) Ability for factory/user to upload pictures for each order showing what all is packed. (Pictures can be saved elsewhere if storage is an issue. Only the last 60 days’ ordered pictures would be needed.After 60 days then can be archived if storage is an issue) Factory user will upload tracking to the table. There should be a sync button which automatically pushes all tracking from the table to their respective sales channel.

I've wished for a while that shared view links contain preview images in messaging apps / social media, and give me metrics on the number of clicks, so I made a little tool to fix that: just change ".com" to ".cool" in any shared view URL. Here's an example: https://airtable.cool/shrXISgTxpgLU0SgP , showing the total number of clicks in the .cool page's third line ("35 total clicks in the last 2 days")  When pasting the link into a messaging/social media ap

Hello, I have a small Solar company and I’m currently using excel to track clients, appointments, materials, etc. I’m trying to get off excel and a friend told me about Airtable. I don’t have the time to learn it and set it up, so I’m curious how much it would cost to get this going. Charles

Looking for a consultant to move me from daylite to airtable

Hi everyoneAs a little weekend project I made a simple tweet scheduler with Airtable. It allows to post tweets once daily at a time you specify. You can set the number of times you want each tweet to post, or allow to repeat indefinitely. Turn on/off at any time. Available at https://amazingairtable.gumroad.com/l/tweetsLet me know what you think! Just doing this for fun for now, but may start to build more complex stuff if I can generate any interest.Peace

Hi! I own a solar company and currently use Airtable for all of our operations, project management, CRM, marketing, Etc. We are looking for an expert that can create, optimize, and automated a base for everything, so it will work more dynamically.

Hi everyone! We were stumped on this for a while and couldn't find any workarounds. So here's how to extract the next date in a series of dates inside of an array or a rollup from another table.1. Convert your dates to UNIX  and wrap them up in a VALUE so that they are all fixed numbersVALUE(DATETIME_FORMAT([date], 'x')2. In the table where you're wanting to store & retrieve the "Next date" in a series, create a lookup of the column you just created in step 1 & chuck a filter on it that says "On or after Today"3. Create a new formula column and retrieve the 'minimum UNIX date' with a MIN() MIN({Your Lookup Column Name})4. Convert step 3 back to your desired date with a DATEADD() formulaDATEADD('1/1/1970',{Your column from step 3},'seconds') Voila, you now have the "next upcoming date" in a series of dates.

Hi allHere's a little workaround I came up with to easily track how many times a checkbox has been ticked using just an automation and a formula: https://youtu.be/3C36OoWb3MQ It always annoyed me the "last modified" field will update whenever a field is edited, and not only when a field matches certain conditions. This means you can't use it to monitor when a box was last checked, only when it was last *checked or unchecked*. I got around this by making a "tally" of how many times the box has been checked or unchecked by adding one character to a string each time this happens, using an automation. Then I use the LEN() function to calculate the length of this string, and divide it by 2. Because Airtable always rounds up decimals when you set the format of a field to integer, this means whenev

If you're looking for all the ways you can use forms in Airtable, check out how Jen Rudd and her team used On2Air Forms to streamline projects for a construction company.  (We have a FREE plan.)They used it for:- Updating records- Create and update linked records- Creating estimates- Filtering specific data per person- Viewing data on mobile- Bonus: Dashboards - While they used Google Data Studio at the time, we now have a feature for creating dashboards in On2Air FormsLearn how: https://on2air.com/resources/h

I built a base to track all the warranties I’ve gathered over the years, for both my consulting business and for my own home. I got tired of having to login to all the different sites and search through my Amazon order history to find what I have protection on and who is doing the protecting. https://airtable.com/shrpom0L2OD3Masjj This table has been filled with some dummy items and warranty plan #s for the sake of sharing publicly, but I’ve allowed copying for anyone who wants to duplicate this for themselves. The “Status” column was actually the trickiest, but I was able to put together a formula that looked at the “Coverage Expires” date and compare it to today’s date, and if it is before today then it shows the warranty as Expired, otherwise it shows it as still Active. In my base I have the product receipt and the warran

I really hope Airtable can auto-detect when filtering "date" type data and will have a date range option pop up automatically. When trying to pull out the report, it is very inconvenient to set up 2 filters with "and" function. 

When the database gets so complex you start a database to track the tables, views, and fields… Have fun out there :slightly_smiling_face:

Looking for someone who can help write some code for my airtable base.Here is what I'm after: Table 1:Name 1, Website 1, blankName 2, Website 2, blankName 3, Website 3, blank Table 2Name 2, Website 2, blank Output - I'd like a function that looks up rows on Table 2, see's that there is already a name 2 identified on Table 1, and puts a message in the 'blank' e.g. Confirmed.

This is a Tell; not a Show.Prompt engineering, also known as shaping prompts to get exactly what you want from GPT-3 and ChatGPT will eventually bite you.This post is here only so that I can say 6 months from now - I tried to warn you.The core model used by GPT-3 is text-davinci-003. GPT-4 is on the near horizon and it will be so much more advanced, the prompts you build into your applications today will be fundamentally useless with text-davinci-004.Prompt engineering is also aptly referred to as "spell casting". You can cast spells on LLM's (large language models) quite easily to achieve favorable results. GP3, for example, glosses over intermediate steps to reach conclusions, often r

Hi all, looking for someone to assist (consult) with a webhook from Airtable entry to Stripe payment. Each row of my base is a bookable course with varying price and date. Would like to setup a button which takes the course name, date and price and sends this to a stripe payment. I think this is possible but I’m still working through the API code. Based in Melbourne, Australia. Thanks

Hey Airtable Community.I work with songwriters and I've created an airtable that logs all songs written and industry contacts.  I'd love to hire someone to help linking records and creating formulas to automate my processes better. Let me know if you can help! Thank you! 

The new Airtable community has many functional flaws, but this missive is about one that is purely a design choice that annoys me. Don't take it too seriously, but enjoy it and let me know your thoughts. Members are classified by planet names; Pluto is reserved for only the most prolific contributors, like @Kuovonne. I was recently promoted to Neptune (from Uranus, another funny story too deep for this post). This member ranking metric is based on the distance from the sun. Apparently the more you engage, the further you are from the Sun.That makes no sense to me. It would seem that the more you engage, the more of a light source you become; hotter, mo

Hi,I'm looking for a Airtable developer (a pro in writing custom script) for a great project. For the first fase we need a solid base that works. Price and time frame can be discussed. After the first fase there is more to come. So basically we are really looking for someone we can work together with long term.The base of the project:From several websites we have leads coming in to Airtable through forms with a Zapier link. The leads (home service requests from specific postal codes) can have one of three categories and need to be distributed to max. 6 contractor (contracters are grouped) from within the postal code region.So I guess the scripting comes in here.. Contracters have to be available, have daily credits, match category type and postal code. If a group only has 3 contractors then a script has to search for another group linked to the specific postal code and repeat this to fill the pool so a total of 6 contractors is assigned to the lead. A mai

Hello everyone, I would like to have the sum of each column of Table 1 in a row of Table 2. My problem is that on table 2 I did a rollup and a link, so I have to add the clients one by one in the Clients column. Is there a solution so that the Customer column fills automatically when I add a customer in table 1? The ultimate goal of my question is simply to be able to retrieve the sum of the columns Achats - Sous traitants - Salaires Flo - Entrée of Table 1 to be able to make a percentage in an interface. I hope I've been clear enough for you to help me 🙂Thanks to all of you !   

Hey Airtable community!I wanted to share a new extension from Data Fetcher called 'Charts & Reports'. This extension allows you to easily create beautiful charts and graphs from your base data, and even download them as PDFs or PNGs to share with others.It's completely free to use, with no limitations on the types of charts and graphs you can create. You can choose from line, area, bar, pie, and donut charts, and customize them with different colors, font sizes, and labels.It solves some of the limitations of Airtable's Chart extension, e.g. you can add multiple fields on the Y-axis, create stacked and horizontal bar charts, and even add a second Y-axis if you need it. You can also bucket your data by day, week, quarter, or year, and aggregate values across records.If you need even more control over your data, we also offer a Pro version of the extension for just $5 per user per

Hi everyone,Sometimes it is necessary to calculate a weighted average, for example, the cost of a unit of goods in a warehouse, despite the fact that purchases were made at different prices. For such a scenario, I made a database consisting of two related tables. Here is the link.https://airtable.com/shrvnJDOuHiPjErXWSince AirTable does not show how the calculated fields are made, I present them in screenshots belowHope this can be of any help.