Ask the Community

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, then there is a colu

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. All targeted encryption fields are set to null values. The cypher created as a result of step #4 is then transformed into a GUID and placed into a designated field in the record With this process, which occurs in about 800ms, the record entered by the user is now obscured; the sensiti

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 just become a single entity 'Joe Bob' )2. If the Copy-to-field already contains the data that is being co

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 TypesDocument TypesWhat I need is a way to display (and ffilter) all employees and their documents, including a placeholder for missing documents.  In this example, Jane is missing documents for both here B and C licenses.Is this possible?

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 Automation, we have a trigger When a record matches conditions in t

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 longer names, so such a process would be a grueling time-consumer. Surely there must be some way to automate this? Also note t

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) for the whole month or year, and the automation would simply find the current day and write the portfolio value in the appropriate column next to it.Beyond the chart visualisation, I'd then need to perform further operations on this table, like weekly/monthly performance, biggest drawdown, average projected annual growth etc.  

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?

Hello,I set up an automation to notify certain colleagues when an asset is due to expire or up for renewal. Everything looks right, but when I send a test of the notice to myself and one other person, the notification goes through, but the identified asset that is due to expire is not included with the email notification. How do I sync up the notice with the asset? Thank you,Alisha

Hello,I have been creating interfaces for my techs to use so they can update jobs while in the field - the interface is designed to give them the information they need about a job, and allow them to quickly take notes, upload pictures, and log their time. Unfortunately, when I open the iPhone app and pull up this interface, I'm not able to edit any of the records! I can see them all just fine, but it's just not editable. According to the announcement of interfaces on iOS (https://community.airtable.com/t5/announcements/introducing-mobile-interfaces-on-iphone/ba-p/160766), we should be able to edit records, but the option just isn't appearing for me.I'm using the List interface, and have enabled the option to allow users to edit records inline. I can edit records using the interface on desktop just fine, but the iPhone app does not allow it. Am I missing an option?