Automations

Someone is sharing an Airtable with me, not my account, "use this data" available..How can I sync this data to either another table I own or via Zapier to trigger a zap?Or do i need to request they share the table with me another way?Figured someone here would know....

Hello,This is a variant on an earlier topic. I have a base where users input lengthy URLs into several fields, and corresponding display text in separate fields. I've been using the workaround where a formula field does this calculation: CONCATENATE("[",{name},"](",{URL},")") and an automation takes that field and copies it into a rich-text-formatted long text field. It's clunky, and even clunkier when you have a bunch of markdown formula fields in your base. I'd like to do this with just an automation, but when I try to do it exactly the same way, I get text output like  [Airtable](www.airtable.com)whereas my formula approach gives Airtable  Here's the automation script I'm using. Any advice is greatly appreciated!  let inputConfig = input.config(); let theURL = inputConfig.theURL; let displayName = inputConfig.website; let recordID = inputConfig.recordID; let thisTable = base.getTable('Table 1'); let blank=""; let markup = blank.concat("[", d

I am attempting to update multiple records in a single automation in a Synced Table. I am unable to update Synced Records from RunScript as I get 'Error: Edits to synced field "Stories Automation" (fldxxxxxx) are not allowed from this origin'.I know I can use the native update record functions to update a single record, but if I put the items into a list attempt to repeat group I am given the error `Synced fields can only be updated in the last action in an automation. Move this action to the end of the automation, or remove the synced field.`What are the options? I'm considering just using an API call to make the changes directly to the original table but am hoping I can do them locally. 

Hello,I am trying to trigger a script when 'Language' field of given record is empty (record=domain).I want the script to fetch domain's language. I first ask script to convert domain to URL, since the API call works best with exact URL and not domain.But the problem is that script can not properly handle permanent redirects. I 've tried handle permanent redirects by trying to convert the domain to a URL using 'https://www' + domainId + '/', but that does not work. I am getting this error: "Error processing https://viberate.com/: Response status was 301 'Moved Permanently' but redirect mode was set to 'error'" How do I solve this?My script: // Get input variables from previous automation steps let inputConfig = input.config(); let airtableRecordId = inputConfig.AirtableRecordID; let domainId = inputConfig.DomainID; // Set up the table let table = base.getTable('Master Draft'); // Convert domain ID to URL let url = 'https://' + domainId + '/'; const apiKey = '123456789

Hello!Hello!I am new to Airtable and Make.com… have tried to make 2 steps work for a month and it has not been working…THE GOAL: What I am trying to do is to extract the transcript from a video file, so after I can produce a written article, a title for the article and the video, and a description for Mr. YouTube.ERROR: Use Column ID: False or 403STEPS: (STEP 1: connecting with Webhook => OK). STEP 2: Getting a record from Airtable and put it into make to transfer the info into Google Drive (video transcript).Problem in STEP 2I have checked the names and IDs and I don’t know what I am missing. My administrator did the same operation and it showed the “Use Column ID: false”, but we didn’t have any problems or errors until now. I have re-written all the code, redone the tables and the whole process. Have updated all my permissions and the token on Airtable. I have 1 test record.ID formula: RECORD_ID()            @ScottWorld @Olpy_Acaflo What can I do to solve this issue

Hi, is there anyway I can test the automation I make in Airtable locally?I am trying to hit my development server and to check/test if there is problem before I deploy the changes to another environment.I tried to use my exposed public IP,  and when I tried to test the automation, it shows this error "TypeError: Requests to '192.168.100.16' are not permitted".Is there anyway to test the automation functionality locally? 

Hello all! I am looking for a way to add images to calendar event automations. Right now we are using outlook’s native calendar application to send out invites to clients and attaching an image of a map to help point them to where they should head during their scheduled appointment. But i figure if we have an automation that can send these invites out at the push of a button, it would save a ton of time. We are already capturing all the information we need to send out these invites in airtable, and all of those translate into the calendar event automation, but we can’t figure out how to include the map images. We tried an tag, but that doesn’t work. What would be the best way to go about it? Can an image be added inline with an calendar event?

Hi! I'm new to Airtable and am very stuck here trying to achieve counting a number of records and showing it in a different table.The columns I want to count are: "Plege1", "Pledge2" and "Pledge3" in "Table1", count the number of "True" entry of all three columns, sum up and record the number in "Table2".I was able to create a formula to count the number of "True" entry for each record, but I can't think of a way to show the sum of all records in "Table2". Could someone help with this? Any suggestion is very much appreciated. Thank you!  

Hello, I’m trying to find the best way to have reports with attachments (photos) automatically post to our team Slack channel upon submission. Basically, I have set up a form that my team can complete that allows for an attachment (photo) upload. After submission I have the automations set up to post to Slack. Everything works except the image will normally have “file not found.” I have the URL set to forward to Slack. Any ideas? Thanks in advance!

We have created a CSV file and try to make automation.How to bring feedback by a product list as automation report and bring a dashboard into live?Are there any examples of dashboards or it should be manually calculate feedback Analysis?An example: Microsoft Power BISource: https://help.usersnap.com/v10.1/docs/feedback-analysis

The question is the following:If we receive predicted emails inside a folder within our email account.How to manage automatic clicks as it is time-consuming to click manually?The link is called all the time Always with the same name: Verify Request

Hi, there!! I need an automation to do exactly what the subject of the topic says. We’ll fill the e-mail field in Table 2 from a csv import. Then we need the automation to lookup that email on Table 1, get the Name value corresponding and then fill the field Aluno in table 2. I found a script in another post that I adapted to what I need but I’m still learning to code so I need help to fix my script. Can anyone pleeeease give me a help? About the script: I added 2 variables - tho I don’t actually need record ID - but I followed the instructions on the other post. Variable 1 is recordID and the value is Airtable record ID Variable 2 is email and the value is email Both variables are being pulled from Table 2 let config = input.config(); let table1 = base.getTable("Base de Alunos"); let table2 = base.getTable("Entregas Plataforma"); let query = await table1.selectRecordsAsync({fields: table1.fields}); let found = query.records.filter(record => record.getCellValueAsString("Nome") == c

I want to set a Date field to the current date time in an automation. I tried using a formula field (with NOW()) from a previous step in the automation to set this Date field but the automation fails with the error;Field "Date" cannot accept the provided value: Could not convert string to date.No amount of formatting of the formula field is helping. 

I am setting up some automation alerts for records that have incomplete information.I would like to trigger an automation if a new record is created to highlight any records that haven't been correctly filled in.Of course, the newly created record won't have had all the data filled in.I am getting a bit stuck trying to "find records" with a "when record is created" trigger that excludes the record being created.Does anyone have any suggestions?

Show me how to make an automation to move a record, its fields and comments from one Airtable base to another Airtable base when it enters a view.

Hi,I am using the "when a new email is received" from outlook email on Airtable automation to collect the information about the email I receive.However, it is not directly possible to get the attachment (is it coming soon?).I have seen some discussion about using Zapier, but Zapier is very expensive. Make is also a solution, but unfortunately the "Trigger module" Outlook email from Make is not "instant", it means it doesn't trigger everytime an email is received but we have to set up an interval for it to run....Not the most convenient (also does it create problems if then more than 1 new email is detected an imported?). So my question is, do you have any other way? Thank you, Have a nice day, Arthur     

Hi everybody, I am trying to set up a specific automation. I have set up already the importation of emails in Airtable, in the table "my emails". It looks like this :Now, I would like to automate the following steps : - check if in table "Contacts", there is in the field "email" the same address email than in the field "email" from the table "my emails".- if YES, then, in "my emails" in the linked field "Contact", link the existing contact with the same email address.- if NO, then create a new record in the table "Contacts" with all the information of the new contact. Basically the idea is simple : if the email comes from a know person, link the email to the person, if it comes from a new person, create a contact for this person.  Thank you so much,  Have a nice day,  Arthur

I have two tables Tenants and Property so i am creating a new record in a 3rd table called interaction where condition is The tenant's move-in date should not be more than one month later than the property's availability date.How to do this ?

Hey guys,I have noticed an issue recently where "Find Records" from a view is not pulling all records from said view, it's only pulling the first 10. I have maximum record limit set to 1000. The view is definitely pulling more records then that. Anyone else having this bug? And does anyone know a fix?Thanks.

I am trying  to connect Google API to access Google Drive and Google Docs inside Airtable automation script.I setup a project with credentials and redirect URI on Google Cloud console and I am able to successfully get authorize code and access token.However I realized that access token might not work in case automation as it expires after 1 hour and I will need refresh token to refresh the access token after it is expired.So i am trying to change my code where I am storing the refresh token, access token and expiry time in a table on Airtable Base. But I seems to have issues while updating records on this table using Airtable Automation Run script Block.I will send my Code at the end of this write up. The problem is highlighted below -In the code search for following comment "// Check if the access token is expired and refresh it if necessary"Next block to that you will find the line having the issue.  Here is o

As ever, something that I think should he simple is proving anything but.I have a table with 4 simple fields:MakeModelLineExists ?DellLatitude2243 HPProbookM123 DellOptiplexC132 I have another table with similar Make, Model, Line fieldsI would like to change the value of Exists in the first table to 'True' if there is a record in the second table that has a matching Make/Model/Line combination.I created an automation that works (sort of) in testing mode. It actually saves one of the values in to the Exists? field as I haven't worked out how to make it say 'True'.But I can't work out how to run the automation on demand. I have tried having a checkbox field in the first table and watching that field, but that doesn't seem to trigger the automation. I would ideally have a button field on each record - sort of 'Check this' - or a button that would check all the fields in the first table.How should I attack this ?

Hi I am a total newbie to airtable so I hope you can bear with me. I am wondering if I could share a link externally with lots of different people without airtable account? This would somehow need to be done through automation because I cannot create all of these different group links as there will be too many. Background: I have data with results of a animal rescue drone search and I need to communicate the progress and results of our searches with the owners of the field. We put this information into a google sheets file. So I need to be able to share the results for one farmer (with multiple fields in spreadsheet rows) via external link. But the farmers should not see each others field but just their own.Could someone help me if I can somehow do this with airtable?Many thanks in advanceJanine

We are using Airtable to track receipts. The current setup is a Receipts tab, where employees can fill out a form to submit their receipts. The Staff tab, is where the list of staff names are that the staff choose from when filling out the form that goes to the Receipts Tab. Then I have a 3rd tab for Reconciliation Month that the Finance Manager can apply onto the Receipts tab when they do the final approval of the receipts. The workflow is that an employee will fill out the form when they have a receipt. Then once a month the finance manager will go in and review confirm which month the receipt applies to so that it will group together.I am trying to get it setup to do an automation that sends the receipts to the finance manager by staff person by month. I am able to do the email that pulls all the receipts together for that month, but can't figure out how to break it down by person. The staff tab has a lookup of receipts by person, but it is pulling all the receipts. I

I tried to create an Automated email, and I don't know how to create a date time format nor rounding number.1. I created new fields with DateTime_Format, but when I put it in the email, nothing appear.2. I also round number in the number field and it won't round numbers in the email

I run an appointment system on Airtable and am looking to send reminders a few hours ahead of upcoming meetings.For example, a meeting is scheduled for 2pm on June 24th, therefore by 12pm on June 24th, I'd like a reminder email sent out.Which Automation Trigger would I need to use to do this? And what would the steps be? Possible solution: could I convert the time into minutes and then set up the formula such that once it hits X number of minutes before the start time, it meets "record conditions" (determined in Automations) which then leads to the automation being triggered?Thanks in advance for your help! ps I'm not interested in using external tools like Make or Zapier as we're a non-profit with limited funds - they just about stretch to Airtable.