I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula ...
I have created a form to create new Project records. Each project requires a unique ID which matches a particular format (XXXX-000).How can I make sure that no-one uses an existing unique ID when filling out the form? I really need to avoid duplicate...
Hi! I'm trying to use a Task Template table & an automation to create Tasks aligned to an Account based on a specific criteria. I've got the automation working with the following set up: When a record matches a condition in the Accounts tableProduct/...
Hello,I'm trying to create a mapping using IF and OR statement, in order to map a set of values for the 'Status' field to this new formula field. This formula doesn't cause an errors, but it only partially works. Does anyone know why this doesn't w...
Is it possible to only show certain fields to certain users?For instance, if someone is logged in and has an email that ends in @whatever.com, we can mark that field only visible to those users.Any other suggestions would be welcomed!
Hi - I am trying to update a forecast in case the field hasn't been updated for over a month. The idea is that if there are no updates, the forecast would lower by 10%. It all looks great, until I have to "Update record", I pull the record ID (dynami...
Does anyone have any ideas on how to label relationships in this CRM we are building? We have multiple relationships we want to label such as spouses, siblings, advisors, parent-child. We also want it to work in the inverse so it shows that Sally is ...
Hello, I am building an Airtable integration for my product to use the Airtable API on behalf of users. I would like to use the Official API client which is airtable.jsIn the interactive documentation link given, I had a look at the "Javascript" tab ...
My table tracks publication start and end dates for various websites, and I need to determine the time between the previous record's end date with the next record's start date.Examples: Site A's publication will be taken down on May 31, and the new ...
I've read through several help topics and I am still having issues, hoping someone can help me. I have a field that is counting the days between the due date and todays date. I need to use these numbers to create a formula to provide an aging report....
喙 Exciting news for healthcare providers and organizations! Airtable is now HIPAA compliant and ready to support your critical work. We understand the importance of protecting sensitive patient dat...
Announcements
We're thrilled to announce the release of Airtable AI, a set of features with the potential to transform your workflows! These features allow you to embed generative AI capabilities directly within yo...
Announcements
Hello, hello! Welcome to this special edition of our Top Contributors post, covering both January and February! Okay I admit it, I got a tad behind on these posts, but that just means double the fun a...
Announcements
Hi everyone, I’m Carla – a software engineer at Airtable and I am really happy to share that we’ve added the ability to dynamically filter results in linked record pickers! You can now limit the recor...
Announcements
