Ask the Community

Hello - we use a formula field to create unique & automated "Activity Titles" for records.Our current formula pulls from various fields:Program (multi select)City (linked field)Type (single select)Date (date)Current formula is: Program & " - " & City & " " & {Type} & (" ") & " (" & (DATETIME_FORMAT(Date,'YYYY/MM/DD')) & ")"This results in an Activity Title that looks like: Corporate Event - Philadelphia Webinar (2024-03-21)The problem we've run into is that some of our Activities are with multiple cities - 30+.So when the formula pulls into those Cities into the title, the title then becomes unusably long - Corporate Event - Philadelphia, New York, San Francisco, Pittsburgh, Buffalo, Winchester, Miami, San Diego, P

Hi everyone, I have created a form from one of the templates and embedded it in my joomla website What code can i add that will make it one long form so that it doesn’t scroll in the iframe? I would like just the webpage to scroll not the iframe if that makes sense. Many thanks Jim

Was just informed that our card was being charged for a pro plan. There was an unauthorized person on our account.  We don't use AirTable and we followed all the instructions: (a)  I deleted the user and then (d) downgraded, but then I got a message that AirTable will go to free on March 17, 2025.  This is unacceptable.

When I use Aritable I either get the solution straight away or spend days knocking my head against the wall just to find out I’m overcomplicating things. I’m currently in the latter situation, so please bear with me :winking_face: I’m designing a Crypto Portfolio Tracker on Airtable. I have 2 tables: COINS TRANSACTIONS I plan to add every transaction I make (buy or sell) to the TRANSACTIONS table. If amount is positive it’s a BUY, if it’s negative it’s a SELL. So far, so good. Now I’m trying to create a PORTFOLIO table summarising/aggregating of all my transactions to reflect my current portfolio. This PORTFOLIO table should aggrega

I have a table for meetings that is linked to a Personnel table and an attendance confirmation table that is also linked to the Personnel table.When a meeting is submitted, an email is sent to each linked personnel record with a form. The form is prefilled with the meeting ID and the Personnel's name. When they submit, it shows that they attended the meeting.I'm trying to find a way - within the meeting table - to show what personnel (linked in the meeting table) have not completed an attendance form using a lookup into the attendance table to find the personnel name. Any ideas are greatly appreciated!

Hi all -Airtable newbies here! I'm an ops manager supporting a team that has a ton of gates/deliverables. There are lots of dates (50+) and it is cyclical every 3-4 months. The team has told me it would be helpful if I created calendar invite reminders for their outlook calendar to keep them on track. I've already inputted all of the deliverables and dates into airtable and created some great calendar tools, but am having trouble creating the piece to bridge the gap to outlook calendar reminders.I was able to create an automation tied to a button on an interface. However, I'm finding a few limitations to this and wondering if anyone has any great solves?I have to press a button for each record/date individually. Is there a way to set an automation to apply to all records with certain conditions? (for example, add outlook reminders for all dates in X cycle?)I can in

Hey all,I'm working on setting up a tracker for my team, but I'd like to set it up so that our final milestone in the Gantt chart is a fixed date that cannot be changed. The milestone date represents our client delivery date that we cannot pass, so if previous dependencies shift, I don't want the milestone to change. It's fine, almost preferable, if we get a warning that there's something wrong. Is there a way to set it as a fixed deadline?I'm new to the community and still learning, so if you need more information, I'm happy to provide it!

If I create a survey form (interface) to be filled out for project requests - do the other departments making the request using the form need an Airtable license? 

Hi, I hope it's ok to ask for some human help here. Like many, i'm sure, I've been getting OpenAI to help me out when my coding doesn't work, and for the most part that's been fine. But i'm stuck on something now.I have a script which takes a 'booking' (which is a record in a Bookings table), looks at the linked record for {Episode} and {Element} and increments the number found within each by 1. It then searches up those records in the relevant tables "Episodes" and "Elements" and tries to create a new record with those found RecordIDs in the relevant fields. I am getting stuck as the script reports that the fields in question (which I've confirmed are correct IDs) won't accept the RecordIDs in the format they are being given. The fields are linked records, able to accept multiple records, so I think the script is presenting the RecordIDs as an array. the script is below, and also the error I receive. // Corr

please help me to add element that will filter result by month, so i want to pick up just month inside filter not date is or is within or something, is there any way?

How to make combinations of field in between columns : Exemple : Product ALPHA - VARIANT LINKED TO IT : SUBVARIANT-X - Items compatible 1,2,3. + SUBVARIANT-Y compatible 7,8,9- If I select SUBVARIANT-X : item 1. Then only SUBVARIANT 8 is compatible is this combination.Any suggestion to make it happen ? 

Hi AllI am looking for a formula to extract project status from a string with multiple response column. Criteria is IF "Market Single" is appear anywhere in the "Updated Status", then return as the 1st word in that particular string. Example below: the output I am looking for in "Final Status" is:- Row 1: Ongoing (Albania in Market single, Ongoing being the first word in the string)- Row 2: Hold (Andorra in Market single, Hold being the first word in the string)- Row 3: Cancelled (Antigua in Market single, Cancelled being the first word in the string)Currently this is the formula I have - and it returns all three response as Ongoing - which is not what I am looking for: IF(  FIND({Market single}

Dear Airtable,The last 24 hours as your paying clients were just awful.After upgrading our plan to Team and successfully paying for your service, the upgrade was correctly reflected in our workspace feature summary which shows 4,466 of 50,000 records, and 0 GB for all the other indicators. Despite that, the base has remained limited since our payment causing us major business impact and problems of all sorts with our web application.What is worse - and it is frankly upsetting for customer - is the astonishing support that has been provided so far. I made sure to describe the situation clearly in a ticket yesterday (00743786). I did receive one reply from a support agent. The reply appears to be a simple copy-paste that is not related to the questions, a practice which honestly should require Airtable's investigation. Your clients pay for your service, they expect a reasonable level of support.Since then, there was full silence from your team despite

Hey all! I'm back with a new issue that I'm hoping won't be too hard to solve but I can't seem to find the solution myself. I have two fields that I need to combine. Field 1 contains a variable, such as GKM3, GKM5, etc. Field 2 contains comma-separated values like L16, L17, L18. I have been trying to find a formula to combine the value of Field 1 with each of the values of Field 2. So the output in the 3rd field would be GKM4L17, GKM4L17, GKM4L18. Unfortunately, when I try a concatenate or substitute function, it only appends the Field 1 value onto the first value in the list, like in Field 3.  I would really appreciate any help! 

The required parameter for the base.createTableAsync call is Fields, but when I put a dynamic list of Fields in it, it says that it's not the right type, when it really is. Is there a workaround? I do not want to hand-key in all of the fields, which may change fairly regularly. Goal: Duplicate the Trainees tableBlocker: base.createTableAsync's Fields parameter does not accept a dynamic set of Fields 

Hello, I created a table of articles I published on my site.  For each row, I inserted the article title, publish date and various tags.   I would like to create a view/report so that Airtable presents me with one long report of all my articles organized first by a single tag..and then for each tag category it would sort the articles by date.Here's what I did:Using the "Group" feature,  I grouped by "categories" (all my tags)  and then i added a subgroup of Date.When it showed me the results (see attached), it showed me rows organized not just by a single tag, but multiple tags.  (It seems it's doing that based on how I added multiple tags to the end of a single row in my airtable).How can I see a long list of all my articles grouped underneath multiple&nb

Hello!  I'm trying to come up with a formula or script or something that will let me know when a duplicate record was entered into my table.  I know I can use Dedupe to find current duplicates, but this is an ongoing issue and would love to be able to be alerted if something is entered into the base that already exists.  I saw another thread from a few years ago that said this was possible with a script.  Anyone have any insight?  Basically I'm thinking that when a new record is created... the script will run and based on the results of that script it either will or won't send me an email.   Hopefully that makes sense!

Page Design is really useful but I can't do a seemingly simple thing.I have a list (view of a table) and I want to layout it and print it in PDF with Page Designer but I can't find a way.It seems you can only print a single record at a time.Can you tell me if there is a way?Thank youDanilo

I have had to change my zapier integration with Airtable because of the API deprecation. It looks like the "API Requests (Beta)" should be an easy transition with the authentication method updated. However, when I put the same URL into it, I can't get it to work and I am not sure what I am doing wrong.My intention is to return the single top record of a view- if there is an alternate way, I could do that too. But I don't know of a way to limit the view to a single record within airtable. This was working great via API.... I just need it to work with the new authentication as well! Any advice as to what I am doing wrong, or an alternate solution would be much appreciated! 

Hi there. Loving Airtable so far! Just wanted to know if there was a way to show on my bar graph block a custom y-axis number. I have numbers on the y-axis from ranging from 0 - 100. Right now the bar graph only go as far as the records go (e.g. till 77). I want to show that 77 is not the max, visually speaking. Something I missed?

Hi there, I would like to use a formula in the primary key column of an airtable data set to create a unique ID, or autonumber, but i want that number to recalculate when i insert a new row anywhere in the master data set so that the ordering is retained. if you use the autonumber field type, it will create the record using the next available number, then all my views start to loose the ordering i want.is there a way to write a formula that will re-calcuate the primary key column to retain the existing order, with the new record in place.  For example: 1 TestA2 TestB3TestC If i insert a row between TestB and TestC, the primary key would show as follows:1 TestA2TestB3Testnew record4TestC 

I created a scheduled email to send weekly when the status of my table matches certain conditions.  The message was done in a grid view to include the column information.  I am trying to figure out how the user that receives the email can actually update the records using the email instead of having to go into the base table. What am I missing? Is there a way to click to the records in order to update from the email that is sent out.  Thanks!

Hi, I would like to be able to share and sync data from multiple workspaces of clients to 1 table in my own base/workspace. For example, I have 10 clients with 10 fields in their base and I would like to have 2 of those fields automatically synced and stacked onto each other into one table in my base/workspace. (Instead of having multiple tables from multiple clients in my base).A solution that we're currently using is having a form that clients can use to add data to our base and a client view on that base in the clients workspace. But that limits the client doing changes to fields that are not in the synced table. Ideally clients can work from their own base and can add rows themselves and can change everything (and not having us to change certain fields that cannot be changed due to links to other tables in our base). Thanks for you help!  

I have a table of job roles and another table of knowledge items. The job role table is linked to the knowledge items table. I have an Excel spreadsheet that lists the knowledge items for each job role. It looks like I can only paste one item at a time into the linked field. Is there a way to paste multiple items in at the same time?Thanks for the assistance.Best Regards,Chris

Hi, im starting to automatize my data base and im finding a little problem sure community can help me with.I use AT to manage an academy. I have a main table in which i record each student profile. Then i have to go to another table which has a linked field  to add the new student record of the main base in order to count students per hour and availability. My idea is that the automation is triggered by certain conditions from the New record, then find the record to update, static, and update the linked field. I have done so, but the problem is that it changes the field content, doesnt add a New linked record, deletes the previous existing records and  i just need to update with the New record matching the conditions.Thank you in advance.