Other Questions

Is there a way to setup alerts or reminders from dates listed that are listed on a table?

Hi all, I’m using Zapier to send survey responses from Alchemer to Airtable. To help with filtering in Airtable, I match each survey question type to the corresponding field/column type in Airtable; so a likert scale (or other radio button question) is mapped to a single-select field, a checkbox question is mapped to a multi-select field/column, and open-text questions are mapped to single/long text field/column types. My survey makes heavy use of ‘Other - write in’ fields, especially in the context of multi-select (checkbox) questions. Commas are often included in these write-in fields, either by survey respondents or by Alchemer in how it formats data. However, either Airtable or Zapier (I’m not sure how to tell which) appears to be seeing the commas and using them to break apart individual responses into smaller pieces that then get entered into Airtable incorrectly. For example, if someone writes in “Planes, trains, and automobiles” into the “Other - write in” option of a checkbox

I’ve created a line chart with records group by year, but the output is showing extra X-axis values that don’t exist. For example, my data has years 2017, 2018, 2019, and 2020, but the x axis of the chart is adding interim values of 2017.5 between 2017 and 2018, 2018.5 between 2018 and 2019, etc. How can I suppress this output? It looks very unprofessional.

When using two numerical fields to generate a scatter plot, the y-axis label does not appear unless “Aggregate” is selected. This means that in order to show the label, you have to select “Group by…” and choose a unique field (because you don’t want things to be grouped) and then select Aggregate, which results in the y-axis label being prepended with an aggregation method (Sum, Min, Max, or Mean), which is not an accurate portrayal of the data that is being charted. The label should simply show up without any aggregation and just contain the name of the field.

Hi, Here is what I would like to do: I have one table (T1) where when I fill a certain field which is linked to another table (T2), I would like it to make a one time copy of certain fields to T1. So I would think that it would somehow have to look up in T2 which record I am referring to and choose the fields accordingly. Thank you in advanced for your input.

In the “What’s New” section of the AirTable support site, the ability to add Salesforce as an external source is listed. When I go to add that however, it isn’t visible. Anyone else failing to see Salesforce as an option for external sync? If it’s coming down the pipeline, was there an ETA given?

Hello. I need to do the following: if I have two columns that I display with and link to a new table. When I choose a record from the column 1, I would like to be able to choose from the column 2 the ones that correspond to it according to the previous selection. For example, if I choose in the “Area” column, “Industrial Activity”, from the Topic column I choose only the three that correspond to it. As shown in the picture Than you!

Hi :slightly_smiling_face: Does anyone know what supported timezones for SET_TIMEZONE for Mountain Time (US)? Thanks!

Hi all, (just learning Airtable) I’m creating a submission form for a client and we’re expecting a large amount of submissions (1,000+). At some point we are planning on narrowing down the options and presenting those selects to the client… as of now I have a “Status” column where we can tag that record with a specific color and filter it afterwards where they only see the reds or the yellows. I was planning on having a link sent to the client where they’d see the back end (the chart, form, and gallery), but ideally I’d prefer to have a separate space, for the lack of a better word, where the client can only see those selects and not turn off the filter and see the other 700+ options. Any advice on how to make that happen? Just trying to figure out an efficient way to show the client the records/submissions that we culled down. Thanks!

Hi everyone! I would like to create a form for my community member to reflect on their week and set new intentions. I would love them to be able to see only their answers in a form that is embedded on my website that the whole community will have access to, is that possible? Thank you in advance for your help!

I have embedded a view into a web page in “card” format, and I’m hoping there is a way to edit the card. It will only show 4 columns in each card - I’d love to show more. Also, my first field is “long text” - I’d love to be able to show more of that long text. Possible? Thanks!

Can anybody explain why the embedded card-layout view only displays a maximum of 4 fields? Please see the attached embedded imagine:

I have a custom app with multiple remotes. I released the same app for all remotes, and not able to find how to enable the app for the base. It does not show up in the UI at all.

Hello! I started to use Kanban as a sales pipeline to track deals and I have been uploading files to those records under the “grid” view. When I view the Kanban, the files are displayed like a thumbnail. I have customized the card to disable “files” and I checked that “files” is a hidden field, when I expand the record. Does anyone know how to eliminate the thumbnail for Kanban cards?

I have a cell that links to a series of events they are listed from the past and future. I want to have a cell that find the next upcoming event in that list?

Hi! I’m trying to figure out what would be the best way to implement something easy to use that would allow anyone to check if a record exists in an airtable base. With a table with these columns: Name | Surname | ID | email I would like to implement an external webapp that given email + ID, checks if the record actually exists and returns true or false. Any ideas? Thanks

Feature Request… Can you make the monthly calendar view scrollable so I can easily drag records from a date in June to a date in July (for example).

Hello, I’ve never asked a question before so I apologize if this is the wrong format. I think I might be making something simple more difficult than it needs to be: I have three tables: A, B and C, and I would like to make unique URLs in table C using automation in the following way: When a new record is added in A, an automation creates multiple new records in C by adding a UTM for A in one field, and a UTM for every record in B in another field, but I would like every AB UTM field pairing to be a new record in C. Currently I am getting a new record with A in one field, and every B record as a list all in one field. In other words, I would like separate new records in C, with all possible AB pairs when a new A is created. I am stuck on the multiple record creation part. Thank you for your help!

I am trying and very close to getting this to work IF(DATETIME_FORMAT({Last Time Done}, ‘YYYY’ = 0000), DATETIME_DIFF(TODAY(), {Last Time Done},‘days’), “Never Done”) I can’t get it to say neverd one when last time done year matches 0000

For Link Table, I have been able to do a “batch” sort, however it only sorts for the first field. Is there anyway to sort this Link Table by multiple fields? For a Lookup Table, how do you sort this information whereas when I expand the record the Lookup records are sorted? Thank you

Hi there, We’re using airtable to rate things across a number of users and devices and the rating field (with stars) does not appear correctly on Android phones. No stars appear and it is not editable, despite the user being Creator level and the field being editable. Is anyone else having this issue with the Rating field on Android? Thanks, Sei

I have Lookup Field (“Status”) that has many records with multiple values per cell. I want to parse out these values using ARRAYJOIN(Status," | "). It only returns me the comma-separated values , without “|”. Any thoughts ?

For Link Table, I have been able to do a “batch” sort, however it only sorts for the first field. Is there anyway to sort this Link Table by multiple fields? For a Lookup Table, how do you sort this information whereas when I expand the record the Lookup records are sorted? Thank you

Hi, Im new to airtable as I see it looks better than excel for doing table and database. I have issue with linking table that has one-to-many relationship. I have Movie Database with 3 tables; 1. Movie, 2. Genre and 3. MovieGenre. MovieGenre stores relationship of Movie and Genre. where 1 movie can have multiple Genre. The way I structure the table like below Movie_Table MovieID | Title 01 | Jurasic Park 02 | Indiana Jones Genre_table Genre_ID | Genre 01 | Action 02 | Adventure 03 | Fantasy MovieGenre Table MovieID | GenreID 01 | 01 01 | 03 02 | 01 02 | 02 I imported those 3 tables from excel. Now, what I want to do is to have Genre on my MovieTable, which populated automatically. I try to link Movie_table and MovieGenre, however what is shown/populated in Movie table is only 1 GenreID. it takes only the top GenreID, while expectation that it should populate those 2 GenreID for th

Is there a way to see the base level audit of who has done what? We have a large Base with specific filters and groupings set on different views, and someone keeps changing these filters and views. We’d like to know who is doing it so we can stop the behavior. This is not record level, it’s base level. Thank you.