Other Questions

Have a view with many columns, and would like to distinguish individual “groups” by adding background colors to these groups. Can do?

Hi all!Is it possible to create a sync-ed table (from JIRA or Salesforce for example) that will import data but also allow to create records?So it's a mix of sinced records + manual?thanks!

I have set up an airtable form that I will send out to a large audience. I do want to restrict the access to multiple email domains for security purposes but it seems like I can only do just one email. Is it possible to do it for multiple? 

Hi all, We are trying to define roles and responsibilities within our organisation. One of the possible models that works really well in Excel is the Responsibility assignment matrix or RACI model. See https://racichart.org/ It is basically a table with tasks as rows and roles as columns and in each cell a marker that defines if someone is Responsible, Accountable, Consulted or Informed (hence RACI) by sdding a letter in a cell. When this table is filled in properly we can give each employee a clear overview of his/her responsibilities. Im getting the hang a bit of Airtable and am able to use it for a lot of our organisational overviews, but I have no clue yet if the above mentioned could also be achieved with Airtable and lead to a satisfying result, or if I should just stick to Excel for this. Would be awesome to hear your suggestions!

I’ve used a Rollup column to aggregate data from another table. There are duplicates in the data being aggregated, as well as blanks. I use the ARRAYUNIQUE(values) to operate on the roll up data. I even created an adjacent cell with an IF statement to test for ISBLANK and it is being returned as being blank. Once I set a filter the Rollup column to not show empty cells, empty cells are still shown. The issue is in the only DB in my account, in the Organization tab.

Is anyone else constantly interrupted by 'Reconnecting' and/or 'Saving Changes' messages? This happens on some of my least complex bases with a tiny amount of data in them. It is extremely frustrating, constantly breaks my focus, and causes my work to take longer than it should. This has been brought up to Airtable many times, but it continues to linger, so I figured I would post here and see if others are facing similar issues. 

I get this notification every 3-5 seconds: “Trying to reconnect… please check your internet connection” The connection is stable. Other apps work well.

Hello there, How does it work with the privacy of Airtable? Can I trust that my data is safe at Airtable? With kind regards

I store price data in a Products table, and link to it in an InvoiceLines table (Many InvoiceLines from One Product). However, when a price changes (is updated) in Products the original price of that item should not change in those records in InvoiceLines that have already been created. Given the Lookup type doesn’t offer it, can you think of a way to achieve this? At the moment the only way I can think of, is to export data from one table and import to another?

What do I do to solve this problem? I’ve been trying to join in with my new colleagues but can’t accept their invitations. I get this message over and over with no instructions on why it’s happening or what to do next. When I type the Airtable message into the Airtable support searchbar I get over a hundred hits but none of them tell me how to fix the problem. When I go to Google for help the search engine autofills my question right away, which tells me that lots of people are having this problem. I wonder why Airtable does not help people in this situation, but I really need to know what to do next.

I am the owner on a team account. I have 2 creators and 7 editors. The 7 editors are not on the entire workspace, but rather on the bases I want them to have access to. I have one base I'd like to create, but I don't want my other two creators to have access to it (sensitive budget information). But I can't find a way to do that without taking away their creator status and I want them to keep that- they've been instrumental in building bases and will continue to do that. 

I am having trouble understanding the WORKDAY_DIFF and DATETIME_DIFF. Primarily I need it to return hours and minutes within 5 working days. Not just whole days with the WORKDAY_DIFF and not just total hours and minutes including weekends with DATETIME_DIFF. Example: Start a project at 4:25 pm Friday and finish at 9:40 am Monday, I would like my Turn Around column to say 2 hours and 15 minutes (2:15). I do not need it to round up to the nearest whole hour. I would appreciate any help you can give.

Hi. Corporately we are starting to use MS Planner, has anyone achieved any level of integration or linking with AT please? Ideally I’d like end users to be logging tasks in planner and they are automatically logged in AT. Regards Rob

Our organization is currently on the team plan and as owner of the team plan, I want to grant owner permissions to another user but it seems this is not available on the team plan.  Is that correct?  If so, why not?  Please consider improving user management on the team plan.  It is not very user friendly and limiting.  

I have an Airtable base with two tables: “PT” (where students submit a form to reserve a date) and “Available time on Math Classes” (which lists all possible date/time slots as text in the format “M/D/YYYY h:mm A” as a linked record). In PT, after a student picks the first date, I use a formula to calculate three more weekly dates. Then I add a filter to find each date in “Available time on Math Classes” and hide them, so whenever the students are willing to book a date and time the other students can't book the same date/time.Despite having matching text formats (and manual searches confirming these slots exist), the Find records step in the automation always returns “No records found.” I need help pinpointing why the automation won’t recognize an exact text match and ensuring these additional dates are properly found and marked as booked. Or I need a way that could hide the other three dates from “Available time on Math Classes”. Note: 1- the “Available time

I am creating a scenario in MAKE to add a new record to my student database once a student is marked as enrolled in my admission database. Everything works well, but I am facing one issue. I am able to use the HTTP Module and “Upload to Google Drive” Module to add the student photo correctly to the student database. However, I have two other file fields in the admission database that need to be synced, and they contain multiple files. How can I ensure all those files are added without missing any to the student’s database?

Hi everyone,In Airtable, I created the a tables with 30 records and I have already sent comments for each records in Airtable. Then connect the Airtable and Tableau using web connector."Now, I want to display these comments as a separate column in  Tableau Desktop automatically and also wants  the newly added commenting records to show in Tableau desktop automatically without any third party tools".Could you share any detailed steps or alternative methods to achieve this?Thank you...

Hello,I'm new to Airtable, and have been struggling to find the best way to solve my problem.I apologize if there is a similar post for this problem, but I couldn't find any that helped me to solve mine.I'm currently designing a base with multiple tables where there is a repeated and fixed information that needs to be reflected in different tables and different tables have different purpose and calculation. Thus, I would like to know if there is a way to create a reference table where I can update the data once and have it flow to other tables as needed.To give more information about what I'm trying to accomplish, let's assume that there are 4 tables.Table 1 - Reference TableTable 2 - InvoiceTable 3 - BillingTable 4 - ReceiptIn tables 2, 3 and 4, there is a fixed amount that needs to be repeatedly reflected for different calculations called and let's assume that the field is named as 'Gross Item Price'. Instead of creating a formula field to reflect the 'Gross Item Price' of $500 (whic

Hi,I am looking for consultants to help with building a relational database in Airtable with our data. I am looking for private consultations and not courses. Please email nishanthi@redabbeylabs.com with details in addition to replying here. Thanks a lot!

Is there any setting to mess with or extension to install that allows you to have an attachment open, but not fill the entire browser? Unfortunately some of our uploaded attachments are scanned & handwritten PDF forms, but ideally I would like to be able to open the attachment easily in a side panel so I can both view the PDF and still access the grid view of the records and edit a few of the fields. For example, the PDF may have a date on it, name of who prepared the form, and a task all handwritten on it. It is uploaded to the table which creates an essentially empty record that just has an attached PDF and I need info from the PDF to fill out the rest of the record. Side by side would be ideal (some of the handwriting is beyond any type of attempt at image rec).

I have many different bases which will have a table that has attachments, and then linked records to other tables within the base which then lookup the original attachments. As of yesterday and all days prior, I could open the attachment in the lookup field in the linked table directly. As of today, I can still see the preview for the attachment being looked up, but when clicking on it the cell goes blank and it won't open. My attachments are mostly PDFs but I'm seeing the same "won't load a looked up attachment" in other bases with photos and word docs as the attachment as well. Looks like it is an issue in the web interface and desktop app, possibly not in the mobile app (android) though.

My record is an account with multiple individuals and I need a way to use SendGrid to send an email to multiple recipients on that account. I’ve tried using a long form with "email1@email.com; email2@email.com;" as the Email Address Field, but it only sends to the first email. However, the email that is received does show multiple recipients in the “to” field. Is there a way around this, or is Airtable just not parsing the subsequent emails. I looked at the SendGrid API and it looks like you need to compose your JSON API call with multiple “to” recipients and so I’m assuming that SendGrid is also only parsing the first email for actual sending. Really really important for us.

Hello, I need to figure out how to display multiple select options in a cell that is contingent upon another cell. I’m making a list of corporate goals, then under corporate goals I have department goals. I want my cell to display only goals that I choose from within the department goal category. I have one column for Strategic Goals, another column for Department, and another column that I want to use to display Departmental Goals. I want to be able to search within the Department to select the goals I want displayed within the cell without it showing me every department goal. Is this doable? Please help asap! Thank you.

Hi Airtablers! I have started a self-study to record day to day activities in my home-based caregiving initiative - taking care of my 91 year old Mom. I am using the default time setting in Airtable - 1/2 hour increments - is there a way to set it to 1/4 hour increments - ie. every 15 minutes instead of every 30 minutes? Thanks!

Hello,I'm looking for a solution that would allow me to build a front-end for my Airtable bases. I've already tried several solutions but I still have the same problem: I have a lot of buttons that trigger scripts (scripting blocks).I may have missed some features or solutions that offer this, but today if I have to migrate my scripting blocks to automation (to go through Interfaces) it will take me a lot of time. Solutions like Softr and others don't seem to allow this either.If you have a way of doing this without too many complications, I'll take it, otherwise I'll roll up my sleeves 🙂Thanks in advanceKevin