Solved

Hi! So, I tried an automation to send an email to some designated people from a list on Table 2 when a record enters a view on Table 1. The users are coming from a linked record from T1 to T2, but when I configured the automation, the system apparently didn't read the emails are emails so, so it failed to send anything. Am I missing something on how to do it?  Background: All of the users are Airtable users but they don't have access to the email accounts linked to those emails.

I have a simple linked table. There is a table of CASES with a bunch of fields and then another table called CASE ACTIVITY which has scheduled activities for each CASE, so the tables are linked by CASEID which is the primary field on CASES.That all works fine. Under CASE ACTIVITY each row is a dated activity, so :CASEIDScheduled actionDate65Sent for review10/10/202465Publish findings12/10/2024I would like to have a formula field in CASES that shows the date when the next activity occurs. And I started with a formula field that simply said "MIN({Date (from Case Activity)})" but it returns a value of zero.Ultimately it would also need to not pick dates that have already passed.Any ideas?

Hi guys. I have a workspace through which we manage our business, an academy. I have just two users, one for the owners and creators, and another for the teachers. Our problem is that we need the teachers to access to some bases and some interfaces of the main data base, but no to all the administration and managers info, and till now i havent found a way to restrain the access just to the bases and interfaces that they need. Is there anyway to manage the permissions or block access through passwords???? Thanks a lot for your time. 

I would like to be able to select data from a list of choices on softr. However, by linking the dropdown option to a linked data column on airtable, the data of another user also appears and I would like to avoid it. So I tried to use dynamic filters, but it does not work.  AS 

Hello folks!Total newb here!I have a base with 2 tables. Table 1 is orders that are placed by customers. Table 2 is a list of those products with a corresponding URL to the image.I'm trying to have the Cover Art field in Table 1 populate with the corresponding date from Cover Art URL in Table 2; based on the Product field in Table1 when the customer places the order.Basically when a customer places an order, I want the Cover Art field in Table 1 to pull the appropriate URL from Table 2, based on the Product field in Table 1.  Does that sound utterly confusing?I've attached some screenshots in case it's helpful.I've been spinning around online trying to figure out how to accomplish something I believe is actually simple.With grace,JQ

I have been reading for hours through the help forum and documentation, but ARRAYSLICE doesn't want to work for me.I want to achieve the following: Show me the first value of an array. My formula is: ARRAYSLICE(verticals_from_contact, 1, 1) but it doesn't show me the first value of the array. Instead, the field shows me the whole array. If I change it to: ARRAYSLICE(verticals_from_contact, 2, 2) nothing is shown anymore.  I tried the formula on lookup fields, linked records, and multi-select fields, and nothing worked (see image). Does anyone have an idea what's wrong?

Hello.Very new to Airtable. I am a designer working with a marketer for an events org. We are using Aritable to manage all our projects. I need a unique number for all the projects and am wondering if it's possible to auto number across multiple tables in a base, as that is how she is going to organize (tab for brochures, tab for print ads, etc.)I also would like an alpha prefix because we will have another base for another events org that we work on simultaneously.Ideally, I would like to have all projects in both bases just be auto assigned a unique number, but I don't know if that is possible either.Thanks for any help!

Hello,I would like to create an automation where I enter the working hours of the respective month and employee from "Table A" into the column of the respective month and employee in "Table B". (January, February, ...) the whole thing should be done once a month.

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"))) 

How to group rows by date so that groups are formed by day, without taking into account time. To get a group of October 4 with 2 rows and October 5 with 2 rows. I understand that the question is in the time display, but if you make a separate column with the formula DATETIME_FORMAT({Posting Time}, 'DD MM YY') and then group by it, then the program takes the date for text and sorts without taking into account the month, only by day.

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?

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 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

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

I have an automation that runs a script to trigger a webhook in Power Automate.  This correctly pushes the Expiring URL to Flow.My next step however doesn't work. PA seems to want a filename in the path URL. Airtable doesn't generate the URL like that.Is there a way to reformat the expiring URL to have a ".jpg" at the end? 

I've used this very helpful page to be able to export my tables out of air table and into Power Query, and from there into Excel: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportHowever, I'm having an issue that some seemingly random columns aren't being picked up by PowerQuery. I've done this with 5 tables, some have worked perfectly, some haven't. The columns that are missing are different types, sometimes check boxes, sometimes free text fields. I can't work out what the pattern might be, and therefore how I might fix it.I'm hoping someone might have come across the same issue in the past, and know exactly what I'm talking about and how to fix it. 

Hi all, We are on the Pro plan, which seems to default duplicated views to personal even if they were originally collaborative. We mainly use Airtable for grid views, though I’m not sure that has anything to do with the issue. I have searched high and low for a setting or option to NOT do this, as we would prefer duplicated collaborative views to stay collaborative, and not have to manually change it each time. Any ideas?

Hi, I'm simply trying to subtract hours in one field from hours in another. I have a column with 'hours recorded' and one with 'hours billed'. They are both formatted as time units (hours). I just want to subtract one from the other in a new field. As an additional question is there a way to set the hour units to just hours, with no minutes, at the moment it's h:mm and I need to enter a 0 for minutes each time Thanks   

I'm trying to connect MS Power Automate to Airtable. A lot of info seems to be stale out there. I have this flow, which parses data. I found this step HTTP Webhook. I'm hoping to make this a trigger for an Airtable automation. However, when I run the flow, it gives me a bad request error at this step.Does anyone know if this is possible to set up like this?  

I'm trying to build an automation that uses a custom script to determine whether all necessary leads have been assigned to a record within the base. The teamsNeeded field (multiple select field type) determines the teams that need leads on the record. Each team then has a lead field (single select field type) where the lead is selected. If "Comms" and "KM" are selected in the teamsNeeded field then the "Comms Lead" and "KM Lead" field need to have a selection/not be empty.I have limited scripting experience but have been able to build the one below. The issue is that it is outputting 'All Leads Assigned' even when leads are missing. The console log for teamsNeeded shows that all teams are being captured - the log for the example with "Comms" and "KM" in the teamsNeeded field reads "teamsNeeded (2) ["Comms", "KM"].Is there something I am missing that is causing the output to always be 'All Leads Assigned' instead of 'Leads Missing' when leads are missing?  // Get values from t

Basically, I'm wondering how to change the fields shown in a linked record field dropdown/select menu.These fields below (Record ID, First, Middle) do little to help me distinguish among similar records.Note that this particular screenshot is of a linked field to a table that is synced in from another base. But my question stands generally, whether for a table«»table link or for a table«»synced table link—what's the best way to choose my own fields to display, if it's possible at all? 

Our company has an inventory of office supplies, which we track in a table called 'Inventory'. This has fields for item description, photo, quantity available, location, etc.We want to create a system to create "checkout orders" and select multiple items, similar to a shopping cart. We want to do this through interface pages.I know I'll need 2 other tables: 'Orders' (overall requests) and 'Order Items' (items requested in order).The question is how to create an interactive workflow to place items into your order.I'd like to have a List or Gallery starting page, which displays all the items in stock. I'd like to do something like a checkbox or button to add items to my order. (I imagine you'll need to create a new order first.)However, if I just make checkbox field on the 'Inventory' table (the master list), this is seen by all users - which prevents 2 users from "shopping" at once.Does anyone have a suggestion for making a good experience? I want to avoid jumping between pages: looking