Solved

HelloI have a task I'm trying to achieve with a script in an automation. It's an automation to run every 3rd week of a month (ideally), and to trigger a script which will find all the Wednesdays in the next month and create certain records on those dates. That part I have sussed out, but what I can't find out how to do would be to grab the data/title from the last record of the current month the automation runs on so that I can make sure the new records it creates in the following month flow on correctly. Eg:Automation runs on 16th Jan, triggers a script to create records on every Wednesday in February, starting with a specific title relative to the last Wednesday record in January.The script needs to find out the title of record on the last wednesday of January (which would have been the 25th) and pass that variable into some logic I'll create to determine the titles of the February entries it automates. Hopefully this makes sense! Thanks 

I can't for the life of me figure out what's happening with this one transaction in the personal finances base I've been building.  Would you guys take a look?These are two of the same type of transaction for comparison.  The top transaction calculates exactly as expected.  The bottom transaction calculates out to -$0.00?!?!  I have traced and re-traced the formulas and can't find the issue, haha!  Here's the flow:The Amount field calculates by choosing the non-empty entry amount field from the following options:  an Enter Amount field that allows me to type the amount indirectly, and the Import Debit and Import Credit fields you see in this screenshot which come from my bank import files.Transactions are designated into one or more categories.The amounts from those designation records are rolled up into the Total Split field.The Left to Split formula is: IF(Type="Withdrawl",Amount-{Total Split},IF(Type="Deposit", Amount-{Total Split})) Does anyo

I’d like to use a rollup field with an array as an input for a formula in a different field, but it gives me an error. It seems to not be treating the rollup as a text string.

Hi,We have three main tables.  Client table records have one or many Interaction Table records, which have one or many Outcome records.To make the process smooth for collaborators and to reduce errors, I have a button on the Client record which launches an 'Enter NEW Interaction' form, with the Clients Name (i.e. its record id) pre-filled. Foe exammpleI frequently duplicate the live base to make test/training copies, every time I have to go into the url and manually alter the Enter NEW Interaction form's URL.  (And I have several other buttons performing a similarDoes anyone know a way round this? I would really like to use the forms name, rather than actual record Id.Margaret  

Hi,  I have an issue when using the formula fields in AirTable when using an IF statement.Context: I need the fields to be format as a percentage, or blank if there's an error/infinity.Here is the formula that I want to use in its simplified form, and I can easily format it to return as a percentage. (FYI both fields used in this formula are rollup fields)Sometimes, the values are 0, or blank, causing the data to reflect as such.  (or infinity in some cases)I want the data to reflect as blank. The following  is the formula used, that would have worked fine in excel/sheets.However, AirTable seems to have no idea to read this as a string or a number anymore since I cannot edit the format:Is this intended, if so, is there a way for me to workaround this?I am aware that it is possible to replace the value1 into 0 (instead of "" or ''), but that would cause a problem with another formula down the line.My result end up becoming a long string of decimal that is hard to vis

Hi,I have two tables that are linked. I have table 1 that consists of the membership information:Email (primary field)Last nameFirst namephoneI have table 2 that adds records after submission of a form. This consists of visits you can do once you are a member: ID (primary field)Email (only field to be filled out in form)Last nameFirst nameDateThe idea is to create records of each visit and it should autocomplete the fields (last name, first name) on table 2 pulling them from table 1 based on the email (matched field). The key here is not to manually select the "link to table 1" field but it should be done automatically.Please I would appreciate any suggestions.

I am running a simple automation to identify birthdays for the upcoming month.  My 'Find records' works beautifully when I test. My second action is to send the list of birthdays to specific managers. The action works, but the email produces a blank message and I know there are hits. What am I missing?Thanks in advance

Hello, I'm trying to figure out how I might be able to extract a portion of string relative to the position of a delimiter or other character.For example, I have a table of Events that are structured as follows:##### | <Name of Event>.I want to be able to use the vertical bar "|" character as the item to extract each chunk of information:##### and <Name of Event> respectively.Any help with the formula logic here would be appreciated!

In my base I got some images saved which I want to use in page designer.I believe I used to be able to use the Image URL in the page designers Image element. It seems still to work for about 24 hours and then the URL becomes invalid (which believe has something do with Airtables new security updates.)However is there still a way to URLs of an image in different attachement fields?

Since manually adding a comment doesn’t go into any existing “fields” of the table, I can’t use trigger to automate this. Can this be achieved using scripts instead?

Thanks to Adam_TheTimeSav and his post Solved: Re: How to make a colorful kanban board - Airtable Community I have installed Tampermonkey and changed the background color of my Kanban board.I would like to go further and change colors for tasks and stacks. Where can I find Airtable documentation on the various options to do this and other things I might like to do in the future? In the script to change background color I findGM_addStyle('#kanbanView > div.white { background-color: aliceblue !important;Where does #kanbanView and others come from and what can I do with them?Where does div.white and others come from and what can I do with them?What options are available such as background-color?What does !important mean?I'm an old-timer who's been programming for decades. I think I can figure out how to do what I want to do if I could find documentation. For starters, I'd like to change the background color of stacks to match the listname. Hope this makes sense

Hi,I've been using Airtable to track the performance of my company's social media metrics so I can pull out trends based on the topic and format of the posts.The problem is that the data from the posts (e.g. LinkedIn reacts and comments) is not kept up to date because I input it manually. I was wondering if there's any way to automatically pull data on the likes and comments of a certain post from LinkedIn and Twitter into Airtable if I link the relevant post?Please let me know if someone has already asked a similar question, I imagined it'd be a common function people would like but I couldn't find anything online. 🙂

I am trying to create a formal that adds a specific amount of days to a date field. The amount of days varies and is pulled using a lookup field. Initially, I was trying to use the DATEADD function but it doesn't seem to work when the added value is another field instead of a numeric value.The formula I have currently is DATEADD({Submission Date},{Health Plan SLA},"days")The field Health Plan SLA is a lookup field that pulls a number from another tab. I need this number to be what the formula uses. 

Hello!I have a list of records that all have a start date and end date column for a number of employees.  I am wondering if there is a way to calculate the number of employees on a given day.  All the employees have different start and end dates.  So for example I want to know the total working on March 1 vs March 7.  I know there is a way to do this in excel using an IF/AND formula but can't figure out how to do it in Airtable. Appreciate any and all advice!  

Hi,I got error message when subtmit phone number to enable 2 steps verification. My country code is +84

Hi there. I'm trying to make a custom auto number. The constant is kasse 00 and then want the autonember to be kasse 001, kasse 002, kasse 003 and so on. Can anybody send me in the right direction?And off cause will there be a problem when I reach kasse 010. It needs to be kasse 010 and not kasse 0010 best regards Thomas

I'm trying replace the following text with different values within [] with values from single select columns[art medium], [main objects], [attribute], [expression], [key light], [detailing], [camera shot], [media], [engine], [artist]I thought this would be fairly easy, but somehow can't get it to work.I tried a Substitute() like this:IF(Medium = BLANK(),SUBSTITUTE(Label, "[art medium], ", "" ),SUBSTITUTE(Label, "[art medium]", Medium)) &IF({Main objects}=BLANK(),SUBSTITUTE(Label, "[main objects], ", "" ),SUBSTITUTE(Label, "[main objects]", {Main objects})) But it subs the text and then renders the remaining text. Does anyone have any pointers how I best go about this?

Hello,I have a rollup field with the following output:FirstName1  Last Name1- XXXX Title Company , First Name2 Last Name2 - XX Title CompanyWithout going back to the original table to pull the "XXX Title Company"  I need a formula to help split and display everything after " - " for each value. Any help is appreciated!

Hello, I'm trying to create a "create record" automation when a new record is added to table A (Seeds); a new linked record is created in table B (Web Archiving_QA). The input data in table A (Seeds) to create the new record is a website URL.The automation is formatted: After successful testing, and turning the automation on. When I input a new URL to create a new record in Table A (seeds), I only get a blank new record in Table B (Web Archiving_QA) But if run the automation with the Test Step section > "Run as configured" I get the correct automation results, meaning the inputed URL in table A shows up as a new record in table B. from in the automation viewlinked URL from table A shows up in the record in table BI run into the same problem when I change the trigger to "When a record enters a view".Why am I only getting the desired results via "Run as Configured"? Thanks!   

Hi!I have a table with freelancers, I have another with expenses associated (payment info & dates that went to each freelancer). What I am trying to do is pull all expenses linked to each freelancer by month. So I have columns labeled with the months on my freelancer's base. I just can't figure out the roll-up formula to limit the column to only count expenses (weeks paid) per month/date range. Thank you!

i am using a step in an automation that i’m hoping will allow me to add a related record to a field that already has related records in it. the prior steps in the automation are picking out which record i want the script done to. i am brand new to scripting, so i’m guessing it’s something obvious. i got this from the documentation here: Airtable Scripting table.updateRecordAsync(record, { ‘Which trainings?’: [ …record.getCellValue(‘Which trainings?’), { id: newTraining }] }); when i test the step, it says the field “Which trainings?” can’t accept the provided value & when i ask it to show me what it got from the step above, it shows me an empty set. the newTraining value is the record id of the related record i want to add to the field. any help is appreciated!!

Hi allIs there a way to delete the certain matching characters that might appear in a column? For example I have a column of data (800+ cells) of company names, and 90% of them are prefixed with a 'number' (that run between 1 and 9), followed by a 'period', followed by a 'space'. For example "1. Some Company Name" or "8. Another Company Name".10% of the data in the column may not have any numbers or spaces, OR some of the company names may not have a 'space' after the 'period' for example "7.Yet Another Company Name" or "And Another Company Name".Amy advice would be greatly appreciated.Stephen 

Hello!  I am in desperate need of help. I can't figure out how to "filterByFormula" in the following script. I am trying to send a JSON payload via webhook to MAKE.com. I only want to send records where a given field is blank. I have tried multiple variations of the filter but can't figure out why it always sends EVERY record.  let table = base.getTable("BA Aggregated Calendar 2022-2023");table.selectRecordsAsync({fields: ["Event ID", "Outlook Category", "Users"],filterByFormula: "blank(Outlook Category)",sorts: [// sort by "Users" in ascending order...{field: "Users"},]}).then(query => {const payload = {records: query.records.map(record => ({id: record.id,eventID: record.getCellValueAsString("Event ID"),outlookcategory: record.getCellValueAsString("Outlook Category"),Users: record.getCellValueAsString("Users")}))};const options = {method: 'POST',headers: {'Content-Type': 'application/json'},body: JSON.stringify(payload)};fetch('webhookhere', options);});

I have a customer (athlete) table that is one row per customer. And a comms table, that logs when each customer posts something in our community (circle) via Zapier.Then, in the customer table I use a rollup to display the date of each customer's last post.The problem is I keep going around in circles trying to figure out how to link the 2 tables. Each customer has a unique athleteID  and circleID, so it should be circleID that is the link between the 2 tables (I think?). BUT when I add a row to the comms table, it looks like I need to know the athleteID too. Isn't the whole point that the circleID is the 1-to-many link between the 2 tables, and athleteID shouldn't need to feature in the comms table?Is it because I'm trying to link tables on a field that isn't the primary key? And if so what's the best way of achieving what I need to?Thanks!

I have a 'customer' table (one row per customer - name, email etc), and I have a 'contact' table that records the date of every instance of a customer contacting us (customer ID, date of contact etc). How would I pull in 'date of contact' into the customer table, but rather than all contact dates being pulled through, only the most recent?So - kind of like how you'd use  'distinct' in SQL, sorted by date Thanks!