Automations

Is it possible where we send a slack automation with button that when you press that button, it updates a specific column on slack?

I have been requested to implement a feedback system for a local business which has several store locations, I want to investigate if a no-code solution with Airtable could do it, possibly using also other platforms linked to it.The "system" should be able to:Have a Form to collect User's personal data (the sign-up to our system), with a prefilled field (which is the specific store name, which is linked to a hidden Store UID <store_uid>) and assign a User UID to that person.Automate sending a "welcome email" with their User UIDCreate Feedback Forms, and on creation:Create an entry in a database for each User UID with 2 flags set to `false`: <collected> and <completed>.Send to all the Users an email with a form with only 1 text field which when filled with the <store_uid> linked to that User in the database, when submitted will set the <collected> flag to `true`.X days later (7 days) send an email with a link to the new Feedback Form to the Users that

Hello I'd like to askso I have 2 different tables1. [User Accounts]2. [Profiles]how to pull data from column (User Role) with value "Job Seeker" only. which is in the table [User Account]and I want the Primary Column [Profile] table to be taken from the Full Name in the [User Account] tablebut only based on User Role = Jobseeker onlyand hope that the avatar column can also be obtained from the [User Account] table

I've created a simple automation that uses a Gmail account to send out an email. The triggering and the sending work beautifully.The text of the email (as I've entered it into the Automations field for this) includes a personalized URL pulled from the individual record. The URL is a link to an Airtable form that has been *prefilled* for this particular recipient. The problem is that the link comes through very ugly. https://capture.dropbox.com/sWYpsxZqITvdfrRHAt first I thought the link was broken, but it appears that it's not. It's clickable. But it's ugly as sin, and I have some non-tech-savvy recipients of this email who may find that link kind of scary.I tried to format the link like a normal HTML link.  <a href="https://etc">Click here for something wonderful!</a>  And I tried using Markdown as well.  But neither seems to work.

I'm having troubles with "When record matches conditions". I have 2 states which trigger the automation, but if my record is on the first state and I changed it to the second state the automation doesn't run. I'm pretty sure that this has worked to me before because I have used it several times, so if this is going to change for ever it will cause a lot of problems with my databases 😞Anyone else has happened? Please, I need help!

Hi everyone, very simple use case here: When sending weekly or even daily digests - it is nice to have the date or time in the subject of the email! We can do this by using the trigger date from step 1. However the formatting is a bit gross. Is it possible to format this date and time so it shows up as friendly or even use a date format formula within the automations ‘send email’ subject line or body?

I've been testing out Airtable before going into full use at our company and while we are planning to more to Pro, the automations suddenly stopped working even though according to pricing plans there should be no limit that impacts us.An example of an automation that suddenly stopped working is one that auto-fills an order status for a new order when it is created. It checks the status field and if it is empty, it fills the field with a default value (Not started).Suddenly one day the automation stopped working even though there has been no changes to the automation or the table it relates to.When testing the automation everything works, but in Run history it says evaluating the condition failed. I've noticed that Airtable has updated the Automation form - previously there was a section for actions and a separate track for conditional actions. Has this broken all the automations?    

I am working on creating an automated email.  I want the email to go out when a user updates a record.  The email should read the following:[user] has updated [task][status]...etc.  How do I set it up so the user populates in the email?

Hi all,I have multiple tables with the same format and layout which ultimately I would like to combined them into one table. I would like each table to have a field noting the entity name so that when they are all combined into one, there will be an additional column identifying the name of the entity. Is there an auto-populate function where i can auto-populate a field with the table name or do i have to add field manually?Cheers,

I have some 'Time-Sheets' that need to be verified once they are inputted (the record is created). I would then like the record "printed" (sent via email) via the "Page Designer" extension for verification. Is it possible for this to be done? Either using a different extension or a script to be used with Automations?

Assuming a trigger is met, and I have at least 2 actions in the automation...What happens if the first action fails?A> Does the automation exit?B> Or does it also try the next action?If B, is there any way to use "previous action" success as an input into conditional actions?I want to make sure an automation doesn't do step B if step A fails.

Is there a way to set up an automation so that the current date is recorded when a specific status is met. For example, When a project's "status" is changed from incomplete to complete, a date column would automatically fill with that day's date?

If "approved" is chosen manually in the status column, I'd like the "Approved" check box to be automatically checked. If "Contract Signed" is manually chosen, I'd like the "Contract Signed" box to be automatically checked, and so on and so forth. I know I can use the "IF" function, but I'm not familiar with code and not 100% sure how to make it work for this use case.Additionally, would it be possible to make this happen in reverse as well? So if the "Approved" check box is clicked, "Approved" will show up in the "Status" column? Thanks,   

Hi - I'm trying to make an automation that moves the information from one record to a new table, when the status of an application is changed to 'successful' - so the applicant will join a successful applicants table.

Hi all! New user here, trying to set up automations and failing miserably. Let's just say i have two columns: "Check" and "Status" that are both multiple-select:I'm trying to set up an automation that, when I change "Check" to approved, "Status" automatically changes to done. So i put "When a record matches condition: If Check is exactly Approved" --- " Update record: Status" and this final updating record part just fails.Please help me, i'm trying a hundred different ways of doing this and nothing works, it looks so simples but it isn't 😞

I can’t work this out: I would like to create a record in a existing view, populate the record fields (including adding an attachment), but hide this record until a scheduled time, when it would then become visible in the view. Is this possible? How? Appreciate the help.

Hey there - script writing newbie here. Anyone know why this is returning "Unnmed record" in my summary? The primary field definitely is not blank. It's a single line text field, some of which are a bit longer, with 20 words.Appreciate the help!

I have a script that runs without any errors but doesn't actually do anything. However, if I go to Test Automation and select a record to test, then run it, it works (almost) as expected. Therefore pretty confused what's going wrong. Image files are automatically downloaded from our server into the mockUpFiles field within a table. File names are like this 63eb679887a459_13030203recqKJDnAJSRJOsSL.jpeg. The script should use title + "_" + designTypeName + "_" + channel to change the filename to something which allows me to identify the contents. Can anyone help tweak this code to make it change the file name as soon as a record is created (Trigger is obviously set to run when a record is created)? const imageAttachment = base.getTable("Pre Mock Prod (PB)"); const recordid = input.config()["recordid"]; const recordToUpdate = await imageAttachment.selectRecordAsync(recordid); let title = recordToUpdate?.getCellValue("mockup_id"); let designType = recordToUpdate?.getCellV

I am working on an offboarding workflow to use when an employee is termed and leaves the company. I made a form that is the start of the process. Once a record is created from a submitted form the automation will send out an email to the terminated user and five staff members that all have tasks to complete. Looking for a way that the staff members can reply to the email they receive, and the reply update the airtable base. See what I have currently in the pic below.Ideally, I would like to have a single select field that the user could pick an answer from and then email it back to to airtable to update the base. As a workaround, I am buiding single select fields in the table and making an interface that I can link to in the email. The interface will contain only the relevant questions for that user.

So I found no way to get the total record count when I am in Gallery view. I would especially like to get the count once I have applied any filter.In the "Full View" the status bar at the bottom does show total count. It also updates when a filter is applied. I would want a similar way to get the count but in Gallery view. The Full view have an additional nice way to get count when Grouping is applied. But in the Gallery view we can't even apply any grouping.Any solution welcome, even if it needs Scripting.

Hello everyone,I hope someone can help me with a scripting problem I'm having.  I am a beginner with scripting and have been taking from examples of what others have posted to get this far.  I'd like to have the script find all records in the Enrollment table that match the input variable Students, then update the "SEB Goals 2" field (linked record) with the Goal input variable without replacing the Goal(s) that are in the field already.  This script could update more than one record but would probably never go beyond 3 or 4 records.  I think the problems are in line 23 but am not sure how to fix it.  The code as is did run, but it didn't add a record to the field.  It seems to have deleted everything in the field.  Any help would be appreciated! 

Airtable is wonderfully optimized for internal user teams. We are trying to build a simple app for external users.We want to enable external users to enter data into a series of linked tables as part of their signup process, with the ID created for them in the initial table used to follow them through the other forms as they move through the linked tables entering data. Basically, if a form could hand off an external user to another form with the ID prefilled dynamically for each subsequent form in the string. This ID is the relational field in all tables.We know how to use trigger actions to update tables, but we want to have a separate form for each table, with their identity established in the first table moving with them from form to form in a single session.

I have a table in which images are automatically uploaded from our server (see screenshot). These image files are then sent to s3 for further manipulation and need a more meaningful filename. I tried to follow this video https://www.youtube.com/watch?v=qUPQoXQQATc which I feel is almost working but I have some errors which I can't figure out. This is my code so far:const imageAttachment = base.getTable("Pre Mock Prod (PB)");const recordid = input.config()["recordid"];const recordToUpdate = await imageAttachment.selectRecordAsync(recordid)let title = recordToUpdate?.getCellValue("mockup_id")let imageField = recordToUpdate?.getCellValue("mockUpFiles")let newImageField = []if (imageField){for ( let [image, imageNumber] of imageField.entries()){console.log(image, imageNumber); let findExtension = image.filename.match(/\w+_\d+\.\w+$/)||[""]let extension = findExtension[0]console.log(extension);let fileSpecifcName = imageNumber>0 ? "-" + (imageNumber) : ""newImageField.push

I have an automation that handles bulk uploaded PDF-files, with logic that extracts an ID-number and date from the filename. It then copies the attachment to a record with matching ID in another table. It also checks a checkbox on the original record of the uploaded PDF to mark it as complete and avoid multiple runs.The automation runs fine, with just one weird "bug": The filename of the copied attachment changes to a random string "XxxxXxxxXXXx". However, if I now delete the copied attachment and go back to the uploaded file record and uncheck the "completed" checkbox to trigger the automation again, the file is copied with its original filename kept!I suspect the reason is related to the automation starting to work before the file has been fully processed by Airtable, and some kind of temporary name is used. But this is also contradicted by the fact that the automation relies on data from the filename to be extracted before it can run...My first idea was to add a delay to the automat

I'm not sure how I can delimit a "Find Records" to update multiple records all at once.I know when it plugs them in as a list, it's trying to do "A,B,C" and obviously airtable isn't getting a match on the ID because of the string of text.Does anyone have a script I can modify to break that out so my Find Records can input a single value, into multiple records at once?Thank you!