Solved

I have been attempting to catch a hook in Zapier from a scripting app that I run daily. The content of the request is designed to capture some metrics from the actual running of the script. I have previously run caught a webhook from a scripting automation to Zapier with no issues. For some reason though, when trying to send a similar request through a scripting app I encounter a failed to fetch issue with some writing on CORS. My code is below, I removed the link within the fetch but it was just the link that Zapier provides within their catch hook step. var bodyContent = { "scriptName": script, "numOfRecs": numRecs, "elapsedTime": et, "recsPerSec": recsPerSecs } let request = await fetch('', { method: 'post', body: JSON.stringify(bodyContent), headers: { 'Content-Type': 'application/json' }, }); This is the error that is happening when I attempt to perform this part of the script. Thank you for the help!

I would like to create an automation that reminds me by email 1 month before a date from a formula field. Unfortunately I can't change the value of a formula field to dynamic or say the date is within 1 month like I can with a real date field. that doesn't work.

Why does my primary field total display xxx Stories on some dBases and xxx Records on others. OK, dumb question, but I had to ask... and it's not in the AT Glossary of Terms.

Hi,I created a script which takes data  in a project financial table and updates special table with payments report.I'm going to setup it to run daily or weekly automation, and add it to many projects in different bases.Problem with updating a single-select field 'Type' (of operation), when new Types appear.here is the issue, automation can't do that (script extension works ok):thinking about workaround - use preparation script, compare and check whether new types available, output them in variable 'newtypes', find any random record in destination, loop Update it's 'Type' through the list of 'newtypes', then return the old value.Then run main script.More clean solution, to avoid affecting Modified Date of existing record could be - Create new record, Loop update it with all new types, then delete it (by script).Unfortunately, Loop must be in the end. Can't return old value, can't run main script(I put 'List of record IDs' in 'Record ID'(to update), it's not quite correct, but

Im trying to write the same formula I have in excel in to Airtable and Airtable erases everything but the first if(and()) statement. IF({Statement} = 1, "3",     IF(AND({Statement2}<=50, {Statement2>0),1),     IF(AND({Statement2}>50, {Statement2}<=100, 1.5)),     IF(AND({Statement2}>100, 2))) I don't get any errors, it just erases everything after that first if-and. Im sure it's something small that Im doing that's causing it not to work but I cannot seem to figure out exactly how to write this in a way that returns the values I need. This entire document is essentially going to be built like this because it relies on data from 3-4 columns. Thanks for your help.

Does anybody have a good workaround for delaying email automations for (example) 10 minutes? Our situation: When a project goes over budget, an email is sent to the project manager But: the email will go immediately, which is a problem, because the project manager might simply be in the process of updating the record, and once he’s finished with his updates, the project might not actually be over budget. Therefore, we are getting tons of false notifications. What’s needed: Some sort of pause before the notification is sent out, where Airtable checks to see if the situation is still true for that record, before sending the notification.

I want to automate the synchronization between two fields in Make and Airtable. I have a “date” field and a “selection” field that contain the same information. I would like the “selection” field to be automatically updated with the same value as soon as the “date” field is filled. How can I achieve this?

I would like to set up an automation to send an email when a condition is met...and I'd like it to run every 2 weeks or every xx weeks or xx months. Is this possible?

Hello, I'm looking for a method to link records with comma seperator like below:Ex: CDA, Fresno Foundation should be linked as CDA, Fresno FoundationBut my current job does the linking separately and creates two distinct linked records as CDA Fresno FoundationIs there a method to accomplish this? Please advise. TIA

Hello everyone,I have a table in which we record events. Some of these events relate to a media campaign that is also recorded in the same table.I have therefore created a column in which you can link a campaign when creating an event. To do this, I use a view in which only the campaigns are displayed.This works without any problems. However, when I assign an event to a campaign, I would like the assigned events to be displayed in the campaign data record.Does anyone have any idea how I can implement this?Currently, only the selected campaign is displayed in the event record, but not the other way around.I would like to be able to click on the campaign record and see all linked events.Does anyone have any ideas on how I can implement this?Thank you very much and best regardsMirko

Why can’t I save a webpage or anything i suppose to an airtable base using the share module on ios? Notion and other similar products allow it

Dear Airtable Community, I’m having an issue with assigning tasks in Jira an assignee from these leads in Airtable. The way my current automations work is every time I assign a status to a specific field, a task in Jira is created, already containing a lot of information from the record, Jira issue’s key is immediately saved back to the lead in Airtable, pretty neat system for us. For some reason I cannot set-up this automation to also assign the issue to a collaborator in Jira, using the collaborator’s name in the “Assignee” column in Airtable. The automation setting only allows me to pick one name, in other words only “Static” value is allowed, not “Dynamic” as with other fields. How can I fix this?

I'm building an automation.If a condition is met, a specific field should be updated with the data from another field. These are date fields. but I always just get an error message

Hello everyone, I hope you can help me with this. I have a table with many records related to Spotify listeners or Instagram followers of various profiles. I usually review and update a lot of data daily. I have created an automation to generate a copy of all records that are modified in the source table and move them to another table so that I can track the evolution, for example, if the monthly listeners of an artist grow or decrease.The problem is that in the destination table, it creates a new line every time there is the slightest modification in any value of the source table. I would need to modify the automation so that, for example, it creates new records in the destination table only once a day, with the lines that have been modified in the source table during the previous 24 hours. This way, I would have in the destination table only one line with the most updated results of everything I have reviewed that day.Of course, if you can think of any other way to keep track of how

Hello, I want to use forms to let people outside my organization link records among my existing tables. I don’t want to let them create new records. Just let them link one field to another. Is there a way to achieve this through forms? I’m having trouble with the primary field being just a string of text. Ideally, someone could select the primary field from a dropdown, and then link whatever they want to to that specific primary field, without creating a new record. Use case example I have a list of companies as my primary field. I want someone to use forms to pick a company and associate it to a topic (currently linked to a Topics table, it basically acts as a multiple select).

Hi. I've not really used forms very much, so please bear with me!I would like to have a form, accessed from a unique form-record-URL, that allows anyone with the link to access only the attachment field in a record, so they can view or download (but not edit or delete) the attachment.Is this something that can be done with forms?Very many thanks.

Not all data records are stored in my table A, so some fields are empty. Now I would like to fill the empty fields using a form. is this possible?Approach: I would have to select the data record or data from the primary field so that the data records to be updated can be assigned correctly. so that the missing data is added when submitting the form.

I want to monitor a specific field in a table called countries that stores comma-separated country codes like “GB, US, ES, SG” etc. If the data in the field changes in some way (i.e. a new territory code appears) then I want to trigger an automation (e.g. send a slack message) but I ideally want that automation to flag exactly what changed (e.g. “TH was added to the country list of record x”). Is that possible with Airtable’s existing functionality? i.e. that you can catch the specific change that triggered the change event? Thanks for any thoughts!

As I'm not entirely confident of the following, grateful if anyone can confirm if my understanding is correct before I upgrade to the Business plan.On the Business Plan:I can share all pages in an interface via a read-only link where users cannot access/duplicate the base dataI can prevent these read-only users from sharing the interfaceI do not have to pay extra for read-only usersNote: In my use case, all users will be airtable users and I'm not considering the public link option as I want to keep the Overview page viewable to my users@Vic_Airtable 

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

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

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

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

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.