Other Questions

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,

I’m having a problem using fetch with the scripting app. My code looks like this: records.forEach(async (record) => { try { // works until here const response = await fetch(...) // never gets here either } catch (err) { // never gets here either } } ) It seems like there’s something going on with fetch that breaks further execution and I’m unable to debug it.

We use forms for a maintenance checklist. Works perfectly. But now we have to put a extra checkpoint appear on the same checklist every 2 weeks. Is that possible on the same checklist? I cannot do it through the conditions. Has anyone have an idea for this?

Hello everyone, thanks for stopping by. I have two tables, a “Properties” table which contains all the properties, their type, configuration, and amenities, and a “Members” table which contains the member fields their desired property configuration, desired property type, and the amenities they need. I’m trying to create a new field on the Members table which has a list of properties(from the Properties table) matching the member’s needs. I’m pretty new to Airtable and I’m not sure how to achieve this. Any amount of help is highly appreciated. Tysm in advance.

Hopefully someone can help me. This is what my current table but more than 10 columns are at the right hand side of this table. How do I export as pdf and have all the names and data inside the table visible inside pdf?

I’m trying to creat a form in which the filled data will fill the fields in a pre-existing record and not creat a new record in the view, but I’m having trouble doing that, and so I want to know if it’s posible to do such configurations in a form.

Hi everyone, I’m new to Airtable and I would like to seek some help on the project I’m creating. I have a 3000+ collection of listings worldwide. These listings are currently divided into four in according to continents. Then main destination which is the country, sub divided into region. Sample 1: Asia and Oceania > Thailand > Phuket Sample 2: Europe > Greek > Paros Sample 3: Americas and The Caribbeans > Mexico > Tulum Sample 4: Africa > South Africa Moreover, I have them posted on different channels that I need to keep track. Channels: website, guesty, airbnb, other OTA’s Each listings have unique statuses on each channels: Sample: Swiss Villa website: online guesty: listed airbnb: connected OTA’s: rejected What my goal is to keep track on how many are “online”, “listed”, “connected”, “rejected” on each channels we have for each of destinations we offer and of course its

Is it possible to compress the area showed in the image? I don’t like that it shows everytime and I can’t compact this

Hi there, Is there anyway to only select items ONCE? I have a single select field type with A, B, C and D, if I pick B on a row, I only want to be able to select A, C and D afterwards. Thanks, Ben

Complete noob here. Building a system to track a series of classes we’re teaching internally. Each employee is assigned to a learning track, which includes a specific series of classes/modules. I have the data linked to show which classes/modules are in each learning track, and which employees are in which learning track…but I’m trying to wrap my head around a way to “grey-out” or “hide” classes already taken by an employee (so they don’t accidentally get assigned to the same class twice). I’d be glad to share my work…although I suspect someone will just say “durp, do this”… Thanks for ANY advice!!!

Trying to download a grid in csv to import data (contact list) for Outlook app for Apple. I use CSV with UTF-8 but when I get to outlook it always give me error code. Losing patience here !

Greetings All, I am interested in using Airtable for project management. I would like to get the structure of the project plan(s) organized properly so that I do not find out later that I put a lot of work into it and got it wrong. Ultimately, I would like to have one high level Gannt chart that shows the timelines for multiple projects. Beyond that, I would like to customize each project differently. For our Core System Project for we would have a list of features for each aspect of the development project as well as a list of tasks and mockups. We will have integrations to other systems that I would like to define as sub-projects of main development project. Beyond that and at the same level as our Core System Project, we would like include other projects such as Marketing, Social Media Engagement, Training Programs, Supplier Onboarding, Country Rollout Plan, etc. These other projects would have tasks

I know this question has been asked before but can you change the colour of text in a text box? We have developed a workspace tracking our clients, however we would like to highlight text using a different colour to draw someone’s attention to that particular concern. OK, I can add a colour tab to that record but someone still possibly has to read through a mountain of data to find the particular issue that was causing concern. Having the ability to highlight or change the colour of the text would be really useful!

DATETIME_FORMAT({Local Time(In Your Time)}, ‘MMMM’ Is the one field for a formula I have, and the source field, {Local Time} is the culprit because I don’t always have date in the field until I actually place a date in there, so of course, I’m getting #ERROR! for EVERY formula field that uses this source date field. I know I can nest an IF formula, but when I tried, based on another community suggestion(not my question), I got an error, so obviously, I need help with the formula LOL Suggestions? I have some other formulas, but I figured I’d start with the easier one first. Thanks!

Our website developer has alerted us to the fact that the Airtable form embedded on our Contact page is taking very long to load and that the Contact page has a very high bounce rate, unsurprisingly. Is there anything that can be done to make the form load faster? The problem seems to be the Airtable script. The form is embedded here: https://www.blinds-express.co.za/contact/ Some loading stats:

How do I deal with getting specifically qualified Aritable help, but not risking someone walking away with the backbone of my business? One of the major drains on my own time is managing a few email databases in Airtable. But the contents of these databases are like the keys to my kingdom. I have some upworkers scraping email addresses full time, but I’m slow to update the databases, or even taking time to cull bounced emails, because it’s so time consuming / requires focus I don’t have right now. I know this is a random question, but I’m hopeful that someone here has had experience and can make some suggestions!! :slightly_smiling_face: