Ask the Community

Hello I have these four pieces of data: Project Name {Text Field, Primary Field} Project Start {Date} Project End {Date} Project Team (multiple people) {???} *can be separate table I want to be able to create these views: a gantt view for my projects This will show the project name and the start and end dates a gantt view for each individual team member This will show each project they are working on My team will consist of four individuals that will be working each project. Some projects will have all 4, others will only have a couple. I need to be able to see how many projects each person is working on and how long they will be busy with projects. For the Project Team data I’ve tried linked records, collaborators, and mult-selects but they aren’t being treated as individuals, they are being treated as a group in all the versions of the gantt I’ve tried.

Hi! I'm trying to set up an inventory system that takes into account materials used for each of our products. On my products table, I have a column for materials and one for finished goods. I've set it up so that when we assemble a product, the materials qty decreases and the finished goods qty increases. This seemed to work well until I ran into this issue:We make notebooks, so the raw materials are the covers. So when we make say, notebook A, notebook A covers would get deducted, when we make notebook B, B covers are deducted and so on. The problem is we also make 3-packs, with one of each notebook A, B and C. These sets are a different product, BUT they use the same raw material (covers) as the single notebooks. I can't seem to figure out how to make it so when we assemble a 3-pack, it automatically deducts one of each cover for A, B, and C. We have several 3-pack designs too, which further complicates it. Any help is very welcome! 

Hi there, here is my cURL as mentioned in the title i'm having issues just on iOS while on Android it works with no problem.https://api.airtable.com/v0/appOwBv51ihqo****/TableName?filterByFormula=FIND("february",{Mese%20Nome})=1&sort%5B0%5D%5Bfield%5D=Created&sort%5B0%5D%5Bdirection%5D=descStatus: 422Error: undefinedI'm really confused, hope you can help 

I need to set up a workflow where users register through a form with their email address, and in some cases, an optional Group ID I will pre-fill using URL parameters. Those users then need to be assigned a unique URL (taken from another table) and then they need to get an email that confirms their registration and shares that URL. To do this, I have two tables:registrationInfoTable: Captures email addresses (and sometimes Group IDs)testLinksTable: A static list of all the available unique URLs. My test base is here for reference: https://airtable.com/appX64txDWlNUmTGO/shryhyKtLyjgBdQiHThe automation I've been using is called "Update registration with testLink" and features the following steps:Trigger: When a record is created in registrationInfoTable. I have also tried a form submission trigger and they seem

I have a question about how to handle member data in a specific set of circumstances.I have a membership base. One table has the members' names and organizations they belong to, if any, in it. People join this organization. Sometimes they join as single people and sometimes they join as a couple. So far I have able to easily handle the single/couple issue, except for when one of them becomes a board member/officer. Now I have to find a way bifurcate them. Do I put them in individually? If so, how do I handle when they join or renew as a couple? Or even better, leave a legacy? Hmmm. Is a puzzlement. And how do I handle when one of them dies?Any thought or help will be truly appreciated.Best, Scott

I would like to hide the primary field in a gallery because I want to use a long field for the title. I understand primary keys and keeping the title short. No problem. But, I don’t want to publish the primary key but a long field. I attached an example pic of what I am talking about but not sure anyone can see it, since all I see is a link.

I would like to run Automation every week on Sunday, and the purpose is to have a running change for my Pivot Tables. I would like to take the "Items", "QTY" and "Last Date/Time Updated" from Table1, and copy/ paste that data into the Table2 which has the same column names. Is this possible and how is it done? I was poking around and wasn't able to figure it out.

Has anyone made / planning to make something like this?I can see how a gallery view would be nice as a starting point for an App with lots of Interfaces, but I can't see a good way to add a simple clickable 'link' to them, other than have a URL in the Record Info, but it wouldn't feel very intuitive? Thoughts?

If I am in Base A and click the “+ Add or Import” button and select the “Sync data from Airtable base” option and select a table from Base B it brings in and syncs the table. One thing though is single and multiple collaborator fields get converted to Single line text. Is this expected? Is there a way to make it stay as a Collaborator field?

Dear Airtable Community,I need your help with the following issues. In the course of project management, the employees have to submit a monthly performance report (%) for all current projects to our controlling department.Example:Project XYPerformance report Nov. 2023: 75 %Performance report Dec. 2023: 85 %etc.It would be great if the value of the previous months remains and is not overwritten, but I don't want to create a new column for the upcoming percentage entry every month.I would be happy if someone could suggest a solution to this.Best regards & thank you

Hey everyone, I had a quick question to see if this is possible. I view my projects in a timeline view that is grouped by what phase the projects are in. The top group are projects that are coming up, but sometimes I dont have a date for an upcoming project aka I dont see the project in my timeline view. I dont want to forget about possible projects that are coming up with no specified date and was wondering is there like some sort of an option with airtable timeline view to have records that dont have a date show up under the group name on the left bar or somewhere where I can remember like ohhhh right that needs to be scheduled? Thank you for any help!

Hello,I am trying to create a stacked bar graph in Airtable like the one I made in excel, but there's something I'm not quite understanding about how the chart extension tool works in Airtable. I cannot group the different day ranges under the record #, only the total, not the individual segments stacked. Any help would be appreciated, thanks.  

I've noticed we've been having issues managing the number of "Builders" we have on our company's Airtable account. In the Admin Panel it indicates that we have a limited number of "Builders" and "Contributors" included in our plan, and there are billing implications if we go over this number. Unfortunately we keep going over the number but can't seem to work out why!I have tried to find more information on the functionality of these user seat license types, but all I could find was information about Airtable user permission levels (Owner, Creator, Editor, Commenter, Viewer) and haven't been able to work out how they are connected, but the definitions of the user seat license types seems to indicate that a "Builder" seat allows users to have Creator level permissions, and a "Contributor" seat allows users to have Editor level permissions:Builder: Builders are able to create and customise bases and workspaces

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}