Ask the Community

Hi all - my IT team has some technical questions about Airtable that I don't know the answers to (or even really understand!). Can anyone shed light on any of the following questions?Is there AD integration for employee users?Is there 2-Factor Authentication for all users?Is the data backed up? For how long?Are the backups encrypted?Is all the technology patched and current?Is the vendor solution patched on a scheduled basis?Are critical patches applied as soon as their identified, both to the solution and to related technology?Is storage provided, and how much?Is it a Cloud/Saas solution (non on-premise-managed by vendor)?What other security measures are taken?Please provide details on the SOS verification.Thank you,Kelsey Deusterman

Hello - Is it possible to add a signature card image (see attached) from my computer to an email in an automation? 

Hi all,I am wondering if it is possible to simply add a multiple select option to multiple highlighted fields without removing any of the other preexisting multiple select choices within those cells?

I've created a base and the goal is to share it as a form:When the user has made their selection, is it possible for anyone to see the results, as demonstrated by this mock up. Trying to create a shift booking application, that users can book a shift and see the results, 

I am trying to create an automated email with inserted % fields. However the percentage is not showing up correctly.For example, the % for the record is 55.50% and it is showing as 0.55% in the email.I've attached screenshots of the Automation Email, Email Preview and the actual Record. Thanks!

Hello, I'm trying to create a new record in my base every time a new row is added to a google sheet. However, when I try to configure the Automation I don't have the option to select the fields I want to add (Title, Brand, Supplier, Cost) but instead it shows me "Product" and "Detail" that are in the headers in first row of the google sheet.Any way to solve for this?Thanks! ProductDetails TitleBrandSupplierCostPantsXTBD$4.00

Hello, how can I rename all the "Web" addresses to a "Link" for a cleaner user experience? Thanks!  

We are developing an Airtable base for our college event planning team. I have linked the calendar to my Outlook calendar, but I can’t figure out how to maintain the color coding for various events. This is important because, for example, we need to track which events require the dean’s attendance. Advice would be greatly appreciated.

Hey Y'all!I'm struggling to figure out how to do the following and would love some help!I've built a base that tracks registered and onboarded people in a "People" table. "Registered" and "Onboarded" are options in a single select field. The end result of what I'm trying to build is a simple graph that has day on the X axis and a record count on the Y axis. I want to have daily snapshots of total number of registered and onboarded people as my Y Axis. I want to automate this somehow. I think I should make a new table with dates as the primary field and then one field that is the total registered people for the day and another field that is total onboarded people for the day.But how can I automate this so I don't have to check and update daily?I figured automation would work, but the options are so limited with a time as a trigger.I'm thinking I might need a script that runs daily?Can someone help me out here? T

Hello,I can't find the issue here that is preventing what i thought would be a very simple table calculation.I have a table called Deals with many different fields but one of them is a currency field that i want to use a rollup field in another table to calculate the sum of the values in this currency field.I'm stumped as to what i am missing here but all i get are zero values. I tried to workaround the currency field by making a formula field that just turns the currency values into normal integers but no luck.I attached a few screenshots for context, hopefully someone can see what i'm missing.Thanks,Alec

I'm trying to add tags to records via bulk import (1,800+ records) and I do not want to override the tags that are in the column now, but add additional tags to that column. Is there a way to do this? 

Is there a way to create a time slot, similar to when you add a calendar a pop up appears and you can choose a date. I've aded a screenshot of what I've created, which is a single select option, But would like it to be more flexible. So, if you choose 9am it will autofill a a two hour duration, 9-11 or if you chose 8am it will autofill 8-10 am.Thanks. le.

I have a time tracker table and a time tracker rollup table.I have a Formula in the Time Tracker Table which Concatenate({Department},"-",{Week #},"-",{Employee}).So the output becomes: Logistics-35-John DoeIn this Time Tracker table, I have a Duration time based on a (Start Date/Time) and (End Date/Time). I have two automations.- 1. When a new record is created take Formula Column and enter the output into the Linked Column cell.- 2. When a record is edited take Formula Column and enter the output into the Linked Column cell.The process that occured, was that an employee uses a form and enters their department, time, and start/end time. When the record is created the formula then creates the data entry (e.g.: Logistics-35-John Doe). The automation would then take the formula and enter it into the linked cell. The linked cell would then populate the linked cell which was a single row (Logistics-35-John Doe)

Hi everyone,I would be grateful to everyone who offers solutionsI have two linked tables: Problem 1  ✅ ResolvedI need a formula for the "Status" column that will display such statuses: Problem 2When I add a new record to the "Sales" table, I need to make sure that the product does not appear in the list if the entire quantity is sold: Problem 3When I select the quantity of products in the "Sales" table, I need to make it impossible to select more than the quantity in "Purchase" table:

How do I create a table that shows the number of emails sent per day?

Looking for a simple formula that spits out that last Friday of the calendar year. I'm trying to avoid needing to make this a manual update so would love to find a formula that just spits that out without me having to update it at the beginning of the year.  Thank you! 

I just spent thirty minutes trying to help an Airtable customer in a DM only to have the message rejected.Khoros places a very high tax on communication and Airtable cannot apparently see why this is not in their own or customer's interests.What are y'all thinking?

Hello. I have data that is in 2 separate sheets on my Airtable and the common reference is the vendor ID.I want to link the column Vendor ID on the Data Page to get information available on the Cost Center Information page when I click on the Vendor ID in the Data Page.On the Cost Center Information page there are multiple cost centers for a single vendor ID in many cases.I tried to link the Vendor ID column to Cost Center Information page but it is only picking up the first line having a cost center.Can I get some help on how I can do this?

Hi there, I am trying to calculate a formula for a discount. The discount category is single select (10% or 20%). I want to calculate what the total revenue will be with the selected discount. The current formula for revenue is (price * quantity) 

Hello, I’m new to the Airtable platform, thank you all for your future answers :slightly_smiling_face: With the Interface Designer application, I would like to display a sum of durations in a graph. The field is well created as a duration but impossible to sum it in the graphs. On the other hand, no problem in the Number element, the sum of the durations does this well. Could you help me on this problem where maybe because of BETA version this option is not developed yet? thank you for your comeback Cordially

Hello community I have been trying to solve an issue. I am looking for the correct formula to automatically fill the columns, (CCC Loads, variable expenses, fixed expenses) in the cost per mile calculator listed below. Those entries will be pull from 2 other table pictured below as well title (operating expenses & ccc loads). Please let me if anyone has any input on how I may be able to solve this issue. 

Hi, I'm creating an attachment via API and it shows the attachment but then gets deleted a few seconds later. Any tip on why this may be happening? Is it a bug in Airtable or the third party I'm using?  

i write this simple script, and get an error:await table.createRecordAsync({"Singal Select":"1"});Error: Field "fldVrE9PBN0HBkpRn" cannot accept the provided value.tried allsow this script:await table.createRecordAsync({"Singal Select":{name: "1"}});and same error all the premission are open...TY!

I set up an actionable message so that when copy needs to be reviewed my client can either approve or reject the design. But when they go to submit their answer, Airtable requires them to log in to AT to answer. My client has no use for AT it is purely my workflow system.Id there a way to get around this issue or does AT need to make an update?

I am running an automation that:reads a set of logics from a tablefor each logic (repeat for each > logics list) executes a script that does some calculationsI want to add a trigger that in the final "repeat for each" loop, a script updates a record in a table so that I know that the whole automation has been executed and can trigger the next one. I can write a script and input the length of the logics list but I am not sure how I can keep track of the current loop number (through a counter or variable?).