Ask the Community

Hi,I'm trying to automatically update a linked field with the data that auto populates in the "Auto" number field when a new record/line is created. I can get the data to return but it's all in one field.  I tried to use the "Update Record" option but continued to get errors Thank you 

I have a table of all USPS zip codes and their respective cites and states. It has over 33,000 records. I would like to be able to use it in another base without having to copy it into the other base which causes it to go over its record limit.Is there a way to do this?Thanks, Scott

Issue: I am trying to have a "Number" field to get updated with values starting from 1, 2, 3, etc based on the position of the task in the chain. I am seeing the numbers are coming off: like 3,3,3,3, for a lot of tasks in the same chain despite there being a hierarchy. And yes there are no circular references for that chain or any branching etc.Script Description: The script aims to update records in the "Tasks" table of my Airtable base. Here's what it does:It retrieves records from the "Tasks" table, selecting specific fields: "Predecessors", "Tasks", and "Next task".It filters the retrieved records to find tasks that don't have any successor tasks (i.e., "Next task" is empty).For each of these final tasks, it traverses the chain of predecessors to update a field called "Milestone Name" with the name of the final task.It performs updates in batches of 50 records to avoid hitting Airtable API rate limits.Code: &nbs

Hello, I am using the Airtable API in javascript. Currently I am using the select method based on the documentation, and I am trying to make use of the returned data outside of the method.For example this is my code:  base('TestData').select({ view: 'Grid view', filterByFormula: `{FUS} = "F002"` }).firstPage(function (err, records) { if (err) { console.error(err); return; } records.forEach(function (record) { PAISearch = record.get("PAISearch"); }); }); console.log(PAISearch);   When I try to make use of the PAISearch variable that gets declared in the return of the select method, I can't get it to be accessible under the Global scope.I would like some advice on how to use the select method to store data into global variables for use in other functions. This works great if I just want to log to console inside of the function, but I need to make use of them el

Hello,On Interface Designer of Airtable, when a user preview the PDF this is working correctly.But, when he download the PDF, Airtable remove the parentheses of the name files.Is it a normal behavior from Airtable ?We need to keep identically name file, because we need it on automation.Thanks 

I have a column of text I need to convert in to title case for an import into another system.Is there a way to make this title case with Regex?There is things like:"PREPARE FOR PRINT""BLUE/GREEN""WHITE / BLACK"Anyone know if this is possible?

We cannot select anything in date fields nor single-select fields. Selection in link fields are fine. The forms are not restricted to the company's domain. They are password protected. Users use the forms on Safari app on iPads.I can fill and submit the forms without problem on a computer under my account. I assume that the problem occurs throughout 2 pm--5am UTC, but this is a guess.

Hello Airtable Community,I'm reaching out for some assistance with a scripting block in Airtable. My objective is to identify duplicate records in a "PNS - Content samples" view of the "PNS" table, based on a unique "Link" field, and merge them. The script should combine the records such that for each link, we keep a single record with data aggregated from the duplicates. The requirement is to preserve non-empty field values from the first record and fill in any empty fields with data from the second record, ensuring that no data is lost from the combined records.The approach I've taken involves:Grouping records by the "Link" field.Iterating through the groups to aggregate field values.Updating the first record with the combined data.Deleting the remaining duplicate records.Here's the code: async function mergeDuplicates() { console.log("Starting the duplicate merging process..."

Not sure if this belongs in automations or airtable.I want to create an automation which creates a new entry in a separate spreadsheet which is being used to track spend for inventory in my business.Ideally it creates a new entry, one for each week.When a new item is added to the main buying spreadsheet, the cost of that is taken by the automation and added onto the spend for that week. Even better if it can take it away from the spend if a refund/return is taking place.Is this possible? Sounds quite simple. If anyone can give me some advice where to start to build this, I would greatly appreciate it.

Just joined A friend wants me to join her "group"? Don't know if that is the right termAnyway, How do I find her organization\company\group whatever it's called hereHow do I send her a message?  

I'm generating Google docs using the automation. In the text of the doc, I'm inserting data from a "link" field. The link field text is getting inserted, but just as text, not as a live link. Any tips on how to make them insert as live links?See the attached pic - the red circled "link" appears as text, not a live link. Below it, the help email address appears as a live link because it's in the text of the email, whereas the Zoom link is coming from a database field. (We have 40 classes, they each have their own Zoom link.) Thank you!

I am looking for a script to assign to a button field.When a user clicks the button I would like for their username to be filled in the "Assigned To:" field. Is something like this possible?

I have a simple task tracker with a single table containing a list of tasks.  I have a self-linking field to allow for a single level of subtasks.  I primarily use Interface lists to view tasks.  However, I also assign tasks to be completed by varying people.  So when I filter to a list of my assigned tasks, the nesting feature breaks.  Airtable will only show me tasks if they are assigned to me.  So if I am assigned to the parent task, I don't see the child tasks.  And vice versa.I thought it could be helpful to append an icon to the front of subtask names to cue me that something else is depending on me completing that task (haha) but can't figure out how to write a formula for that!In the data views, the parent task has the child tasks linked in the subtasks field.  So the child tasks have empty subtask fields.  Therefore, I have nothing to search for.Anyone have thoughts or worked through something similar? 

Hello!I am hoping someone might be able to help. I have a PROJECTS table and a STAFF table, and a link between them to see all the projects that are assigned to each staff member. Once a week, projects that are completed are archived and removed from our list. However, the archived records in my linked record field on my STAFF table are still showing up. I tried to fix this by adding a Conditional Rollup Field to remove archived projects, and then linking back those Projects in a separate linked record field, but two things are happening.1. The automation linking the Rollup Field to the Linked Project Field is giving me an "insufficient permissions" error message. Trigger is when the Rollup Field is updated. I have full permissions as the creator, both tables are in the same base, and both fields are "editors and up". Also, i am able to manually copy/paste. So it should work, no?2. When I get this automation linking correctly, will it even successfully UN-link t

I have a automation that I have set to email people their response to a form I have and the date and time that gets sent out through the automation is the wrong time zone, the time zone on the form itself is correct so I'm not sure why the automation is changing the time zone? when its pulling the information from the form

Hi there ! 👋First of all english is not my mother langage, sorry if my english is not perfect.I'm working on a customer networking project.We have a multitude of tables, but there's no specific naming convention. they're table used by sales people, so not necessarily a tech culture. &#x1f605For example, in one table to determine which sales rep is the owner of a customer, the name is "owner", in another it's "Account Manager".To create a dashboard grouping together a multitude of information, I've decided to create join tables, as the information I group together will inevitably be useful elsewhere.Is it possible to add the "owner" and "Account Manager" information in the same column to this join table?In SQL, it's possible to do this with "virtual columns", but I haven't found anything about this on Airtable.If this doesn't work with Airtable, do any of you have any feedback on data aggregation using Airtable -> Zap

We currently pay about $3-4k/year for a "training platform" which as far as I can tell, is just a file storage front end that you can upload PDFs of certificates to and then launch a couple videos or slide decks from which are followed by short quizzes. When you complete the quiz, the training for those embedded vids/slides is recorded as complete.I have not come up with an approach yet, but is there any decent way to replicate this functionality in airtable? I have an entire training tracking base setup that is working great as a prototype, but the feature that would be great to figure out would be replacing this "built in" online training and tracking function from the other platform (literally the only thing we have going for it, I have no idea why someone selected this product or people got excited about it).Essentially, I have a log of everyone's various trainings. Some are online on 3rd party safety training sites, some are in person practical trainings with a co

HiI'm looking to embed the an airtable form into my site but I noticed that unless we set the COEP header to be unsafe-none rather than credentialless.  Are we not able to set the iframe as credentialless for added security?Thanks!

Hi everyone ! 👋I'm setting up a database with a lot of elements coming from different tables.It's a database on which sales people have to make modifications, but I'd like them not to have access to this database in Edit mode.To remedy this, I'd like to create a form with an active search.e.g.: They enter a customer's name, and all the information we've already pre-filled in the fields, to avoid duplicating questions.Have you already implemented this? Is this possible?If not, what tools or workflows would you recommend?Thank you !

I have an org chart that's looking good except for one thing: the lines that connect the name cells are in a faint blue that is all but illegible. The help bot gave me irrelevant advice, so I'm trying here. How can I configure the color of those lines? It's unusable like this.

Hello smart friends 🙂I've got a base I'm building to track companies within a community with their contact info and other demographic data listed.I'm pulling data from two different sources into the base (displayed as one primary table and 14 other segmented sublist tables) and need to incorporate the data in the following way:- The primary / working list that has the entire list of companies in it needs to have the ability to be segmented by "affinity" tags- The data to determine those tags is in each of the segmented lists, each of which has a handful of entries from the primary list but sorted by a particular affinity, i.e. "black-owned" or "women-owned"- And since some companies will have multiple affinities, i.e. being both "black-owned" and "women-owned", the tag column needs to be able to account for multiple entries coming potentially from each of the indiviual segmented sublists. I can see a way to link a reco

Need a way to have the sum of the columns be viewable in an interface like below.  

Hi All! I am hoping this is an easy problem to solve 🙂I thought this would be really simple, but I'm struggling.I have a project "Start Date" field. Every time one of my users updates that "Start Date" I would like AT to automatically retain the last start date before that change in a "Last Start Date" field.So if "Start Date" was 01/05/2024 and someone changed it to 12/05/2024, then "Start Date" would read 12/05/2024 and "Last Start Date" would read 01/05/2024. Each field would then update every time the "Start Date" field is consequently updated, which can happen numerous times.Any help / advice would be very much appreciated. I am hoping that this can be done with AT as opposed to using any external connector.......

I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and if I filter for the specific month, will it still work?Thank you! 

Can someone tell me if there is a way to select several tables at once to move them? For example, when creating new tables, they are automatically placed at the very end of all existing tables. We have a lot of tables in our base, and I often have to create more, usually many at a time.  If I need them to be located at the beginning, or at the top (of the table list), it can take time I don't have time to move them one by one. It seems like it would be a pretty basic function that you would be able to select more than one table at a time in the table list and drag them up to the top of the table list, or select more than one table's tab and move them over all at one time. I've done searches, but cannot find an answer. What am I missing? Thanks.