Other Questions

My data consists of 4 tables, each table having a unique ID that is a number. Those numbers are the links between the tables. When I bring it into AirTable, everything is linked properly, but the linked field being a number isn’t of any use when a user tries a search, They need to be able to enter something other than the number of the record to find what they are looking for. If they are looking for something in the linked table with a column of City, they need to be able to search by the city instead of guessing at numbers until they stumble across the right one. A workaround is to use a concatenated field starting with the number then throwing stuff into it that would be useful for searching. I a working on converting it to use just such an approach but there are a lot of multi-instance fields that are a royal pain to convert. There has to be a better way. I know there is something obvious that I am missing.

I have inherited the task of updating and managing Airtable for our group. We have a Google form of data fields that I need to import into an existing Airtable. Or I need to revise/edit the column headings on the existing Airtable. Best approach? Thank you!

I have a field of categories like this: Consulting & Professional Services; Venture Capital; B2B; Enterprise; Intellectual Property; Professional Services Investment Banking; Finance; Capital Markets; Venture Capital; B2B; SAAS Professional Services; Consulting & Professional Services; Venture Capital; B2B; SAAS Capital Markets; Venture Capital & Private Equity; Finance; Venture Capital; Consulting & Professional Services; B2B I want the single (or multiple) select to parse out each individual category. Is there any way for me to do that?

I am using gallery view on my website to display membership profiles. One of the fields is essentially “preferred name” and one is essentially “birth name”.l I only want to show the birth name if the preferred name is empty. Any suggestions?

I would like to display the number of records that I have in a table on my website. I know I can do this manually, but I would have to keep updating it manually and was wondering if there was an automated way. For example: “567 products and counting!” Where the number 567 is the number of records (rows) in the table that updates automatically when records are added. Is this possible with javascript or something?

I am new to Airtable and would like to be able to use Vega-Lite to add charts to my dashboard but modify them to display the numerical value on top of the column. I have added a screenshot of the chart that Vega-Lite pulls in along with the code. Any help is appreciated.

Hi there, is there any option to edit a single data entry (row) by using a form or targeting it via API? Example: We’ve got 100 data entries / rows relating different 100 people. We’d like to give them the possibility to update their data by their own without having any kind of access to the data from someone else. How could we do this? Thanks in advance!

Hi, there is a wonderful app for Googel Maps. But unfortunately, I can’t use it as a view and share with my users. Can we get Google Maps as a View please? Pretty please?

Hello, I am trying to print a multiple record list from Page Design. I have tried this before and everything was OK. I haven’t changed anything recently but now I cannot see and print the whole pages. There is a two pages list and I can only see and print the first page. The second one is empty and so the list is not full. Please, can you help?

Hello, I am importing multiple values from zapier that are separated by a comma. I would like for them to be imported as an entire column as oppose to multiple values separated by a comma in a single cell. As seen in the image

Dear Airtbale Community, I own an E-Commerce store which makes personalized jewelry for pet owners. I use Airtbale for managing my orders. We used to upload a JPG file for each customization, but we changed some stuff in the backend of our system, so we have to use .DXF for fulfilling our orders. The issue I am having right now is that Aritbale automatically converts DXF to a TXT file and the file is unusable after upload. Is there a way to not convert the file and upload the file as is? Thanks so much Seung Kim

Hello :slightly_smiling_face: I would like to know if this behaviour is normal and how to fix it. Thank you

I need help. I tried to login but all the tab are not loading properly

Hello guys, is it possible to create a field where I have a drop down (multiple select) list where I can also set the number of items, without creating another table to do that? Something like having [chair, table, pen] as choices and the possibility to add the number of the items, (chair, 3), (table, 1) etc. Thanks for helping! PS: is it possible to create a form that references more tables?

Is there a way to create a checkbox grid similar to that of Google Forms?

Hi, I just faced the problem quite a few times. I made my form and put all the necessary questionnaires for my users’ interview and when I reopen the form it seemed a few of the questions are missing from the main form. I was wondering what a misbehave it is and facing it quite a few times make me crazy about it. Would be appreciated if you look at it asap and solve it for convenience. Thanks, Ahsan Habib Imrose Founder, AgroChain

Hey folks, I have a need to be able to programmatically see the change history of an airtable base. We use airtable as an internal app for configuring our product for customers and I want to be able to see how our customer facing team changed the “draft” configuration before and after specific requirements gathering interactions with the customer, in order to understand what information we’re actually getting from that interaction. Imagineering a solution, if I could use the API to query specific snapshots that airtable takes automatically already (we’re on a Pro plan) that would be a solution, but it looks like that’s not an option. Short of setting up a regular job to use the API to essentially take my own snapshots to delta, are there any out of the box solutions to this problem?

Hi, We are currently using the Jira Cloud app to sync our jira tickets with Airtable. We have a few custom fields that will be important for pulling over from jira–i.e. Customer and Sprint. Is there a way to add additional fields into the Jira Cloud App sync?

Does anyone know what determines the order of records structured as milestones in the GANTT view? Right now, if two milestones have the same due date, one seems to arbitrarily stack on top of the other in the GANTT view. Does anyone know what dictates this order? Is it not possible to sort records in the GANTT view? Also - does critical path not highlight when GANTT views are organized with grouping? I can’t seem to get it to work when I group by project category and then by project.

Hi, I’m a new user and starting with the Free plan - I suspect I will need to upgrade to Plus or Pro. Some help on these basic Q’s would be greatly appreciated and which plan I need to achieve these. How are the records per base calculated? Is it the number of lines per table or per base? I need to ‘search’ across all tables on a base, not just the current table - which plan will solve this? Eg. if a client calls and I don’t know which session they belong to (or which table they’re on) I can search via their mobile number across all tables. Printing: Can I select individual lines or columns to print or do I need to hide the columns not required first and then unhide after printing? Thanks for the help, Suzie

Hi guys! I’m quite new to airtable and have no experience in writing strings. I have read the syntax page, but could not find out what i should do to get the desired outcome. I have a column with the name “Referral URL” In this column, urls will be entered trough zapier when a user submits his/her credentials. Something like this: “www.test123.nl/test-ebook-landingspage/?ref=xd3r4n” I have another column next to the “Referral URL” column which is called “Referral Code”. What i would like to do is, eliminate everything before “=” and place only the “xd3r4n” in the cells of the “Referral Code” > This should be automated en run everytime someones signs up Is there someone who has experience with this? Looking forward hearing from you guys!

I would like to share my base with others but several of the fields have the ability to be filtered. I would like for the people I am sharing the base with to be to filter the fields but not be able to change any of the information in the fields. Any suggestions on what options I need to select to accomplish this or is this possible to do?

My company helps provide aid to individuals in very life-threatening situations in other countries. Their personal identities and whereabouts are closely guarded for their safety. Each person is a record in our base. We would like to map out individuals by city in the Map App in order to help with basic logistical planning. My only question is: Does using the Map App (Google Geocoding API) enable Google access to any information in the Base/Table/View outside of the 2 columns (location-text column and Geocoding Cache column) required to set the Map App up??? Thanks for any insight into possible security issues implementing the Map App!

I’m creating a community-facing form where folks can click a button to open a client’s webpage - IF the client has a webpage. However, if they DON’T have a webpage, I’d love the button to not appear. As it is, it’s disabled, but is there a way to make the button disappear if conditions aren’t met? From the screenshot: The first entry lacks a checkbox or website. As such, I’d like that button to be invisible, as opposed to merely greyed out. The second entry has a true checkbox and a website, and the appearance of the button is fine. Any ideas?

Hello, I have a calendar view of a database coloring the records “the same as” and then checked a single-select field called category in the database. The coloring works perfect but I would like to know if it is possible to add a calendar color key on top or the side so you can at a glance check what the colors correspond to which type of entry in the category field. Thank you,