Ask the Community

Hello, I have a price list table and I want to update them following sector index.I will use api from the french statistic instute to automate the process but I am not sure which tool to use. I woyld be keen on just doing an airtable script.I am able to use the api of the institute (but I don't know how to code it into airtable script), the answer is a big xml file which contains basically a large number of series with dates  and values for each in two lists of the node serie X. What I want is to be able to parse this xml to merge the dates because there are the same and put it in a column and create one column for one index with the value.There are plenty of tools but I don't know which process is the best.Thanks you for your help!If required, I can attach the xml response file.

I’m very new to airtable but have learned a lot by watching tutorials and searching the community. I’m not sure if I’m searching for the right thing for this particular issue though. I’m setting up an airtable for a client who has a form that needs to be completed by his clients on a weekly basis. He needs to know who hasn’t submitted the form 3 days past the day he sends it out which will be on the same day each week. For instance, he’ll send the email with the form attached to be completed every Monday and if someone doesn’t fill it out by Thursday, we need to automate an email to follow up and remind them to complete it. I’m thinking I need a field dedicated to auto-populating whatever the current day is or at least a formula that shows when the week starts and when it ends. What formula do I need for this? This is literally the last thing I need in order to complete this airtable setup but I can’t figure it out. Any help would be greatly appr

I have a solution with 2 tables: An Invoices table containing invoice information (date, amount, etc.) A Payments table containing payment information (amount, method, date, etc.) I want to link these tables so payments can be applied to invoices. I need a column that shows the remaining balance of each invoice after full or partial payments are applied. I created this using a lookup field and formula field in the Invoices table. However, I'm having trouble when I need to apply one payment across multiple invoices (either to the same vendor or different vendors). Currently, the lookup field calculates the full payment amount towards each invoice, which is incorrect. Is there a way to split a single payment across several invoices, allowing me to specify how much of the payment should be applied to each invoice? I need the final balances to correctly reflect the payments for each invoice.

I created a form for our rental car contract in Fillout. Everything is populating correctly into airtable except the time. My issue is that I put the "date - time out" in the form eg 12/19 8:00pm. It will populate to airtable as 12/20 3:00am if I have the airtable time set to UTC. if I change the time in airtable to Denver (which is correct) it populates properly from fillout to airtable. HOWEVER, when I open the PDF everything in changed back to being a day in the future at 3:00am. I think it will work properly if I create seperate fields for date and time, which I can do, but it seems like it should be able to work by doing it the way I am. I'm sure this is a timezone code I cant for the life of me figure out. Please help, Thanks!

Hi,I am setting up an automation with integration with Outlook emails. I can only find limited trigger options. I don't want all my emails to go into AT, only select ones. I figured I would do this by making the trigger conditional, i.e. only when an email is designated with a certain category will the integration trigger and the email post in AT. Does anybody know if this is possible?Thank you in advance, Christopher

Hi there-- When working with the Form builder (NOT the interface or the form view), I get the following message when I go to publish a form with a linked field. Does this mean that the linked record itself is somehow exposed, or is this warning just in regards to the fact that the linked field in the form builder can be configured to show additional fields and not just the primary field? Thanks in advance for any help.Linked records will be visible to anyone on the web.To hide sensitive data, edit the linked record field to limit what users can select. 

I have a list of volunteers that, when I collapse all, clearly shows their hours for the year - see attached.I would like to sort by this list in order to be able to see who had the most hours this year.Is that possible? If not - how else can I aggregate the info to get what I need?Thanks!~Lisa

Hi Airtable Community,I am wanting to create dashboards to represent my data from Airtable, using Google Looker Studio. What is the best way to get my data from Airtable into Looker Studio automatically? I have tried using the 3rd party Airtable Connectors offered on Google Looker Studio, but I keep getting an error where access is automatically revoked by Airtable due to  "security concerns". I have looked at the 3rd party integrations on Airtable and all seems fine there in terms of permissions.Using the Google sheets sync function won't work as my datasets are too large. And I am not too great at working with APIs either. And the Interface provided in Airtable is not an option.Any suggestions would be great!Thanks!!

I have this formula for calculating the quarter and the fiscal year of when an invoice should be paid.Program Start date is 7-4-2024 (which is Q3). I want it to be paid the quarter after (so this one would be be paid Q4, FY24) but its showing Q3 - FY25. How do I adjust? the formula below for a "Program Start Date" of 7-4-24 to show that it should be paid Q4-FY24? IF({Program Start Date},"Q"&ROUNDUP(VALUE(DATETIME_FORMAT(DATEADD({Program Start Date}, 1, 'months'),'M'))/3, 0)&" - FY'"&IF(

Hi everyone, I need to create a single field that automatically shows the top 3 clients for each employee, based on the total number of bookings (records) they have assigned to them. Ideally the field would be dynamic and will adjust automatically. We are using this field to integrate with external platform, Glide.We have separate tables for clients, employees and bookings, and all utilise linked records for other purposes so we are very familiar with them. I'm just unsure about how to pull this data automatically, and if it can be done as a multiple linked-record field or if it would only work as a text formula.I understand a lookup field can be used to show the first or last 3 items based on the lookup source, however I can't sort this to show the highest ranked. Example below. I really need to show the top 3 clients for each employee, and be able to easily click into their details like a linked-record allows.

Hi - looking for some assistance with an interface where I am looking to achieve filtering according to a selection. The example is as follows, I have a timeline view which we will filter by a 'Customer' field, which we would then subsequently want a field which we have called 'Deals' that only relating to the specific customer. The currently 'Deal' filter is a look up field which comes from a separate base.  

Hi everyone, a few questions as I'm trying to find the best solution.Background; my employee would like to export client data from Airtable to import into a Google Sheet as they prefer working in that platform (they have issues with how AT can't filter/search via record comments, so we use a long text field for 'notes' but it overrides if someone else adds to it -- any solutions here would also be helpful).They will use the data to follow up with clients that have not booked their service after set periods of time (e.g. 3 months, 6 months, 12+ months).Anyway, back to the main issue - they want to be able to sort/filter, or automatically change the colour or move into a group after set periods of time since their latest booking. I'd prefer they work directly in AT as the data will always be up to date and it doesn't rely on automations. They also need to update data in AT after contacting the client so it'

Hello all, anybody seen the following in Automations:I can't find any documentation on this.Any ideas what the use case for this data being available might be?

This is driving me nuts and I can’t believe I’m a hard time figuring this out… I have a personal AirTable account for my freelance clients, personal projects, domestic stuff. I also have several partners that use AirTable. I do not wish to merge these accounts because that’s insanity, but I would like to be able to use both simultaneously without signing out/signing in constantly. Is this a very easy feature that I can’t figure out? Otherwise I’m launching a private window + the app or I could use something like Station to have multiple instances running. Ideally, I’d be running both my personal account and my work account from the desktop app, mobile app, etc. Any ideas?

I planning to make a service that pushes airtable data on changes, including comments.Is is possible to watch for comment changes via Airtable webhook? It is not stated in the doucmentation explicity, so I would like to clarify. Thank you.

Hello,I have a project table and a milestones table. I want to update the status of my project record to “complete” when all the statuses of the linked milestones are also “complete”i have a roll up field which pulls back the unique array of the milestones, so I have all the milestone statuses comma separated as a text string, but I can’t figure out the formula to look at that field and determine if all the milestones are showing complete or not 

I’m trying to create an online volunteer sign up system very similar to SignUp Genius, but through Airtable so that the data is easier to work with on my end for scheduling and data management. Ideally, it would show the event options, the position options, and then once all the positions are filled for each particular it would no longer show the option to sign up for that event. I would want to gather each individual volunteers name, email, and phone number. So this is less for long term volunteer management right now, but so sign ups and scheduling management for a series of related events with similar staffing needs. It’s pretty small scale, we have about 20 events that need 2-4 volunteer staff at each. Thanks in advance for any suggestions!

I’m working on a directory that has a Categories column set to the Multiple Select field type. I’ve cleaned up a good number of mistyped entries in this column, which created a lot of unused categories. Whenever I filter by a category, I see all of the unused data in the list. Is there any way I can remove all unused data?

Hey there,Thank you for reading me !I have a small issue while using lookup fields within a formula.I've got 3 differents tables : projects, actions, animationsA projet is made of several actions which are also each made of several animationsThe project primary field is a formula : Year / Name (2024 / Orange)The action primary field is a formula : Project primary field lookup / Action Name (2024 / Orange / soccer)The animation primary field is a formula : Action primary field lookup / Date (2024 / Orange / soccer / 12/12)My issue is that in action & animation primary fields, some unnecessary "" are added, i get :Action primary field : "2024 / Orange" / SoccerAnimation primary field : """2024 / Orange" / Soccer"" / 12/12I have tried a few formulas but I don't get how I can remove them. Any ideas ?Thank you for your time, have a nice day ! 

When I use the user search in my list interface, it displays "4 results" in the search field but no items show in the list. What am I missing?

Hi,I am super new to this. Essentially I want to have a master base that my team and I can work from that is synced to 4 other bases that our partners work on individually. I don't want one partners data to reflect on another partners base. Is this possible?TIA!

I'm working on a project where I have 3 tables in play."Database" - "Data2" - "Match"The script I developed allows me to take a record from the "Data2" table, compare it with each record from the "Database" table and if there is a correspondence between the two, based on 3 specific values ​​which are multiple choice fields, then it is created a new record in the "Match" tableThe automation starts n times based on the number of records flagged in the "Data2" tableThe problem is that having more than 1000 records in the "Database" table, even if I have optimized the script as much as possible, in some cases I run into the 30s limitI show you the current code:// Ottieni le variabili di input let inputConfig = input.config(); let nomeBando = inputConfig.nomeBando; let areaInteresse = inputConfig.areaInteresse || []; let tipologiaSoggetto = inputConfig.tipologiaSoggetto || []; let settore = inputConfig.settore || []; let bandoContributiReco

I am looking for a way to parse a lookup field (Sprint Start Date) that contains multiple, comma-separated date values, and pull the most recent date into a new field. For example:IF --> Sprint Start Date = 2024-10-12, 2024-12-22THEN --> Formula Field = 2024-12-22 I have tried to use the following formula to parse the Sprint Start Date field and convert it, but it always returns the same value, or an error:DATETIME_PARSE(MAX(IF({Sprint Start Date}), VALUE(DATETIME_FORMAT({Sprint Start Date}, 'YYYYMMDD'))))Outcome #1: 12/31/1969 Outcome #2:&nb

I want to add images to an attachment field in an Airtable.  I've read all of the documentation and Community comments but can't seem to find an answer to my problem.I have a publicly accessible link to the imageI can call https://api.airtable.com/v0/{baseID}/{tableID}/{recordID} and add an image fine, however, I want to make multiple other calls adding new versions of the image and this call overwrites what is already there but I want to keep the previously uploaded files.  (I understand this is an Update call and that logic makes sense.)Therefore, I believe I should call  https://content.airtable.com/v0/{baseID}/{recordID}/{fieldID}/uploadAttachment  passing in a similarly form

I'm attempting to paste Date and Time information into an Airtable "Date" field which has the "Include time" option checked. But, when I paste Date and Time information, it all goes in the "Date" part of the cell, and none of the text goes into the "Time" part of the cell.For example, I'm trying to paste "11/21/2024 10:00 AM" into the Date and Time cell, but it puts all of this text under the "Date" portion, keeps the cursor in the "Date" portion, and enters the current time (i.e., 2:13 PM) in the "Time" portion of the cell, lol.How can I accomplish this basic copy-and-paste operation with Airtable's Date-and-Time formatted column so the Date goes in the Date, and the Time goes in the Time?For those unfamiliar, Airtable's "Date" field with "Include time" checked creates a cell with seemingly two cells within it, as shown in the screenshot below.Finally - I have all my dat