Other Questions

When I export values from a table I get three weird characters at the start of only the first line which contains the field names. My first line looks like this Member,Forename,Middle Names,Surname,DOB,Address 1,Address 2,Town,County,Postcode,Home Phone,Mobile Phone,ICE Contact,ICE Number,Email Address,Occupation,Qualifications,Interests,Disabilities Is this a bug?

I’ve been sharing my form for a while with no trouble, but after making a small change today it won’t share anymore. Generating a link, previewing or pressing “Open Form” all lead to a blank browser tab. Any tips would be very appreciated :slightly_smiling_face:

Does any know if Airtable tracks failed Logins by a user and locks their account if a maximum number is reached? And do they lock the account and sent any type of email or notification to the user for them to know that someone might be trying to access their account. I am trying to understand what happens if someone tries to access our companies data if they figure out one of our users email address. Thank you

I have a small farm and use Airtable to track the animals. I have a table for their basic info (name, dob, etc), one for weights (used every time we weight them), one for any treatment(s) they get, and one to track breedings. I’d like to be able to have a view where I can pull up an animal by name, then see all the other associated records regarding it from the other tables. If I pull up animal “Bob,” I’d like to then see his weights and treatments in the same view (by most recent). I’ve tried searching these forums and the web to see if it’s possible, but have come up empty. This view would normally be used from a mobile device.

AirTable on my iPhone 8 lags a ton. My coworker shares the same bases, but his app opens and loads normally on his iPhone XR. I have tried reinstalling the mobile app, but I have not resolved this issue for a month.

I’m hoping someone might be able to help me understand if Airtable can be used effectively for file storage and organization instead of Dropbox. The reason for using Airtable is because I want to be able to tag, filter, link and otherwise organize files in a way that I believe can’t be done with Dropbox. My specific use is real estate data, so for example, I’d like to be able to organize PDF files (e.g., market reports), each of which would have its own record/row by different variables that can be dictated by the field/column (e.g., City or State) and also link those files to other records (e.g., a contact or a property related to the record). It doesn’t seem like this is an intended use with Airtable, particularly given the 20GB limit for a Pro user, but Dropbox (which I currently use) and its competitors don’t seem to offer the same dynamic ability to organize files, so I’m hoping to figure this out with Airtable (or find out the best alternative). Is there any reason I can’t or s

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