Other Questions

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 figu

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

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 instea

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 t

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”, “veg

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

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 Outso

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 th

Hi There, New to airtable and loving it so far. I am wondering if its possible to add a column to my table that only I can see but when the table is viewed when its embedded on my website no one else can see it. I am trying to eliminate the use to my second spread sheet for details my customers don’t need to see in their order.

How do I find table creation date? I’m looking for a ‘table properties’ section where I can view ‘table creation date’ and ‘table updated date’. Does this exist? Seems simple enough but I can’t find it anywhere.

I have some tables that has many records and I want to have another table that will be called Macro View and its going to include all the counts of each table. For example I have one table that is called “Peoples” and it has 50 records there, then I have another table that is called “Animals” and it has 25 records there, then I have another table that is called “Cars” and it has 10 records there. Now what I want to achieve is that in this MacroView to have the sum of these records like example below: People : 50 Animals : 25 Cars : 10

Hello Friends! I am using Airtable for project management. I want to make sure we have not scheduled more than 6-8hrs of tasks per day for team members/resources. Is there a way to create a calendar view that would show the number of hours of work assigned to each team member? I’m guessing I might need a Calendar Table and use linked records, but that would destroy the ability to use the Gantt chart. Any suggestion would be greatly appreciated! Thank you! Paul Warren

I’m using AirTable as an inventory manager instead of Excel, but when I output more products than what’s on my inventory, my inventory marks as negative. What I want is that in the output row, I always have a limit according to my stock, so when I try to output more units than I have, it mark an error or only corrects to my maximum possible. The issue is that the person that register the outputs not always knows the available stock, so if he outputs 100 units of “x” and there are only 50 on stock, he won’t notice that the inventory is in negative.

hi. i wanna do a simple array of objects in airtable like: [{option: “abc123”, name: “abcabcd”, text: “lorem ipsum”}] they do it here for example when you choose attachment field but i wanna do it with a simple ( item=value ) in array