Ask the Community

Hello'I am trying to create a table 'Customer Interested Events' which maintains basic customer information (customer e-mail is PK) and additional fields  (selectable fields) 'Event Category' , 'Event Location'.Based on the customer interested events another table 'Event Manager' would be populated which is linked with above table 'Customer Interested Events'. Purpose of this table is to assign a suitable manager against each Event Category. The PK in this table is a computed field "Event Category+Location" and has additional fields like 'customer name', 'location','event category' (lookup fields from the linked table), 'event manager'.I am trying to maintain one unique record against each (event category, location) with all corresponding customer names, locations merged in the respective fields (if multiple customers booked for the same event category, location) so that one manager can be assigned.While merging customers against an (event category,location), I could see PK 

I have a BASE with an Events Table, a related Contacts Table (One to many), a Schools table related to the Contacts, and a Groups table. related to an event where a group can be associated with multiple Events. In the Groups Table, I have a lookup that finds all the Contacts from all Events related to the group and another lookup that finds the School related to the contacts that show up in the first lookup. Because the same people attend multiple Events related to the group, the result in both lookups have duplicate values. My goal is 2 field that only shows the unique values present in each lookup. (Unique Schools and Unique Students) related to a group. I looked at using UniqueArray but couldn’t get the desired result and am looking for any Step by Step help that you can provide.

Unique Lookups - We have a Collections table, and a Projects table. Several individual projects will link into a single collection. Each project may have the same resources working on it, or it could be different team members. Currently lookup will pull in a name 5 times for example, instead of the same name only appearing once. Is there a way to use Lookup to only show the unique resources similar to the way Rollup Arrayunique works? I don’t like rollup because we lose color coding when doing this on single select fields and we lose notifications/automations that can happen with contact fields. I know I can run automations to watch for changes and then create a duplicate field that writes the values for the cell, but it would be nicer/safer/cleaner to not have to do that. Is there any way for this?

The result I am looking for is similar to the ARRAYUNIQUE function for a Rollup field. However, the results are a link to another table, and it seems that using a rollup can only show text results as opposed to clickable records. How can I make lookup field show only unique results, or make the unique results of a rollup field clickable?

Hi! I'm pretty new and having difficulty figuring out the logic of how to write this: (single select) Status = "review 1" or "review 2" (Long text) Feedback must not be blank If the above is true then it should provide an output of - "Ready!"And then preferably the errors can drill down to the exact issue..If the status is neither of those - Error, wrong status! If the feedback box is blank - Error, missing feedback! This seems simple but I can't seem to figure out the correct formatting to return correct results. Help appreciated 😄 

Hello Quick question, I haven’t been able to work out how to do this, but may be missing something. Can I have a row of say 6 buttons across the top of a grid, to give quick and easy access to filters? ie - click on the “available” button and only available records show. I’d have buttons for “out of stock” etc too. Hope this is possible - better than having a drop down filter. Much more visual. Thanks, Andrew

I use Airtable for my business and have my customers fill out a form with their info. For the Address column I currently have it as a single line text and that is causing issues. Customers are filling it out is '10 whalen rd' instead of "10 Whalen Rd Rochester NY 14608". I have the field as required however because it is a single line text I can't force how the address is implemented. How can I fix this?

Hi everyone, here is my situation: I'm working with KPIs and must record the people whose projects have been trained.  I'm using forms to collect the participant's data. So I have:Table 1 "People trained": the table where I have the forms and the data collected about people trained is stored.Table 2 "projects":  which is the one where I have the project data and want to update their KPIs when a form is summited. So my idea is to have in the table "projects" a count of people by the different KPIs registered in the table "people trained," for example, I'm looking to have in each project record the number of women that have been trained under the framework of that project. So, it means that every time a form is submitted, each project record needs to be updated.I already have linked table 2 with Table 1 by the projects field using the "Linked records" type, so when a person fills out the form, they can manually select the project that belongs to the activity they are parti

Hey everyone,I am slowly moving forward in my airtable scripting journey. What a ride so far. I would need some advice on best proceeding to finalize my script.Context:I created a script triggered from a button, to match client records with potential real estate properties, based on a set of preferences such as the number of bedrooms, the type of view, or some house features. The script does the following steps:- Fetch the criteria value from the record used for the automation (the client)- for each record in my property listings, it calculates a base score for each criterion (0 to 10)- It applies a weight point system to the criteria scores and outputs a Total property score (normalized from 0 to 10)- I then slice the top 10 properties and link the IDs to the client record under a specific linked field. Can't lie, as a no-code person, it took me a few days to get there.Currently, the criteria weight points are fixed, and stored in a const. This works but some extra flex

Can anyone spot any glaring mistakes in this formula? The more expressions I add on, then it 'saves' but then overrides with a simpler version of the formula... so assuming there's an error but I'm not seeing an error message and it's infuriating me (facepalm)There are some fields that need to reference themselves if they are not empty, the rest need to refer to another column if column A contains ***OTHER CHARITIES*** I've been going round in circles for a while now and losing the will 😄 IF({Charity Selection -Series and Challenge Charity Partners 2024}!='', {Charity Selection -Series and Challenge Charity Partners 2024}, IF({Charity Selection - Mixed funding 2024}='***OTHER CHARITIES***', {Other Charity Selection - Mixed funding 2024}, {Charity Selection - Mixed funding 2024}, IF({Charity&

Hi,We've been using HubSpot integration for several weeks now, but in the last days, the integration has been repeatedly interrupted by Airtable, and everytime we reconnect it, it was disconnected again after few hours, and finally permanently revoked (see screenshot attached). We've reach out to HubSpot support but they don't know what is happening since everything is working fine in their end and the integration is disconnected on Airtable's end. Regarding auth token and permissions, we haven't done any change in the last days that might trigger this interruption.Could you please assist us on how should we proceed here in order to re-run this integration again without facing new interruptions? Thanks in advance!

I am trying to integrate the properties of a ticket from hubspot to create an airtable row… The problem was the properties doesn’t show on the airtable. Everything was all set and completed in husbpot. Anyone who knows how to fix this?

Hi Everyone! For our base, we do a lot of emails out to external people (students, contractors, etc.) . We generally want them to reply to our emails and so we set up other automations to bump them if they do not fill out a form. One issue we have is that often times people will reply to our email but not fill out the form. We're not currently able to address that - and so have to manually record that they've replied in the base so that we don't bump them. Has anyone found a workaround to track "email replies" such that we don't keep bumping them? I know usually this is done by attaching some sort of cookie to an email or similar. I know this is possible in Hubspot sequences, but I haven't found a similar solution in Airtable. This would be a big win if we could have something like this! 

Hi everyone,I was wondering if we would be able to automatically add an URL as an "URL-Attachment". This way I would be able to fetch a QR Code image and have it in my table.I could not find anything online. Unfortunately I can't install extensions that are not directly from Airtable. Thanks for your help,Eren 

@Sho answered my first URL audit Find formula question: My followup question/challenge:I want to clean up (not just identify) the {Link URL} field and join it with {reftag} field:Addmissing https://and/or missing "s" in http://Removeinvalid characters; e.g., ' §the following querystrings:?ref= ?ref_=&ref=&ref_=Then join two fields ({Link URL} & {reftag}) based on logic:If {Link URL} Does NOT contain '?' append {Link URL} with '?ref_=' & {reftag} fieldIf {Link URL} contains '?' append {Link URL} with '&ref_=' & {reftag} fieldHere is the original solution used to callout errors in the {Link URL} field: IF( {Link URL}, IF( OR( FIND("http://", {Link URL}), NOT(FIND("https://", {Link URL})) ), 'missing https, ' ) & IF( FIND("http://", {Link URL}), 'missing https, ' ) & IF( FIND("ref=", {Link URL}), 'remove ref=, ' ) & IF( FIND("ref_=", {Link URL}), 'remove ref_=,

Hey! Thanks in advance for the helpThis is my problem, and I know how basic it sounds but I haven't been able to get this done! I'm creating an automation and Im setting it up so when a record matches a condition (WPM (numbers column) is not empty AND is less (<) than 35) updates a record (Candidate stage (simple selection) to --> Rejected)But what it does is its sending all numbers (less, equal, higher) to Rejected except when WPM is empty (at least that worked) I've troubleshoot as a maniac and nothing seems to work out - Any idea?

Hello,Referring to this Volunteer Management template:Volunteer Management Template - Free to Use | AirtableHow can I combine all of the tables into one 'Master' type of table so that I can run queries across table fields?I understand that there are lookup fields.  But each Volunteer Event has multiple Volunteers.  Each Volunteer can have multiple skills.  So if I want to run a query where I want to find out the pool of skills that the pool of volunteers bring to Volunteer Events between Sept 2023 and Octo 2023.  How would I construct the Master table (or some other method) to run such a query?

I am attempted to pull 1 item of information from a table to use for a formula in another table. The referenced table has 1 field and 1 row only:I want to use this value in another table with a lot of records for a formula. I have attempted to link the 2 tables together: Then created a field for the value:The column has the value of 0. What am I missing here? TIA!

Are there help entries providing best practices for normalizing data?  Typically data comes in somewhat non-normalized, records with duplicate (non-unique) or empty values.  Take as an example, the following table, Grocery_Shopping:DayQtyItemTypeMon4applesfruitMon10snap beansvegetableTues13strawberries Tues6potatoesvegetableTues5kiwifruitThurs23bananasfruitThurs6bananasfruitI can manually create a unique table of Types, then manually change field type in Grocery_Shopping.type so it's linked to Types.type.  Similarly I could do the same, creating unique reference tables for Day and Item.  What many users need to a set of rules, automations, links, etc which automatically update reference tables when additional entries into Grocery_Shopping are imported.  If there is such a set of best practices, please point in their direction.  Thanks.   

I am confused. I set up an UPDATE RECORD AUTOMATION that seems to work in my 2 test tables, but it still creates error messages sent to me by Airtable.I have two tables to test this: The first one is CONTACTS MAIN with the following fields: This is the second table: CONTACTS AUTO with the following linked field and lookup fields. This is an alternate version of CONTACTS MAIN with EMAIL as the primary field, which I need for certain tasks. The second CONTACTS AUTO table links to the primary NAME field of CONTACTS MAIN and pulls in all the other information as lookup fields.I need to keep the two tables in sync. So, I created automation. Whenever I add a record to the main table, it creates the same record in the second one. I also set up an automation that updates every record in the second table that I tweaked in the first one. This automation also works, but it creates Airtable error notifications.Would someone with automation knowledge be kind enough to review what I did? I

First of all, I'd like to thank all in the community who helps in advance!I have chosen Base Design for this post's location, though formulae etc will also be appreciated.I'm running a SMMA and am still new to Airtable despite making good progress over the last week and need guidance setting up a base in Airtable to gather metrics via scraping. This base has three main tables, Post View, (Social Media) Account View, and a client View.In Post View, info about each individual post our clients make such as # of views, # of shares etc as well as the time and date of posting is collected. In the Account View, data pertaining to view, shares, data the view, share, like and comment count data for both (Today) and (Yesterday) are displayed. The third table is further aggregation to give a better top-down view.I have two main questions. In the second table and third tables how can I ensure that the data for 'Views Today' becomes the data in 'Views Yesterday'?Also, specifically for the

Hi - There is data in one of my tables that I cannot edit because apparently I need to "Upgrade to Enterprise to edit synced tables". Can you explain what this means, and how was the data able to be entered in the first place if I've never subscribed to Enterprise (someone else actually setup the table so I don't know how it came into being)?  What are synced tables?

Our team's admin had an emergency situation and is going to be unavailable for the foreseeable future. They weren't able to unlock two forms on our website before leaving. Is there anyway we can have permissions assigned to another team member, so we can access and unlock these two forms?

Hi there,I want to create a new field called "Original Start Date" and this will be populated from the "Start Date" field when someone enters in a new project.  Like a lot of projects the Start and End date moves a lot.  We want to reference back to when it was first originally entered in.Where do I start?  Do I create a new field in the "Projects" table called "Original Start Date" and then create an automation the populates this from the "Start Date"?I was referencing this article that mentions creating an automation.But I don't know the steps in connecting the two.Any help is greatly appreciated.Thanks!

Sometimes the Community is helpful in solving a problem, but sometimes we need more support than this. When I first started using Airtable, it was possible to get support  - good support! - from a human being. At this point, I can find no way to do so - the bot just takes me around in circles. (We do have a paid account). Can anyone advise on how to get support from someone at Airtable when necessary?