Solved

Help!I can't get the automation below to change the status of our EE to moved out. I keep getting receive invalid inputs. Basically I want it to be when the lease end date is today or past and EE status is not canceled then it will change the EE status to moved out. Thank you!

Invoke-WebRequest -Uri "https://api.airtable.com/v0/{baseId}/{tableIdOrName}?maxRecords=3&view=Grid%20view" -Headers @{"Authorization"="Bearer YOUR_SECRET_API_TOKEN"} Error Message in Windows Power ShellInvoke-WebRequest : {"error":{"type":"INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message":"Invalid permissions, or therequested model was not found. Check that both your user and your token have the required permissions, and that themodel names and/or ids are correct."}}At line:1 char:1+ Invoke-WebRequest -Uri "https://api.airtable.com/v0/{baseId} ...+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-WebRequest], WebException+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommandI tried using curl command also, curl "https://api.airtable.com/v0/{baseId}/{tableIdOrName}?maxRecords=3&view=Grid%20view" -H "Authorizat

Hello! I'm running into an issue when using "Find Records" with Conditional Logic automations. In past, I thought I could use Conditional Logic automations to update each record in a list of records but now it seems those automations won't run unless the automation is set up as "Run as a List".  However, there's not currently an option to use both Conditional Logic automations and Run the automation through a list.  Is there any other way around this issue other than writing a custom script? I'm glad there are custom script options, but I came to Airtable for the no-code, so I haven't had time to take a course on Javascript yet... 🙂 Any help is appreciated! 

I've tried this several times and nothing I do seems to work. I'm trying to wrap this formula in an IF(ISERROR( so that if there is an error it stays blank and I can't get it to work. I'm working with a formula field that sometimes displays text and sometimes a date. if it's a date, it should be used in the formula to give me the new date and if it's text, I just want the new field to remain blank.  IF( AND( {PAY2 TV From}="PAY1", {PAY1 Formula/Manual} ), DATETIME_FORMAT(DATEADD({PAY1 Formula/Manual},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"), IF( AND( {LTR}, {PAY2 TV From}="LTR" ), DATETIME_FORMAT(DATEADD({LTR},{PAY2 TV Amount},{PAY2 TV Time Frame}),"LL"), "" ) ) 

Hey everyone, have a question about a formula I can't get working correctly.I only have a date field (Date) and a formula field, with the formula Date=TODAY()The formula returns a 1 for today and 0 if it's another date. So far so good.What I want is if there is no date that is today, I want it to return 1 for tomorrow and 0 for the rest of the dates until a Today date turns up again.Is this possible?Its just for a simple API filtering that shows what rows to read from.

I am trying to track a weekly trend by capturing the $ value in our pipeline at the end of each week and have it populate into another table. I have a "Projects" table, a "Sales Team" table, and a "Reports" table. Projects are assigned (linked) to someone from the "Sales Team" table. I am using the roll-up field in "Sales Team" to roll up the $ amount they have in their pipeline. I also have a Pipeline target field and field that calculates their percent to target. It would be nice to be able to  pull all of the data, but I am mainly focused on getting their Name, their branch/Office Location (Single Select Field), their current pipeline, and their pipeline target into Table two. I planned to set up an automation that is set to trigger every Friday at 4pm that will pull the current data at that given time. I need to make sure when the next week comes around and it triggers again, it doesn't update the records from the precious week but only adds new records with the current data a

Hi, Need help to edit a script I found on "Extensions" by Mike Pechter  called "Gantt auto set dates". The script was set to calculate duration in weeks. However, my team is hoping to calculate duration in days instead of weeks.Could anyone help? There is no way I can upload a .docx of the script though. So I posted the script as a reply below.Thanks.

I am going cross eyed trying to figure out the correct formula for getting a % field to show up in an automated email as a whole number %. Either rounded up or down. I have tried so many and it still is not pulling correctly. I have tried round up, ceiling and a few other but they never carry over correctly.  

Hey All,I maintain a fork of one of the R packages for manipulating data in Airtable and have run into some issues while trying to create a function that uses POST to handle extremely long queries or queries with more than 22 fields and the offset values to retrieve a table with more than 100 records. See package here: https://github.com/ecohealthalliance/airtabler/tree/masterThe function in question is this one: https://github.com/ecohealthalliance/airtabler/blob/master/R/air_post.RWhen using POST, the  offset param seems to have no effect. The offset ID changes with each request. So if i have 600 records, the first offset id is "itr72y1g3QhvFAKE1/rec9RPMSRlQrWVyum", then the second is l ""itr72y1g3QhvFAKE2/rec9RPMSRlQrWVyum" etc. Only the Offset ID (the bit that starts with `itr`) changes, not the record. By contrast, with GET requests, only the record ID changes.here is an example of the body of a post request:  { "offset": ["itr72y1g3QhvYZw5Y/rec9

Hello,I have 3 tables Beijing, Shanghai and General in the same base. I want to auto copy/paste records from the first two to Table General when any records input in them. I created 2 automations with same triggers when a record enters a view and same actions to create record in Table General for Table Beijing and Shanghai respectively. I have 2 questions.Question 1 - Automation BJ ran well but empty lines created without any data appearing. Input 2 lines of data in Table Beijing,Automation BJ ran successfully (the first two at 10:21 and 10:22).Line 3 and 4 were created but without any record in Table General.Question 2 - Automations SH didn't run at all.Input records in line 5 in Table Shanghai.The automation didn't run at all even though it tested well.  I did delete the automations and recreated new ones from scratch but they didn't work.Can anyone help? Thanks

I have 2 tables: “Home Staging Projects” and “Inventory Items”. In the “Home Staging Projects” table, I want to vlookup on the “Project ID” and return the sum total of “Rental Price” for each inventory item selected for that project listed on the “Inventory Items” table. I hope that makes sense.I’m not sure if this makes a difference, but the “Inventory Items” table is linked to the “Home Staging Projects” table by (formula) “Project ID”.Is there a way to use a formula for this?

Hi,I try to set a link within the same command, that created a new record. The createRecordAsync command works as long as I set all other attributes, except the one with a link (the red line). As soon as I add the red part, I get the error message - see screenshot. Can anyone help me please with that? let newrecord_miete = await table_tacs.createRecordAsync({                     "TAC_Date": per_positive_tac.getCellValue("TAC_Date"),                    "Bank Account": per_positive_tac.getCellValue("Bank Account"),                    "TAC_Amount": active_bruttomiete,            &n

I have written the script below to select records from one table in my base and insert them as new records in a second table.  The script is working, however it times out after running for 30 seconds.  The process is selecting and creating about 200 records.   Is there a more efficient way of writing this script so that it happens faster and doesn't hit the 30 second limit?   I've read that maybe i need to create an array so that multiple records are inserted at once, but I am brand new to scripting and not sure how to achieve this.Any updates / changes / suggestions would be most welcome!Thanks    //Script Purpose: //1. Select fields "Client" and "Client Family" from all records in the table "Client Master" //2. Using these values, create new records in the table "Bank Recs" //Define source table let table = base.getTable("Client Master"); //define fields to retrieve const fldClient = table.getField("Client") const fldClientFami

I tried using interface designer and it is a very cool feature. One thing I would suggest to have is a sharing the interface like a view. For example, I would like to share particular interface in read only mode and do not want the user to be able to go and see all contents of the base. Currently, if I give read-only permissions the user can go and see all tables in the base.

I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0. UPPER({PostCode}) will make them upper caseREPLACE({PostCode},4,0," ") will put the space in the middleHow can I do both of these steps in one formula field?

HI, I have the following problem - pls see also the screenshot enclosed for deeper explanation.I set per script a link in a multi-link enabled cell/coloumn. This works fine:await table_tacs.updateRecordAsync(per_positive_tac, {[nameReplacedBy]: [{id: newrecord_miete}]}); I then want to add in the same cell a second link, i.e. attach a second link. I try to do this with this command:await table_tacs.updateRecordAsync(per_positive_tac, {[nameReplacedBy]: [per_positive_tac.getCellValue(nameReplacedBy),{id: newrecord_BK }]});But this throws an error (see screenshot) - I tried various ways, but none works; Any help from the community? If there is a better way to get the topic solved - also fine: the objective is just toset the 2 links to "newrecord_miete" and to "newrecord_BK " in one cell, which is column "nameReplacedBy" of the record "per_positive_tac"Thank you!, Chris  

Hi, I need an attendance tracker for a nonprofit organization that organizes different activities throughout the year. I first tried doing a form that our coordinators of each activity would use to report the activity, time, description/impact, and attendance. The attendance is linked to a table that compiles the beneficiaries of the different activities that are run by the Non-profit. We already have some beneficiaries or previous participants in this table and so some of the attendees are already in our records, but when we have new attendees, I would like to be able to generate a new record from a form. I am able to add a new record in the grid view, but not in the Form. I have already tried doing an interface and it still won't give me the option to add new records in both form or interface. I do have a plus plan (not the free version).Our objective is to be able to have a beneficiary registry or a complete list of beneficiaries to report to our donors every year. We

Hello Airtable Community!I am trying to build something and I am STUMPED. Hoping someone can help! CONTEXT: I run a coaching business that services multiple clients. I am trying to build a tracker that tracks the number of coaching sessions that are booked each month.I would like to track (1) total number of monthly sessions across all clients and (2) the total number monthly sessions for each client. Clients can book up to 3 sessions.Currently, I am only doing (1) total number of monthly sessions across all clients. I have a table that records each booked session and links it to the month that it was booked in. The linked record then uses a count field to sum up the number of Session #1s, Session #2s, and Session #3s. Lastly, I use a formula field to sum up the total number of All Sessions (#1 + #2 + #3) to get a total of sessions booked for each month.THE PROBLEM: Currently, since each record is linked separately by session number, I am not able to easil

HelloI imported a excel doc where I prioritize items based on a 1-4 scale for sorting. I also use "Z" to sort items to the bottom that no longer need a priority. After I imported to airtable, its only letting me sort my priority column "First - Last" or "Last - First" which I am not familiar with. So i changed the "z" items to "999" thinking airtable might only recognize numbers. Didn't help. The "1" priority is still not sorting to the top.In short, I get that airtable wont sort as if it was a spreadsheet but i need to know how to label my prioities so they sort.Right now, I am using 1 - Ultra High2 - High3 - Medium4 - Low999 - Unavailable or ScreenedHelp?

I have a script, creating records from an API. The API data works fine. Instead, I'm having trouble entering a Linked Field value. I understand it needs to an array, but I can't get it to work.I have one table of Schools. The script loops through the schools, does an API call using the school ID, then creates records in the Courses table."school.id" returns the Airtable record ID correctly in the console log. I need that to be entered in the School Link field at the end. Please let me know what I'm missing.  let schoolsTable = base.getTable('Schools'); let schoolsView = schoolsTable.getView("Schools View"); let schoolsList = await schoolsView.selectRecordsAsync({fields: ['Account ID']}) //get school IDs for (let school of schoolsList.records) { console.log(school.id) let currentCourses = await remoteFetchAsync("https://XXXX", requestOptions); const currentCoursesData = await currentCourses.json(); console.log(currentCoursesData); //create records for c

I have been trying to wrap my brain around this for months now. I just can't figure out how to do it. I want a table with all my team's tasks. Each project has multiple assignments and each assignment has multiple tasks (usually around 10 or so). We usually enter 10 - 150 assignments at a time and they are spread out over multiple start dates. There are a couple of different assignment types and each has a different list of tasks. There's some additional data that we attach to each assignment (requirements) and tasks (expected hours to complete, etc). All of that is in various tables. Our upload spreadsheet has all the requirements, first person assigned (starting the assignment), start date, etc. What I need to do is enter, copy/paste, or upload the list of assignments and have airtable: 1) create the list of tasks for each assignment based on the assignment type1a) each task in sequence using a formula (e.g. start date + 3 work days) to create a due date1b) the ne

Hi all, I have a table with a field that is constantly updated (everytime the user clicks a button, this field stores the user email). The problem is that when a new user clicks this button the email gets replaced by the email from the user who clicked last. I would like to set up an automation so that every time this field gets update for it to copy the email to a different field where all the emails from people who have clicked gets stored.So far I created a text field which receives de email information when the user clicks the button and also created a linked field (linked to the users table) that is where I would like to have everyone who has clicked.Any tips or help will be highly appreciated. Have a great weekend everyone

Hi Everyone,I'm new to Airtable and formulas and have a pretty simple formula that is displaying a hyphen as a result of a calculation of zero, instead of the number 0. I admit I borrowed the formula originally from one I found on here, but not sure why the number I've designated isn't being displayed.It's not a true numeric calculation, but a replacement I'm using to give a numeric value to a field that also has text for ratings, i.e. 3 - Exemplary, etc., so that I can total up all the ratings from different categories and assign a value.Here's the formula:    IF( {Field1} = '0 - Deficient' , 0, IF( {Field2} = '3 - Exemplary', 3, IF( {Field3} = '2 - Accomplished', 2, IF( {Field4} = '1 - Developing', '1', 'Out of range' ) ) ) )    I personally have no idea why the formula shared was nested and if that has something to do with it, but everything else about the formula is working. It's displaying like this in the table and the interface. 

Hello Community, please help to solve in an elegant way!I have record, and in a field called "FOOD" I have text separated by comma, let's say in the text I have"FOOD" = Apple, Carrot, sausageI then have another table caleld "FOOD CATEGORIES" with all the food separated by categories like (Can be a table for each category, same situation):Apple - FRUIT Banana- FRUIT Mango- FRUIT Carrot - VEGETABLEZucchini - VEGETABLEPotato - VEGETABLESausage- MEATBeef- MEATChicken- MEATIceCream - DESSERTCheescake - DESSERTCandy - DESSERTSo now I want that in the field next to the field "FOOD" will be a field called "FOOD CATEGORIES" where it will appear the food categories according to the table classification, the previous example, I want to see CATEGORIES FRUIT, VEGETABLE, MEATAt first I tough I could do with a super concatenation of IF, but seems not very elegant approach.The real challenge is that in the field food, could be a lot of different items, so I want that the match will be d

Quick functionality question. Is there a way to highlight a set of records and make quickly assign them the same value in a given field? I.e. instead of assigning them the same value for X field independently, just highlight the records and do it with a couple of clicks?I know about the fill handle, but that isn't always practical