Ask the Community

Hi there!I've created and automation that does the following when a record getting updated...Watches FIELD A for update (which I do a copy/delete/paste of 50 records to trigger)Finds all records where FIELD A contains FIELD A (identical names)Updates FIELD F with a list of values FIELD B using FIELD A matches (x50)Updates FIELD E with a list of values from FIELD C using filed A matches (x50)Updates FIELD G with a list of values from FIELD D using filed A matches (x50)Here's where I need support figuring the next part out...Once the above automation runs and I then update 1 record in FIELD A the automation will still run but only tweaking that 1 record accordingly...Watches FIELD A for updateFinds all records where FIELD A contains FIELD A (identical names)Updates FIELD F with a list of values FIELD B using FIELD A matches (x1)Updates FIELD E with a list of values from FIELD C using filed A matches (x1)Updates FIELD G with a list of values from FIELD D using filed A matches (x1)What I n

Hello! I would like to dynamically edit an embedded view or dynamically pre-edit records of a shared interface.I see these two routes as leading to the same result (?):Show a preselected set of records on a public place (no airtable account, no email signup) with just a link or embedded on my webpage. Does the question make sense?Super best case scenario is to call specific "filtered by formula" records through the API/URL and have these records nicely presented either on an interface or an embedded view. 

Hello, Im trying to create a form where someone will need to upload some assets. But I want the assets to automatically be added to dropbox where I will store the assets. The form is just a way to get the required form filled out and assets uploaded.  

Hey guys,Trying to create a template that will be sent to a customer based on a records status. I want to create a button that gives the client receiving the email the opportunity to click "approve" which will then fill the field and give me the chance to create another automation based on the entry.When the email is sent, the button after "approve here" is not there. Is this possible? 

Dear community members,I am trying to create an AI extension within my team's Airtable so that we can have AI summarizing the table for us more easily. I am done with the development, but I only realized now that the only option for me to publish it is to publish it publicly, and it even needs to be reviewed by the Airtable team.Is there a chance I can publish this in a way that only my internal team members can access the extension and not publicly? I don't plan to sell the extension nor allow others to use it, but I am not sure if there's an option for me to do so.I am expecting something similar to Figma's Private Organizational Plugin  Thank you in advance for your help!

Hi all!I'm using Airtable to track leave requests and automatically add peoples approved leave requests to Google Calendar. Currently, I have 'Leave Start Date' and 'Leave End Date' date fields which are used as the 'Start Date' and 'End Date' of the creating a google calendar event automation. However, the event rarely gets published with the correct end date. Instead, the event often gets published with an End Date one day before the submitted 'Leave End Date' (i.e. a leave that's supposed to be from October 1-October 10 will get published as October 1-October 9). Both of my calendars are in the same time zone, and even more confusing, the Start Date is always correct. Any help or suggestions would be greatly appreciated. Thanks so much!!

Hello!  Is it possible to make a URL that opens a specific date on an Interface with a Calendar? You can link to specific dates on Calendar Views by adding "?date=YYYY-MM-DD" to the end of the URL. Is the same functionality or something similar available for Calendar Interfaces?I've looked through a bunch of help pages, and can't find anything that mentions it one way or the other.--The first issue I'm trying to solve is that when you search for an event on a calendar interface, you have the ability to open the event details, but not the ability to jump to that event on the Calendar (this is the only thing I miss from Google Calendars, but I miss it a lot). The only option is to navigation arrow click through weeks/months until you reach that date, which is extra annoying if the date happens to be years in the past or future. I could potentially fix this by adding a button to the event details page that links to the Calendar Date of the event.The second issue I'm trying to so

Hi, I'm trying to link two tables.  One of my tables (Inventory) has a URL field that I'd like to reference in the other table (Customer Project).  All the fields have linked well except the URL isn't working on the field I linked to (Customer Project).  For reference I have an inventory table and a Customer Project Table.  When I go to the customers table, I'd like to use the link from the inventory table.  I set the Field with the URL as a look up.Seems I've missed a step or misunderstood something. Thanks  

Is it possible to embed the interface into a webpage? Kinda like you can do with an Airtable gallery view?

As the name suggests, I would like to copy and consolidate records based on one field into new tables. Perhaps an example would help: Let’s say I’m a store that sells apples, oranges, and bananas. Every time I sell a fruit, I record it in the Main Table by selecting the fruit in a dropdown menu with other purchase information like customer name, date and time of purchase, etc. The dropdown menu is multi-select since customers can buy more than one kind of fruit at a time. In addition to all fruit purchase information in the Main Table, I would like to create three new tables: Apples, Oranges, and Bananas that only contain the purchase history of the one respective fruit. The idea is that each table will automatically copy over a record from the Main Table when I select a fruit. Any ideas on how I might go about doing this? Thanks in advance!

I recently created my first automation with conditional formatting. This is a great feature that I will be able to get a lot of use from, however, the only condition group in my automation that is working properly is the first one. The run history will show that the others have worked, but my team isn't getting Slack messages from the automations like they're supposed to.  How do I fix this? 

Hello and thank you for considering to help me!Every day, my Airtable is supplied with additional lines through an x ​​bias.How can I create a view that only collects last week's rows?I only manage to get the lines from 7 days ago and not all those from last week.Any idea ? 🙂Kindly

I have searched for how to do this, but it seems unclear. There is no way to group by year, specifically. You can only select past year, next year, specific number of days, etc. So how do you group items by year?

Hello,Is it possible to combine multiples of identical x-axis values in the interface chart?I have multiples of identical x-axis values and I want to combine those values into 1 bar.I could make a special summary table with a roll-up but then the person using the interface would not be able to filter the records the way they want, so I need the chart to show all the records and be connected to the accessible filter element in the interface.

Hi I'm looking to create a way to delay an automation (The automation is that every time someone creates a ticket it will automatically create in their Outlook calendar a new appointment/reminder) the issue that I have is that if I put in a date that I would want for some reason it creates itself on the day it was created not the day that it's being scheduled for.Is there any way I can schedule to the day it was created to the scheduled date and not the date that was created? 

Has anyone had success asking Chat GPT for Airtable formulas? I've only asked it a few Airtable related questions so far, but I have to correct them all. Curious if anyone knows if there's a specific way to ask that will get formulas in the correct Airtable format.

Good morning.I use Airtable to inventory my craft supplies.I have built a new workspace, exactly like my first one. I am trying to move individual records from the first base to the second base.I am not techy (read senior citizen) and need the simplest solution. To build buttons or automations or any of the other wonderful things mentioned is beyond my ken. Of course, if this is the only way for it to be done, I will need very simple instructions. I did try to copy and paste, and it didn't work. It only moved one cell.TIA

Hi, I'm copying contacts from one table and pasting them into another table. I'm looking for a preview of these contacts on a button click. Is there a way to add a button in the script?

Hi all Airtablers, I was trying to connect a task from Apify to Airtable via Datafetcher. I did that in the first run a few weeks ago and it worked. Now i tried to schedule the task, but it gives the error below.  I checked the actor task and it's fine. not sure where is the issue. any help/advice is appreciated.  

I've come across a strange issue.Using MAKE (aka Integromat) I'm using an Airtable Search Records module with the following formula:AND(Lower({Email (from Members)}) = "{{lower(2.`recipient email`)}}", {Order Number} = "{{51.`$1`}}")It accepts it but does not return the required record. The Order Number is a number field, and I've tried the formula with and without the "I've done with this similar tables and records but for some reason this one is not working and I cannot fathom out why.Any ideas?

Anyone know how can I enable these selections shown on the video?https://www.youtube.com/watch?v=38sS2hJKKtk : This is what it looks at my end: 

Why is the GRID view not working, but the LIST and other views are ok.It reports an error in the GID viewNo tasks found for "https://airtable.com/sh********I".Try editing your search query.Please some advice and help

Hello, I have been using the Airtable API and having some problems in that.First of all, OAuth access token is getting expired before 60 minutes. When I try to refresh the token using refresh_token it stays this:{"error": "invalid_grant","error_description": "Invalid token."}If I refresh the token frequently, it works fine. But it is getting expired before 60 minutes (as written in docs) and after it expires, I am unable to generate token again. PLease Help! Thanks

Hi community.I have a single-select field called Sector in a table called Projects. I'm trying to cast this field to a string.The reason I'm trying to do this is that I'm trying to build an automation, in which I will need a conditional step that will check this stringified single-select field to a multi-select field in another table to see if the multi-select field contains the the selected value in the single-select field.Thus far, I've created a formula field in Projects with various formulas (or formulae, for the sticklers out there), including:- ARRAYJOIN(Sector)-Sector-LEFT(Sector)No matter what, when I go to the automation it won't let me choose the field because AT says "Cannot assign list of string to a string".Please help!!!Thank you!

I've been building interfaces that have "add record" buttons in them, and because of that I've realized that I've miscategorized some primary record fields for what a record is called when I first created a table. For a table that is based on personnel records I somehow selected "company" from the dropdown list when I first made the table and now in the interface for a personnel record I have a button that displays "Add Company". Ideally I could change the "What should each record be called?" option in each table, but I'm not seeing any way to do this once the table is created and the initial selection is made. Alternatively, I would love to be able change it to "Add Person" as one of the options in the interface designer, but doesn't appear that's an option either.Does anyone know a way to do this either in the interface designer or after a table has been created?