Other Questions

I have a CRM and on my Interactions table, I want to be able to create an Interaction and select multiple contacts on a record at the same time. The linked record allows linking to multiple records - I can select records one at a time, but this is taking time. I cant shift-click or CTRL-A to choose multiple records. The use case, is if I send a promo email to all my contacts, I want to have one interaction with multiple contacts. I have been looking at this for hours, can’t figure it out. Any help appreciated. Thanks

Hi folks, I’m trying to create a page designer app which includes a couple different single-select fields. There’s no issue with fields that are entered directly on the view that page designer pulls from—those show up correctly styled as they appear in the airtable grid view, with the rounded bubble & color-coded background. However, any lookup fields consistently show up in page designer as plaintext, even though they also appear with that same bubble styling in the grid view. Is there any way I can get page designer to render these lookup fields with the same bubble styling as well? Or worst case, can anyone think of a good workaround where I can “hack in” some similar color-coding via formulas/etc?

I will try explain my case. I own a theatre school I have a base to manage the interation and publication on social networks through integromat. I got another base to manage my current students in which i have their IG nicknames. I got another base to deal with marketing contacts in which i have some of their IG nicknames I want to have a synched table on the social network base with all the IG information i got from students and marketing contacts in orther to mention them in a proper way on my social posts. That is easy. This can be made trhough a synchronization from several resources what is possible now. However, sometimes, i want to mention a nickname which is nor a student neither a marketing contact, so i would like to add manually this type of records. This way i would have to use only a link to another table field to include every person i want to mention on a post. Is there any way to do that?

Is it just me, or has anyone had mini heart attacks when almost clicking (or actually clicking) the erase button when you meant to download something? Could I get a thumbs up to request this changed from @Airtable?

Good Day! I was wondering if I could get some help with a scenario: In the scenario a particular individual could have multiple records linked to them within another table. In the scenario let’s use contracts as an example. 1 individual could have multiple contracts with start and end dates, along with an attachment. In the “Master” table we can quite easily look up the Start and End Dates based on a MAX(VALUE), but my question is this: How would I go about linking THAT SPECIFIC contract to the given dates without showing all other contracts?

Hi Everyone, My team and I are planning on migrating our Project Management tool to Airtable. We have more than 2000 tasks, among them ~500 tasks that have a multitude of dependencies. We appreciate the Gantt view showing those dependencies. Unfortunately we have so many dependencies that the dependencies on the Gantt view are hard to digest and to work on, particularly for those that are showing as “invalid”. Is there a way to extract/highlight invalid dependencies into a separate table, view or even field? Or another solution (e.g. formula) to easily alert and/or track these invalid dependencies other than the red dotted arrows in the Gantt view? Note that the flowchart app is not meeting our needs: app limited to 100 records, records’ timeline not taken into account, thus no option to highlight invalid dependencies. Thank you in advance, Lucas

Hello, I have been building out an inventory system that shows all products, the amount of inventory and the price per product. Within the base, this inventory table is used to link to a transaction table that allows you to generate a transaction with multiple products with a total value. Following this, the transactions table links to an invoicing table where you select the transactions that were made and puts it all into an invoice with use of the page designer app. This process works fairly well, I’m not super happy with it but it works for what it needs to do. Where my issue arises is that we are constantly changing pricing on parts we sell and I cant change the pricing without changing past records. I cant change the past records because my company wants to use them to track all past sales. I set up a table to put all inventory received into the system. In the receiving table, you input the item and the price that you want to sell the product at now but I don’t know how to figure

I have the Pro Plan via a recent upgrade. Previously under this Pro Plan I added and used the Nobull app. Today I discovered that the Nobull app is deactivated. When I try to add it again, I am told “This app is available on the Pro Plan” and that an upgrade is required. I have encountered the same issue when trying to add another app. I understand that this post is a support request best sent via a direct contact to Airtable. I did so, but hoping for any comments as I await Airtable’s response. Thanks!

Hello everyone. (please excuse me for my English, I use Google Translate) I am in the process of making a small application to record my working hours with the Kodular site, and I am using an extension that allows me to use Airtable. Everything is going fine until I have to save some long text. It looks like this: 2100001 - Client1 02:00 task1 2100002 - Client2 04:00 task2 2100003 - Client3 03:00 task3 Etc … If I enter 3 lines like in this example, it saves the text correctly, but if I have more lines, then it cuts the text to me and it shows me “…” See for yourself with this screenshot: Is there an option to check, set or anything so that I can have all of my text in full? Thanks everyone!

HI I have 2 tables in Airtable. One si projects and the second table is Actions. I created a column in the project Tables in which I set a color. Actions are linked to a project (only linked to one project + lookup field to “color” from project table) I would like in the calendar view to set the color of the tasks the color of the project it belongs to Which seems not possible since for an action, I can only define a color in a single select field - color is not a single select field so no way to set my action to that color (that is not only for calendar, but it’s the same for Grid or other views). Is there a way to set the color of a tast, the color of the project ? Thanks

Hi! Here is the general idea of the process that I am trying to implement in Airtable: (1) a participant completes a survey and their results are entered into Airtable (2) the results from that participant are automatically plotted using Vega-Lite (3) the Vega-Lite plot is then automatically sent to the participant via email Setting up the survey in (1) is clear to me. For (2), I was thinking that this could somehow be implemented using AirTable scripts. I know that it is possible using AirTable automations to have the creation of a new record trigger a script to run. However, is it possible to have a script create a Vega-Lite plot using the data from the single record that was just created? My idea for (3) was to generate a url for the Vega-Lite plot, update the record in AirTable with the url in a column and then use AirTable automations to send an email including the url. The only parts of this process that I am uncertain about is whether it is possible to: -generate a url for a Veg

Hello! I’m in the Plus plan and trying to make an automation to email people on my table but there is a restriction "On your billing plan, you may only email collaborators with verified emails. " Does anyone know if the Pro plan allows that functionality? Thanks!! Adriana

Hey there, I would like to show: Total Number of Vendors Defined as the # of vendors in each cohort. This lives on a tab called “Vendor - Main View” Total Number of those Vendors with Completed “AERs” AER Completion is defined as a date corresponding to the Step 27 shown here in the table named “Checklist v2.0”. (An empty cell implies the step is incomplete) The thought is that we’d show “Of the 12 vendors in the January cohort, only 9 of them have completed AERs” “Of the February Cohort, 2 have completed AERs”. Thanks in advance for your help!

Hello, i have set a password for my Form. I tried to open this url the first time and it asked me the password. I submitted the form. Then, i open the url again but now it did not ask for password. How can i prevent this?

Hello all. I use buttons to navigate between my interface pages, however when I navigate to a different interface (using a button) the URL opens in a different tab. Is their anything I can include in the URL to stop it from doing this or is this just standard behaviour? I guess I could create one interface for everything and that would solve it but it’s not how I’ve designed it currently. Thanks in advance. Dan

I am looking for a simple formula to compute hours worked. I have “Start Time” and “End Time” and am looking for a formula for “Total Hours Worked”. I tried one of the other formulas that I found on another post and was unable to get it to work with my table. If someone could provide me with a simple formula to add my start time and end time and output a total hours worked I would appreciate it!

I’m curious to see if anyone is having an issue with their IOS app reverting back to the view that was last used on their desktop? Example - On my desktop I’m using Base#1, View#1. Then go to my IOS app using Base#1, View#2. If I close my phone’s screen do some work. Then go back to the Airtable app, it will show a grey bar at the bottom that says “loading”. The app screen will blank out then go back to Base#1, View#1(which is what was on my desktop). It will also close the record I have open and revert back to the desktop’s view. The IOS app used to not do this. I’ve contacted Support and sent a video of the issue.

Why there is no place to put suggestions for the mobile apps? I guess it is because Airtable doesn’t recognize the importance of the issue when the Airtable support says “most people do not Airtable use mobile app, instead use desktop…” Anyhow, this is a quite frustrating issue and an easy fix. The close button on the top left in the attachment view is way too small. I’m on iPad mini, but same issue is n iPhone and Android phone or table. It takes me at least 10 times to hit the button to close the window when I want to exit the attachment detail window. Please make that button larger and thicker. Here is what I mean: This is similar to my earlier post but it was related to MacOS where the close button is also tiny and it is too close to the window buttons (red/yellow/green) and if not careful I close Airtable app window instead of the Attachment detail overlay window. Similar issue, similar fix needed. Move the CLOSE icon in attachment-view window further from the

I am helping my church with a project and have what seems like a simple problem to solve. I have a table with a list of Serving Opportunities (greeter, discussion group leader, children’s leader, etc). Column 1 is a list of Individuals (linked to Individuals table) that meet certain criteria…as an example it might be that they are a member of our church. This column contains the names Andy, Bob, Chris, Craig, John, Joe and Sandy (all members). Column 2 is a list of Individuals (also linked to Individuals table) that meet a different criteria, perhaps they have children under age 18. Column 2 contains the names Bob, Fred, Craig, Jason, Sandy and Sarah. What I’d like to have is a third column that returns matches in Column 1 and Column 2 (names that appear in both). In this case, it would be Bob, Craig and Sandy. I’m sure this has been asked before, but I can’t seem to find a solid answer. Would love any guidance! I’ll also note that there are instances based on the Serving Opportunity w

Hi Everyone! Can you help point me in the right direction to help solve for my use case below? Any examples of scripts are much appreciated! Use case: Create a simple matching script that will take inputs from a form and then return a list of matches based on the inputs Below is a (slightly) simplified version of my use case. Goal: to match people with specific types of food based on their allergies and taste preferences for a wedding. Data: Table 1. Food List. This includes Information about certain types of food. Each record includes a food choice with the feature “allergies” and the feature “food preference”. Feature: “Allergies” Allowed Values: “peanut”, “gluten”, “dairy” Many to Many relationship One person may have multiple allergies and one allergy may exist for multiple people Feature: “Preference” Allowed Values: “kosher”, “vegetarian”, “vegan” 1 to Many relationship Each person can only select one preference. One preference may be true for many people. Table 2. Customer requ

Hi all- I have a table sourced by a CSV upload with properties and owner names (and lots of other fields) on single rows, 1 row per property. Some owners own multiple properties. I’m using Airtable to clean this up and separate the single row source data into two different views- one of ‘properties’ to upload properties as ‘deals’ into a CRM, and another view of ‘people’ upload as ‘contacts’ in the CRM. If there are 50 properties, there may be 35 owners, ergo, 15 owners own more than one property, but i only want to upload 35 owners, and those who own multiple will be linked to multiple. I don’t want to upload duplicate instances of the same contact just because one person owns two properties. I just want one instance of that person, and in the CRM would link them to both properties. I’ve used this solution from @W_Vann_Hall to identify when an owner owns multiple properties, and have a count of properties owned, but what i am trying to do now is create condition in the records t

Hi! I am creating a task list template that has certain tasks that need to be completed 20 days prior to event, 14 days prior to event, 12 days prior to event, 2 days after the event, 7 days after the event, and so on. I’d love to be able to pop in the Event Date and it autopopulate real calendared DUE Dates based on those parameters so that I can use it over and over for each new event without manually typing in each due date for every single task, but am struggling to figure this out. Can someone please assist me? I am new to airtable and watching lots of tutorials!

Hi, I’d like to take some information from a website and put it in a column on my database. The information is the perceived market value of individual footballers on a website called transfermarkt.com The values change regularly, so I’d like that to automatically update in my database. Is this possible? Many thanks in advance

In a Grid View, how would one filter out tasks that are only “Ongoing” as seen in the Gantt Chart? The tasks have a start and stop date, and I want to show only tasks that should be currently happening. This will help eliminate distractions of future things that shouldn’t be worked on yet. Background: In the Grid view, the primary items are tasks. I use this Grid for scheduling and delegating work to coworkers. For each task, I have a “Start Date” and a “Due Date”. To visualize these tasks, the Start and Due dates drive the Gantt Chart. See the following image: Essentially what I want to do, is create a grid view that only shows the items that today’s date is touching. Another way to say this is, show only “Live tasks” on a grid view. In the following image, that special grid view would only list “Blow form tooling, Prepare RFQ folder and Docs for Outsource, Phase 1 Complete, Phase 2 Meeting, and Phase 2”. I tried to create a simple formula that can describe if a task is currently ong

Hi all, I’m running into a perplexing Airtable approach that I’m needing some help on. Here’s what I’m trying to accomplish. So, if this makes sense, in essence I’m creating a new record in one base that creates a linked record in a second base, and those records’ due dates and statuses need to sync for each related record, with the source of truth for those fields being what’s in the second base. The below may provide more detail. 1.) When a record is created in the “submit for editorial production” in Airtable Base 1, that creates a record in Airtable Base 2 in the “Editorial assignments” view. I’m currently using Zapier for this need and plan to continue doing so. Airtable Sync doesn’t appear to be an option since Airtable Base 2 receives records from several different and unrelated bases, and using Syncs for all of these isn’t an option right now. For the score of guidance today, I’d like to continue with the Zapier approach. 2.) When the Status (dropdown column) for a record in Ai