Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
Hello! First time user of Airtable, so bear with me:grinning: I have a Long text field that I am trying to limit the number of characters entered into it. From reading the the posts, it looks like that is not possible, correct? In another members post they suggested using LEN and COUNT, but I’m not sure how to implement it. From what I’ve figured out so far is that I would need to create another field (a formula field) to count the number of characters (including spaces) from another field in the same record. So, let’s say my long text field was named Product Description. What would be the formula entered (in the new formula field) to do a count of characters? Also, would the character count show in the new field and change as I’m typing in the product description field? Or if there’s another way… Thanks! Sue
Hello community, I created a DB to collect startup informations through a form.To impose a synthesis, I need to set a certain limit of characters for “long text” question.I can not find a way to do it with Airtable form, so I am integrating a different tool.Nevertheless, it’ll be more practicle for us to stay inside Airtable.Any suggestion ? Best regards,Marco
Good day.I have a “whole” staff table, with various “statuses” SOWs, Guests, and FTE. However, a newer table was linked to the base, with “special” contractor statuses. I need to have these “added” to the above Full Table, along with their statuses, etc. The whole needs to be the final source as it’s used across bases. How might I go about this?
I changed the primary field in a source table. I also want that to be the primary field in an existing synced table, but the primary field doesn’t change.If I go to “Update sync configuration” and then “Edit synced fields”, then select “Specific fields in the source...” it does not give an option to change the primary field, like you can when first creating the sync.I’m syncing a view from the source table, so I could create an identical, duplicate view there and then change my sync to point to the new view, but I worry about how that will impact all the lookups I have configured. Will I need to redo them all, even though the fields will actually be the same? So I’m hoping there’s a way for the synced table to use the new primary field from the source.
Hi, I am trying to set up renting hours for a local association and I am looking for the best way to do that.We have some outdoor material that can be rented by the hour. Would you have a smart suggestion for not having to write manualy 8 lines (8hours per day of renting) x 123 days (4 months of the summer) = 984 lines ?After we will see yo integrate that with a google calendar.Thanks
Hi,This question is a detail out from another question (here: https://community.airtable.com/t5/automations/dynamically-scalable-email-content-by-quot-tag-quot-instead-of/m-p/202260#M19754), for reference.I’m trying to abstractify our CRM’s mail setup using an automation with Find Record steps with Dynamic variables. One variable I need to use is “Tag” that links contacts to an area of interest (nature, sports, food, etc). Since I use the Tag classification in many places throughout the base (currently 8 tables), I have made it into a Linked Record instead of a separate Single Select for each table. Yes, I know that if I'd use Single Selects this would work without issues :).The problem is I can’t figure out how to use a Linked Record as a Dynamic condition in a Find Record step. I’d like to search exactly so I choose Tag “is exactly” from the Dynamic conditions. Then I only find a “Make a new list of” option, under which I can choose the tag (“nature” in this pic).Testing this setup y
Hey there, and welcome to the official Airtable EDUser Group! Whether you're a seasoned Airtable user or just getting started, this group is your go-to hub for all things Airtable as it relates to the world of education. We welcome you to use this space to explore, connect, and collaborate with other Airtable users in K-12, higher education, L&D or customer-facing EDU roles. Be sure to join this group hub, and subscribe to the group so you're notified of upcoming events and fun discussions. 🎉 To kick things off, lets introduce ourselves! Here's a template to get started: Name:Company/Role:Location:How has Airtable helped you unlock wins for your work in the EDU world? We can't wait to see the connections that are made through this group!
Hey everyone! We recently shipped two features for BaseQL that I’m really excited about.For those that don’t know, BaseQL provides a GraphQL API for Airtable that makes it easier to build custom apps with your Airtable data.These new features came directly from user feedback about workflow pain points.TL;DR: You can now query Airtable views directly and have full control over filtering/sorting related records in a single API call.Querying Airtable ViewsBaseQL now supports querying specific Airtable views using the new _view argument. This feature leverages Airtable’s powerful ability to create custom views with specific sorting, filtering, and grouping configurations.Why this mattersMany BaseQL users were manually implementing sorting through rank columns or creating complex filter combinations to match what they had already configured in Airtable views. Now, you can simply:Configure your data organization visually in Airtable using drag-and-drop Query that exact configuration with a s
I need to take the fields visible in a particular view, and convert it to a pdf that I can then send via email. Is this possible via airtable automations?
Originally when we created our system, we used text fields to record the Call Time and Gig Time Span. Since we have the time zones already saved for each record, I am wondering if there is an easy way to do the following: Switch the Call Time Field from a Text Field to a Time field (without having to type the time zone every time) Switch the Gig time Span Field into 2 different Time fields for both previous records and current records, a Start Time and End Time. Similarly, I do not want to type the time zone every time. Moving forward, I would like to only have to type the start start and end time for an event in separate fields (not in the text box).If this is possible, these would save a ton of time and allow us to do better, more efficient work. Thank you for your help!
I'm creating a form and need to create some conditions to separate our large inventory into categories. When I create the form view from the data table screen, and run a test the dropdown looks like the first snip below and appears to enter the data sheet with all of the correct information. When I add a new field and link to record, choose the same table, set up the conditional formatting and run the test, the dropdown looks different (second snip) and all of the information goes into the data table except for the name. As far as I can tell they are set up exactly the same way, the only difference is the Product ID field is automatically entered when I create the form view. Any ideas on what I'm doing wrong or how I can properly duplicate the product ID field?
Hello, I work with ships and would like to create a grams/day formula which takes the date from our last interaction (order) with that ship to measure from. I cannot work out how to have it search for the previous record to take that as the date to give the days passed value for the equation.Anyone have any tips?
Hi there,I wonder whether there’s a way to bulk print selected records with a page designer template. Currently there’s only a way to print either current record or records of a specific view. The problem: When the view contains more than 30 records it ends up in a browser freeze. So I wonder what possibilities does the community see to solve that. Thanks for your help,Florian
Hi there, Is it possible when creating bar charts that you can have visuals like we do on Excel or powerpoint? For example On the X axis I want it to have the month, Y axis to have submissions made but the actual bar to show the each teams who have made submissions for those months. Essentially, for one month it will have 3-5 bars which represents teams A-E Thank you
Hi Airtable folks, I’ve got this really fun bookkeeping base I’ve created, which I use in conjunction with Fintable.io (a way to push bank transactions into Airtable – highly recommend!). Since Fintable downloads the transaction names from my bank statements in all sorts of different ways depending on how the banks format them, I wanted to create a formula to extract the Vendor name from when I receive or send money through Zelle. The thing is that this can show up in a variety of ways:ZELLE FROM FIRSTNAME LASTNAME ON DATEZELLE TO FIRSTNAME LASTNAME ON DATEZelle Payment to FirstName LastNameZelle Payment from FirstName LastNameZelle Payment to FirstNameZelle Payment from FirstNameAnd so on… What I’m getting stuck on is how to combine two formulas I ended up creating: one that returns both the first name and last name of the person (but when there is no last name, returns some of the random extra characters after the first name), and one that returns only the first name, whether there
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.