Builders Board

I’ve been working on a time tracker automation that allows my team to update a status field and kicks off a time tracker in the background so they don’t have to worry about tracking their hours. The solution I came up with works well for me, but I have read through a few options from @Justin_Barrett and @kuovonne here Record timer script and here Time Tracker Block + Button to start? The Setup I have 6 fields Current status Current status change time previous status Previous status change time total time Current status = Previous status Check A view is set up with a filter based

Hi, Seeking an airtable consultant who can also code. Languages: node.js, serverless & AWS Lambda. Would be ideal to also have strong natural sense of UX/UI. Thanks, Jordana

FOMDM is a ministry that helps pastors meet the needs of the men in their church. We have created a growing database of resources available - now need to develop a way to Search & Display options. I.E. A pastor asks for resources related to Anger… We then provide him with a list of books, bible studies, DVD, MP3’s, message recordings and etc.

Good day, We are looking for a good consultant/developer business-oriented who can help us building a full process between all our touchpoints (Mailchimp, forms. Google ads and Facebook/Instagram ads, Zendesk online chat). Thank you Best. JA

The latest update (4.1 as of 10/13/20) makes the date field almost unusable.

Hey Guys, We are a vacation rental property management company that use Airtable for data keeping. Our model requires slightly more complicated than what we have on Airtable as solutions as we have the following layers: 1- Revenue table (bookings and collections that took place last month) 2- Fees (Our fees from bookings that took place) 3- Expenses (Expenses that we paid on behalf of owners and that we need to deduct from their net earnings) Our monthly Reports to our clients goes as follows: Summary page Revenue page Expense Right now, what I do is make all the data processes on Airtable, connect it to ClicData and then make a PDF for each client for one of these reports. Finally, I compile the 3 reports into one Statement PDF Report which I put in Airtable again and its automatically emailed to my clients. I would like to automate this part. I am thinking of a script that allows me to do the following:

Now that the Custom Blocks have been publicly announced, I wanted to show a block that I have built. :new_moon_with_face: Name: API Connection It can fetch data from a JSON API and populate your table with the data. :mag: Where is the block? On github - https://github.com/saas-developer/airtable-api-connection :video_camera: Demo :studio_microphone: I also have a course on building custom blocks on Udemy (I hope its not against the rules to post this) :dollar: Hope this inspires your hackath

Hi Airtable Community! I’m looking for some help with creating an automation or script (I don’t know if it’s that complicated). I need the record called Date of RTL to be updated WHEN the record called "RTL = YES. The date that needs to populate is the date in which the condition becomes true in RTL. Example: A5 Liquor was RTL=YES on 8/17/2020, which I manually selected. Right now it’s a manual process and as you can see, I’ve forgotten to update it a few times. It does not have to retroactively update the Date of RTL, but would be helpful. Cheers!

Hi there, My name is Ben and I’m a community manager for a US based tech brand. I’m looking to set up a comprehensive database of published reviews & coverage of our products, full list of our important contacts, and a tracker for products we’re looking to send out to publications. I have somewhat limited experience here although I do have a decent base for this project set up. I would love to talk more regarding specifics as soon as possible!

Looking to hire an expert in database design (a good understanding of Airtables new sync feature is a plus) and an expert in writing script. I like to learn and understand some of the basics, but occasionally need help to to get going in the right direction instead of figuring out by trial and error :slightly_smiling_face: Thanks

# Re; Dynamic reasons to reachout {your social signal} This is first of a series of Airtable Base templates that will make your sales outreach more effective by being relevant at Scale lean more in the Learning Center #1 - Create a simple but very effective reason to reach out , using the {action} ( a comment, a like , sharing post ) in a {Channel} ( Linkedin, FB, Quora, Medium …) and the {Keyword} ( what was it about) ​

Is there anyone out there that would take what I have done and make some changes for me? bill@tuckpixs.com

Looking for someone to build my airtable on 11 users we are a wood factory we produce furniture and we need to make a base for product production and making production updates for each order I did a base and I need someone to help me build it !

I don’t have time now to learn how to develop an Airtable Base. I know what I need and want to use. Therefore, I want to hire an expert to build a simple Base for me, which can then be made more complex little by little. The first development is very simple. Surely I can learn and do it by myself, but now I prefer to hire someone to do it for me. Regards. Juan Carlos

I played around with Apps for the first time today. I built this (alpha) tool https://github.com/UnlyEd/airtable-app-bases-compare which basically prints out a Markdown text about the base configuration (all tables, fields, options, etc.) and can then be used through another Text Diff checker tool to figure out what the differences between two bases are. This is essential to us because we have bases that must be eventually sync (staging > production) and we were getting lost in changes until this. I hope you’ll like it as much as we do. Keep in mind it’s still an alpha version and subject to massive changes, but it does work and might help you today. :s

Hi I am a consultant working in pro sports and am keen to understand more about Airtable. My data/information services can possibly delivered via Airtable, where I am currently using Google Sheets and PDFs currently. Each client would require their own environment (workspace) and I would be refreshing their data daily/weekly (which is another question I will need answering). I have read plenty on here and watched YouTube videos, but I would really like to understand the more about the client UX for when Bases are shared externally, via links. Ideally, my clients will be ‘read only’, for the Bases, and I would be keen to see an example of their User Experience - can someone send me a link or provide a video that would present this? Furthermore, would they be able to manipulate the Kanbans, or would that require a different level of access? Thanks for your help.

Hello Airtable experts! :wave: In our agency and freelance no-code work, we’ve noticed a really strong growth in the volume of no-code projects, especially in the past year or so. Luckily, it seems like no-code is definitely becoming an appealing solution to more and more startups, solo founders, but also “traditional” companies. Being that the first generation of makers is already out there, with many of us starting agency businesses or working as freelancers, we wanted to create a freelance platform dedicated specifically to no-code and put our skills and expertise in front of as many clients as possible. With a lot of awesome learning communities around, there seems to be a gap when it comes to finding a good amount of no-code project work in a single place - I am sure many of you are over the chaotic search for the few no-code jobs on Freelancer and Upwork. On top of that, the upfront bidding process on such platforms makes sustainable and rewarding work a pretty

It always surprises me when professed experts are unable to truly understand a market’s topology. How is it possible to claim to track the no-code sector with the list of tools and services referenced in this article? Seriously (trends.vc)!?! These are the “no-code players”? I can think of one that’s missing - rhymes with fair-label. :winking_face: Carrd Webflow Bildr Adalo Glide Softr Bubble Sha

Base -> HTML -> PDF This “show and tell” is based on a project I worked on for the Computer Museum of America (see this post: TimeLine of Computer History). Airtable Pro plans can make use of the Page Designer block, but if you don’t have a Pro plan or want something that is a bit more customisable, then this might work for you. Really, this is about outputting base data into a PDF, but uses HTML as an interim step. The benefit of HTML is that is hugely customisable and, by using CSS, you can pick from a huge range of colours, fonts, layouts and so on. Possible use cases for this might include product catalogues, invoices, brochures, data reports and so on. Or even large format wall displays 100ft long :slightly_smiling_face: The code I used in the CMOA project was very specific to that piece of work, so this is a more generic way to ge

I have an SMS app and want to link the responses from a phone number to a first/last name in my database.

Hi Airtable lovers! :rocket: I wanted to share a personal project I’ve been working on :slightly_smiling_face: I started my Youtube channel because I want to help more people build (and more importantly, UNDERSTAND) nocode databases because I know how challenging it can be to get started. The first tutorial series is on building a great CRM. Here’s the channel: https://www.youtube.com/airopsconsulting Here’s the most recent video: https://youtu.be/exIYtS4EdFA This video is great if you want to learn about how to link tables within your base and why using views is so important! Thanks!

Would love to share with the community here a UserStyle that modifies the display of Airtable’s Kanban view to make better use of available space and simplify the cards UI. It also applies thin scrollbars all over airtable.com (this block may be removed) and modifies a collaborator field with the title “Action of”, if it exists. Don’t get me wrong, the Airtable team is doing a great job, but the chrome is a bit on the heavy side with all those borders. Several design choices are “embedded” within the implementation, therefore impossible to modify. See here for the UserStyle and instructions on how to use it: https://github.com/Arty2/userstyles#airtablecom-neat-kanban

So I typically input the data from my excel and copy past it here. But many of my records look weird, and i have to manually fix them. How can I Avoid this problem ? in the scrreen shot only the partial name shows up.

UPDATE 09/05/2020 - The new “updated record” trigger for automations makes this workaround unnecessary (more notes in a comment farther down in this thread), but I’ll leave the thread here anyway. Using Airtable’s new (but still technically in beta for Pro-plan users and up at the time I’m writing this) automation features, how can an automation pick up all changes to a field? It wouldn’t be a new record trigger, and the only other option right now is a new record in a view. If the field in question was simply going from empty to not-empty, the triggering view—and any connected automation—would pick it up after the first few characters, and wouldn’t operate on the full contents because the record would need to leave the view and re-enter it again to re-trigger the automation. So how can a lengthy change to a single field re-trigger an automation multiple times so that its full contents are processed? As with many things, it’s a m

Data Explained 2.0: Airtable flowchart block does not suffice unfortunately Hello there, we are looking for help with the following: We want to connect a database in Airtable to a Flowchart tool. We want entries from Airtable to get imported into the flowchart tool as described below. The Airtable database Our database contains several rows and columns. Each row contains survey responses of 1 user and each column contains that user’s response to survey questions (each response is text such as: “I looked at a datafile”). For example: Row 1 might contain the data for user 1 and user 1 might have given the following responses in columns A-C Column A entry: “I analysed data” Column B entry: “I checked the results” Column C entry: “I verified the assumptions” The flowchart tool We now want to import this user’s responses to a flowchart app so that these 3 responses “appear” in a flowch