Solved

Right now I have a basic quarterly reporting function working in one of my bases, but I’m curious how I would improve it. I have a formula that looks at the starting date of a project and uses that info to tag it with the correct quarter and year. Great. That works fine. Where I’m a little more confused is how to then get that info consistently out onto a reporting tab. As of the moment, I’ve created a tab with each quarter of 2021, and I have an automation made for each quarter so that when a record appears with a 1Q-21, 2Q-21, 3Q-21, or 4Q-21 tag, it will be linked to the corresponding quarter record in my new tab. The issue, though, is that I would have to do this for every quarter of every year. Not the end of the world, but a little annoying for the long term. Is there any reasonable way to automate the process of creating the new quarter records for each year and automatically adding any records that should go into those quarters going forward without manually adding each quar

Hi there, :wave: I’m hoping someone could help me out there with an automation issue. So here it is : I’m recruting people. So I manually create a new record in a TABLE A. This record contains several information : email, name, contact date… I’ve also created a “single select field” called “Document received ?”. The choice is between YES or NO. An Airtable form is sent to the candidate. It helps me gathering datas such as : ID Card, Licence driving, email, phone number, etc… Then, the form appears in a view : in a TABLE B. Here is the problem : When a new form is received in TABLE B, I want to automatically update the record that matches the name (or the email) of the candidate in TABLE A. So I want the field “Document received ?” to automatically turn “YES”. PS : I’ve created a “LINK TO” field in table A and an automation that works. BUT I have to manually update the field before the automation runs. Otherwise I receive an email that alerts me about an automation error. Do you

As a result of my newbie status I have a lot of fields in each TABLE of my base that are not going to be used. This happened over the course of several weeks as I developed and revised my base. Is there an easy way of knowing if fields in my TABLES are being used anywhere in the base? And if they’re not a quick way to delete them?

Hi, i need help with a formula if this is possible. i have a table containing a “date” field and a “formula” field that calculates the age from that. ( DATETIME_DIFF(TODAY(), {Person nr}, ‘years’) & ’ years, ’ & MOD(DATETIME_DIFF(TODAY(), {Person nr}, ‘months’), 12) & ’ months’ ) everything is perfect here so far, but i would like to make a new field that contains age groups, like 0-10, 10-18, 18-30, 30-50, 50-100 lets say. is there a formula for making this? and can it change buy it self when a person goes from let say age 29 to 30 and so on? or is there a way to search, filter or group already for lets say ages between 20-40 or 30 and up? or 25-45? Hope you understand what i am looking for, and every help i can get would be much appreciated! Thanks, Viktor Update: if its more simple to remove the “months” thats ok.

Could somebody help with a formula? Thanks in advance :slightly_smiling_face:

Hello, I am new to Airtable. I tried looking for this answer already in the community, but I could not find a post. I am using Airtable Automations to copy specific fields to another table. So far the first three fields have been a success, but now that I am trying to copy the value from the formula field, it won’t show or copy that value from that field into the other table. Is this a limitation in Airtable? Thank you for your assistance!

Hi, I have created a database with records in Airtable and want to now import an excel file. I want to be able to import and map fields from the excel to various fields in the Airtable Record. I could not find an article with a simple answer to this. Thank you. Regards, Imran

Hello Community, I am struggling with a formula which I thought would have been easy and I would need some help: What I am trying to achieve is: if column a is empty, return value A but if Column B is empty, return value B, but if Column A contains the value X in the string, return X. This is what I have been trying so far: IF(({COLUMN Al} = BLANK(), “VALUE A”, IF({COLUMN B} =BLANK(), “VALUE B”, IF(FIND(“X”, {COLUMN A), “X”))) My problem is that even if the formula doesn’t trigger an error, I am not getting the result connected to the last part IF(FIND(“X”, {COLUMN A), “X”))) What am I doing wrong, please?

Hello the Community, I’m sorry for this stupid question, or, at least, a question coming from a beginner… but didn’t find my answer since days! I have to manage a coaching data base, where I follow each appointment with the Coachee’s Name, the Coach’s Name, the date of the appointment, the debriefing etc… And I would like to create an indicator showing the number of coachings done by a coach since the 1st of the current month. I don’t want a count since the past 30 days, but since the 1st day of the month. For example: we are the 22nd of Jan and I would like to count the number of coachings done since the 1st of jan… not since the 22nd of december. And of course, I would like to have it in an automatic way to follow it each month. Thanks a lot for your help!

I’m trying to have a field formula yield the later year found between two date fields (even if one of the fields is blank). I’m completely confused how to add a IS_BEFORE function into the IF(OR) statement… The fields I’m working with is: {Last Modified/Reviewed} and {Date Pub}. I want a third column to return the YYYY that is later of those two (or the only one not empty of the two), and if the year is before 2018, to give me the label “2017 or older”… Formula to output the later YYYY of two date fields Formula to output the later year of two date fields?

Hi there, unfortunately, I have not yet found an answer to my question in this forum so I am asking myself. I have a single line text cell which is always structured similarly to the following: Brand Name Product Name (Color / Color / Color) I would like to extract only the portion in between the brackets into another cell. Meaning my output would be Color / Color / Color Unfortunately, the number of characters before the first bracket and within the brackets will vary. That is my main concern and why I have not yet found a good formula to fix this. Any help is very much appreciated. Thanks in advance!

Hey community, I wanted to give a proactive heads up that we’re currently experiencing some downtime for some users. Our engineers are actively investigating the issue, and we’ll have more updates as soon as possible. I would recommend following this incident here on our status page for updates, but I’ll also update this topic once the issue is fully resolved.

Hi! I’m trying to get a field to output one of 4 results based on what it finds contained in a single Formula Field (Date reformatted field to YYYY-MMMM, pulling from the MMMM portion). If {Year/Month} is “Jan” or “Feb” or “Dec” or “Nov” = “WINTER” If {Year/Month} is “Mar” or “Apr” or “May” = “SPRING” If {Year/Month} is “Jun” or “Jul” or “Aug” = “SUMMER” If {Year/Month} is “Oct” or “Sep” = “FALL” This is what I tried but I’m getting an error. I managed to get it for one IF(OR) statement but am having trouble linking all four: IF( OR( FIND( ‘Jan’, {Year/Month} ), FIND( ‘Feb’, {Year/Month} ), FIND( ‘Nov’, {Year/Month} ), FIND( ‘Dec’, {Year/Month} ), ‘WINTER’, IF( OR( FIND( ‘Mar’, {Year/Month} ), FIND( ‘Apr’, {Year/Month} ), FIND( ‘May’, {Year/Month} ), ‘SPRING’, IF( OR( FIND( ‘Jun’, {Year/Month} ), FIND( ‘Jul’, {Year/Month} ), FIND( ‘Aug’, {Year/Month} ), ‘SUMMER’, IF( OR( FIND( ‘Sep’, {Year/Month} ), FIND( ‘Oct’, {Year/Month} ), ‘FALL’ ),"")

Hello, I’m setting up my first Airtable Automation where I have two fields: Date and Status. If a Date field is on or more than 7 days old (for instance, if today is January 21, I would need it to pull from dates that are January 14 or older), I need the Status field to say “Old.” For dates that are within the past week, I need it to say “New.” When I set up the Automation, I get a failed test, with “Received invalid inputs” as the error message. I have a feeling it has something to do with my Record ID not matching up, but I don’t know what to do there and I’m having trouble finding documentation on it. Any help is appreciated. Thanks!

I have the following code that is looking for the value of a calculated field. But I’m getting an Error: no field matching … let rootTableDat = await rootTable.selectRecordsAsync( { fields: [“Zeiss Planar 80mm 2.8-Prontor CB”] } ); Should this work? Is there a preferred way of doing this? Thanks.

I tried to make a custom formula with this expression, but it fails. If(Or(Phase= “5. On Hold”, StartDate>Today()), “5. On Hold”, If(Phase= “Complete”, “Complete”, If(Or(Phase= “1. ToDo”, And(DueDate<=(Today()+7), Phase <>“Complete”, Phase<>“5. On Hold” ) ), “1. ToDo”, If(Phase = “2. Planning”, “2. Planning”, If(Phase = “3. Doing”, “3. Doing”, If(Phase = “4. Controlling”, “4. Controlling” )))))) Do you have any advice?

I’m considering storing information about users in an Airtable table. One of the fields would contain a unique username. From my application, I would like to find the user that corresponds to a given username. I think that the recommended approach would be to retrieve all records with a parameter filterByFormula= {Username}={My ID} as shown here. However, if I’m not mistaken, this would entail Airtable to scan all the rows of the table in order to find this particular record and thus would be very slow for a larger number of rows (O(n) complexity). Is this the case? Can I create an index (as in a relational database) to make such searches faster (O(log n) complexity)?

I’m trying to make monthly reports of a few thousands entries. However my script never stops, and not sure what the mistake is. I’m pretty new to JS and not sure if it’s my loop within a loop that is the problems? let wip, wipOrderView ,tableWIP, queryWIP let cost, costReviewView, costTable, date, customer, garment, switchs, totalFactCost, costTime, estTotalCost, price let currentMonth wip='Work in Progress' wipOrderView='Monthly_order_review' cost = 'Costing' costReviewView = 'Monthly_Overview' date='Date' customer='Customer' garment = 'Garment' switchs = 'Switch' totalFactCost = 'Total fact cost' costTime = 'Time' estTotalCost = 'estTotalCost' price = 'priceScripting' tableWIP = base.getTable(wip).getView(wipOrderView) costTable = base.getTable(cost).getView(costReviewView) /////////////////////////////////////EVERY MONTHLY REVIEW ////////////////////////////////// let everyMonth = async () =>{ output.text(`This will take a little time as the system is compiling thousand

Not sure this is the right category, but… Is there a keyboard shortcut to check a checkbox? it’s incredibly annoying when doing data entry to have to switch to my mouse to check off a box… i’ve checked the shortcuts menu and don’t see it, searched the forum here and don’t see it, but i might not be searching on the right combination of words? any clues on this would be great… i’ve tried spacebar and enter and shift enter and a variety of other possible, intuitive solutions but none of them seem to do the trick. if it’s NOT a thing… then @airtable dev… could it please BE a thing! :grinning_face_with_big_eyes:

Hi, I’m looking for a formula that can help me understand my “task capacity” for the day. In other words, let’s say I have “estimated time required” set for all tasks for that day, and that equals 7 hours… how can I then: a) First create a formula or setting to tell Airtable my capacity for the day is 8 hours, and… b) How can I then create a formula that takes that day’s tasks and lets me know if I’m over or under capacity? An example… If my max was set to 8 hours for the day, and I have 7 hours of tasks, AT would tell me I’m in the green (Green check symbol). If I have 9 hours of projected tasks, AT would tell me I’m over capacity (Red cross symbol)? I’ve attached a screenshot of my current “Tasks” view inside my own project manager, in case it’s of help. Thanks in advance for any assistance! -Christopher

Hi! I am using an airtable automation to move certain data from the record to a different table, then I would like to automatically delete the record in the original table. Can I take that last step using Automations? I couldn’t figure out how. Apologies if this is well documented, I couldn’t find it though! Thanks!

Hey All I am stumped and have not been able to find a solution. Any help would be much appreciated. Problem: I have 3 columns that match “Champion” I have a 4th column I want to print “Champion” but only if all three columns match Champion I have tried SWITCH({R segement} & {F segement} & {M segement copy}, “Champion”, “Champion”) but is not working Thanks

Hello Friends, Needing to use datetime_diff to return days, hours, and minutes. I can only get the days to return the value. Tried all different types of formula nothing is working. Any thoughts?

I’m trying to make a simple repport and wonder if I can make line breaks in a table? I have tried a few different things like: output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': 'finished\ncompleted' , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': 'Delivered<br>Completed' , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': 'Delivered\nCompleted' , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': ['Delivered', 'Completed'] , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': `Delivered Completed` , '%':100}, ] ) The closest I’ve come to a line break is this: output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50},

Any suggestions for how to view my Bases properly in Chrome? I’m on a Macbook Pro viewing on a LG monitor, although if I move the tab to my Mac the issues still exists. All is good when I’m on Firefox. See comparison of both browsers in screenshots.