Ask the Community

 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!

Is it possible to export a revision history? And if so, can a specific date range be specified?

Hello. Thanks for any help regarding this.I have an integration running in Google Sheets where Amex charges are downloaded into a Google sheet, almost realtime.  My goal is to create a connection so that when a record is created in Google Sheets it is copied into an Airtable base. I think it should be just one way from Google Sheets to Airtable.The challenge is that the integration between Amex and Google sheets deletes all existing records and does a full re-creation of ALL the records in the Google Sheet whenever a single row is added.I didn’t realize this when I created a Zapier Zap to create a new record in AirTable every time a record was added to the Google Sheet. Before long I had thousands of Zaps on hold.  For example, in the Google sheet if one new Amex charge is added, for some reason it deletes the 500 existing rows and adds back 501 new rows.  I asked support for that product why they do it, but I’m certain they’ll have their reason. Just haven’t heard back yet.So to make

Hiya! New user here, so forgive me if I’m being silly! I’d like to limit character input into forms to a certain length (let’s just say 32 characters for argument’s sake). The proposed form is for clients who want to submit product descriptions to an app (hence the need for character limits). Now I could go through and check each one individually, but it’d be great if I could just set a limit warning instead. I read this previous post: https://community.airtable.com/t/limit-characters-in-long-text-field/7353 but it still doesn’t solve the client-facing form issue. One thought I had was another app integration? I haven’t checked if this is possible yet, although I suspect I’ll fall into the same character limit problems. Has anyone got a suggestion or a neat way to make this happen? I’d be much obliged! If you don’t think it’s possible, please leave a comment saying so - it’d be great to know either way!

Hello, I have a base that has the date and time in one field, I have created another field and I would like to have that field enter the YYYY from the date time field using a formula. Would anyone know what the formula would be? Thanks in Advance!

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?  

So I have a table called Investors. Say there are 300 records here. And I have a table called Companies. Say there are 100 records here. And I have a tabled called Individual Investments. It’s the intersection of Investors and Companies. An investor can invest in any deal they choose and invest any amount. So I might have, say, 2,000 records here (but obviously I wouldn’t have more than 30,000 — which would be if every one of the 300 Investors invested in every one of the 100 companies). In the Individual Investments table I list the Investor, the Company in question, and the amount they invested. We’d like to send a report to each investor that lists all their investments and how much they invested. I once figured out how to put this together in the Page Design block and I’m sure I can muddle my way there again (or come here for help) but I also want to email out this report as a PDF. And not just one big report showing all 10 investors what all 10 invested in, but a customi

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?  

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

During the keynote, the speaker showed an interface that had a interactive map with a list of records shown along side it. Is this a new feature or an existing one? How do I use it?

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

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?

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?

I have a table linked to an application form. This table has a field with a check in it.I have another table within the same workspace for people that are referred, also with a check in it.Right now, new members apply and then I have 2 records: one from the application form, another from the manual enter I did as the person got referred.I want the system to update all records when someone applies using the form, so it doesn’t create another record, but fill in all the information on the already created one. Is this possible?I can’t seem to make it work via automations. 

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 

I had AI Labs turned on and noticed the new 'Ask AI' feature appear when looking at my interface. In my testing, it seemed like it'll return any information from the base to someone who asks. Does this feature only work for people who have base access, or will it also return information to interface-only collaborators? 

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 

I am trying to display field values within a text element in interfaces, much like in Page Designer, to support detailed instructions. For example:To create a new workscope:1) Please take note of the Case Summary Name first: {Case Summary Name}2) Click the button below to create a new workscope.I have tried using {Field Name} and converting it to code with the <> button, but that doesn't work.Other suggestions?

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

Hello all, I am trying to automate/ organise/ consolidate the way i run my Shopify product information.I use Airpower (a 3rd party API integrator) to sync Airtable to and from my Shopify.I am trying to create a product description field (rich text/ HTML) then sync it to my Shopify product information field.Currently:My product information field is in Rich Text and will sync across to airtable. What I want:I wanted to split the field further - e.g. About The Item, In the Box, Compatibility So that I can make the formatting more consistent ​​​​The Result Format I want: <h3>About The Item</h3>This phone case is… The colour is… It is made of durable plastic etc...<h3>Compatibility</h3>iPhone 16 Pro iPhone 16<h3>In The Box</h3>Phone Charger etc.Is there a way to achieve that using formula (e.g. concatenate)? Thank you!

Has anyone successfully engaged with the Airtable sales team via email? I have submitted the "Contact Sales" form about 5 times over the last month or so, here: https://airtable.com/contact-sales?ref=htcs.prd&_gl=1*1555h4p*_ga*MTkwODg1MjkwLjE2NjY5NjkwODA.*_ga_VJY8J9RFZM*MTY5NzU2ODA3OS4xNS4xLjE2OTc1Njg3NzAuNTcuMC4w Has anyone successfully gotten in touch with a salesperson to get pricing/information about an enterprise plan?

Hello everyone,I am experiencing lag issues across the different interfaces I provide to my users.Pages take a very long time to load, which makes it difficult for my colleagues to manage their work.Do you have any solutions or advice to help minimize the loading time between pages?Best regards,Zeel

hey all,I try to render an image in page designer. It works fine for uploaded images but if I only have an Image-URL - How can this be shown on the page designer. Thanks for your helpFlorian

Hi! good day!I am currently using the formula below to determine if a record/records is within last weeks Sunday to Saturday. Sunday being start of the week and Saturday being end of the week. AND(       IS_AFTER(           {Time in},           DATEADD(               DATEADD(                   TODAY(),                   -WEEKDAY(TODAY(), "Sunday") - 7,                   "days"               ),               0,               "days"           )       ),       IS_BEFORE(           {Time in},           DATEADD(               DATEADD(                   TODAY(),                   -WEEKDAY(TODAY(), "Sunday") + 0,                   "days"               ),               0,               "days"           )       )   ) If today is the 20th of June then my Current formula will tag my June 8 , 8AM record as false. If I adjust the time to 8:30AM, formula will tag it as true, would like the formula to include the entire day of sunday up to the entire day of saturday. Appreciate the help!

I want to use server-side Airtable API calls to completely replace all options in a "Multiple Select" field type. Specifically:Current options: A, B, C Via API call: First delete all existing options (A, B, C) Then write new options (D, E, F) ​Question:​​ What is the correct request body structure for this operation?I've tried the following JSON structure, but always receive this error: { "error": { "type": "INVALID_REQUEST_UNKNOWN", "message": "Invalid request: parameter validation failed. Check your request data." }}My attempted API call:--data '{ "options": { "choices": [ {"name": "D", "color": "blue"}, {"name": "E", "color": "green"}, {"name": "F", "color": "green"} ] }}'Key Points:​​Field type: Multiple Select Operation: Complete replacement (not incremental updates) Error persists despite correct authentication and field IDCould you provide:The exact JSON structure required for complete option replacement? Any special parameters needed (like enable