Ask the Community

For some reason a number field is not showing up in the Interface's filter options.This happens specifically if you choose a layout with a specific widget (I'm using timeline in this case).If you choose a blank layout though, the number field IS available in the filter!What's with the inconsistency? Why would a different layout have different functionality for the same feature?I guess the alternative would be to just use a timeline in a blank page, but I don't want to that. I prefer the feel and options when you pick the timeline layout directly.

Hello - I have a date column of when an event will occur (Showcase Date) & I am wanting a formula to populate deadlines based on number of days before or after this date. Here is the formula I created but it is not working. Any suggestions? I have tried: DATETIME_FORMAT(DATEADD({Showcase Date},{Number of days},'days),'MM/DD/YY')

Dear community, Does someone know how color a field by level of progress? For example, all tasks under 30% of completion in red, tasks between 30-60% in yellow, tasks between 60-90% in blue and tasks between 90%-100% in green? I’m sure that is something very easy to do, but I’m new with the PRO subscription and I still learning Thanks all!

Hi, I'm using Create Record API, my requirement is sending a image to a field in table. But the API requires to send an image URL instead. Would anyone know if there is a hosting service that can return the image URL while ensure the image uploaded is not being public? Or would Airtable team have plan to provide such a service? Thanks!

Finally have gotten fairly complete on a prototype base design for tracking training records for our company (construction industry) and while I have a decent interface setup for showcasing what we could potentially do, I am wondering if sticking with airtable native or moving to one of the 3rd party form and/or front-end platforms (fillout, noloco, softr, jotform, etc) is the right approach (costs being a consideration as well).The general use case is a base with a couple of tables used to track employees, what training they have taken (CPR/1st aid, scaffold, trench excavation, fall protection, etc) and which of those are active, expired, or expiring soon. It also logs and tracks incident reports on the various sites (what project was it on, what employee involved, what happened, corrective actions, etc).I have an interface set that has:A dashboard for our training metrics (% of training complete, what trainings are delinquent the most, filter by project/d

Hi,For some time now, the unlink button on a card shows as a mere white dot when hovering over the item. Only when you hover over the button itself does it show the proper dark background / white 'X'.This makes it hard for users who aren't very familiar with Airtable to work with our interfaces.

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 !