Builders Board

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 the scope of an entire year.So, one of

We are using Airtable as a simplified CRM system and need more freelance support to deal with minor changes, enhancements and automations as and when required, and to support users with training and data take on.I anticipate we need 7 - 14  hours per week.Please advise your experience and rates per hour.  It would be helpful if you are working in or near to UK time zones. Thank you

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 perspectives, so don’t be shy about joining in!We can’t wait to see what you have to contribute! 😃

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 irrelevant to the query.The Khoros search engine has no idea that Vega-Lite is an entity, much less an Airtable extension. This says a great deal about the indexin

Building out a social media calendar where one of the fields indicates the Copy that will be going in a post. Was hoping to create a separate formula field that automatically searched the Copy field for any hashtags and listed them there. Support’s initial response sent me the formula below as a start, but it only pulls in the first # within the copy section. Wasn’t sure if anyone had any ideas/suggestions on how to expand it to pull/list all of them. Thanks in advance! IF( FIND(" “,{Notes},FIND(”#",{Notes})), MID({Notes},FIND("#",{Notes}),FIND(" “,{Notes},FIND(”#",{Notes}))-FIND("#",{Notes})), RIGHT({Notes}, LEN({Notes})-FIND("#",{Notes})+1) )

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 this) Title Case (Like This) In the following example, we have a field named PRODUCTLINE where values have been imported in lower case

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 DoneView by Priority - Showcases all of the issues based on priority which is: Low, Medium, and High.View by Status - Showcases all of the issues that have been DONE.   The default fields that have been added are:Name of Issue.Priority.Description.Steps to reproduce.Screenshots & Videos.Assigned To.Status.The client is notified.Board View (Status).Date of Submission. The Issue Tracker also includes a table called "Team Members" to which y

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({State}="HI", "HST"

At Uptown Stories, we provide workshops in the arts to underprivileged children and families around Manhattan. We use AT to record and track registration data, donation and donor info, grant applications, and job/intern applicants. We've built a foundation on our own, but now I'm looking for the right person to help us streamline, sync, and scale our bases. Essentially, looking for someone equal parts Developer and Architect/Advisor for a 2-4 month initial contract with the option to retain as an advisor at the offset. Compensation will have to be commensurate with experience and compatibility. We're a nonprofit so funds are always tight, but we want to invest in this development and will gladly pay the right person to partner with us on this project.If this sounds right for you shoot me an email: joshua@uptownstories.org and I'd love to chat further! 

Our non-profit has a database that is in Filemaker that I'd like migrated to Airbase. I'd like someone to provide an estimated cost.

Hi Airtable Community,I run a contracting company in the property restoration space. We have started renting equipment to other contractors during peak / spike events (like hurricanes and other natural disasters). We are looking for someone to develop the following overall process:We want the ability to "scan" equipment FROM our inventory TO a job (rental customer) right out of our Master Inventory of all of our equipment.We want those serial numbers / items to be automatically brought into the agreement we have the cutomers sign - more or less capturing (by product / type / serial #) the items they are renting.That is just the high level of what we are looking for. If interested, please respond and I can provide more detais. Thanks. 

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, Guy

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. Functions required: Assign order to factory Track shipme

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 app, the link preview will show a screenshot of the shared view as well  More details here: https://airtable.cool Please let me know if you have feedback/thoughts! I did this as a quick side project last week for personal use, but if there's demand, I can work on making it better/more performant

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 whenever a box has been checked an odd number of times (e.g. 3) this will round up the half length of the string to 2 (i.e. 1.5), but when it's been checked an even number of times, there'll be

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/how-on2air-forms-helped-consultant-and-construction-company/