Solved

Hi. Would like to know is there a way to do automation so that I can count how many times I have checked a checkbox? :white_check_mark: The counter (or variable?) should increase by 1 every time I check a checkbox in the corresponding record. It should NOT decrease by 1 if the checkbox is unchecked. :white_medium_small_square: I need this function/automation because I have recurring tasks every week and want to count the times I completed the task. Also, I think there is currently no way to uncheck a checkbox by formula / automation. How can I make my weekly tasks show up to be unchecked when a new week starts? Thanks! P.S. I have tried this method: By automation, every time a record is checked (trigger), I create a new record in the ‘Script’ table. The record has my task’s ID as its name and the number (initially 0) copied from the triggering record field ‘counter’. Then, another action is modifying the triggering record by adding 1 to the Script record. But it seems doesn’t work

Hello there I would like to avoid user copy and paste in one of our tables. For this is have created a button and modified the excellent ‘copy values from one field to another’ script by @JonathanBowen to my needs. This works really well to copy a value from my source field to a target field, replacing the existing value in the target and leaving a create date in the source field. Now what I want to achieve is that that target field is a linked primary field in another table. At the moment users do this manually with copy and paste, but we do not want to introduce the idea of copy and paste as a function, a button would make this more elegant. The idea behind it is that we use one table to build a product by formula from other field values, so that we end up with a full parts code in one field (the source). This is then pasted into the linked field to create a new record in a parts table. However if I change the field name in the code from a standard text field to the linked field I ge

Hello, I’m Spanish and I can speak a little English. I’m new in Airtable, sorry if my question is too easy for you. I have a shoop with several makers (“Créateur”) I would like to sum “Prix” for each “Créateur” in the field “Total pour créateur” I’ve made a formule with SWITCH but its does’nt work {Prix} + SWITCH( { Créateur }, “Sophie”, SUM, “Mathilde”, SUM, “LMC”, SUM ) Can you explain how to find the solution ? Thanks Date____________.Créateur_________Prix_________Total pour créateur 5-3-21___________Sophie___________80_______________80 5-3-21 __________Mathilde __________60_______________60 5-3-21 __________ LMC ____________50_______________50 5-3-21__________Sophie ___________20 ______________ 100

Hi, I have got a problem and hope someone can help me, I want to copy a record from one Table to another Table in the same Base when I change the Status of the Projekt via a Single Select Field. So when I change the Single select it should be shown in the other Table. Is it possible to get this Work ? Edit: The Record should be also stay in the first Record Mit freundlichen Grüßen T.

Hi :slightly_smiling_face: Does anyone know what supported timezones for SET_TIMEZONE for Mountain Time (US)? Thanks!

Hello, would anyone know a formula to add a date with a time and bring the result of date and time updated? example: Start date column: 6/7/2021 1:45 am Duration column: 0:45 Result column: 7/6/2021 2:30 pm. Thanks in advance ! :blush:

I am building a simple daily task management automation. I want any task that was not Done to be forwarded to the next day at 3AM so when I start work I have all uncompleted tasks automatically in today’s task list. So far… Trigger When records matches conditions When Date is yesterday And Status is not Done Action Update record Record ID: Record (step 1 Trigger) | Field values | Date Fields: Date | Today() Also tried DATEADD( Date, 1, ‘days’) Trigger test ran successfiully. Action test failed “Received invalid inputs.” Wondering how to do this? (New to Airtable.)

Is it possible to get visible fields for a chosen table and view? I checked the Airtable scripting documentation and I cannot find the property to check if a field is visible for that view

Hi! I’m trying to figure out what would be the best way to implement something easy to use that would allow anyone to check if a record exists in an airtable base. With a table with these columns: Name | Surname | ID | email I would like to implement an external webapp that given email + ID, checks if the record actually exists and returns true or false. Any ideas? Thanks

Hi! I’ve tried to read on my question since a lot of people also ask about it in the community but I’m still not very clear with the answer, so I will share my specific scenario to be sure. I’m setting up Airtable workspaces for a Company that will have 9 Pro users. By this, I initially assumed it would be $20/year per user. BUT… it got a little confusing with the different shared workspaces. So the 9 users are spread into 3 different departments: 3 users in HR, 3 users in IT, 3 users in Sales. Each team will have their own workspace. But there are some processes where the Sales Team needs to share certain Bases from their workspace to the 3 people in IT Team to complete a process. Does that mean, even though the 3 IT Team are already paid Pro users, there will be an additional $20*3 users for them to have Editor permissions in specific Sales Bases?

Hey Community: I built a pretty extensive base that tracks all the places a band has been. I want to be able to have a formula that will take this field’s output and make is a list. I will never know where the commas may fall for the names of the places. A sample result in my field is the following. , , , , , , , , , , “12-11-20 - New York, NY Rockefeller Center”, , , “10-27-18 - Bridgeport, CT BRYAC Restaurant & Raw Bar”, ,

Hey all, I am trying to generate a date in a formula field by using the data from two other fields. -I need the formula to read the datum in the {End Date (Current)} field, determine if it’s blank and then if it is not. want it to then calculate the date based off ANOTHER field {Days Notice to Cancel}. And if it is blank I want it to say “1”. So far I feel like the below formulas need to communicate but I am not sure how to combine them to make them talk properly. (however, any suggestions are helpful, even a whole other formula combination). IF({End Date (Current)}, “field is not empty” DATEADD({End Date (Current)},-{Days Notice to Cancel},‘days’) IF({End Date (Current)}, “field is empty”, “1” TYIA!

Hello wonderful Airtable community, I am working on an email automation that will report on student progress through a variety of courses. I have each course listed as a single-select field, then the possible grades listed as the options to select. I want to send an email report that shows these grades: Class 1: {GRADE} Class 2: {GRADE} My problem is that no matter what options I select when building the automation, the GRADE field shows up blank. Thanks so much for your help! Katie

I maxed out 500 fields. It’s disappointing cause I didn’t know about it or I missed it wherever it’s mentioned. At least the Account overview should warn me earlier I am maxing out the number of fields. It doesn’t say anything about that. Now I have to spent days and days to redesign the table, maybe weeks… I have lots of fields primarily because of many complex formulas I have. I rather do multiple steps with formulas so that it’s easier to fix them or update them, given how unhelpful the formula editor is in Airtable. Now I will have to fold many of these fields together to free some space. I have alone 30 fields taken up with formula to generate separate URLs for attachments in the attachment fields (Yes I know there is an addon)… and so on. If I sound a bit frustrated, yes I am. That’s SILLY this 500 fields limit. If it was 1000, fine. But I would have thought maybe 5000 or unlimited. I have lots of formulas and dozens of automations… It will take me weeks to fix this. This is an

I feel like I’m close with this one, but it’s not quite working. I want to show quarters of the year, so if a column equals “January 2021”,“February 2021”, “March 2021”, I want it to show “January - April 2021”, and so on for each quarter. I’ve attempted it with IF(OR), but it’s not working. Appreciate any tips here. IF(OR({Result Month/Year}="January 2021","February 2021", "March 2021"),"January-April 2021",IF(OR({Result Month/Year}="April 2021","May 2021", "June 2021"),"April-June 2021"))

Can anyone help me with a formula? Here’s what I want to do: Take a total number of words: for example, 60,000 Subtract my current number of words: for example, 20,000 And then take that number (40,000) and divide it among the number of days left before my deadline. TIA!

Hi guys, I’m trying to create a unique alphanumeric code(length 4) out of Record ID and Autonumber. But I am getting an error while doing so. Is there any way to find it? Thanks, Chintan

I am trying to create a view based on rooms and multiple items within that room. Is there a way for me to just output the room number once at the top and then the related records for that room beneath? Currently, i have it grouped by room in view, and the records just show up in rows with the room number on each. Current: Room 111 table Room 111 chair Room 222 lamp Desired: Room 111 table chair Room 222 lamp

Someone else asked about adding carriage returns to formulas (it’s done like this “\n”). I’m trying to find a similar command for tab or indentation characters. That way I can generate text formatted like this: Product: Orange Quantity of Product: 5 Instead of this: Product: Orange Quantity of Product: 5 @W_Vann_Hall I bet you’ll know

Hello everyone! I’ve got several cols (days of the week) that have a time that I wasted in doing a task in minutes (ex: 120). All that I’m trying to do is a SUM of this minutes but in a h:mm format. Example: The task is “Book Design” and the minutes I’ve spent in doing that task are (120, 120, 60, 60, 30). The SUM of that minutes is 390… that’s 6:30 hours. All I want to have is this number 6 and I don’t know how to get it. Thanks in advance!

Hopefully this is a simple one and I explain this correctly: I have a table of products containing several fields, including: unique product ID and price. (Let’s call this the primary table) I am using the Data Fetcher Airtable app to pull updated product information from an API into a separate table in the same base. (Let’s call this the secondary table). This also contains a unique product ID and price I want to fetch the price in the secondary table and update the relevant price field in the primary table, using the product ID to ensure the correct item is updated. If these were two tabs in Excel, I would just use a vlookup to look up the id and return the price. However I can’t figure out how to get this to work in Airtable. Any advice much appreciated. For info - the two tables do have a name field, containing the name of the product, however the names in the primary & secondary tables don’t always match, so I cannot use this field to match an item. Many thanks

Hi! :wave: I am having some difficulty with creating a formula in my database. I have one table - ‘Feedback’ - where each row is a bit of customer feedback, and each bit of feedback has a column for ‘Insight’ (i.e. what type of problem it is) and another column for ‘CSAT score’ (ranging from 1-5). I have another table - ‘Insights’ - which lists all the insights from the feedback table in the first column (these are linked). What I want to do is calculate the average CSAT score for each insight. I have managed to create a new column in the insights table entitled ‘CSAT Score (from Feedback)’ which looks up the CSAT scores from the other table and presents them for each insight, separated by a comma. What I then want to do is create another column which averages these scores. However, when I used the formula average({CSAT Score (from Feedback)}, I get the error message shown below. Do you know how I can fix this?? The CSAT scores in the Feedback table are formatted as numbers, so I th

I’m running a scripting app that loops through all the records in my Airtable using await table.updateRecordAsync() in a few fields, including a single-select field. Every once in a while, through human error or something else, we’ll wind up passing something to the script that makes it try to update the single-select field with some value that isn’t one of the options for that field. Right now what that does is cause the script to throw an error and abort entirely. What I’d like to do is have it throw an error message and continue on to the next record in the table. What’s the best way to go about this? Excerpt of the script in question below (for context, we’re a nonprofit helping folks in the criminal justice system): if (parsedNewDate.valueOf() != parsedOldDate.valueOf() || postSentencePrison != newPrison|| inmate.releaseCode) { if (parsedNewDate.valueOf() != parsedOldDate.valueOf()){

I’ve created a simple table to inventory my card supplies. After creating I decided to make changes and combine two columns into one, then I deleted the no longer need rows. I now realize that I should not have deleted the rows but should have left them empty for reuse. My question is…when I want to create a new row is there any way that I can re-use a deleted row ID?

I’m building a database to track uniform assignments for the local high school marching band. I have one table for students, another for the jackets, another for the pants, and so on. In the Students table, I have a field using the link to another record option linking to a jacket. I’ve been careful to make sure to not Allow linking to multiple records. I’ve then gone into the Jackets table, and made sure to not Allow linking to multiple records. What I can still do, however, is assign the same jacket to multiple students. And when I go to the Jackets table, I can see that the same jacket is assigned to two people. I would love to have this set up in such a way so that once a jacket is assigned to one student, it is not allowed to be assigned to a second one. Is there a way to do this?