Show and Tell

Dear Community:I'm currently running a communitys survey with a giftcard drawing. I've noticed some suspicious responses come in (emails with formats NAMENAME #####), non-standard/nonsensical answers to fillable responses. Some are also in other languages, which is not a flag in and of itself since we are a multi-lingual community.One section is for busiensses and requires a business address - folks who don't give me one in the area geography (in town) are disqualified. I hadn't required this for general population as I don't want to discourage respondents, but since I can't use CAPTCHA I'm currently thinking my best solution is to require an address, state its necessary for data validation, and disclose that my org won't use or share this info?Any advice on best practices, ways to accurately clean my data, or other methods to ensure valid responses and not a flood of randos just wanting a gift card? Thanks!

I use Airtable for budgeting, because I'm that guy who finds a few little things that I don't like about every piece of software I use, and would rather be in control of how something as important as my budgeting system works... even if it means working within the constraints of something like Airtable :smirk:In any case, one of the things I was missing from good budgeting software, when I switched to using Airtable, was monthly tracking charts. But something that I like to do, and which isn't supported by many other budgeting softwares is annual tracking charts. For our family, tracking something like a "Clothing" budget doesn't really make sense to do on a monthly basis -- there are some months we don't buy any clothes, and some months when we buy ALL THE clothes. Using the monthly "sinking fund" style of budget for this made it difficult for me to determine how well we were doing at actually keeping to the budget. Much easier to do within th

Looking for even more Airtable communities where you can share your love & passion for Airtable?The Airtable experts at ScottWorld and BuiltOnAir have teamed up to bring you TableForums: The Airtable Discussion Community!TableForums is a place where you can learn from Airtable experts, connect with other Airtable enthusiasts, and get the support you need to make the most of Airtable.Come network with like-minded individuals, share tips & best practices, and get help with any questions you might have. Whether you’re new to Airtable or a seasoned pro, we’re excited to have you join the conversation. We’re always looking for new ideas and

A few days ago, I tried to help another Airtable enthusiast concerning a question about timelines. According to this community platform, I have written about  3250 posts since 2018, and despite my grandfatherly age, I recall one such post about Vega-Lite that would be perfect to help this customer.When a search engine believes you've made a mistake crafting your query, such as a misspelling, it tries to help. In this case, it demonstrates a significant degree of cluelessness.Did you mean: negative-lite ... Seriously? And what will this brilliant discovery engine tell me about "negative-lite"? Feel free to dive into that rabbit hole. We need to press on with a point to this post.Looking through all 42 pages of results did not contain the post I was looking for, but it did give me a few laughs like this one. It's entirely ir

After importing data, it’s not uncommon to want to clean up and normalize data values, especially text fields that may have all types of inconsistencies. Unfortunately, Airtable doesn’t support in-place transformations where formulas can be applied to modify the field contents of all cells. This is where the Field Tweaker script block can help. It supports in-place text transformations including upper case, lower case, and title case modifications across all records for select fields. The script is published below and this base provides a simple sales table to experiment with and also includes the script block. When you run Field Tweaker, you define a changeset which includes the table name and the field name you want to tweak, and lastly - the tweak you want to apply which in this example script block includes: Upper Case (LIKE THIS) Lower Case (like th

A simple and minimalist base to help small businesses and teams track issues and squash bugs. Get the template now on https://www.airtable.com/universe/expJSAwygjVK9DfJ2/issue-tracker-project-managementSupport Server: dsc.gg/trackers - Get Help on Discord.Currently, the base has the followingGrid View - All Bugs - You can preview all of the issues that have been created.Board View - Kanban - Sorts all of the issues by the following categories (cards) which are: To-Do, In Progress, Code Review, Final QA, Passed QA, and Done

I thought this might be useful for others, as I had to figure out how to do it for myself to automate sending emails during the right timezone for the recipient; here’s a list of all the timezones for US states: IF(OR({State}="CA", {State}="WA", {State}="OR", {State}="NV"), "PST", IF(OR({State}="MT", {State}="ID", {State}="WY", {State}="SD", {State}="UT", {State}="CO", {State}="AZ", {State}="NM"), "MST", IF(OR({State}="ND", {State}="MN", {State}="WI", {State}="IA", {State}="NE", {State}="IL", {State}="KS", {State}="MO", {State}="OK", {State}="AR", {State}="TN", {State}="TX", {State}="LA", {State}="MS", {State}="AL"), "CST", IF(OR({State}="MI", {State}="IN", {State}="OH", {State}="ME", {State}="VT", {State}="NY", {State}="NH", {State}="MA", {State}="CT", {State}="RI", {State}="PA", {State}="NJ", {State}="MD", {State}="DE", {State}="WV", {State}="KY", {State}="VA", {State}="NC", {State}="SC", {State}="GA", {State}="FL", {State}="DC"), "EST", IF({State}="AK", "AST", IF({

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 

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

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 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:

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

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

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.

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!

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 colors

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 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?