Ask the Community

I'm working on a tracking system for a coral restoration project. To report coral bleaching to my Bleaching Report table, a user selects a date and all structures where bleaching was observed (linked to my Structures table) like so:Bleaching Report table:I would like to add a new record for each structure along with the corresponding date to a different table, like so:Structure Bleaching table:I tried setting up an automation which triggers when a new record is created in Bleaching Report to create a new record in Structure Bleaching for every linked item in the Structures field, but it seems only 1 record is being created even when there are multiple structures linked in the field. Here is my automation setup:

I'd like to buy a book (or 2) on Amazon (or other) that I can use as a decent reference for scripts, formulas and other advanced topics and would love some suggestions. Given the ever changing nature of products such as Airtable, I want to make sure I buy something that is relatively recent that would have the newest features, or at least most of them.The basic stuff (field types, etc) are self explanatory to me, so hopefully a book that has more solutions than the core fundamentals of which I've mostly been able to learn with vids and the like. I know that the basics will be covered in any book, I just want to make sure the back part of the book with the advanced stuff is relatively deep in content, if that makes sense.

Hi All,I'm fishing for some ideas on how to structure my Project Tracking Base. Here's what I'm trying to do:I have Projects in a table, with a Project Manager, and Team members assigned from my People table. I do want to keep track of the role of each person on each project. This role can be different for each project they are working on, so assigning them to Departments or Roles in the People Table does not work.I'm hoping to not have to create another table (let's call it Roles for now), since it I think it will complicate the Interface. I want people to simply add team members to the Project in pre-defined roles.The other way of doing it (easier interface) means having a field in the Projects table for each role. Trouble with this approach is that new roles keep on being added (as needed on projects), and I can't be editing fields, forms, interfaces, etc. each time a new role is needed.Any suggestions on a better way to structure my base to acc

I'm building a task tracking app within airtable to use with Glide. I would like to do a rollup of total hours spent on each task bucket (four in total) for the current month, week and day. I cannot figure out how to do a sum of each task for those time frames as a numeric value and hours spent on each task. Any help appreciated.

I am attempting to create an automation when a record is created in a specific table that will see if that record exists in another table and if it does, update the record that was just created with a date out of the other record. I'm not sure at what point the automation is suppose to run for the new record being created, but it seems as though it is running too soon and not waiting for the piece of data it will use to look up the record in the other table. I hope that makes sense. If anyone has any ideas, i would appreciate it.

Hello everyone. I’m still new with Airtable but I’m trying to learn. I am integrated in a sports club, volleyball club. I’m trying with Airtable to make a table that updates results of games. The idea is that each team director can enter the results of a game in a simple way, and then get the complete list of results. Is there any template that does something similar? If you guys can help me I’d appreciate it.

Hi. I've got a base in AirTable which I need to be able others to update through a form in fillout. I only want specific fields to be updated by the form. In the case as shown in the screenshot I only want people to change the status and no other fields. When I chose to limit who can edit fields such as name, email etc to nobody but leave the status field as editable by anyone the form doesn't update that field. I only manage to update the status field when all other fields are editable but then it will obviously create an issue that will allow people to edit the base. The idea is that people would report status updates by the form and they would need to see certain fields of the form.  Could anyone point me to some resources on how to accomplish that? Thank you.

I have a base with different tables, each one linked to other bases. Is is possible to edit an attachment field? I am able to edit other type of fields, as for example, checkboxes, but not the attachment ones... 

Hi. I've searched for a solution for this, but no luck (yet). I tried THIS but it didn't do what I needed. In the referenced example it had a single action for each task, which assumed a fixed list, and my source will vary.I have 3 tables:Application (record trigger)Board Members (grid view of filtered table "Members") currently 9 records in view.Member Approvals (goal is to create 9 records, 1 for each board member and has application data.When an application record is created, it should trigger the "find records" on the board member view and create a record for each board member and include all the application data in it.  However, when I do this, it wants to create a single record and a comma delimited l

Hey Airtable community,Been hitting my head against the wall for the last hour with this. I'm trying to write a formula for:If {Donor First Name} is not empty, then the field would read: {Donor First Name}&" "&{Donor Last Name}And if {Donor First Name} is empty, then the field would read: {Name}And if {Name} is empty, then the field would just remain blank.Here is my stab at the formula, which I am getting an error message for: Any ideas how to make it work? 

Hi there, I've started to play with AI features (love it!) but I'm experiencing issues with the AI field allowing to generate text.I want the AI to analyse text within attachments and return structured data. It works pretty well when analysing PDFs but it doesn't seem to work with HTML or TXT files. While field HTML is properly filled with a document (HTML in that case), the AI keeps asking to fill out the field.This also occurs when using TXT files but it works with PDF. Are you aware of such limitation or can it be considered as a bug? If that's a limitation, can someone think about a convenient way to store HTML data as plain text? When converting my HTML to PDF before upload, I'm losing the HTML as text since it's rendered as webpage within my PDF. I'm using Make (ex-Integromat) for that purpose.Thanks a lot for you help!

ciao,i'm having an issue which seems rather crude to me but i can neither work it out, nor find exactly relatable posts on here:i'm having a sales base for artworks, in which there is a field that links to a client-record from another base (contacts base which includes clients as well as artists). this i add manually when i set up a new sales-record. there is a second field which links to the artist of the sold work, which i of course also add manually.now i'd like for the link to go both ways, so that in the contacts base there is a field that automatically shows all the artists of who they've bought works in a clients record drawn from the sales base as well as a field that shows in an artists record, which clients have bought works by them.i hope i'm not being super redundant here, thanks heaps!

Hello Airtable Community, We have an Airtable list with our internal communications.Now we have some communications that take place at regular intervals (X weeks).I just can't manage to build an automation that creates a new record for each of them.For example, every 14 days for the next year a record with start, end date & name. Any ideas on how to do this? Many thanks and best regardsMirko

In Langchain, it can use chains like SQLDatabaseChain to utilise the power of NLP and convert the user input into SQL query code (JS or Python) then execute the code to retrieve what is needed from SQL database such as PostgreSQL.Does airtable support such query and would possibly be supported by Langchain in the near future?I guess if the script can be made and executed at the back end for each customised query, that would also work, is that feasible? Thanks.

Hi Airtable community, I am looking for AI tools with which I can query our team's Airtable database with. It's a massive database with about 5000 entries, and each record contains a vast amount of information. The idea is that we can query the Airtable with questions regarding the data.I worry that existing AI add-ons will not be able to handle that amount of information. Does anyone have thoughts or recommendations on what an appropriate tech setup would be for this?

Hi everyone,I’m looking for some guidance on creating conditional forms in Airtable. Let me explain:I’ve set up a base for project management where each project has different tasks based on the program type (and there are multiple programs). Ideally, I want to create a form with a predefined task list, allowing Project Managers to fill in details such as start date, assignee, end date, status, etc., without having to manually enter each task name.Is this possible with Airtable’s Teams plan? Any insights or workarounds would be greatly appreciated.Thanks in advance!

Hi. Trying to find a calendar integration that will populate film and schedule info from Airtable for our film festivals. Basically, we schedule films in venues throughout a week and need them to be organized consistently and show info like start time, run time, end time, etc so we can share with staff and our cinemas. We're using Google sheets to create our SCREENING OVERVIEW because it doesn't work in Airtable to use the calendar. So need something that looks similar to this in the end, with the full screening schedule per day in separate tabs:Any help or ideas are appreciated. Thanks!John

I have 2 datafields, room type (single room & double room) and guests (1 to 2 names)if in singleroom and the guest (the volume is 1) should say "occupied" in the formulafield andif in room type (double room) it says and guest (the volume 2) then “Occupied” should also appear in the formula fieldMyCode:   IF(AND(room type = "double room", {client overview} = VALUE(2), room type = "single room", {client overview} = VALUE(1)), "occupied")   

Hello, I am trying to just multiply Roll Ft Size x Lin Ft. But I keep getting an error. What am I doing wrong here?Thank you for any help here.  

Hello, I'm creating a fairly simple base to track all of the violations for an HOA board. I'm trying to create a field to calculate the total number of times a house has gotten the same violation in the past year.The Base has 3 tables, "Homes" with address and owner, "CCRs" using 'CCR ID' as the name of the violation, and "Violations" that collects the date of the violation, the 'Home', and the 'Violation'So, I basically need to have another field that counts how many times the same 'Home' and 'Violation' are both in the same row over the past 365 days.I got this to work by using grouping. In the attached picture, the highlighted number is the number I need to get to populate in its own field. Thanks in advance for any help! 

 If a record created in Openings Tracker (table A) is created, then I want to add that record to the linked record field in Summary Tracker based on the fields Opening Distinction and Req Status. The linked record field is pulling the openings record from Table A based on manual addition right now. If the record is created in Openings Tracker, I want it to automatically add to the total number of openings for that Opening Type in the Summary Tracker (table B).

I am using a summary of data connected to a linked record to populate the dashboard. The Youth Care Professional 3rd shift seems to be filtering as two numbers separated by a Comma. I am not sure why this is happening there and not with the others. The fields have the same conditional formatting for all the fields to the right of linked record. Only this one seems to be noting as 2 numbers. 

Hi everyone!I'm trying to set up an automation which is triggered every time I receive an email with a particular subject line. I want it to follow a workflow where Airtable parses through an excel report in the email, extracts the data from the file, and appends it to a pre existing table.Attached below is a screenshot of what I was trying to do, but I don't see any options to extract data from an attachment.Can someone please advise on how I can do this?TIA!

I have a column that fills in the State Abbreviation from Jot Form. The form is a drop-down selection that is the same as my single select column in Airtable. Somewhere new duplicate selections are being generated with new submissions. I am trying to figure out where to even look for how this could be happening. Any help would be appreciated.

Hi there, Is there any way I am able to sync my Airtable contacts with my iCloud contacts so all of the contacts on my Airtable will also be on my iPhone? And vice versa. Without having to do it manually of course. Let me know, thank you.