Builders Board

Create a Day column : DATETIME_FORMAT(Date, "d") Formula for days names : IF(Day="1","Lundi", IF(Day="2","Mardi", IF(Day="3","Mercredi", IF(Day="4","Jeudi", IF(Day="5","Vendredi", IF(Day="6","Samedi", IF(Day="0","Dimanche","Erreur" ))))))) Create a Month column : DATETIME_FORMAT(Date, "M") Formula for months names : IF(Month="1","janvier", IF(Month="2","février", IF(Month="3","mars", IF(Month="4","avril", IF(Month="5","mai", IF(Month="6","juin", IF(Month="7","juillet", IF(Month="8","août", IF(Month="9","septembre", IF(Month="10","octobre", IF(Month="11","novembre", IF(Month="12","décembre","Erreur" ))))))))))))

Recently, a member contacted me directly asking for help … I am have been searching desperately to find a clean way to break apart an address like this… 123 anywhere st, San Diego, CA, 90001 Unfortunately, there is no “clean” way to do this without a Split() method as described in detail here. And rather than jumping to the end by showing a unified working formula (that even I would be unable to read), I approached this question by providing a framework for tackling almost any parsing challenges. Without Split() we are forced to fabricate rather complex formulas and like many of you, my brain is incapable of juggling a lot of string pointers to create that perfect [single] formula. And therein lay the issue - we often assume we must build a single formula from the beginning. This is neither necessary nor likely to be helpful. Sure, you want to use the fewest number of fields and create concise formulas for simplicity. However, there’s plenty of time to polish the code once you have s

Hello, i am new here and unfortunately not able to program. I would like to have a quotation from someone who is good at airtable to solve this issues: monthly order taking order export to supplier packing list insert by supplier notifications I have a privately designed app but the functionalities i see in airtable are much more advanced and my goal would be to substitute my actual with a “airtable” based one. Is anybody willing to help me? Thank you

Hello, I am new to airtable and would like to explore hiring a consultant to help on set up some automations and integrations for a startup company. We are currently working within the product catalog template, and have set up our products, vendors, etc. but now need help with the next few steps to make everything come full circle. -set up the page designer to create custom invoices that automatically populate from our orders, have the PDF integrate back into our client orders page, and automatically send them emails with their invoice PDF’s. -Automation within selections of items – where product selection and selected information would appear in a PDF/tear sheet with specifics (thumbnails, links, price, dimensions, etc.) Automations with a survey platform – we are currently using survey planet, and can only see how it is manually integrated. Creating and organizing a client database, with all of their information and files. Looking forward to getting some guidance here so we can get

Looking to create several new fields, likely in a new table, including “most recent engagement date” which pulls the most recent date from multiple date fields in different tables (e.g. events, tasks & communications), and “most recent engagement content” which pulls the corresponding text field from the record that was pulled for the “most recent engagement date”. We are trying to create a report that includes these new fields, and I think we will need to create a new table to do this. Looking for an expert in reporting across tables or advice for where to find a consultant who can build this!

HI, We are a production company with around 10 employees looking to hire someone to com in and give our team training on Slack and Air table.

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :yellow_square: Kanban Board Block Starting from today our new Kanban block is available. With the Kanban block you can visualise your workflow in a board view with stacked cards and sync any changes across from Softr to Airtable. :straight_ruler: Horizontal List Details Block This new List Details block is centred around a horizontal layout. This new block is perfect for reducing the amount of scrolling and aligns your fields horizontally across a column of 3 instead of vertically. :mag_right: New Hidden Fields We have added two new hidden field types, including Page and Full Name. These field types allow the sending of hidden data that you can use to identify users and pass the data across to third-party tools or integrations. :art: Softr Design workshop We are running a 1-hour live webinar today - hosted by our in-house

Hey Everyone, Softr is doing a free design workshop on Oct 21. :tada: :bulb: We will outline the best practices when designing your Softr website or application, demo the design options within the Softr studio, design resources, tips and tricks and time for a Q&A at the end to answer any questions you might have. :bangbang: More details and registration form here: https://softrdesignworkshop.softr.app/

Right now, we currently use AirTable as our e-commerce product catalog. But we have hit some limitations with the current setup. For instance, in order to update pricing and other product attributes we utilize the import CSV app for every single table within each base that we have. Which can be very time-consuming. So… We are looking for the ability to upload the spreadsheet with the various attributes in it to an entire base thus updating all of the tables. Below is a Loom video, which depicts our current process and what we are looking for as our desired solution. We are looking to hire an expert for this project within the week. Looking forward to connecting with an expert soon!

Here’s a simple yet powerful base I built to manage a community books library. You can use it to manage the borrowing of any physical items - books, wheelchairs, tools, etc. It includes: Automatic reminder emails a week before the designated return date Automatic borrowing and return dates Automatic borrowing statuses Library dashboard Feel free to use and tweak it for your own purposes.

The sheer amount of whitespace in Airtable has always bugged me a little, so I’ve been making little edits to the stylesheet here and there to get more data on-screen. Below you’ll find some screenshots of what I’ve done and the code required to make it look that ugly. You can use something like the Stylus extension/plug-in to apply the CSS to Airtable. Note: I’ve come up with this code mostly through trial and error, so use at your own risk. (Let me know if something breaks spectacularly and I’ll try to help, but there’s a possibility I won’t be able to figure out what’s going on on your end.) Also, the actual structure of the HTML is changing all the time, so don’t be surprised if the code stops working suddenly. EDIT: fixed code line-wrapping In this first example, I’ve removed the row number and expand record button from the grid view – I’ve always found them superfluous. (There’s also a header hack that reduces the vertical space quite a lot and smushes everything together which

The Problem: A common workflow in Airtable is the gathering of Surveys or Forms, and often we want to link multiple surveys or forms submitted by the same person back to a single Contact record for that person. However, exposing Linked Record fields to do this in the public form itself is undesirable because we don’t want form users to see all the names of existing contacts in our base, and it also precludes form users that don’t yet exist in our Contacts table. This leaves us using manual processes to establish the link between a form submittal and a Contact, where the form user is just entering their name or email address. My Solution: I’ve written a script for the Scripting Block that aims to solve this problem and automatically establish links between submitted forms and existing contacts. In addition, this particular version also logs a survey/form submittal as an “Interaction” in the Interactions table. The Script in Use: Here’s a short video demo:

My client would like to integrate Airtable with a handful of services. Each service provides access to API. Flexible hours. Thanks Jake

Last week I launched my FREE (unofficial) Airtable manual in French, “Airtable à z”. It is mostly for novice users, but I tried to make it interesting even for people with good knowledge of our favorite no-code platform. Sorry if you don’t speak French :winking_face: . The guide is 100% made with Airtable. The PDF was built with Page designer with the same layout for all the pages but 2… It was a bit of a challenge and I even made two versions, Landscape and Portrait (both on A4). I used Softr to build the website from the base. If you wonder why the hassle to make this manual it’s because there is no other supported language than English. La semaine dernière, j’ai lancé mon petit guide illustré, en français bien évidemment. Avec des centaines de liens d’aides Airtable traduits via Google Translate automatiquement. Le manuel est entièrement construit sur Airtable.Tout le contenu du site est gratuit !

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. :gear: Editing Table Blocks In addition to our recently released ability to edit List Details and List Blocks, starting from today you can now allow editing of Table Blocks :control_knobs: Conditional Chart Filters This new functionality allows you to apply specific conditions to your chart blocks. For example, say you want to show specific data in a chart block to a particular role you have defined within your application, allowing some users to see one set of data and the other another set. :yellow_square: New Blocks We are continuing to bring you more functionality and design layouts to take your Softr application to the next level. • Today we have launched a stunning new mosaic image blocks allow you to show multiple images in a beautiful new staggered layout. • Full-width image block which will take the entire width of th

With the upcoming upgrade tomorrow, now is a good time to think about your Airtable Backups Strategy. Of course, we all hope and expect the upgrade to go smoothly, but having a backup of your data outside of Airtable is always an Industry Best Practice. It’s an insurance piece of mind to know your have an external backup of your data in case of outages, accidental (or intentional) deletion of data/attachments, etc. Don’t worry if you’re not performing backups - you’re not alone! But today is the day to start. On2Air has you covered if you’re ready to start! For the fist 20 signups to our Backups solution, you can get a 20% off your initial subscription period (bigger savings on annual plan!) Check out the service: https://on2air.com/on2air-backups and on checkout use promo code: BACKUPNOW Oh and don’t forget to turn off any external automations (zapier, integromat, on2air, etc) you have running to avoid the error messages that will come while the Airtable database is down tomorrow!

We have an excel spreadsheet that we use to calculate pricing for customers. Our goal is to hire a consultant to develop a web enabled form that mimics the spreadsheet to add to our existing website as a self service option. Additionally, we need to add sign-on security so we identify the user and apply the correct pricing. The spreadsheet serves really well as a design template for our requirements. We will make ourselves available to collaborate on the business requirements.

We are looking to hire a consultant to help us set up a more complex workflow & automation. Here’s a brief synopsis of what we’re trying to do: We’ve started looking at how we can duplicate some of our client-specific views that we use for reporting purposes and we were wondering if there was a way to automate this duplication process. I believe that just using the duplicate option isn’t viable due to the formulas involved in each view and the different rollups required to set up the reporting view all need to be set up with it. We were curious if there was a way to automate this to where we can potentially set up and fill out a form and it automatically updates & creates the formulas with info that we input into the form, which would take this view duplication process from around 25 steps to just needing to fill out specific info into a form. Does anybody have expertise in this? Feel free to reach out to me here or at justin@famnetworks.com

Hi there, I’m part of a non-profit residential mindfulness center. We use notion and airtable for most of our systems including admissions, donation tracking, guest forms, and more. We’ve built it thus far in-house with a little bit of coding help. Looking to hire someone long term that can help with upgrading our systems including: Visual Dashboards to visualize our metrics (how many interest forms are we getting, tracking donation amounts, etc.) Custom links working with our Wordpress PayPal to create payment forms that will then automatically update AirTable record with paid and how much was paid Sending automated weekly reports of our various departments Financial Forecasting to track how we’re doing and more We’re pretty competent when it comes to making the tables and forms but the more advanced integrations and making it all into one system is a headache and would love some support for someone else to build it with us.

Disclaimer: self promotion Hi folks! We’re looking for users for the upcoming beta launch for Shoptable, a Shopify <> Airtable integration. Shoptable brings the power of the Airtable platform to Shopify merchants by creating a live, bidirectional sync between Airtable and Shopify. Using Airtable to run your shop means you can leverage custom tailored views, automations, and reporting tools to run your shop, all within Airtable. There are almost 2 million Shopify merchants and they all use the same Shopify Admin interface. We’re going to fix that. You can check us out and get on our waitlist here: https://shoptable.app/ Feel free to comment below if you have any questions.

We are a small content site that need a way to keep track of contacts which we use to interview for article research in our writing process. On most articles we try to find an expert and interview them about the specific topic. The goal here is to keep track of people we’ve interviewed so we can reuse them and also make sure we’re not stepping on each other’s toes and emailing the same people at the same time. Right now we are tracking in various spreadsheets individually and we have to check with everyone if they have contacts or who is talking to who and when. Key Features: Contact Table - captures key contact info, tagging based on expertise, display last time we talked Interactions Table - log all the interactions we have with the contacts in above table Contacts Table: We want to maintain a good list of experts we’ve worked with over the years so we can tap them again if there is a good match for a future article. We also need an easy way for our writers to add people and ens

I own a small furniture business in Sri Lanka. I would like to bring over all of my google sheets and set up all the documents on airtable with images so I can have my whole team using it. Would someone be able to help me. Thanks Jalal

Formula: IF( LEN(TODO_REPLACE_WITH_IBAN) > 0, IF( REGEX_MATCH( SUBSTITUTE(TODO_REPLACE_WITH_IBAN, ' ', ''), '^(?:((?:IT|SM)\d{2}[A-Z]{1}\d{22})|(NL\d{2}[A-Z]{4}\d{10})|(LV\d{2}[A-Z]{4}\d{13})|((?:BG|GB|IE)\d{2}[A-Z]{4}\d{14})|(GI\d{2}[A-Z]{4}\d{15})|(RO\d{2}[A-Z]{4}\d{16})|(MT\d{2}[A-Z]{4}\d{23})|(NO\d{13})|((?:DK|FI)\d{16})|((?:SI)\d{17})|((?:AT|EE|LU|LT)\d{18})|((?:HR|LI|CH)\d{19})|((?:DE|VA)\d{20})|((?:AD|CZ|ES|MD|SK|SE)\d{22})|(PT\d{23})|((?:IS)\d{24})|((?:BE)\d{14})|((?:FR|MC|GR)\d{25})|((?:PL|HU|CY)\d{26}))$' ), 1, -1 ), 0 ) Documentation: This formula checks if the structure of TODO_REPLACE_WITH_IBAN is correct (each country has its own specification). It only considers countries that are within the SEPA area. Specifications: IBAN Examples, Structure and Length SEPA countries and IBAN length - Google Sheets Google Sheet based on the above data structure, easier to work with Outputs: 1: Has a valid SEPA IBAN structure 0: Is empty -1

Hey there!Do you use both Airtable and Google Drive?Yep, every single dayEh, sometimesNopeI wanted to show you how you can automatically create invoices (or any document) in Google Docs using data from your Airtable base.https://www.youtube.com/watch?v=lg_h6kDAak0 This uses the On2Air Docs. It allows you to automatically generate documents in Docs from any data you have in Airtable.Copy the free Invoice Google Docs template and the Sales Base Airtable templateSet up the automation in On2Air Docs using the settings from the article/video (you only have to do this part 1 time)Click Generate Invoice in your baseView your newly created invoice in Google Drive and a PDF version in your attachments field in your Airtable base! Automated Invoice Templates in Google Docs and Airtable (+Free Template) |...In this guide, we’ll show you how to generate invoices using Google Docs plus how your can use your customer data in Airtable to automatically generate an invoice in Google Docs.&nbs

Hello, i need something similar to this video. My budget is 100euro, you can contact me on andreibobocea619@gmail.com. Thanks a lot! That’s not my video, is builded by somebody else but it’s over my budget.