Builders Board

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 warranty purchase receipt attached for reference and it’s proven helpful already. I hope this helps someone else, if there’s even anyone else out there that is literal

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 resulting in misleading or entirely wrong conclusions. It is especially poor at math and computations in excess of three digits. But, when you insert a simple phrase "step by step" into the prompt, it seems to get a lot smarter. In some cases, this simple prompt assertion can increase its intelligent

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, more intense, and perhaps more central you are to the community. @Kuovonne should be Mercury if not the Sun itself. When @Kuovonne doubles her engagement in a few years, what’s after Pluto? Dwarf planets? And are these even politically correct? Eris is a little bigger than Pluto, which has i

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 mail notification with lead inform

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 month. This gives you access to unlimited charts and reports, and lets you download your reports as PDFs

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.

Hello Airtable community! I’ve read a few posts here about the calendar view iCal link taking up to 48 hours to update on Google calendar/Outlook, more than enough to break a workflow. After a few hours, I stumbled on a GitHub repository that forces Google to resync the Cal link, either manually or at a set interval. I did a few tests and it’s working as intended, updating my calendar every 15 minutes. Please note that it’s a Google Apps Script, so will not work with any other calendaring platforms. The repository is located here: https://github.com/derekantrican/GAS-ICS-Sync. Instructions require very minor modifications on the user’s end but are very clear. I have no affiliation with this developer, but this script certainly solves a problem that I know many of you have had!

Hola! Tengo una base, y en una tabla tengo dos vistas, quiero que solo una puedan ver y editar todos los invitado, pero la segunda vista quiero que solo algunas personas lo puedan ver y editar. Las opciones de airtable en la versión PRO son: Todos pueden editar, o la vista solo para mi, o nadie. Yo quiero que un grupo de personas pueda verlo y editarlo y el resto de personas ya no puedan. Adjunto la siguiente imagen, aunque representa los permisos de un campo, me gustaría que eso se pudiera configurar por vista. (imagen representa la edición de algunas personas que yo puedo seleccionar)

Hey guys, I made some customizations for the new Airtable forum and figured I'd share them in case anyone else found them useful!You can turn off whatever features you don't want, and I've left comments in the code to help with figuring out what you can customize (e.g. customizing the unread topics to show up with red font or something)FeatureOriginalNewCustomization of Read vs Unread topic colorsMake the Reply Box fixedCustomization of Reply Box heightIncrease usable area of the Private Message pageHow to useInstall TampermonkeyOpen the extension, click “Create a new script”, and paste the code found at the end of the post into it and saveYou’re done!NotesI’ve been using this mostly on Firefox on a Mac; let me know if you hit any issues and I’ll do my best to fix itThe Code  // ==UserScript== // @name Airtable Forum UI Helper // @description Various UI additions to make life easier // @author Adam - The Time Saving Company // @match https://community.ai

Hi,I have a list of employees entering work, with start time, end time, number of hours, employee ID, etc. All day I try to come up with a sensible way to generate a list for a given employee, so that it can be quickly printed and signed later. I've tried with google sheets, google documents and it turns out that creating a list using make in each of these solutions is failing and complicated. Any ideas?

I've been scouring all threads, extensions, and templates for help with creating a base- and several threads I came across that had the same requests as me tended to come up with "hire an expert"My workflow consists of different phases:1. Inquiry2. Proposal/Research3. Booking/Follow-ups4. Planning5. Prep6. Week-Of Event7. Cleanup8. Follow UpEach phase has a bunch of different tasks. For example, the "Prep" stage has each of these tasks:Create Flower RecipeRent Van/TransportBook AccomodationsFinalize Hardgood CountsOrder materials for special mechanicsDigital MockupsFinal CallCreate TimelineSubmit Flower OrderPrep Hard GoodsAdjust Packing ListAll of these tasks in each phase need to be repeated for every event. And each of these tasks has a deadline range relative to each event. (submit flower order needs to be done between 21 and 45 days before the event). I am fine setting a single deadline for each task, but the deadline depends on the project date.Right now I have a table for Projec

I use airtable essentially to create daily schedules.These schedules are PDFS that i print from the layout extenionsi then upload the pdf to a seperate kanban view for employees on site to be able to go thru at start of day to know what they need to do.All of sudden, airtable has "forgotten" or corrupted all of the pdfs or images that were in the table.I can't upload anymore either. If I delete a corrupted file and try to reupload, it just reuploads a corrupted file that has a link to support center embedded if you try to open it as an attachment.This effects the way I run this business pretty critically unfortunately. Maybe this is the equivalent of a storage capactiy paywall?

We are an apparel development company and use Airtable extensively throughout our office. We are in need of a developer to help with the additional functionality of Airtable to even better suit our needs. If you are a qualified candidate please contact me at dlau@rideicon.com. Thank you.

Hi everyone, I just wanted to share a quick tip I use. I often see people use Zapier or miniExtensions to do this basic operation so it may be easier to do this way. I am using the Automation feature of Airtable to trigger when the record has a “pending URL” (that should be processed). When triggered, Airtable let’s you set the Attachment field type with an “URL” value and will automatically convert it. (tested for images and PDFs) Demo base available here Florian

[Note: As this process is a crucial part of a number of other Airtable routines — for instance, finding the latest/first/largest/smallest something of a group of somethings, or [seemingly] any method allowing the value of a field in one record to be used in a calculation performed from a different record — I find myself entering it increasingly frequently. To save my fingers and others’ patience, I’ve decided to create a post dedicated solely to the process I can later reference as needed. The following will create a link from every existing record in a given table (here called [Main]) to a single record in a second table (here called [Calc]). The creation of such a link between tables is a necessary first step for a number of Airtable routines. In [Main], define a new single-line text field called {Link to Calc}. Set the value of {Link to Calc} for every record in the table to equal ‘.’ — that is, the period character. This can be done by entering ‘.’ in the first row and draggi

Hi guys, I need some suggestions in a course to learn more about airtable. I need an special focus on forms, formulas and interfaces

Hey ATCF Community! If you want to securely connect your entire database / warehouse from Airtable, we built Bracket for exactly that (https://www.usebracket.com/)! With Bracket, any change in your backend data will be reflected in Airtable, and any change in Airtable will be reflected in your database (e.g. Postgres, Mongo, Snowflake) – or you can sync data in one direction Why did we build this? Because Airtable made databases accessible to non-technical people, but it can’t function as a true backend to a company. With Bracket, you can turn Airtable into a UI for your database to get the scalability of a database with the amazing user experience that Airtable offers. See how it works here p.s. If you know SQL, you can even set up SQL statement logic between the database and Airtable (joins, filters, you name it) and still sync both ways.

I’ve been playing around CSS selector on the Web Clipper Block and created a Clipper that automatically extracts information from a LinkedIn using the CSS selector. This could be useful for recruiters, sales reps, or people just building a social network. Here’s my full write up: https://www.notion.so/Building-a-LinkedIn-Scrapper-on-Airtable-af052e46f3454d40909990d75fbdfde8

Simple sales db, inflow from jotform. Need to add several messaging options to create ready terminals for sales team. Texting, email, Whatsapp, maybe direct calling (optional).