Other Questions

Hello, I have a table in the following format: Each record consists of a model of shoe we will produce, and the number columns are the sizes (Brazilian sizes). So we have sizes 33,34,35,36,37,38,39,40. In the size columns we have the quantity we will produce for each size. The column supplier is the supplier who will produce I would like to make a pivot table with the following information: Supplier Size Quantity Sup #1 33 0 Sup #1 34 16 Sup #1 35 17 Sup #1 36 18 Sup #1 37 25 Sup #1 38 16 Sup #1 39 12 Sup #1 40 0 Sup #2 33 5 Sup #2 34 12 Sup #2 35 16 Sup #2 36 19 Sup #2 37 24 Sup #2 38 17 Sup #2 39 13 Sup #2 40 7 The reason why, is that i want to visualize the data in the first format, but export a csv in the second format. Any idea how to do it? Thank you

Hi there, Is it possible to do a rollup field where you only add the values based on a certain criteria? Please see the graphic below which I think illustrates what I’m trying to achieve vs. what I’m currently getting with a SUM(values) rollup field. I think I have to try and write a conditional rollup. I tried this: IF({Player} = {Player}, SUM(values), 0) but with no luck (probably obviously). In plain English the formula I am trying to write is - if the player is David, show David’s career points total. Any help would be greatly appreciated. Thomas.

Can people with view-only links see blocks?

Hi there! I am new to airtable. I am having an intention to do bulk meta description requests for list of domains I’ve got. Please suggest me the best shortcut, I guess the best option should be Google MetaData API, right? Is there any way to connect airtable directly to Google API without 3rd party? Thanks! Eugene

I am tracking badges earned each year for a kids club. I have a member table that contains info about each member, such as what grade and club they are currently in. I plan to create a Badge table that will contain the names and dates for badges earned. It needs to have a separate record for each year for each child. When I create a record for a child this year, I want to use the current year, the club, and the name to generate a sort field for the record. Next year I want to be able to do the same, but the year and possibly the club will be different. I don’t want the sort field in previous records to change. Is there a way to do this without having to manually enter the sort field info?

Hey guys, I’m having a problem when using a formula that refers to a column that uses SET_TIMEZONE Here’s what I have Column 1: Formula: DATETIME_FORMAT(SET_TIMEZONE(CREATED_TIME(),‘America/Sao_Paulo’), ‘DD/MM/YYYY’) Output: 27/02/2020 Column 2: Formula: DATETIME_FORMAT({Colunm 1} ,‘MM/YYYY’) Output: #ERROR! Can you please show me what am I doing wrong?

I have the primary key column with a single line text field of venues. When I attempt to sort them in ascending order 1 record won’t sort correctly. Cate’s Place, South Australia – is sorting before Adelaide Recording Studios, South Australia. All the other records after this are sorting perfectly. I’ve even tried removing the apostrophe, but that didn’t change anything.

Full disclosure: I have absolutely zero experience with JavaScript (learning as I go!) which is why I am completely lost here and can’t do much searching in other people’s posts because I won’t understand the code. I have three templates that I want to make available to my team, all separated into views within my Marketing Tracker table (views: Webinar Template, Content Template, Event Template). The script that I currently have (below) requires me to choose one of those views (in this case, the Webinar Template). Ideally, I’d like to allow my team to 1. pick the record they are creating from (selectedEvent below) and 2. pick the template they want to create from (Webinar, Content, Event). I can’t figure out how to create two selections for the team (one to pick the record, and one to pick the template). See screenshot 1. The other thing that crossed my mind is, if possible, to have the script reference another field (if field #1 = “event” then create based on Event Template, if field

Im looking for some support to help with block views. We have 30 + clients who are all at various stages of progress and Id like a single block view to help me see. A client paid for 10 and has 8 booked, 2 remain Overall view of meetings, ie 150 paid for - 50 booked in Status of meetings etc Airtable Client View: Axiom Workspaces (14 Meetings) - Airtable Explore the "Client View: Axiom Workspaces (14 Meetings)" view on Airtable. Is anyone able to help us create it?

I’m trying to get the parent name based on the page id and parent page id, the image below will exemplify better what I’m trying to accomplish. Does anyone here already did something like this or is aware about some Airtable native formula to do that?

I had the word ‘STUPID’ show up as the last name of one of my customers. (I have no customers with that last name.) It showed in bold up on top of the record, but not in the field, LAST NAME. The customer’s correct name was listeded in the LAST NAME field. The comment section on the right did not note that anyone had changed the name to STUPID. When I went back to check the customer’s name on the main list of customers, STUPID was no longer showing up anywhere. I feel like someone was messing things up in back of the record. There are only 4 employees who use Airtable in my office. Any ideas?

Hi, We have two separate paid workspaces that we want to combine into one. Is there an easy way to transfer bases from one workspace into another workspace that is under a different account?

I want to create a new form using Typeform block on Airtable share base. I can’t use this and I get error: Something get wrong If you continue to experience this error, please reload the page or contact the block publisher. I tried reload page few times but it didn’t work. I can’t send message to e-mail adress partnerblock+typeform@airtable.com. Could you know what is wrong with this?

Hi. Is it possible to completely turn off sharing of the views? Our company data is private and confidential and I want to be able to completely turn off data sharing via: shareable grid view link (allows read only access to an entire view) or form view (allows data input into the base table) If this cannot be done we cannot use Airtable; it is a deal breaker for us. I am surprised there does not appear to be a simple option some where to do this. Am I missing something? Thanks in advance for any help offered. Jim

Hi there, Quick question about the revision history. Let’s say I created a record on January 1st and then upgraded to pro on March 1st. Will I see the revision history of January and February after I upgraded? Or the revision history only keeps track WHILE in pro? Thanks!

I’m trying to show a chart where records are counted and grouped by week. Nevertheless, the weeks where there are no records do not show on the x-axis. I would have liked these weeks to appear on the timeline with the value 0 rather than not showing up at all, which is misleading.

I’m am creating a database of sighting records of bird species. Each record includes: ORDER (a taxonomic unit for a grouping of species which may include one or more FAMILIES) FAMILY (a taxonomic unit for a group of species which may include one or more GENUS) SPECIES (the individual species) DATE SIGHTED (date species seen) Etc. For reporting, sightings need to be sorted based on the standard taxonomic order of ORDER>FAMILY>GENUS>SPECIES. I imported my sightings from a CSV in the standard taxonomic order. For example, the first set of sightings include: ORDER (Anseriformes - Waterfowl) > FAMILY (Anatidae - Ducks, Geese, Swans) > SPECIES (Anas platyrhynchos - Mallard) > DATE SIGHTED (January 1, 2018) ORDER (Gaviformes - Loons, Penguins & Petrels) > FAMILY (Gavidae - Loons) > SPECIES (Gavia Immer - Common Loon) > DATE SIGHTED (January 5, 2018) My question is how I create reports that apply or fix standard taxonomic order that always puts ANSERIFORMES fir

I am brand new and testing this product and like what I see. I must be rather clueless because I can’t even figure out how to post a link from any source. Am I missing something?

As you can see in the image, the id User can group the same records with the group button, but the Is it possible to show only the ones in this group with the most recent update?

Dear Airtable Team, Here is a video comparing the display of a long list of “products” linked to an “order” on 3 different phones: 2 iphones 7 ( A1660 et A1778) and 1 android phone (Redmi by Xiaomi). The 2 Iphone 7 have different behavior when we click on the “see all X linked Record” (there are 12 records, only 10 records are displayed). The Iphone 7 A1778 (in the center in the video) displays all 12 records correctly. The Iphone 7 A1660 (on the right in the video) displays the 10 same records and FORGET the last 2 !!! (no problem with the android phone) Regards !

Hi, I am new to Airtable and am working on a property management project. I’m trying to use Airtable to calculate property rental metrics (e.g. nights stayed, average rate per room, total revenue) by property. Each property (e.g. property 1, property 2, etc) is listed on multiple listing platforms (e.g. Airbnb, VRBO, Expedia, etc). The listing platforms allow me to export stay data, where each record is a stay (e.g. check in date, check out date, nights, total revenue, property, guest, reservation # etc). However, each platform has a different format, so I’ve created a separate table for each platform. I created a summary table where each row is a property and each column is a metric from one platform (e.g. Airbnb stays [count of rows in Airbnb table that weren’t cancelled], Airbnb total nights [sum of nights field in Airbnb table], Airbnb Revenue [sum of revenue in Airbnb table], same for other platforms). Then I can use a formula to sum the stays, nights, revenue, etc from across al

Hello, I have a list of Zoom sessions that I need to get out to my colleagues for meetings. However, when I put all of the information in the block, from the database on airtable, they don’t come up as Hyperlinks and they are difficult to copy from the PDF I send out. I was wondering if there was a way to make them a clickable link to make everyone’s lives easier. Thanks!

Why do I get this error message when trying to link Fields both to other tables and within the same table? Are you sure you want to convert to this field type? Converting to this field type may clear some cell data from every record in the table. If the conversion causes a problem, you can press CTRL Z to undo. Thanks!

I use Zapier to post data and and PDF file attachments into Airtable records. This has been working fine for months. Today I find that my PDF file attachments do not display previews in my expanded Airtable records - they appear as generic file icons - and the download icon/link is not visible - I can see only the ‘Rename’ and ‘Remove’ icons. If I click on the attachment to get to full screen preview, the viewer loads with an error message: ‘Unable to view file, please try again later’. Does anyone know what is going on?

Hi there! When sharing a “Read Only” view of a base is there a way to prevent the “readers” from viewing the Activity in an expanded view? I want folks to see the information provided without being distracted by how the data came to be. Thanks!