Ask the Community

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

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...

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

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"} ] }}'

I need to have the formula to calculate the total revenue and profit from my sales records table, which has been linked to my product inventory table. The aim of this set up is to update records automatically with every sale.

Hi my name is Jerry.  I am not at all new to Airtable but my experience is not particularly broad.  I built our Airtable base 8 or 9 years ago and haven’t done any development work on it since.  I am not a programmer.My problem:I am creating a package receiving solution for our freight forwarding business.  We receive packages, log information regarding that package and place it in the racks for future handling.  I am looking for a way to easily add a photo to the package record during the receiving process.The process: A new record is created by scanning a preprinted, barcoded label which is then applied to the package.  The scan gun is then used to scan other information from the package such as shipper an

I have numbers 00001 to 00014, but have not listed the numbers from 00015 to 00200 yet because I to update photos with a watermark. However, I have records from 00200 onward updated and on the website. Is there a way to include 00015 to 00200 as empty records to maintain the sequence of autonumbering then input the record for 00201 and continue? I hope this makes sense.  thanks Linda 

Hi Dear Community how to add a column for updating the price same as ther second image Thanks         

Hi Everyone, I've started using the new interface forms and come across a few issues with loading. The latest one can be seen in the attached. When a client receives a link in an email to the form, then adds some text, they get this error when submitting 'Refresh Page to Submit Form' (Refreshing doesn't help)This works OK if I'm logged into Airtable but not from a incognito or anonymous users. The form is set to allow anyone on web to submit. Anyone else having this issue? looking for a quick fix rather that return to the previous forms Cheers       

How many rows/columns/cells can Airtable handle at its maximum limit? For example, Google Sheets can handle up to 10 million records. What’s the limit for the Airtable?

Hola, hay alguna herramienta para modificar los formularios por defecto, altura de las filas, espacios, quitar cabecera, etc.

Hi, I have about 50 task fileds that each have a status. They can be marked as Assigned, In Progress, Complete, Question for Supervisor,  Question for Administrator. Each field is a multiple select field, because sometimes there is a question for both the supervisor and the administrator. I have a view for the supervisor and a view for the administrator that are each filtered to only show tasks that have a question for them. I have a formula field for each them that pulls out which task has the question.The formula for the supervisor is as follows: (The admin has the same formula, just with ADMIN instead of SUP in the formula)CONCATENATE( IF({Task A Status}="Questions for SUP", "Task A"), IF({Task B Status}="Questions for SUP", ", Task B"), IF({Task C Status}="Questions for SUP", ", Task C"), IF({Task D Status}="Questions for SUP", ", Task D") ) This works great. My question is, what if I have a ques