Ask the Community

Is there a way to filter a table that has been grouped and totaled (sum) by the group's total? 

Hi,I'm a relatively new Airtable admin. We have a user who can log in using SSO, but when he does he gets an error message saying that his free trial period is almost over. Since we have an enterprise account, I would think he shouldn't see that message.His account looks ok to me in the airtable admin area:(I covered over his real email address for privacy, but it looks like the rest of our users - uniqueid@dartmouth.edu.) I've tried signing him out of all sessions from the button shown, and had him log in with a different browser and a private window. None of those things helped.I opened a ticket with Airtable support, but I thought it was worth posting here as well. Any thoughts on how to fix this?Thanks and have a good day,Joe MontibelloMana

Hello, I would like to ask someone from the community for advice, or the correct formula, since within Airtable I solve such tables, or a linked table with several fields / windows, while it is a kind of recorder and at the same time an evaluation of records in the recorder of activities of members of a team.So I have one table called Schedule of activities where I have the first column which belongs to the Activity ID, the second column which belongs to the date and the third which belongs to the Type of Activity and then there are other columns with checkboxes, each one belonging to a specific member - e.g. Member A, Member B, Member C etc. (one column for one member).And then I want in the next table, or table field /table window called Summary of members' participation in Type of Activities, I wan to make a summary of the number of participation of specific members in specific types of activities. So I have in it the first column belonging to the ID of Summary,

We do a lot of difficult things for clients - from complex integrations to crazy mapping and data visualizations. But a recent project required field-level encryption in the new Google Tables product as well as Airtable. Encryption Scenario: User fills out a form and reveals confidential information in one or more form fields targeted for encryption. The user also enters a “passkey” - think pin-code like “2998” or a password like “good1ucktryingt0geu$$this”. The form is submitted and an action script immediately transforms the entry in many ways. The target encrypted fields are combined into a collection of strings and encrypted using a 256-bit AES algorithm resulting in a single cypher key. Al

Hey everyone,I am building a sort of meeting room booking system.So the meeting room will have a fixed availability between 9am to 6pmHowever, the bookings can have 5 variants:15min30min45min60min90minHow can I allow people to book meetings based on the time they want, but block out the availability despite the duration differences? I'm happy to compromise and limit it to 2 options if necessary.

I am creating an automation between airtable and slack, so when a record is created in a view in airtable it notifies a slack channel, and tags people based on another field - but I'm having a few issues!In the record we have today's date, the task type, details about the task, the scheduled date and the member of staff needing to be notified. If no staff member is mentioned, it notifies the channelI have the trigger set up as "When a record enters a view" and a delay totaling 116 seconds (multiple scripts one after another) with an action to find the record. In the run history this is complete, and it shows the fields and their content - however the slack notification is not including any of the fields in the message. Additionally, if 2 members of staff are tagged, it only actions the first one, then finishes the automation. Any help appreciated, some images attached

Hi there, I have several different views and I am getting the data pushed through Zapier. I need all the new leads to be showcased in the "new leads" view. Where can I set up rules so all leads will be here in 3-4 weeks or something like that? Thanks.

Hello, Airtable community. I have a Google Drive synced Airtable base and all Zoom call recordings are stored there. I need to use an app to show the Zoom recordings by clicking on the drive link. Is that possible anyway? Any app for that? All apps I tried, are looking for the attachment field. Thanks in advance. Dave

Hi all,I am trying to create a grid view in which I keep track of projects (the latter come into through Airtable forms).Each project goes through 6 stages with specific tasks associated to them (the tasks are always the same for each project). I would like to have a list that shows the tasks that have been completed for each project against the ones that are missing and, on the basis of this, I'd like to be able to track the progress (through a progress bar/formula?).Is is possible? If so, how could I set this up?

Hello everyone,I have a form from which i collect various data for my events. I am trying to create an automation to pull 2 parts of the form to put them in 2 new records in some other tables (Form -> Contact[table] and Company[table]).I was having no issue at all until I tried to pull the data of a single select field from my trigger record (the form) and use it as input for a single select field in the other table. It only gives me the possibility of choosing an option from the destination table an not from the trigger record. Also meaning, the blue button to choose which data to pull isn't appearing.Anybody had the same issue and/or have a solution for this subject matter ? I would really appreciate your help !Thank you all

Hello everyone,I need to insert the current date in a filed when a second field is updated (Yes or no) in the record updated.My need is that the first field is a "Date" because it could be modified inserting a different date in the case of any modification.I can not find any solution: automation with a button is too difficult for me (script) and automation does not the job for the record updating.Please can you help me? It seems so easy ... (I surely prefer Airtable but actually Spreadsheed does it in a minute). Best regards A. Borriero

I’m curious if anyone else has tried pulling data from Airtable into AutoCAD. I understand that AutoCAD can connect to SQL databases or an ODBC source. That makes me wonder if I could connect to Airtable through the ODBC Data Source Administrator in Windows to then connect to AutoCAD. Thoughts or Ideas?

Hi, I am a new Airtable user and I have a problem with the display of data in Calendar view: the date of today is wrong and tasks are scheduled one day before the defined date (see attachment). If I login on the phone the dates in Calendar view are correct. How can I correct the today date in Airtabel on my PC?

Hi all,I am stumped on this, but I imagine it's something fairly straightforward.I want to run an automation that will copy data from one field (Copy-to-field) to another (Copy-from-field) but preserve the original data in the Copy-to-field.Note - the Copy-to-field is a look-up field.The trouble is, when the Copy-to-field contains data, it  is wiped by the new data from the Copy-from-field.I have tried adding the Copy-to-field as a data source in the Copy-to-field in the automation, along with the new data I want added but this throws up two problems:1. It combines the original data with the new data, rather than keeping them as separate entities as I need, which is important because this is a look up field (i.e. it creates a new combined record in the look-up table e.g. instead of 'Joe' and 'Bob' as two distinct entities, the entry jus

I have interface pages utilizing the "tab" filters, but im not seeing any way to default to a specific tab. Instead it defaults to "all records" every time. Even if i navigate to a specific tab, and copy the URL to share with someone, it refreshes back to "all records" tab.

I am trying to create a base that tracks documentation-compliance.  Essentially, I have employees that have one or  more licenses, where each license requires the presence of a variety of documents to be in compliance.I created four tables:Employees - obviousDocuments - a list of each employee's documentsLicense Types - a list of licenses that an employee can holdDocument Types - a list of documents types, to be assigned to a document and required by a licenseMy current structure:EmployeesDocumentsLicense Types

Hello 👋I have been building automation to link data from one table to another when one table receives data from Airtable's Web Clipper extension.I have a way to do this, and when I run each step of the automation test, the data is populated in the correct fields in the other table.The problem is that on the final step of the automation, Airtable thinks that it received invalid inputs despite it correctly updating the record when running the test.I will try to outline the automation below:1. Web Clipper is sending data to a table called 'Applications'; it has a single select field for Companies, linked from a table called 'Companies'.2. If a company does not exist in the Companies table, there is a text field for New Company's.3. The rest of the data is entered into the Web Clipper and sent.4. A New Company is entered in Web Clipper as single line text, and this is mapped to the Applications table.5. In the Automa

I need to upgrade to Teams, but don't have time right now to  re-train myself and others if necessary.  What are the major differences between the two products?  Will the bases look and act the same in Teams as it did in the free product?

Hello,How can I change who receives the notification when a form is submitted. There are other people designated as owner in our workspace. 

Basically the title. This was working yesterday, showing the name of the person who modified the record most recently. Now it shows the red ! triangle and says "Invalid visual variant" in the Record Detail.What's weirder is when you open the interface editor to try and figure out what's going on with the Record Detail, it shows the correct name.

Hello all, I am stumped. I am trying to combine data from two multiple select fields, into one. For the sake of confidentiality, I have created an example of what I am working with, using part of the Greek alphabet instead of the actual data: The goal is to combine these two columns into a third that looks and behaves exactly the same as the first two, simply with the data from both combined, into one. As easy as this feels like it should be, every single option I’ve seen either turns the output into text strings (which renders it useless for our tracking purposes), or else it requires a great deal of manually typing or copy-pasting the individual options of the multiple select, into the formula, one by one. It should be noted that while I have only used four Greek letters here, the actual number of entries we are working with is well over 600, and with far lo

I have information coming in from another application that puts a list of email addresses in a text field and I want to use that list of emails to each contact associated with that list and link them in a separate link field. I've tried to think through ways I can use Loop on Zapier, but it overwrites each subsequent contact, and Airtable doesn't seem to let me use a comma-separated list as something to use with it's repeat action in Automations. Any ideas?

Hey guys, Just signed up and exploring all the possibilities of Airtable.What I need to do is create a chart tracking my financial portfolio performance over time (I doubt it's possible to create charts, so essentially a table with two columns - one with the day, one with the portfolio value - extracted from another table. Can the entry creation be automated?So let's say every day at 6am, it creates a new entry for that day and takes the value of the portfolio at that time.I hope it's clear.Example: Sun 24$10,250Mo 25$10,480Tue 26$9,880Another option would be to have the days pre-populated (manually

I've been trying to find where the configuration settings are for a table with no luck. I'm sure it's obvious but I'm not seeing it anywhere.I'm currently using the grid view, but can't add another row.

Hi... I can use a little bit of help here from the experts....  We currently have a Google API integration with Airtable  on a project and we have set up routing and it is working well to create and updates routes (route records) within AT for us, but we don't know how to do 2 things we want to do:I don't know how to get an actual link back from Google Maps to the route record (we are using Make for this integration) to just show the route (waypoints) on an actual google mapI am wondering if there is any way to update the route waypoints (drag and drop on the map into a different order) and have it actually update the route records in Airtable when we adjust the route order on the actual map?