Ask the Community

Hey amazing people 🙂 I have a rollup field puling in unique values, and I really would like it sorted (in this case by ascending date) but I can't figure out how to do that? Community Search didn't bring much up for me.Here are my settings:And here is my display result I would like to see "March 3rd, 2023" March 4th, 2023" "March 5th, 2023"It seems to pull in based on the order of my current Top view in the Table it is pulling from, but even swapping the View with the sort order I want didn't seem to change anything (And I don't want that view at the top anyway)Any ideas?

I have 2 tables with a many-to-many relationship...Companies companyName, companyCountries (linked to Countries table)Countries countryName, projectPhase, countryCompanies (linked to Companies table)The projectPhase is country level, for example...GB = "go live"JP = "phase 2"MY = "go live"US = "phase 2"1 company can have multiple countries, and so on the Companies level I've created a rollup using ARRAYUNIQUE(values) but I've run into a problem with a scenario like this...CompanyA is live in GB and JP and shows "go live, phase 2" CompanyB is live in JP and MY and shows "phase 2, go live"I've read a bunch of posts on this behaviour and how the rollup retains the sort order of the original linked source (in this case Countries), but my Countries table needs to be ordered as it is, and there's so much variation in my companies data that regardless of t

Hello everybody, at first I set one column in my table 1 so that I can link it to items of records from a different table 2 (via multi-linking to record). Then I wish to fill a different column in table 1 through rollup function with another matching item of the same records from table 2. Problem is, that the order inside the rollup column is automatically opposite to the order in the first column linking to the record. I would like to have the same order in both columns, but I cannot set anything about the order connected to the rollup function. Can anybody help, please?

Hello, I'm looking for a WordPress plugin that would allow this: For each new entry in an Airtable table, retrieve the images and text and insert them into a defined WordPress page (always the same, it would be to create an image and text library...)thank you.

Hi everyone,  I'm trying to be proactive with the the imminent change to the integration with Airtable. I've connect Zapier via the App Update (Presumably using OAuth) and connected Make with an OAuth connection.  However, I expected to see the connection appear in Airtable under the developers OAuth section but there is nothing. How would I manage and revoke these connections if I can't see themCheers all, Jason   

The new Interface feature allows you to filter a collaborator field by “current user” which is a great time saver. Anyone know if they will make this available in regular AirTable views? I really need it.

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

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.     

So full disclosure I do not have a ton of experience scripting, but I have built quite a bit of stuff in office script with the assistance of chatgpt and a lot of follow-up questions/research to understand what CGPT did and why it did or did not work.Did the same here trying for my first scripting automation but I am kind of stuck on an issue early in the script. The intent is that whenever a record is created or updated, the script should grab ALL records in the table that have the same values in two fields as the new/updated record. IE if a record with training type "CPR" and employee "Steve" (both are linked record fields to other tables) is created or updated, then the script should retrieve ALL records in the table that have CPR and Steve in the respective fields. It should then look through those found matching records and find the one that has the maximum (most recent) date in the date field, and checkmark that record. If another record previously had the checkmark, th

I have a Table, called Production Sheet, and each production "day" links to a master Batch sheet for that week. There can be many production days pulling from a single Batch Sheet in another table. I can link to the batch sheet just fine. What I would like to do is have the batch sheet show all of the linked production days, which would be separate entries in each of the production days. I thought this would be simple by running an automation, when a batch sheet is linked on the production sheet, by finding the batch sheet that matches that date, and adding that production sheet date to a field in the batch sheet. Of course, this would need to concurrently add to that field and not erase it, as multiple records would be added daily throughout the week. 

Apologies if this has been asked/answered but I couldn't find that thread - I really did look!I have some MAKE scenarios with many Airtable Modules, all linking to single Airtable BASE - itself having many Tables. But, I want to set up a clone of everything (All MAKE Scenarios duplicated and pointed/linked to newly duplicated Airtable BASE).I am using "Column IDs" in the Advanced section of all my Airtable Modules in MAKE. Why? It seems to offer a bit more flexibility for changing field names in Airtable, so they update automatically when referenced in MAKE. However, this seems to be working against me now - see below.Column IDs doesn't make any difference if I simply CHANGE an existing Airtable Module to connect/link-to the New Airtable base - the field mappings downstream break. Fine.But, I never give up, and I have the Developer Tools for Chrome, and it has this weird tool called Remap Source, which does what I want! But in order for it to work, I have

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 fr

I’m trying to figure out if AirTable can solve equations with unknown variables. For instance, a break-even analysis based on data in the table. (Revenue per unit ⨉ Units sold) − (Fixed costs + Cost per unit ⨉ Units sold) = 0 (200 ⨉ Units Sold) − (1000 + 100 ⨉ Units sold) = 0 Where Units sold is the unknown variable (“x”), and I would like to know the value of “x” where the equation returns 0 (break-even). A normal equation solver would give: (200x)−(1000+100x) = 0 x = 10 So, could I get “10” to display using an AirTable Formula? Thanks!!

Hi all,I have created an automation which takes an action based on whether a value (a list of dates, via a lookup field) contains today's date (via a formula field). Both are formatted to only include date and not time. However the action is not working because the value returned for the first step is [object Object], rather than an actual value (the list of dates). Any ideas? Thanks!

Hi,  I'd like to create a "Business Health Check" Dashboard, and I'm thinking Airtable might be a good way to do it,  but as a new user I'm not sure how to start. Basics:1. Dashboard view:   Show changes to each category over the past few months (line charts most likely)2. Form:    Owner would fill this out weekly with data for that week3. Data/Questions (this is where I'm not sure how to lay the data out for the questions, or to record it in a way that the charts could use it).  Question examples    - Time Period (Date 1 to Date 7 - usually a week - ie Mon-Sun)    - Booked for how many days out (likely do this as a number field:  1,2,3,4 .....     - How many new inquiries did you get from x source this week?  Number field    - How do you feel about business this week?  - Drop down selector - Not Good, Good, Indi

My airtable account does not let me generate an API Key, instead it pushes me to creating a PAT. I have used a PAT and successfully linked to Make.com however as far as I am aware I need an API Key to integrate Airtable with Voiceflow, so does anyone know how I can overide what it is saying and generate one. Or can someone help show me how to use the PAT to link with Voiceflow.

1. The Date Time Button in the filter when we select a date the data is not the same in the table where it is linked? When we select the past month, the value of the data is not match in the table when we filter it2. Can we do math operations in a table that is not in the same row but in different row?

I’m starting using AirTable and VoiceFlow. I use the following URL Endpoint to GET JSON string and it works fine. httpx://api.airtable.com/v0/appRDBju2BbYrBKCc/colori?maxRecords=1000&pageSize=1&offset={offset} I need to add filterByformula function. Could you suggest me syntax and how i have to use it? Is there a good documentation for this anywhere? Thanks very mach. Federico

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.

Hi there,We have a number of users who have interface only access (i.e., no base access). One of our pages uses a 3 level list. When they attempt to add a new linked record/new row through the interface by using the + icon (e.g., a task or action), they get a permissions error. Any insight about why this might be happening would be helpful. 

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? 

Is it possible send an Airtable form without the Airtable cookies (disable the cookies)? We don’t want to save the forms's information in the cookies, when it’s not necessary.