Ask the Community

Hi all, I have been playing with the SYNCH API for a while with excellent results. I found this capability very useful for creating and updating records. So far so good.My next challenge is to fill a table which one of its fields can hold a text coming from a legacy system. The problem I'm facing is that those texts include "," (commas) since they are descriptions and side information related to every record.I would like to keep the original format, otherwise it can be difficult to understand and read, however, when I try to use the synch API to move the data, I just crash with the CSV definition. I have not found a way to scape the commas in the string that is passed to the synch API, so it cannot process the request for those records.Has anybody faced the same situation? any hint? workarounds?... any help is welcome 🙂

Hi everyone, i'm a new user of airtable and just wanted to ask if there's a way to do this?The first Col row 1 (red box). If that specific row is not blank.It will fill out the entire next col (blue box).  

Hi everyone! Please give advice on how to sort a list of records inside a Google Doc. 

I'm trying to write a formula to check whether a lookup field contains a specific value.These lookup fields might contain one or multiple values, e.g.applesapples, pearspears, bananas, strawberriesI've been using the formula IF(FIND("apples", {fruitName}), "yes", "no") In this case, I would expect 1 and 2 to return as "yes", but only 1 is returning yes. Find seems to require an exact match, and if there are other values in the lookup field, it returns false. Does anyone know what I'm doing wrong here?

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 fro

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,I'm looking to connect Google Analytics 4 or Google Tag Manager to Airtable. I can't seem to find a direct link option or any place to input custom code snippet to achieve same purpose.Thanks a lot!

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

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?