Other Questions

I have a table with many fields but only a few records. Horizontally scrolling to see all the fields when there’s a lot of empty vertical space feels weird. Is there a way to flip the display of rows and columns so the screen space is used more efficiently for these kinds of tables? To be clear - I’m not talking about pivoting the data. I just want to see rows vertically to make best use of the space.

Good afternoon, I am very new to Airtable. You will realize it, if you read my post ! :slightly_smiling_face: I have a table with the dates and times of arrivals and departures of guests at the airport. I want to know the number of days I will have to allocate the cars that will transport them. The cars are rented on a full day basis. I am trying to calculate the number of days for the cars, taking into consideration the dates of arrivals and departures of the guests. I am using the formula DATETIME_DIFF({Date departure},{Date arrival},‘d’)+1 The formula is returning the result taking also into account the time of the day of the arrival and departure, and I really want only the full day. I believe that the solution is very simple, but someone can help. For example, one guest arrives on 26/06 at 11:00am and departs on 02/07 at 09:00am. the result that I’m trying to obtain is 7 days, and not 6 days Many thanks in advance…

Continuing the discussion from Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B: Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B To me this sounds like a job for a rollup. Not knowing the specifics of your base, I’m going to just take a stab. I’ve tried to make sense of a dozen posts about merging fields, etc. but can’t find something that I can understand, to merge two fields - which are referencing records in another table. Here’s the scenario: “Table A” has hundreds of sources “Table B” has a field “Column1” which links to a few records from Table A “Table B” also has a field “Colum2” which links to some records from Table A e.g. Colmun1 might link to 6 records e.g. Column2 might link to 7 records Some of the records in Column1 and Column2 are the same. Let’s say that 4 records are the same. We want to combine or merge Column1 and Column2 so that all linked records are in on

All, I’m trying to import a file doc file that exists in an airtable attachment field into Google Drive in integromat. So it actually creates a file, by the name that I have assigned. But when you open it, here’s what it looks like: You’ll notice first that it doesn’t open in editor. And what you are able to make out of the text is the address of the file in airtable (according to airtable). As far as the setup in Integromat, here’s what the settings look like:

Hello, I have a base that is currently public and a view that is also in "community" mode with presumably public settings, but logged-out users cannot access the records that I have linked in the Gallery. How can I fix this? Pictures of configuration attached.

I used the Airtable CRM template to build a CRM for my company.I have a Organization table that collects company data - a Contact table that collects individual's data - and a Events/Activity table that tracks what events/activities contacts have participated in.I currently have all of this data tracked in Google sheet.On my Contact table I have the organization table linked to the Contact table so I don't end up with two tables of data on organization.I can't figure out how to upload my contact data into the Contact table so that it uploads the organization data into the Organization table so it will be linked to my Contact table. 

How do I change the name of a table's "noun"; the noun is listed in a row's context menu: In this case, the noun is "vehicle".

Hi Airtable Community, I'm trying to understand the cost structure for Airtable licenses. Specifically, can a "read-only" user still submit product feedback through an integration? For example, a Customer Experience Agent who has a "read-only" set of permissions still submit product feedback through Zendesk to Airtable without being billed?

Hi everyone, I am wondering if it's possible to create radar charts using Airtable Extensions. I would prefer a way that allows me to create one with minimal code, but I am open to other methods as well.Thanks!

Over the past few weeks we made changes to our data. We have a main reference base where we link a number of tables from and after changing and deleting some information from that base, Airtable has been reallocating records (wrong ones) in every single linked table. Can anyone let me know how to resolve this? We have a table that has a list of organisation names that is synced to various tables. After we cleaned out that list, we realised that where Airtable would usually leave a linked record blank when something was deleted in the main reference list, it is replacing the deleted data with its own data (organisation names on the list 

Hi everyone! Just a simple question (so simple that the bot did not manage to answer to it) from a real dummy. I just use Airtable to store personal data (no shared base, no third apps use): will the API keys deprecating affect the availability of my datas? Will it prevent me from sign in into my bases? Thanks a lot to anyone who will solve my douts. 

When I type in the name of a task ticket in the Primary Field, is there a way to quickly confirm the name, exit the cell and make a new record?At the moment to do the behavior I'm asking about:-I make a new record, with the + or shift enter, enter in my name \ string, hit esc, then shift enter to make the next record.The desired behavior would be a hotkey or shortcut that combines the sequence Esc + Shift Enter.  Shift + Enter after string entry --while data entry in the cell is still active-- would be ideal to work with current new record behavior.

Have a base set up to track orders in progress for a commission artist:table 1: order detailstable 2: tasks related to orderPossible to create an interface that looks like an order summary card that includes:order details in left columnlist of all tasks linked to that order in right columnSo tl;dr -- how can you create a listed of tasks - specifically related to one order - in an interface page?

Hello all!  I'm using airtable for my inventory management system.  I'm using a bar code extension, and it needs a field to generate barcodes from that will be either 12 or 13 digits.  I already have a field that has just started from one and numbered each record / item sequentially.  So I'd like to change it to just add enough leading zeros that it will work with the barcode generator.  I don't even know where to start, and everything I tried to google was way more complex than my current understanding of code / scripting.  Would be easier for me to understand if there were a solution with airtable formulas but whatever works.  Thanks!

Anyone know what determines the start of the week in Calendar View? I have some bases where the week starts on Monday and others where it starts on Sunday, but I’m not sure why and I have no idea how to switch between them.

I'm new to my company and there are a lot of existing bases set up that I have access to where I can use the Gantt chart feature and other features on the Team Plan. When I go to make my own base, mine are on the free plan. I'm a paid user, so is the team plan based on the workspace? I'm confused why I'm paying for Airtable but have limitations with my bases that other ones do not have.If I do need to be granted access to the workspace on the team plan, is there a way to not have all bases visible to me, just the ones I've been invited to?

Hi, We are setting up Airtable to manage multiple clients with multiple projects and teams. Each client has is own Base, and each project has its own task list. Is there a way to see all tasks across all projects in one place? One of the main problems we are trying to solve is to find a way for each team member to see all of his or her tasks in one place even though they are located in various bases. Thanks for the help and suggestions!Best regards Malin

I'm not impressed with the refund process, and would like this issue to be addressed by staff. I know the forum is mainly users, but there is no phone number by which to reach staff. I was prompted by the automatic reply I received after emailing Airtable Support to leave a post in the forum as this triggers a response time within 72 hours. Evidently, I'm not the only one forced to go this route only to be repeatedly told forum members can't do anything, but we go through the motions nonetheless in the hopes of having our issue dealt with in a timely manner. So, my useless and ridiculous post poses the following questions in the hope that someone compiling forum activity for internal reports will flag it:1- Why is there no phone number by which to reach staff for billing issues? Being re-routed many times by a bot is frustrating, and submitting a Request Form feels like we'll just end up in a big stack which will only garner a generic response.2- Why are refunds issued in credits, and

Hi - I’m running into a problem when I try to group a list of events. The dates are from Dec. 21 up to Dec. 22 and I’ve one column witha formula that extracts the month from the date column. I can sort my table by the date field and it’s all fine, but when I then group by month, the order gets messed up. How can I create a grid view that is sorted by month and shows the month in the right order? And in addition with a two times December (21,22) entry?? Thanks for any help!

I am supposed to create an app in Power App. My data source is Airtable. Therefore I want to export the csv file from AIrtable to SharePoint or Excel Online automatically on daily basis. Kindly let me know whether this is possible and documentation related to this

I am new to Airtable and would like to know the best way to build the architecture around data and tables from you people who are more experienced Airtable users.More specifically I am building a Supplier database of approx. 100 suppliers. Each supplier have a unique ID as identifier. I would like to share this ID across tables, so that the records are linked to each other based on the ID.When creating a new record (supplier) in the main table, then I would like this record to be auto-created/displayed in the other tables (or than one can only add data for records that exists in the main table)My idea is that the main table is for the key supplier information and other tables are for grouping of data.Like tables for:Main tableContact informationPrice informationIntegration informationlogistics informationetc.What data architecture do you recommend or do you have a better proposal for how to build an internal supplier information database?

Hi there. Does any know how to prevent my csv data from breaking when I transfer it from a csv export to my spreadsheet?Problem (CSV Export Bug): When I export the data, a piece of the notes column rolls over into a new row, resulting in additional rows that are unrelated to any record.Thank you in advance! 

Greetings All,I have recently created a base paired with an interface that I believe could serve as a beneficial template for users seeking similar functionalities. It's important to emphasize that the key functionalities and features of this proposed template are primarily housed within the interface designers, relegating the base to a backend role.I am keen on making this template publicly accessible, and I wish to accentuate its interface-centric features prominently. Although I am considering the Airtable Universe as a potential platform to share this template since it seem the only spot for sharing "base" templates, I am uncertain if it is the ideal place given the significant interface-related features of my template.Could anyone suggest the optimal method to share this base and interface as a cohesive unit?Appreciate your insights!

I have a 'Learn more' URL link on each card, but when I click on it, it opens up to an expanded intermediary page showing the same link information.  I have to click another time to go to the destined URL. Is there anyway I can bypass the intermediary page?  Please advise.  Thank you.

I got 3 tables:  As you can see on table Lectures i started matching Lectures with Trainings one-by-one. But the list is very long. Do you have any idea how to match Lecturers with trainings on one table?