Ask the Community

I have four (4) columns that are number data fields titled {Trip 1 Miles}, {Trip 2 Miles}, {Trip 3 Miles}, and {Trip 4 Miles}. The settings to the number data fields include decimal places and a screenshot of the settings are attached.Column five (5) is titled {Total Miles Traveled} which is a formula data field that SUMS the total of the number data fields listed above. THE PROBLEM TO SOLVE: I am unable to get the formula in {Total Miles Traveled} to include decimal points in the SUM total. A screenshot is attached. The formula is totaling [26.70 + 26.70 + 9.10 + 9.10] and is rounding the answer to [72] instead of the desired answer with decimal points as [71.60].

Request - Please don't show the drop down arrow for records that have no child items!Thank you!

I have a form where every month the team leader enters the hours of the employees as follows: Employee 1: "35 hours"Employee 2: “48 hours”. up to 15 employees per team leader. Table A shows me all the hours entered by each employee in each month. All employees are listed in “Table B”. In this table I would like to add up all the hours worked so far. how do I get this done. Employee A can be listed under "Employee 1" in month 1 and under "Employee 4" in month 2. Theoretically, every employee could be entered in the 1st - 15th position. So I would have to add up all the hours of each employee, regardless of whether, for example: the employee is under “Miztarbeiter 1” or “Employee 12” and so on. you would have to tie the hours to the names or something.

To set Button visibility it seems I need to upgrade, it a Team plan enough?

I working on a formula that will provide me with 4 different outcomes depending on a products Variance from our target cost of product/FOB. Any products that have a variance less than -5% need to output "Red -5% or More Variance", products with a variance between -1% and -4.99% need to output "Orange -1% to -4.99% Variance", products with a variance greater than -0.99% need to output "Green - Meeting or Exceeding Target", and any products that have an empty value need to return an empty value. I have figured out how to return most of these responses, but I'm hung up on how to return the empty value. Any help will be greatly appreciated! IF({P1 FOB % Variance From Target}<= -.05, "Red -5% or More Variance",IF(AND({P1 FOB % Variance From Target}>= -.0499, {P1 FOB % Variance From Target}<= -.01), "Orange -1% to -4.99% Variance",IF({P1 FOB % Variance From Target}>= -0.0099 , "Green - Meeting or Exceeding Target"))) 

Hi there, I was wondering if and how I can make a (prefilled) field in a form read-only. I am basically creating a form to answer a question. The form should be generic, but the question should change. But it should not be changed by the user themselves. I know the field wouldn’t “really” be read only since the user could modify the query string parameter, but that would be good in my usecase to prevent unwanted changes to one of the fields. Thanks!

I have three columns: Email Sent (Yes/No) Date (Sent) I would like to add a fourth col to display the number of days since the email was sent (i.e. Current Date - Date Sent, displayed as Days). How can I write a formula for that?

Hi, I am having trouble creating an automation to update a record in a table. When I try to set up the "Find Record" step, I'm getting an error that "cannot assign list of string to string" and I don't know how to proceed or how to fix my data set up in order for the automation to work.The issue (I think) is that in the table I'm trying to update has a linked field which is the unique identifier I need for the automation to find the value I want to add to the table I am updating.  I'll try to explain the data structure and what I'm trying to do. Table 1: ContractsTable 2: Contract Items (this is a list of "products" that are associated/organized with Contracts for clients in Table 1)Table 3: Books (this has an association with Contracts (from Table 1) to a book). One book can have several contracts. One contract can have several books. Table 4: Results (Products from Table 2 is the primary organizing principle for this table, and this is the one I am trying to updat

Hi Some of my team are having trouble clearly viewing what days / weeks the records are in within the TIMELINE view as it feels like there should be gridlines or at least column lines, not just the blue 'today' vertical line.Is there a way to toggle these lines on or off does anyone know, or would anyone want this feature too?TIACharlie

Is it possible to delay an action from happening? I really like Slack notifications for new records, but I’d like the action to wait say, 1 minute after the record is created so that I can finish adding all of the fields. Is that possible?

I've searched on the community for solutions to combining one field that contains a date and another field with a duration to create a datetime field, but haven't come across any solutions to solve it. I'm using the DATEADD() formula but Airtable is not returning a correct results. What am I missing?

I’m trying to expand a base we use as a booking system for photography sessions but feeling stuck. In our current system, users fill out an Airtable form with their contact info and select a time slot (field linked to a table of time slots, filtered by what’s still available). That info generates records in the main Appointments table. This system has worked well so far, as we’ve only been offering slots with one photographer at one location. We’ve been offering 30 slots per day and about 3 different dates at a time, so at most the user sees 90 options, which is more than ideal but has worked ok. Now we’d like to offer 5 dates, but more critically, we want to add a second photo station in a different location on the same dates. That means the user will now be selecting a time slot from a field with 300 options, and there will be two slots for each date and time (eg 10A Monday @ Location A vs. 10A Monday @ Location B). The biggest limitation I’m hitting is I can’t add the same field (ti

Hi everyone!I created a base for employees in our company with the table where are all information about every employee. I also created a form to update those information if necessary. I prefill all the fields and create a button field so that i can quickly open the form. But somehow that button doesn't work with some of the employee. they were added after I created this button. I attached some photos for you so that you can see what I'm talking about.Does anyone know what is the problem here?

Assume you have a total of 100 items and a multi-select field that allows you to select from a set of values. You want to find out what percentage of the total is represented by the selected values.

I have a date field that contains "2020-11-26" and another field of type selection. I would like to put the date "2020-11-26" in the selection field by transforming it into "26/11/2024". How can I do this?

Hello, I am really thrilled with exploring the features of this new and game-changing Airtable functionality. I think it would be super useful to my team which deals with hundreds of social media posts per month created and edited by several of our departments. To give this a go, I started by creating an interface which would help our education department organize their programs and link social media requests to records another table - I already have all that setup. Where I am stuck on, is on the ability of creating a new record from the interface itself (i.e. create a new upcoming program from the interface where I am browsing the programs). I cannot find an element such as “add new record” or for that matter “delete record”. Do we have to go back to the regular grid-views to add or delete records? That sounds a bit convoluted… I am loving the new feature and I understand that it is in Beta, but I really want to use it to its fullest and would love any suggestions, or if we could add

I am creating an automation script in transferring data from a source table to a target table. The source contains AI generated responses so everything is in text. I have 4 fields in the target table as single-select fields and I found out that the error I am getting is for those fields. Here's the code below. Hope someone can help. let sourceTable = base.getTable('Update Repository'); let targetTable = base.getTable('UPdates');  let inputConfig = input.config();let recordId = inputConfig.recordId;let newRecord = inputConfig.newRecord;// Fetch the record from the source tablelet record = await sourceTable.selectRecordAsync(recordId);// Fields where AI responses are stored in the source tablelet flag1 = record.getCellValue('Name change - AI'); let&nbs

Greetings mighty Airtable community,We are trying to set up a very simple automation called "FIND SIMILAR RECORDS" within our blog article base (hundreds maybe thousands of records/titles/articles) that would look like the example below. When a new record is created, we'd like to automatically Find and Group (and Sort) similar records in order to look for redundancy or duplicates. Meaning:Every time someone goes to "create a new record"When "specific service" field is [current item] entered into the new recordAnd/Or "keyword" is [current item] entered into the new recordAutomatically Find and Group similar records in order to look for redundancy or duplicatesWe'd like this to be an automation rather than to set it up as a simple search option.It seems like a simple request but the free version will not play nice. When we asked Airtable support if the app will do this, they said they cannot help with automation setup. For example, we're not sure:-- if this would be a script to run,

Is it possible to add logo in Interface Form?

In the Change Request form I've created, users can enter information about a change request -- item, change type, notes, screenshots, etc -- and then they can use a multiple select dropdown to choose up to four Regions where the changes should apply.I'm using a Repeating group to cycle through the Regions input to create a separate record for each Region. 4 Regions chosen, 4 rows, 3 Regions chosen, 3 rows, etc. Beautiful! The trouble is, it also creates a single row with ALL 4 or ALL 3 regions etc on it. How do I stop that?

I set prefill data for certain columns and created form for other fields. On entering form data, new row is created but these prefill records returned empty. I thought new row will contain prefill data regardless of how it is created. I referred this for temp solution: Can I prefill a portion of a form?

Hey guys, is there any way to Web Scrape Data from Websites into Airtable? It’s actually just a single row I need. Best regards

I need my company logo to appear in every record in a table so that I can have it appear on the sales brochure I create in extensions (unless someone can explain how to do this using the static element there but I can't find a way to attach it there).Is there a way (possibly an automation?) to have that field auto-fill with the attachment whenever a new record is created? Thank you

I added a button field to my interface but it’s not clickable. I don’t see an option to make it editable when I go to the properties to try to configure. I’m assuming this is a bug — buttons would be handy to include on an interface!

Hi there!  Sorry - this is probably simple - but I'm having trouble finding a simple solution for the sample issue below (pretend scenario for ease of explaining):I own a fruit store, and I sell individual fruits & bundles of fruits:Table 1: Multiple records of Fruits (apple, orange, banana, watermelon, cantaloupe)Table 2: Multiple records that are Bundles of Fruits (Red Bundle contains apple & watermelon, Melon bundle contains watermelon & cantaloupe) where I have the Bundles linked to the Individual Fruits recordsTable 3: I would like to create a third table that would be my Total Inventory - so each record in this third table is the individual Fruits as well as the Bundles.  I would like to have this third table autopopulated, so I don't have to remember to manually update the Total Inventory table every time I add in a new individual fruit or bundle.Is this possible?  And the reason I want this in the first place is that I would like to create a separate