Other Questions

I have a formula that pulls text from another field. That field is a link to another table. Airtable is creating quotation marks around the text if the text contains any punctuation marks. Is there a way of stopping this??

Hi all - I have a table in grid view that I’m trying to group and then sort alphabetically. The table is: Grouped by StateOrProvince from First-Last Sorted by StateOrProvince from first-last No matter how I group, sort, etc. I can not get the table to group/sort alphabetically by State. Any insight you can offer is so appreciated. Thanks!

Does anyone know what the character limit is for the length of URLs of photo images exported in CSV files? Is there a way to limit the URL size/length?   

first off: recurring issue: where can i report bugs?the record history seems to give wrong information when the change in the record was an addition of a linked record. the record history should say "[USER] created this ['record' or custom name for record as per table settings]" but it does not respect the table settings of the related table and does not use the custom name of the record of the linked table.i.e. i have two linked tables, one called "products" and one "sales". the tables are set up so that records in the "products" table are called 'product' and in the sales table are called 'sale' (for example in the footer of the table when summing up etc).when i create a record in the sales table say 'sale #5239234' related to say the record 'GREEN APPLE' on the product table, the record history of that 'GREEN APPLE' records should say "[User] created this sale" and display the change in the link-field. instead it says "[User] created this product", but i crea

Hi all, I’m currently trying to set-up a pie chart via Airtable’s ‘Blocks’ function. Is there any way to choose my own colour for each of the segments? The default colour scheme that my pie chart is using is completely contradictory from the labels of each of my segments - and I can’t find a way to change it. Any ideas? Thanks in advance. Cheers, Mark

I am in Real Estate and have created at table for all my transactions.  Some date fields are calculated based on a formula.  For example, a Loan Application is due x# of days after contract date - it can vary based on the contract.  I am creating a template that lists tasks based off that calculated date.  I create the template and choose a relative date but the calculated date is not listed, only dates that are manually entered (vs. calculated) are showing.  Does anyone have any suggestions on how to accomplish this?  

Hello! I'm trying to create an email automation to go out to my team on a weekly basis that would display our top three social media posts by engagements within a certain timeframe. I've figured out how to set up the email and created a view filtering for that timeframe and sorting by engagements. I've seen there's not really a way to limit a view to a certain number of records automatically, but I wondered if anyone had any workarounds or ideas for setting up this email to go out without the entire list having to go out each time and without me having to go in and manually change something in order for the email to go out? Tall order, but appreciate any help.

Hi, I'm currently on a free plan with five editors. We are considering upgrading to the Premium Team plan. But wnat to clarify if $20 a month means we can retain our five editors from the freemium plan. 

Hey guys,I am trying to find a way to relink Personnel records on a base with synced tabled from 2 different bases in order to limit interface views off Airtable accountsBase Personnel - All Personnel info including airtable account using the User Field typeBase Project Tracker - Overall project information including Personnel like producers linked to record on a synced table from the Personnel base. Airtable accounts are a lookup field.Base Asset Tracker - Synced to Project Tracker to assign assets, pulls over information like producers. Also synced to Personnel base to assign assets to people. The synced Project table on the asset tracker currently pulls over the producer information but obviously as a single test field with the producers in a string out. Obviously I can't change the field type to relink to the Personnel synced tab

Hi !I have the team plan, previously plus, with the bonus payment of 10usd per collaborator per month.If I add a new collaborator, will I still maintain that price? Or will I start paying 20usd per collaborator per month?Thank you.

Hello all My script below, looks through records in a table to find any records that have a field value that matches the record that kicked-off the script (automation) when a button was clicked. The field used for the condition is a Single Line Text field (Tracker Cycle ID). The actual value being compared is passed into the script via input.config (matchCycleID).  I do not get an error but the script does not work as intended and the script editor tells me "This condition will always return 'false' since the types 'string' and '{ readonly matchCycleID: string; }' have no overlap.(2367)".  I would assume the value of the field being passed into the script via input.config is a different type of 'string' than the value in the record being compared (record.getCellValueAsString('Tracker Cycle ID')). &nbsp

Hi to all 🙂We have a couple of bases shared within our team members. I would like to see if anybody is 'inside', and to see what is he doing in any of bases. Is it possible to set somehow?I know about the options 'last time modified' and 'the person who last modified', but I would need some more accurate and in the real time.Thank you all, wish everybody Happy Holidays 🙂

Hello AllI send automated SMS to a list of contacts that is present into another table with the lookup function.My problem is the phone numbers are displayed with a coma as a separator (see picture below) and my sms provider does not recognise it. I would need to have  semicolons instead of commas Can you please help me with the syntax in case I would have some formula / rollup ?thank you 

Hello,I, like many here in the AirTable forums, have dealt with seemingly "random" file deletions. One of the issues with this bug is that it is often sporadic. However, I have recently refactored one of my cloud processes that processes data from a record, generates a data file (application/json type) and puts it back into the record. I have a consistent set of records that I can run this process on, and I can literally watch my process write in all of the files, and then anywhere from 1-20 seconds later I see the files deleted  realtime! I know that my code is doing nothing to actually delete the files, and you can even tell from the record history that something is awry because the original file write is by our "Software" user and it specifies the Users token, and then the deletion is also done by the "Software" user but no token is specified (see attached screenshot). I feel confident that I have no old API key based processes that would be doing this action. 

Hello community!I have a problem, which I've been unable to resolve myself.I have two different tables, of which one table contains different entrees (table 1), which get combined in the other table in groups (table 2).Now, in the first table (table 1) with different entrees all entrees have a name connected to it.But in the other table (table 2) that groups these entrees the name should also be shown (rollup from table 1).Now the problem is that the groups of tables exists mainly from entrees with the same name. And if I show the name through rollup, I see the name many times, not just one time. I would like to only show the name once if the entrees all contain the same name.Hope my explanation is clear.Does anyone know how to do this?

I have attached below all the images.In number, it gives me 100.In percentage, it gives me 10000%but I want only 100%   

The Team plan is $20 per seat/month billed annually. Does the "per seat" mean users? So if we have 10 editors, it'll be $200 per month? But the plan also says it includes unlimited editors. It's very confusing...

I often copy data from several fields at once, so I need to use a horizontal scroll to select all the data, which is not really user-friendly. That’s why I thought maybe it’s possible to create a button field that copies data from some fields of the same row and sends it to the clipboard. I did some research and figured out it can’t be made with built-in Airtable features. I guess custom scripting may help, but I’m not familiar with JS, so I have no idea where to start or if it’ll even work:sweat_smile: Any help would be greatly appreciated!

Hi Community, I am attempting to develop a QC DB for my international QC inspectors, in my dept we manage over 18,000 unique item id’s manufactured by over 400 factories, in 20 different countries . I keep a list of Item IDs and Factory IDs on a source of truth database which I have synced to my prototype inspection DB. For Simplicity Sake, these two tables, within source of truth DB, are as follow, Item IDs Table Primary Field( ITEM IDS) Secondary Field(Factory IDs-linked to Factory IDs table) Factory IDs Table Primary Field(Factory IDs) Secondary Field(Item IDs-linked to item IDs table) Within my inspection database, I’ve created 2 linked fields within the inspection table. Filed One(Factory ID-linked to factory IDs) Field two(Item IDs-Linked to item IDs) I would like the QC inspector to enter a factory ID in field one… after which I would like the QC inspector to select an item ID in field two… And alas we reach t

Hi guys, I have created a "date field". 3:19 pm is my current time, but once I had it created, it showed the wrong time - 12:00am, I tried to click "use the same time zone for all collaborators> GMT/UTC", but the time was still wrong. I don't understand which step I had made wrong. 

Is there any way to change different versions of domains to its root domains? example: If we add Column 1 https://www.domain.com/ https://domain.com/ https://www.domain.com https://domain.com http://www.domain.com/ http://domain.com/ http://www.domain.com

Anyone found a way to control the font size on Print View?

Hi there, I'm having issues with formatting when pulling data from Airtable into Formstack Documents (integration via Zapier). Detailed explanation below.The Profile field in Airtable has a large body of text and is formatted with line spacing between each paragraph. However, when I create a document merge via Zapier into Formstack, the formatting is gone in the merged PDF. All the other content in the document is fine as it's part of the PDF template, whereas this Profile section is dynamic so it must be pulled from Airtable. Other fields are pulled from Airtable, but they usually only go over one line so I haven't noticed any line spacing issues.I'm not sure if this needs to be resolved via Formstack itself, or if it's the way I've set up the PDF template in Adobe Acrobat. Or perhaps something else entirely.Any suggestions would be much appreciated!

Hi there -- I'm using Airtable to build a database of jounalists on Meta's Threads. I've made a form so people can submit their details: https://airtable.com/appWgEz1pjYySqFTj/pagzqw2grYU9luJob/form My base consists of four tables: Journalists, locations, publications and beats. The form primary creates a new record in the Journalists table, but I'd like to use the same form to add new records in the other three when necessasry -- i.e. if someone works for a publication that isn't listed.Is this possible? With apologies if this has been answered before -- I did a search around but couldn't see anything relevant.CheersDave

I’m trying to automate an order ID. So when a new row is added, it is given an automatic ID. The existing ID from pre-AirTable looks like: LS000000 E.g. LS and then six zeros. The first order should look like LS000001, the next order like LS000002 etc Currently I use: Field 1 - AutoNumber (AutoID) Field 2 - Formula = CONCATENATE(“LS00”, (AutoID)) Which gives LS001, LS002 etc. It looks right when we get to LS001000 e.g. all 6 digits now present. Any ideas how to force the six zeros from the start?