Solved

Hi everyone,I'm relatively new to Airtable, and I need to automate a simple report that aggregates metrics within an Airtable base then emails it to users. Here's some examples of the performance metrics I want to calculate:Total A IDs generated (there are multiple kinds of IDs)A ID "win" rate (i.e. when IDs = A,  and winner = TRUE)CTR increase per minMost winning ID B/C/D -- (ex: D by XX% over B and by XX% over C)Total testing time: XXX minsAvg testing time: XXX mins/testI've setup the initial framework of the automation (i.e. sourcing the table and emailing it users), but I'm struggling to aggregate the metrics that I want sent out. Right now, my rollups are only working on each row, instead of aggregating the entire column. When I try adding a SUM or COUNT formula at the bottom of each column, it doesn't work. Any assistance is much appreciated! 

I looked for other solutions on the forum and either I'm too much of a novice to know how to solve it or it didn't work for my problem. I have a rollup field that is collecting multiple dates. I'd like to have it only return the earliest date in the list.  Is that possible?  I tried using MIN(values), but only got a 0 in the field.  Thanks!

Hi everyone,Since the storage for my attachments is limited, I've compressed the images and uploaded them on Airtable, and stored the high-quality ones on Google Drive. Now, I want to add URLs to shared Google Drive images so they can zoom in on the image (a function that Airtable is currently missing).Because there're records that contain multiple attachments, they will have more than one URL. I can add multiple URLs in a long text field but they display as lengthy URLs and don't look nice. Is there any way to display it as multiple buttons?Thanks in advance

I have a series of Interfaces that all start with the same record picker.  I'd like to pick the appropriate record in the record picker of the first interface and then pass the value I've selected in the record picker to the remaining interfaces so that I don't have to pick it at the start of every interface.  Is there a way to do that?

I have addresses with several fields, some fields are not always necessary.MemberOrganizationMail Address2nd Mail AddressCityStateZipo CodeTrying to get a multi line field that has no blank lines.Here's the formula I am using. I cannot find a way to get rid of the blank lines. What am I doing wrong?I also included a screen shot of the existing multiline field.Thanks in advance for any help, Scott TRIM( IF( AND( Organization, {2nd Mail Address} ), Member & "\n" & Organization & "\n" & {Mail Address} & "\n" & {2nd Mail Address} & "\n" & City & ", " & State & " " & {Zip Code}, IF( AND( Organization, {2nd Mail Address} = BLANK() ), Member & "\n" & Organization & "\n" & {Mail Address} & "\n" & City & ", " & State & " " & {Zip Code}, IF( Organization = BLANK(), Member & "\n" & {Mail Address} & "\n" & {2nd Mail Address} & "\n"

I'm debating on changing a single-select field to a multi-select field, but I'm uncertain on the effect it will have on all of the dependencies.I have a Progress flow that follows cold leads (potential investment deals) into committed investments, where we then put the deal into either a 'Syndicate Investment" view or a "Fund Investment" view, but some deals have both investments. SO, in the view prior to putting them into one of these investments, i'd like to change the single select to a multi-select that will allow me to put 2 tags on select investments where both the syndicate and fund will invest, thus moving the deal into both views. Is this going to screw up my full flow process? 

A noob here with Airtable. I've been looking for a way to consolidate data automatically between two tables.I want to match sales data from store into product database. At the first table I have product properties database. At the second table I have sales data from the system. They share in common the product code.The first table looks like this:Product code | Product name | Product units sold | etc...The second table looks like this:Product code | Product units sold | etc...Problem: As the sales data is imported into second table with DataFetcher extension, it is not easily connected with other product data. I'd like to somehow combine this data automatically, so that when browsing the first table, it would fetch the units sold information to each product based on the common product code. I would imagine the solution to be running an automated script? The script would be like:if [the product code in table 1] = [the product code in table 2]then set [the product units sold in table 1]

I've got a little script on Zapier where if somebody registers for a Zoom meeting, we add them to Airtable. To avoid duplicates, I search for to see if we already have a record for the registrant with a query like this:OR({Email 1} = "{{email}}",{Email 2} = "{{email}}",{Email 3} = "{{email}}",{Phone 1} = "{{phone}}",{Phone 2} = "{{phone}}",{Phone 3} = "{{phone}}")However, if Airtable doesn't find the email in any of the three email columns and the {{phone}} is blank, then Airtable will return a result for a record with a blank phone number, which is obviously not what we want here.Is there any way to construct a query that will not return a match for an empty phone number?Thanks!

Hi, Myself and another team member are on the business plan and under the same domain. I have an option of sharing just an interface but another team member under my same business plan and domain cannot.  When they try to share just an interface, it's saying, they need to be on a paid plan. However, they are, they are on my business plan.Any help/guidance is greatly appreciated. 

**3/18 UPDATE: AT support was unable to find any evidence of why this happened; we were also unable to recreate the events and have it happen again. The ticket with them remains open; best guess is that it happened during the same time as a service outage (there was one that affected rich text fields around the same time.)We have a table in a base set up as a simple ticketing system, nothing fancy.Users update a long text field with any actions/updates to the ticket in question.All users who have access to the base access the same way (grid view), though they each have their own view set up.We utilize the '@mention' feature to notify the responsible party after certain actions, and when they become responsible.We've noticed that any time someone enters new information in the long text field and '@'s' someone, the record removes all previous '@'s'.I've watched this happen in real time, and am confident that the system (Airtable) is making these changes, and not the human user, even thou

Hello. I have two tables. Project has a date field "submit date." It is linked by the "Project ID" field in Project to the "Project" field in timelines.. Linked records in the "timelines" table vary on category (color team), with one called "submit.". Each timeline entry has a date associated with it. When the "submit date" is updated in Project, it should update the "submit" entry for that project with the new date.I am having difficulty making an automation for this.Step 1: When a record is updated. Step 2: Find records. Find records in the timelines table where the color team is "submit" and the project matches the project from the Projects tableThere is something wrong with this step but I don't know what it is.Step 3: Update recordThis would update the submit date in the Timelines table, but I can't seem to get there.Could I get some advice on how to finish this automation?Thanks! 

Hi, just trying to get some advise on how to start creating an inventory managements base on airtable. We provide kits with have their own unique indentfying number - and each kit contains devices which we record the serial numbers of - they belong to each individual kit. Is there a way to build this out so that the Kit ID "contains" the unique devices? But still make them moveable and flexible ? We also will need to track stock that has not yet been built into a kit - but all with have unique serial numbers. Many thanks for any insights! 

In an Interface, is there a way to allow users to edit records in a Kanban element but restrict them from adding a new stack? 

I'm using this formula in a Deadline Alert column: IF({Deadline} < NOW(), "Late", IF(IS_SAME({Deadline}, TODAY(), 'day'), "At Risk", "On Time")) I have a separate Status Column to mark tasks Done. Is there a formula to show "Done" (instead of "Late") in the Deadline Alert column when "Done" is selected in Status? 

When entering a new record in a grid view in airtable.I want to start an automation that will create a new grid view with some specific filters.Practical exampleI have a franchise. And when I register a new franchisee, it will automatically create a grid view, with some specific filters. Then I'm going to share the visualization of this grid view with this franchise.look the videohttps://www.loom.com/share/3cfbea4199d0488a89500344a4f98acb

Hello,I'm reaching out for assistance with an issue I've encountered while trying to interact with the Airtable API. Despite following the documentation provided by Airtable and ensuring that I've granted the necessary permissions, I'm consistently receiving an error message.Here's the API request I'm making:curl -X POST "https://api.airtable.com/v0/meta/bases" \-H "Authorization: Bearer YOUR_TOKEN" \-H "Content-Type: application/json" \--data '{"name": "Apartment Hunting","tables": [{"description": "A to-do list of places to visit","fields": [{"description": "Name of the apartment","name": "Name","type": "singleLineText"},{"name": "Address","type": "singleLineText"},{"name": "Visited","options": {"color": "greenBright","icon": "check"},"type": "checkbox"}],"name": "Apartments"}],"workspaceId": "wspmhESAta6clCCwF"}'However, I'm consistently receiving the following error message:{"error": {"type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message": "Invalid permissions, or the requested

Hey guys, I have a button in my Airtable that triggers a Zap in Zapier. I'm using this code: { "https://hooks.zapier.com/hooks/catch/14888220/30r6035/?recordID=" & RECORD_ID() }, but it's triggering the Zap twice. I'm also using multiple buttons, and it's not working as expected. Can you help me troubleshoot this?

Hi,We have a scoring system that rates functionality in an interface. So as not to bias the total score, if the functionality isn't present we ask evaluators to give it a -1.In Excel, the final score is determined by a formula that:Counts the number of criteria where the score is >= 0Determines a max possible score based on the number of criteria scored (e.g., there are 10 criteria in a category but only 9 of them got scored the max possible score is 9*3=27 (9 criteria scored * highest possible score))Adds the values for each of the criteria scored to get the actual totalI'm able to use sum to get the total score but I'm not sure how to get the number of criteria scored without using countif which Airtable doesn't seem to have.Is there a way in AT to do what I'm trying to do? Any help is most welcomed. 

Suppose you have a series of records that include zip codes. There may be many of one zip code and a few of a bunch of others. How do I get a list of the frequency of these zip codes? So 14757 occurs 6 times and 14722 occurs 9 times and 20021 occurs 3 times, etc. I want to get a list of the zip codes by how often they occur and if possible a count of that frequency.Any thoughts would be greatly appreciated.Scott

I expect this is beyond what Airtable / 3rd party automations can do but if achievable this would be an absolute game changer for me. I would like to create three fields. Field 1 (Single Line Text) / Field 2 (Attachment) / Field 3 (Attachment).In Field 1 - I enter the name of an employee. In Filed 2 - I attach a multipage pdf. Then in Field 3 - I get the multipage pdf with the individuals name across it as a watermark.I've tried programs Zapier, CraftMyPDF, pypdf but hitting hurdles throughout. Any ideas are enormously welcome.     

I'm building a PTO request workflow in Slack which adds a record to an Airtable. Airtable then automates some downstream steps which will post the PTO to a shared Google calendar etc. It was working fine. I wanted to make some modifications without messing with the original workflow so I duplicated the workflow itself as well as the Airtable. The Slack workflow duplicate allows me to choose that duplicated airtable (I added it to the integration in Airtable) but it simply won't work when I try to run the Slack workflow. Slack throws "The service used for this step isn't available" when I try to run it. I deleted the Slack integration in Airtable and re-created it with a request from Slack to no avail. I also tested deleting the copy of the table to see if the error changed, and it did- Slack would say "The user doesn't have permission to use this step." instead. A brand new airtable base from scratch works, but I don't want to re-create the existing one if I can avoid it. Any

Hi,I have a table named "Customer" whose field is "Address"I also have a table named "Invoice" where the associated fields are "Target Customer" where it is linked to "Customer" table and it can linked to many customers; and "Latest Address" which is a roll up field.In my case, i only want to retrieve the last address of the last linked customer. So if i have ["Customer1","Customer2"] in "Target Customer", the "Latest Address" must be Customer2's address only.How can i achieve this?Note: Customer1 and Customer2 are not related to any created time or updated time or any min max value. The sequence is totally random. Thank you

Hello there,https://api.airtable.com/v0/appycQyQBCRaFT2aD/Tebi-Category-Test?maxRecords=110&view=Grid%20viewI'm using this API to get the my table's data and after that I will process this into my CMS and then to fetch next records there is offset which I'm using to get another records. Since the records are more than 100 server might get out so I tried to get less records like 10 but offset is not there in the response.so can someone help me to get less records and also the offset in it ?Thank you.

Is it possible using a formula or automation to compare two multi-select fields and show which items are missing from the 2nd? I'd like to have a 3rd field that would show just what was missing from the completed list. 

The "Add record" and "Add milestone" controls are disabled in our Gantt view. Removing all filtering, all grouping, and disabling/re-enabling "Use milestones" in the view's settings have not helped.'How is this supposed to work?