Ask the Community

Hi guys, any help here would be great. I am trying to make a list of records automatically send to me every 24h, this list is based on status, all of this works, but my problem is I can't seem to get the list to be clickable?Tried both:[Link Text][List of 'Base record URL']and[Link Text](List of 'Base record URL')Any help to make these clickable would be great  

How can I have an automation (or formula) return only the first record in a manually sorted table or view? I have clients submitting tasks and manually sorting the tasks according to the order in which they would like them completed, and we only work on one task at a time. I'm trying to build an automation that changes the status of the next task ("next" is determined by the manual sort field) to "in progress" when there are no longer any tasks for that client in progress. How can I do this without creating views for every client? 

Hi, community! I need some help with this. I'm setting up a bank reconciliation in Airtable and need a column to record all the transactions from my bank account. Additionally, I'd like another column that shows the running balance for each transaction, reflecting the total income and expenses up to that point. I'm not looking for a single overall balance, but rather a balance that updates with each individual transaction.

For those who can help, would you please let me know how to count the number of attached files in the Attachment Field in Airtable?

I have two tables:Key Source FormulaSourcesWithin the Key Source Formula table I have a field called URL FormatAn example entry is:   https://www.website.com/search/?q="Company"&t=weekIn the Sources table I have a value called Company Name Texte.g. Apple, which I want to substitute into the URL Format. This should return a result like:https://www.website.com/search/?q=Apple&t=weekThe SUBSTITUTE formula I have is:SUBSTITUTE({URL Format}, "Company", {Company Name Text})It returns #ERROR.I have even used the Airtable AI to write this formula and it doesn't work.A

I've created a table where I have a multiselect field, and then grouped the data by that field.The effect in my table is that each unique combination of selected fields from the multiselect column has it's own group. So for example, if one record has "A" in that field, and another has "A" and "B", I have one group that JUST has the record with "A", and separate group for the records that have ONLY BOTH "A" and "B" (so the first record with ONLY "A" is not included in that group).I know some people don't like this but I actually want it this way - and what's frustrating is that now when I'm creating a List Interface, it works the opposite! So my list of records is grouped in the interface by that same multiselect field, but now the records are duplicated across groups.So, the record with only "A" is showing up in the group that is labeled "A" only, AND in the group that is labeled for both "A" and "B".Is there a setting I'm missing to get the list vie

I created a very mobile-friendly app using AirTable, had participants download the AirTable mobile app, and attempted to showcase the mobile interface with about 80 participants in a room. Participants complained of seeing completely blank screens or only partial amounts of data showing up.Is the Teams Edition insufficient for this use case, and do I need the business or enterprise version to handle this type of traffic? *P.S. The wifi was not the issue. 

So I’m a real estate agent and I use Airtable to keep track of all my deals. I have one block for rentals. In rentals it’s very common for a prospective tenant to want to see all my current active listings. I typically have 40-60+ rentals at any given time, some times more. Right now, when people ask for my list, I ask for their search parameters, go through the entire list myself, then respond back with a few listings. The problem is I have 25-75 people reaching out a day and 40-60 listings, plus an entire buy/sell side of the business. It’s becoming impossibly time consuming. So when I heard about the ability to create a shareable link to my up-to-date database, I got really excited. Especially when I realized I could hide fields that are for internal use only and I do not want prospects to see. But then I realized the primary field is the address of the unit and there is no way to hide this (but it’s really important to hide addresses for a lot of use cases I won’t

I’m currently selling my airtable base as a product. How to do that? Is there a way to create a user base that will be able to view the database? Collaborators would work best, but I don’t want them to see my changes and emails of other collaborators

I have been getting this very annoying bug where when I start editing on any interface page, the logo and header images on all of the overview pages across all of the interfaces in that base are automatically removed. Nearly every time I publish after making changes to one interface page, I have to reupload headers and logos to all overview pages. I hope developers can fix this soon!

Hi guys, I current have a button that opens a url that is a Make Web Hook, I was wondering is there anyway for the same button to also update the record.My plan is to open url to send email in sengrid, aswell as update status from Open > Sent. Has anyone done this before? Any assistance would be really helpful Thank you!  

I am testing a simple base approach which has three tables: Clients, Contacts and Jobs.The clients table has linked records to contacts to denote all the contacts that we work with at that client. And linked records to jobs to denote all the jobs we are working on with that client. A client can have multiple linked contacts and multiple jobs, but contacts and jobs can only be linked to one client.When I'm creating a new job record, I'd like to select the specific contact at the client who represents the lead contact for that particular project.I realise this can be achieved by a simple linked record field to the contacts table. However, when selecting from the contacts table, this shows all contacts regardless of which client they are at. Which theoretically means it would be possible to assign a contact from a different client than the job is for.What I was hoping was that there was a way to filter or add conditions to the linked record options so that w

I have Airtable views embedded on a google site page, and when you open a record detail you can see the attachment thumbnails in the attachments field, but then when you click on one of the attachments to view full-size, there is an error message "this page is blocked by browser". I have tried with both Chrome and Edge, and get the same error with both browsers.Attachment thumbnails in record detail:Error Message in Edge:Error message in Chrome:  

I'm building a project management platform. In my current configuration, there is a table for Projects, and another for Tasks. When a Project is created, an automation runs to add corresponding Tasks. The Project table has a "Status" field, with options for In Progress, On Hold, Canceled, and Done.When a Project status is changed from In Progress to On Hold, I added an automation that also changes the status of the underlying Tasks to On Hold (so the individuals to whom those tasks are assigned now to pause work on them).But how would I create an automation to switch that Task status back to In Progress if the parent Project status is changed back?If I set the trigger to be "when record in Project matches conditions (status = In Progress), it's going to update a lot of tasks that should be updated.Is there a scripting solution for "if a project was On Hold and now is In Progress, change all underlying Tasks statuses that were On Ho

Hello,I have a base that has many tables that are synced via emailed CSVs. One table was initially set up with multiple emailed files where they were ingested as updates to the table, which resulted in the ~100,000 records needed. for initial setup.Since then, updates are sent through each night with updates (which are much smaller record counts). Some of the records that are updated causes them to fall "out of scope", meaning they aren't needed in the table anymore. I'm aware of the ability to delete records, one by one, that are not in the source data (current emailed CSV), however since the emailed CSVs are a much smaller subset, and at this point there are MANY "out of scope" records, it would result in searching through a list of over 100,000 records, for each record that needs to be deleted.Now, to my question - is there any way to mass delete records, given the circumstances described above? I am able to identify the

What does done look like? (The requirements I collected)My CEO is wanting me to build a base that ties project management and PTO together for better task/project orientation.1. This base should display all projects and tasks as well as the leads and team members associated with them. 2. For PTO, the person's name should be linked with the dates that they will be out of the office.3. The dates for the PTO and Tasks should tie into on single calendar view that will allow my CEO to view everything from one place. 4. Alerts/errors should be displayed when a deadline or start date is set on a day where that lead, or assignee, is taking PTO.5. There should be an automated availability field that displays the persons availability for the week depending on their tasks/PTO assigned.  The base I have accomplishes 1-3, but I am stuck on completing requirements 4-5.Is there a way that this can b

I am developing software for car appraisers and have structured my database with five tables:Enduser (Appraiser) - Unique identifier: Email of the appraiserClients of the Enduser - Unique identifier: Email of the client (One appraiser can have multiple clients)Vehicles of the Client - Unique identifier: Vehicle registration number of the client (One client can own multiple vehicles)Appraisals of the Vehicle - Unique identifier: Report number of the appraisal of the client (Each vehicle can have multiple appraisals)Payments for the Appraisals - Unique identifier: Payment number of the report number (Each appraisal can involve multiple payments)Is this structure appropriate? One potential drawback is that when importi

Hi all,I have a really simple script as part of an automation, that is supposed to open the URL of an interface page item that was created earlier in the same automation.I'm aware there's a button to open a URL in the interface designer, but then i can't have that button run the automation... function NewTab() {            window.open(            "https://google.com_blank");        }

I'm creating a platform for project and task management. I have multiple users and multiple interfaces.One of those interfaces is an Admin section where projects would be assigned to users via a dropdown menu. I'd like this Admin interface to only be accessible for select users. But it appears that users who aren't given access to this Admin interface cannot be selected in the project assignment dropdown. For now, I've given those users read-only access to this Admin interface, but I'd prefer that this interface be hidden for them entirely. Is this possible, either on our current Team plan or any of the other account levels?

HeyheyI'm need a dynamic filtering option in the interface so I'm trying to use the built-in filter. For some reason the filterable fields that appear are not all the possible fields but just a random selection. I need to filter by status but status field is not an option to filter with the built in filter. See screenshots. Anyone can help ?

Description:I am looking to create a photo contest application in Airtable for a  pageant where users can view contestant profiles, vote for their favorite contestants, and manage the entire contest flow. SetupContestant Profile Section: Each contestant can upload their photos, provide personal details (name, age, hometown, etc.), and add a bio. This section should display contestants’ information for voters to view.Voting System: A voting mechanism where users can cast their votes for their favorite contestant. Each user can vote once per day, and votes should be tracked and counted in real-time.Voting Results Dashboard: A dashboard for tracking and displaying current vote counts for each contestant, including graphs or charts for quick visualization.Admin Panel: A panel for managing contestant entries, approving

I would like to use a link from Google Maps in an automatic Emil. every time the connection is rejected. I had previously entered an address in Google Maps and then went to "Share" and copied the link and then stored it in an email in Airtable. every time I get the following message: see attachment

Hello, I have two Date fields that need to show the time remaining (in years/months). My attempts at declaring the correct formula have not been successful. Here’s a screenshot with the field outlined where I want to show the difference. I believe this is the closest I’ve come: DATETIME_DIFF(TODAY(),Rent Commencement,Lease Expiration,‘Years’,‘Months’) Thank you! Anet Gambina

Hello, I am new to airtable My issue is I want to calulate the difference between two dates and calculate the seconds also, but i cant even add the seconds to the date how this could be calculated if it’s not even added. Im using the Datediff formula, is there’s any other solution?

Hey all! I have recently started using Airtable and I have been searching for an answer to this question for too long. I am attempting to track volunteer hours. I have a form that people will complete every time they have a “shift”. This form asks people when they came in and when they left. I want to create a formula that finds the difference of the End time and the Start time in order to find the total time of their shift. I have read through several ask the community questions similar to this and tried several formulas; including DATETIME_DIFF. However, nothing seems to be working. Please help! Thanks in advance.