Solved

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!

Hi, I created a form for simple data entry and am including a “Created time” field so users will not have to manually fill in the date the form was submitted. The issue is, I also have legacy data from an old system that I want to import into the same table as the form submissions so the old data and any new data can be analyzed as a whole. This old data is organized by date and those dates are important to retain. When I add any old data into the table, the Created time field auto-fills to today’s date and I am unable to change it to the correct date. Are there any solutions for maintaining the Created time field, but also maintaining the correct dates for the old data? The only option I’ve thought of is converting the Created time field to a Date field, but that would mean anyone submitting new data via the form would have to manually enter the date. Thanks in advance! Colleen

I am new to scripting & know that I dont know exactly what I am doing however I like to learn & am kind of learning on the job taking it 1 step at a time.When creating a script the following code will allow the user to choose which table & field they want to use in the script from the script settings. // Click the "gear" icon in the top right to view settings let config = input.config({ title: "Script Title", description: "Script Description", items: [ input.config.table('selectedTable', { label: 'Table to use', description: 'Pick any table in this base!' }), input.config.field('selectedField', { label: 'Field inside the above table', parentTable: 'selectedTable', }) ] }); I want to be able to select multiple fields. But I only want to be able to select:Fields that are either a singleLineText or a multilineText.Only be able to select each field once.How w

I have a series of fields I want to concatenate together. The final result needs to include a semi-colon in between each piece of data, but not all columns have data. So I was working to do an IF statement to check if the last of the columns (far right column of data I want) had data, if so, concatenate it with the other fields. The formula I came up with (but is not a valid formula and I can't figure out why) is:   IF({Revenue Rolodex}, CONCATENATE({Revenue Rolodex},”;”,{VIP Day Social},”;”,{4M Event},”;”,{Applied to DID},”;”,{DID Calculator},”;”,{VIP Day Bootcamp},”;”,{2022 Advent Calendar},”:”,{VIP Day Quiz},”;”,{FREEBIE: Roadmap},”;”), IF({VIP Day Social}, CONCATENATE({VIP Day Social},”;”,{4M Event},”;”,{Applied to DID},”;”,{DID Calculator},”;”,{VIP Day Bootcamp},”;”,{2022 Advent Calendar},”:”,{VIP Day Quiz},”;”,{FREEBIE: Roadmap},”;”), IF({4M Event}, CONCATENATE({4M Event},”;”,{Applied to DID},”;”,{DID Calculator},”;”,{VIP Day Bootcamp},”;”,{2022 Advent Calenda

I want to create a file upload interface on my custom app so that collaborators/users of the app can upload an image from their file system to the base (instead of using the airtable interface) Is this possible, and if not, can you suggest any workarounds? Thank you!

I'm a scripting newbie and need a little help...I'm attempting to create a number of placement records, linking to a booking where the number of records is inputted by the user.I've cobbled together pieces from various example scripts I've found, but I'm hitting an error. Please see details below.This is the script:      This is the error: And these are the details of the object: Currently I suspect there's a type mismatch somewhere - but any help would be greatly appreciated!   

Hi All,. I am relatively new to Airtable and am hoping for guidance regarding an issue I have encountered. I have a table of riders which I use to record day to day notes and injury information. It is reviewed daily by our Doctor who then decides depending on the injury if the rider should take a break from competing or if they can be cleared immediately to continue . When the Doctor decides that the rider can be cleared I would like to have a button that she clicks which clears the relevant fields but also automatically creates a new record in another table to retain a copy of this information for reporting purposes at the end of the year. The relevant fields are 1) a linked record from another table showing venue incident took place 2) checkbox 3) a single select 4) long text 5) attachmentthanks

Hi, anyone can help with a trick to hide a record if one is marked with a tag?Example hereI want the Data Intelligence Intern to be excluded from the form without deleting it from the record Any tips?Cheers! 

 Hello everyone,I have to create a calendar of course sessions and I have a table in which I enter in one column the date, in one column the start time and in another column the end time because different days might have different times.I use the formula DATETIME_PARSE(CONCATENATE(DATESTR(Date),' ',{Start Time})) to create a date & time that can be displayed on the calendar. However, the result of the formula returns the wrong time, increased by one hour.Am I doing something wrong or is it a bug?Thanks for any assistance!

Hello, Is there a way to configure this formula to only return a time during specified business hours (7:30-4PM)? DATEADD(WORKDAY({Last Modified},1)) Thanks :slightly_smiling_face:

Hello! Is there a way to use the "When a form is submitted" automation trigger but send different emails based on different responses to the form? We have a single select option and we are looking to send different emails based on which option was chosen. I would just choose the "when a record matches conditions" option but we sometimes change the single select option and I dont want emails sent when that happens, just when the form is submitted. Im happy to use a workaround but dont know exactly what that might look like. Thank you!

Hello, my goal is create an automation that update all record meet record update.see atached filewhen I change the value of record indicated from 99 to 1, I want all others records of same finish and same date chage to 1 too.ThanksSylvain

Hello all!  You guys have been so helpful in the past, I've got a new question to share tonight!  I am working on a base to track finances.  We categorize all our expenses (and income) and then budget for those categories.  I need to assign a category to each transaction I import into the base.  Occassionally, we will have a single transaction that purchased items from multiple categories, for instance we bought clothes and groceries at Walmart.  Clothes and groceries are separate categories.How would you guys structure your base to make recording these transactions as smooth as possible?Thanks!

Hi,Hope you are all doing well.I need a little help. I have a simple single select column which have different tags and can be updated time to time. I want to calculate the edit history of each tag in other column and wanted to know how many days requiring each tag i.e when it was changed from in progress to shipped. I want to calculate the time and no. of days.I'd really thankful if anyone provide me best solution 🙂Thanky you