Automations

I have a table with a JSON string in a long text field. I want to use the individual values in the Airtable Automation to update a record. I pass the JSON string to the script and want to get it back as an object (like retrieving the body from a webhook) where I can select the individual values. I tried JSON.stringify but that returned just a string. Output.table (noticed in documentation) is not recognized. I have no clue how to format the output function to return the value as an object instead of a string. I want to solve this within Airtable. Any ideas?

I have multiple images in a field. How can i change each attachment name using one click script? The attachment name should be based on {name} field. Thank you for the advice

Hi all. I have a very complex base with a job table and a location data table. I created a separate service report table with a form where i can inspect a room and use a checklist to select all the things which need attention as well as all the things that are done. I tried to make automations to create a job for each selection on the checklist, however i ran out of automations (is that a thing? perhaps i read the message wrong) So instead i made a single automation with conditional actions that would create separate records for each condition (or so i thought) but if one preceding condition on the list is not met, then all the proceeding actions will not be triggered even if their conditions would otherwise be triggered. Am i approaching this wrong? Surely there is a way to branch actions? Or maybe I could make a separate base and sync the jobs across manually?

I have a table that records data for truck checks that our employees perform. One of the fields are linked to another table that hold information of the individual vehicles. I had an automation that would automatically update the mileage of the vehicle selected in the vehicle table with the mileage that was enter on the truck check table. It worked great for a year but is now broken. I cannot figure out how to get it working again. Anyone have any advice as to how to set this up? The configuration is not very intuitive.

Hello Airtable Community I’ve been going around in circles on this problem, and am SO close using an automation, but not quite. Three tables: PLACES - List of places to hire (inventory) BRIEFS - List of briefs (the requirements of the hirer) SELECTION - List of a places linked to a brief i.e. the selection to present to hirer (client portal) The interface for internal use: Page 1: Create a new brief (form) Page 2: Active briefs (record view) The workflow: Ideally, the internal users would be able to add multiple places (linked records) to the Active briefs (record view). And when a place is linked to a brief (places can/will be linked to multiple briefs) a new record is automatically created in the Selection table as a unique record linking the location to the brief. The client portal: I am using the SELECTION table to create a Softr app to present the selection/response to the hirer - looking up details of the place from PLACES. The hirer can only see selections relevant to them (t

Okey… i get two table… in the first table when user login in the app, create a record with email. when it creates a record in the first table, I want it to create it in the second one, but if the email is repeated in the first one I don’t want it to be created again in the second one, for example: Table 1 ---------Table 2 hello@gmail ----hello@gmail bye@gmail ----bye@gmail one@gmail ----- one@gmail hello@gmail … “no create record” … two@gmail ------ two@gmail thx!!!

I’m trying to create a authentification for my application https://docs.bravostudio.app/integrations/user-authentication/authentication-with-custom-backend When i make the second step “Creating the API collection and requests” I did all thing but when i test the good values i can’t connect with because i’m not authorized, i give you the screens See the tutorial with the link to understand more and help me if you can it’s really important for me Célian

I am getting a 503 response from Mailchimp API when making a simple GET request. The same request from Postman works. Any ideas why we get a 503? Thanks!

I need a timestamp when a certain option is added from a multiselect list. I can’t use the “Last time modified” timestamp, because I don’t want the timestamp to change if other options are later selected from the multi select. I have created a view for records to filter into as soon as the specific option is added from the multi select list, but I am still having trouble time stamping the day the record moved into that view, and never have it change.

Hello! I built a form where several fields are long text with rich text formatting enabled. When the form is filled out, I have an automation set up where the contents of the form are sent as a slack message. Right now, I have an issue where the form will have hyperlinked text, but the automated slack message shows the markdown syntax for the hyperlink and not the hyperlink itself. Is there any way to fix this? This is the slack message I have set up: The Hyperlink at the end “Here is the running list […]” works. It is the hyperlinks in the tokens that are breaking to look like: [Link text Here](https:/ /link-url-here. org)

I have the following forumla Email address: " & Email & " blah blah blah. If ends up looking correct in the forumlas field However when I grab that field and use it in an automation, it adds a \ to the start of the email. I feel like this is a tricky markdown thing, but can’t figure out how to ignore it. In truth I am actually happy for the email to not show up as a link. Any ideas?

I have a google sheet that has blank cells. When I try and run an automation to create a new record when there is a new row in the google sheet the automation stops at the blank cells. Here is an example of the google sheets row in question. The row is generated from a form that branches so the blank cells are a must. Is there a way to run this automation?

Hi Airtablers I am trying to create/automate a weekly report (or record) that contains summaries from other tables. So for example, I have a ‘Daily Report’ table, that contains a column with a %. I’d like to create a record in my ‘Weekly Report’ table, on a Saturday, that automatically sums all the columns from the previous 5 days. It’s not a problem to do this on the outset, but what is a problem is having the Weekly table use a fixed date to sum the past 5 days. I can’t figure out how to specify that the sum should only be from say Monday 1st to Friday 5th in the weekly report, and the week after that should automatically sum from say Monday 8th to Friday 15th, if that makes sense? So like this: Week 1 report created automatically on 6th that contains sum of Daily Reports from 1st - 5th Week 2 report created automatically on 13th that contains sum of Daily Reports from 8th - 12th Week 3 report created automatically on 20th that contains sum of Daily Reports from 15th - 19th …etc

I am trying to figure out a way to trigger an action when a specific status record is updated. For example, when a person is moved to a "Pre-Qualified’ status, then trigger an action to send an email. Is this possible? I don’t need just a status record update, but a specific status record update. Thanks!

Is there a script or automation I could use - if due date is saturday or sunday, change due date to friday before? Thanks!

Hi all, I have an error when I reproduce this example: Airtable Scripting let record = await input.recordAsync(‘Select a record to use’, table); Throw this error: TypeError: input.recordAsync is not a function Does anyone have an idea of what I need to change? Thanks, Arthur

Trying to setup automation when an actual date gets recorded in a field, if it is different than our planned release then it would update the planned release date field. Once it does this, I would like it to send a slack message to team managers for reference/visibility. However the moment someone starts to type a date in the field, the automation kicks in with first key stroke and results in wrong date being captured and slack message sent prematurely. See attached example. I have tried triggering on date field change, i tried when enters view, I tried when a formula field changes. All of them result in same issue. The only way to get it to work is if the user uses the date picker which is seldom used.

Dear all is possible add formula to the trigger. See image sample. Thank you for you support.

Hi All, I am new to the airtable and Airtable Automations. I have a table with a column ‘Filled Date’. I wanted to schedule an automation to happen every night to delete the records with a date that is 60 days prior to today. I don’t know if am doing it wrong, but I tried to filter the rows using below code, but it’s filtering entire records: var today = new Date(); const table = base.getTable(“Table1”); const query = await table.selectRecordsAsync({ fields: [“Filled Date”] }); const todelete = query.records.filter(rec => Math.ceil(Math.abs(today.getTime() - new Date(rec.getCellValue(“Filled Date”)).getTime()/ (1000 * 60 * 60 * 24))) > 60); console.log(todelete); Can anyone help me on this. Any advise is much appreciated. Thank you.

I’d like to trigger an AT automation with a webhook (when webhook received). I want to trigger to this webhook from within a MAKE scenario… I don’t even want to send data… just trigger the AT automation at a certain step in my MAKE scenario. How can I do this? Webhook modules in MAKE don’t fit the bill… any workarounds? (API call or otherwise?) Thanks

Hi, I’m trying to use the script to automate the emails in my database. I’m pretty new in airtable, so I’m trying to figure it out. This is a fake example of my database: I want to create a code that sends emails only to people that have the status “To send,” and I would like, for example, Sara will receive 2 emails: Report C common email with Suzi (The email should have both emails as “To”) Report A I know how to send a common email to everyone, but I would like that everyone will have a personalized email. First of all, is it possible to do it? I’m not sure about it. Secondly, Can someone help me, or give me any clues or resources to look at? Thank you :slightly_smiling_face:

Sorry, this is quite a convoluted ask and I understand it may be too complex for a simple response. Context: We have a community of 60 individuals recorded in an airtable. We run a limited dinner series to allow them to network with as many people as possible in as few instances (say 4 - 6 only). We manually generate groups of five persons for each dinner using various criteria such as persona, interest, gender, etc. In some instances, we wish to increase the chances of similar profiles meet. In others, we want to decrease chances. Ask: Is there a way to use automation or script in Airtable to automate this group generation? We would also like to ensure it creates a value in response to “have these individuals been grouped before” so we can increase or decrease that criteria.

Hello- Does anyone have a an automations solution with this one? Trying to add in a Adobe URL and have it automatically convert to a PDF in another attachment field using an automation. I did try it out and this was the message I got: JavaScript is required to run Acrobat online services I tried with a Airtable URL and it works fine, I am not savy with Java/Scripting at all. Thanks!

I need to send fields from one table to another (in another base)… I want to add ONLY those that donlt exist yet, i.e avoid duplicates. I need to do this automatically as a required step in a MAKE workflow. This is what I’ve been trying (and am stuck) Data flows from Table A to Table B. For TableB, I create a view with only the records that haven’t gone through this process, so I do not repeat the search over teh full table everytime On this view, I run a SEARCH RECORDS module in MAKE. The output is a series of bundles. I need to extrat only the one fied of interest from all output bundles and put them in an array. So then I can iterate over this array with another SEARCH RECORDS to check one by one if they exist or not in destination table… then I add a record with all resulting entries which do not already exist. This seems way too convoluted, but I’m struggling to figure out a more direct way to do it… Surely there is a better way. I mean, it’s fairly simple: “from within MAKE, copy