Ask the Community

Hi guys,I currently have a status filed (New, Opened, Responded). I have the "New" and "Responded" sorted via automations, but is there anyway to update the "Status" from "New" to "Open" when someone opens the record within an interface screen.Any thoughts or help would help massively!

I have a very frustrating problem that started last week. I have an automation that when a record is created a slack message is sent to a slack channel attached to the record. It fails every single time but if i test it it works perfectly every time. It worked until last week and now fails eery time. Any suggestions

Hello AT community.Really scratching my head here, maybe someone can help.Some context, my company offloads data for carriers. We have clients that host access points, basically wifi radios, those access points each bring in a certain amount of revenue.I have a client table, an access point table (basically inventory), and a Access point revenue table. The Access Point table is linked to the client table so it shows which client owns it. The record ID for the Access point table and the revenue table are the same. What I need is an automation that will match the Access Point in the Revenue table to the Access point table to the Access Point in the inventory table. If they match I need it to pull the client that owns the access point and add it to the record in the revenue table. Hopefully that makes sense and thank you for the help

I want to integrate langchain in airtable using Javascript. How can i pass values to langchain Prompt/template and log back reponse back to Airtable?

Hello !I am building an e-commerce platform where employees can buy services and products while benefiting from a coupon from their employer. Therefore, for each service and product, I might have dozen of different prices depending on who their employer is and how much they finance.I would like to generate a specific Stripe URL for each Airtable record, so that an employee could select a service or a product, and I would send them an email with the price applicable for them, and the Stripe URL. This URL would redirect them to a Stripe page with the amount prefilled (and ideally their e-mail too), so that they can proceed to checkout.I would like to know if that is feasible and what are the key modules I must use to do so.Thank you,Elodie

Is it possible to create a formula field using the API? if so how Can we do it can someone provide me the right json structure and syntax

Hey there! I am trying to allocate monthly expenses across our business units (BUs)  based on pre determined splitting criteria, some of those criteria change month over month, such as the percentage of revenue each business unit is producing. What I'm trying to do right now (but failed at it) is linking four different tables: 1. Transfers --> All the payments we have done in a month2. Suppliers --> A list of all suppliers we currently have3. Splitting criteria --> A list of all the possible splitting criteria (Equal splitting across BUs , splitting by  revenue%, etc) 4. Splitting % --> Given each splitting criteria, how would the percentages be assigned to each BU each month. For example if the split is by revenue %, what percentage of revenue each BU produced every month, or if it is equal splitting all BUs get 33% every month. This table has the following columns: month, splitting criteria, pctg to BU1, pctg to BU2, pctg to BU3. What I've been tr

Alright, this is a bit convoluted, so I'm hoping someone out there is much more comfortable with automations than I am because this is driving me absolutely crazy. I have a list of companies that are being tracked as they're evaluated, but I want to be able to cross-reference them on the same table to indicate they're being evaluated for the same need. For instance, if I have records for Coke, Pepsi, and Dr. Pepper, I want to be able to go into the Coke record and have a linked record field that points to the same table, and I want to be able to link Pepsi and Dr. Pepper as also soda options.That part is easy, I've got it configured. The trick is that when I do this, what I want is for an automation to automatically go to the Pepsi record and update the linked record field to add Coke, showing the two are linked. Same for Dr. Pepper. The dream scenario is that Pepsi and Dr. Pepper would also reference each other automatically, but I bet that's probably pushing it a bit far.I am at a lo

There are a bunch of great input methods that one can use in the scripting extension to take text imputs or allow a user to select a specific record. THey are not avaiable in automations, but unfortunately it seems that running a script in an interface requires one to use an automation. Is there a way to get inputs from user through a pop-up in an interface run script?If not this is a much needed feature!

I am creating a table to get a detailed look at my finances. I want to see cost per day by city and category for the following table schema:Purchasesname, cityName, cost, categoryCitiescityName, daysInCityHow do I create a table with the following fields:cityName,category,costPerDaycity1,food,$20.00city1,lodging,$100.00city1,activities,$50.00city2,food,$30.00city2,lodging,$110.00city2,activities,$60.00I want this to be automated so minimal manual work besides adding each purchase as a record is unnecessary.Currently, I am running into trouble auto-selecting the records by city and category. I have tried with automations but I am running into an unknown error:Invalid filter on Category (Invalid filter value: [ "Essentials" ])

I have a Record Review Interface that is shared publicly. As expected, the record displayed when following the public link is the one at the top of the underlying sort. I'd like to display a different record in the table as the starting point while retaining the sort for the list of records. The URLs appear to follow a predictable pattern, and the initial URL for the public interface is rewritten as a URL with an appended query (after a "?") referencing the displayed record. The query consists of a six-character string which is consistent, "=rec", and the internal record ID.When I construct a URL containing the query for the desired record and attempt to load it, I receive an "Internal error, Try refreshing the page." message. This also occurs if I simply cut and paste the rewritten URL into a browser window after following the base public link. I am using a browser session that is not signed into Airtable to test the URL strings.Any ideas?

I am setting up a calendar for my team. I would like single day events (records with a start date and no end date) to automatically copy the start date into the end date field.Fields:StartDate - always filled unless TBD, which I have another marker forEndDate - often left empty if a single dayI've tried to make automations and scripts, but I keep getting errors that I don't understand how to fix. I assumed this would be pretty basic, so I don't know what I'm missing. Basically what I want is:IF EndDate is EMPTY, THEN let EndDate = StartDateI don't have enough experience figure out the syntax in airtable; any help would be appreciated.

I have an automation that sends an automatic email. There are 2 date fields in the text. This should display the date and time. unfortunately the date fields are displayed as in the attachment. how can I change this?It would look nicer if everything was like the last one. could be removed

I want to send an automatic email, but unfortunately I get an error message every time I test the automation.although the correct data field was selected and an email address was also stored. That used to always work but suddenly it doesn't work anymore

Hi there,I was able to successful write and run a script for a basic "like" button on a table where team members can sort of upvote a table item. The problem is it does not refresh on the interface for a long time and does not give any haptic feedback to the user - not a good experience at all and very easy to find yourself hitting the button multiple times.Is there a way to get the value to load more quickly on the page? Like a field refresh trigger or interface refresh action?  //Read var record = input.config().getLikes; //console.log(record); //math var newLikes = Number(1 + record); //console.log(newLikes); //update output.set('likes', newLikes);      

Hello,I would appreciate if someone could help me.In the attendees column, I can link multiple names in one record.I want to create an automation that allows me to create a record in another table whenever a name is added in the attendees. I tried doing it using the automation in airtable: whenever a record is updated in the attendees a record is created in another table with the name of each person. But the problem is all the names are being shown in that table.So, how can I create an automation where I can have the name of each person in one record.

I have a formula field that only shows me the name from a string. I would like to use this name in an automatic email. Unfortunately I can't see the name.

I have a name and the corresponding date of birth in a data field, separated by a "|" I would like to use a formula so that only the name is displayed to me. the name is before the "|" sign. I tried LEFT, but only got ERROR

I need some help with an automation.When a particular record in table A is updated, then inTable B the contents of (Planned Move-in and Planned Move-out) in the fields (Move-in and Move-out)

How do you write data separately to all the records you find when you automatically find multiple records？the follow example find 2 records, then the next action step run fail, what can I do so that the updated action is written to each of the two records found?

Dear Sir,I need help in creating rankings of products based on its quantity.We have a table with 3 fields. Name of Fruit, Quantity, Ranking. We want to rank the Fruits as 1,2,3,4... based on the quantity of that fruit. Whenever the quantity of any fruit changes, the Ranking should update itself.Any help will be appreciated.Thank youNavin

 In a few of our bases, we have either password protected the shared grid view, or we have disabled the share view link completely. However, we're finding that a different URL for that same grid view is still being accessed, even though there is no link associated. This means people with a link are able to see the contents of this grid view. We're also finding that this URL is different from the original link that was associated with the base.Is there a way to view what links are tied to the base? Has anyone else experienced this issue? We are trying to get these links offline. Hope this makes sense. Please let me know if any clarification needs to be given.

DescriptionThere appears to be an issue with Rollup Fields when used in conjunction with Linking Records and date columns. The problem occurs when the Rollup formula becomes more complex.How to ReproduceCreate a Rollup Field that references a date field in Linked Records.Set the Rollup formula to MIN(values).Result: Some records correctly display dates (as expected, since not all linked records have values in the corresponding date field). Change the Rollup formula to a more complex one, such as: IF(MIN(values) = BLANK(), "-", MIN(values))Result: All records now display "-" instead of the expected dates. Expected BehaviorThe complex formula should behave similarly to the simple MIN(values) formula, showing dates for records where they exist and "-" for those without dates.  

Hi guys!Losing my mind trying to figure this out – I thought it would be a super simple formula but just cannot get it to work. Here's the lowdown:I'm mapping out placements for an editorial website – there's a carousel that will feature 5 articles each week, rotating between 12 different articles. I want to be able to count how many times an article has already been used in the plan.So, I've got a table here that's grouped by each week (ie. "1. 9 Nov"). Below is an example screenshot showing the first 3 weeks (but there are 7 in total):A breakdown of each column:Name: The name of the week (so it can be referenced in "List of placements")Article: This links to another table with a long list of hundreds of articlesPlacement: A single select field with the name of the particular spot the article will take in the carouselWeek: Single select field with the name of the week (used to group the articles as I couldn't do single select as the first column)List of placem

Hi,I wonder if I can somehow give a copy of a Base to another user?I have a blank Template base (with just the column names and formulas and such) and I would like to give a copy of this Base to another user. This other user is NOT part of my company or organization. I do NOT want them to be a 'collaborator' in any senses - I just want to hand off a single copy of the Base to them, and then they can do whatever they want with it, and not involve us at all (or our account at all). Is this possible somehow?thank you!-Ed