Solved

For a table with organizations I have a partner field that links back to the primary column itself. Suppose an organization has 10 partners and I put them in the Partner field, then all those organizations will get that one organization in their linked partner field. But I would like for them to get all the organizations in their partner field, ideally minus themselves. Thoughts on how to do that?

I would like to create a scoring system for climbing competitions using airbase. I’m having a lot of issues with this in general. And I’m sure that I’m not doing it efficiently. Essentially, I want to create a scoring system that can be inputted by multiple judges using one source of competitior names. But the judges won’t be able to put all of the scores of one competitor in at once. One judge will put one score in. And the next judge will put another score in. So I need the ability to update their records. Let’s say there will be 4 climbs. I would like one judge at each of the 4 climbs. The judge will choose the climbers name from a dropdown box and enter the scores (ie, top, zone, attempts to top, attempts to zone) on an airtable form. The judge on the next climb will also have the same form but will score for the next climb. 1.I created 1 table (named Summary) with all of the climbers and columns for the scores of each of the climbs. 2.I created another table (named Update

" Hello Airtable" need to remove initial white-space from the text in the script.

Not sure if this was covered before. I’m trying to use the datetime_diff function in a formula as a trigger to send out an email 5 minutes before the meeting starts. The problem is that this function is very sluggish to update. In other words it might be 10 or 15 minutes past the moment it should trigger before it refreshes and shows the correct difference in time. But by the time it updates it’s too late to send the email out. Is this a bug? Or is there a workaround? Thanks!

I have managed to create a get request (I’m 90% no code) and then info is coming back but how to then write it to a field?. let table = base.getTable("TARIC Code") let url = "https://www.trade-tariff.service.gov.uk/api/v2/commodities/"; let config = input.config(); let response = await fetch(url + config.commodityCode ); console.log(await response.json()) I want to take the result directly into a field to then sift through it for what I need.

I want to list each linked entry in the “facts copy” column as a separate bullet point in a bulleted list in another column. Here is the table: Here is the formula I tried to use unsuccessfully: REGEX_REPLACE(CONCATENATE({Facts copy}), “, “, “<br>⦁“) I am not a programmer so apologies for my lack of knowledge.

I know this is simple but I’m struggling for some reason. {Average Weight}/2000 * {Base Rate} + {Surcharge Calc} It adds the ‘Surcharge Calc’ which is a percentage just as a number. What I’m trying to accomplish: Average Weight = 10000, Base Rate = 15, Surchage Calc = 20% 10000/2000 X 15 + 20% = 90 I’m getting 75.20 Thanks

Hello, I would like to set up a calculation to allow me to multiply a number according to conditions. IF(), but I don’t know how to go about it. Here is the request: My column: ( hide) Inventaire Composant sortant (Unique) corresponds to a set of products: ex: 1 table. "I could have called this ( hide) Inventaire Produit fini sortant (Unique) → This is what I take out of my stock but as a product as a whole (single). The question is for my column: Inventaire composant sortant ( Calcul pied), I would like according to conditions to be able to say if table with 2 feet, multiplies (( hide) Inventaire Composant sortant (Unique)) x 2 (# (hide)Pieds), if table with 3 feet, multiplies (( hide) Inventaire Composant sortant (Unique)) x 3 (# (hide)Pieds), if 4-foot table, multiplies (( hide) Inventaire Composant sortant (Unique)) x 4 (# (hide)Pieds), idem for if 1 feet and if Blank(), leave the field empty This would then allow me to subtract Inventaire composant sortant ( Calcul pied) from ( hi

Hello, Can someone help me to write a code to extract all the URLs associated with my attachment in a particular record? As you can see here, i have 3 photos where i need to generate “https://dl.airtablexxx1,https://dl.airtablexxx2,https://dl.airtablexxx3” in a field named “joined” Thank you for helping me

Hi folks, Formulas aren’t my strong suit, but I’m hoping there’s a way I can do this. Essentially, I’m helping my school manage teacher assignments, so I’m building a simple database to help me organize and visualize this data. I have two tables: 1 for Courses and 1 for Teachers. I have them linked together such that if in the Courses Table I type in a teacher’s name, then that course will show up on the Teacher’s tab (and vice versa). In the Course tab each course has a numerical value assigned to it based on the number of times per week they meet. What I would like is a column that tabulates the total number of periods assigned to a teacher that is calculated based on the courses assigned to that teacher. Does anyone have any formulas that can do it? I was hoping a lookup field would be a sneaky shortcut, but no luck. See my attached screenshots (I’ve cut off the teacher names field for privacy’s sake):

I’m using IF Statement with return numbers for two conditions: If it’s a car, one value, if it’s a motorcycle, another value. Everything is ok about that, however, when trying to multiply the presented result, it shows #ERROR!, how to solve it?

We use Airtable for Work in Progress at our golf cart repair shop. We have numbered cones that we physically put on customer carts in for repair. My goal is to limit the number of units that come in for service to 20 units. I want to create a field on the service table that corresponds to the numbered cones. So I would match a service ID to a cone number. Ideally, I would like to use a single select and once I assign “1”, I would like that option to be unavailable for the other records on that table. Right now single select will allow me to keep selecting “1” for all of the records on that table. I also tried setting up the cones a separate table and using a linked field. That didn’t work either. Open to any suggestions! Thank you in advance!

I am creating an ordering system to help distribute items between multiple stores. I would like to have the option to attach quantities to individual items in the same order. Here is my order form as it stands. You can add multiple items to the record no problem but the way to attach the quantities to the items is not sustainable. Ideally, I want to be able to attach those quantities to the items themselves. Is this possible? Thanks for any and all help.

Hi guys We have several columns including ‘multiple select’ options within and wish to combine all these columns into one. Is there a way to do this across the entire table, or do we need to manually duplicate the options and then manually go through each record to combine everything? Many thanks in advance Harvey

I have three columns in my table. Lat/Long Combined - Example: 18.194608875237545, -63.08524490907154 Latitude - Example: 18.194608875237545 Longitude - Example: -63.08524490907154 The formula I’m using in the {Latitude} column is: IF( FIND(",", {Lat/Long Combined}), LEFT({Lat/Long Combined}, FIND(",", {Lat/Long Combined})-1 ), {Lat/Long Combined} ) The formula I’m using in the {Longitude} column is: LEFT( RIGHT({Lat/Long Combined}, LEN({Lat/Long Combined}) - LEN({Latitude}) - 2 ), FIND( ",", RIGHT({Lat/Long Combined}, LEN({Lat/Long Combined}) - LEN({Latitude}) - 2 ) & "," )-1 ) When there isn’t a value in the {Lat/Long Combined} column, the {Latitude} fields are blank, but the {Longitude} column is populating #ERROR! Any help would be much appreciated. Thank you

Hello everybody! I was wondering how do I see what a form password is set to. Is there a way to view that?

Hi team! I’ve been using this wonderful formula to set a due date for something, but the issue I have is that it defaults to 12:00AM. How would I append this formula to set it to, say, 4AM? Using a formula to return the date of 1st day of last month Formulas Hi all, New to Airtable and by no means a whizz when it comes to formulas. In short, I need to create a formula that will return a date of the 1st day of last month. In other words, today (May 21st), the field should show a date of April 1st 2020. As soon as we hit June, that date should change to May 1st 2020. Any idea how I could do this? Thanks all… Thanks!

Hi All, I have multiple schools participating in multiple programs. Each program has its own form. So, we would send school A a form for program A and a different form for program B. In an attempt to make the forms as simple as possible, we are not asking the schools to select the program, rather I want to use automations to update the program name (linked) depending on which form is being submitted. For example, School A has been invited to participating in Program X. They complete the form, then the automation enters “Program X” in the linked program field. I just copied the text from the primary field of the Programs table. I set up an initial automation with the first program we have, and it worked perfectly. Then, I set up a new form for the next program, and I duplicated the automation, retested the trigger using the new form, and updated the program name for the new program. (Again, copied from the primary field.) In this case, the automation fails, indicating and when i review

I have a datetime field that includes data that’s precise to the second. I’d like to filter records based on an accounting window that’s somewhat unusual (like 2pm Thursday to Thursday), rather than just Thursday to Wednesday for instance. I saw there’s an old forum question on this, but it’s about 5 years old. Is there any update on this topic? How to filter by time not only date Dates and timezones Hi, I do have a datetime field containing,… well, date and time. I’m building a view now for a export and I need the filter to only show me certain entries prior to a special time (not only date). It looks like the filter does only take dates and not a time - at least I couldn’t find a syntax that works. How do I filter and show only entries that happened before a certain date AND time? Thanks, Frank

Hi, I am super new to Airtable scripts and I am stuck with trying to fix this error. It looks like I need to add the topLevelAwait module somewhere, but not sure where. So far what I did was to install the Hello-World app in my localhost and then replaced the contents of index.js with the contents of the [YouTube Example Script](https://airtable.com/marketplace/scraGQUFvORtvmHC5/import-youtube-analytics) since it does similar things to what I need and I would like to learn from it. The issue is that when I do a block release I am getting: ModuleParseError: Module parse failed: The top-level-await experiment is not enabled (set experiments.topLevelAwait: true to enabled it) File was processed with these loaders: * ../../../../usr/local/lib/node_modules/@airtable/blocks-cli/node_modules/babel-loader/lib/index.js You may need an additional loader to handle the result of these loaders. Any help will be appreciated, Thanks in advance!

Hello! I am hoping for some help on a problem I have. :slightly_smiling_face: I have a Projects table and the following fields: Status: a single select field that is either Confirmed, Completed, Prospective, or Declined/Did not pursue 3 Date fields for recording when the single select field changes to Confirmed, Completed, or Declined/Did not Pursue. Each with historical data I don’t want to lose. I would like the following to happen but don’t know if I can do it in a formula or automation: When the status field is updated to be “Confirmed” → Record the date in Date Confirmed When the status field is updated to be “Completed” → Record the date in Date of Completion When the status field is updated to be “Declined/Did not pursue” → Record the date in Date Declined Any assistance is greatly appreciated! I am still relatively new to AT. :slightly_smiling_face: Thanks

Hey all! I have a simple bar chart I want to show the total count (Y axis) for a given formula field. My view grouping does this very well, but when represented as X-axis in my chart, the chart app adds a parenthesis value to the label unexpectedly, growing the number of X-axis values significantly. Attached is view of values (only 7 unique values for X) and how they’re being messed with in the chart. Chart settings added as well. Any advice is greatly appreciated in advance, thanks!

Hi, I am creating an automation that will have several conditional Actions, but I can’t seem to get past the first condition. My trigger is a view, and when I test my trigger I can see the specific field I want to use in my action condition, but when I test the condition I get an error. Here are the details: The field that I want to use in my condition is a formula field and contains text, e.g. “John Doe”, and I see this value “John Doe” when examining the result of testing my trigger. The name of this field is “Account Lead” I have no actions that run for all records While setting up my first conditional action, I set my condition as “If ‘Account Lead’ is John Doe” where I select the field ‘Account Lead’ from the trigger action, and type in “John Doe”. I have also tried using “contains” instead of “is” but I get the same failed result. When I test this condition, I selected “Use input from previous steps”, and click “Test Conditions”. I get the message in red “An error occ

I am not sure if this is possible in Airtable or if it would required Zapier or other integrations (which I am open to!), but here it goes. We are trying to find a way to automatically combine and send records on a monthly basis. These people submit responses for each project they are working on, so we want to combine all of those project responses together and send them one email that has the status of all of them. In the above screenshot, we would want to send records 1-5 to Alan, 6-7 to Alison, etc. Right now we do this by hand by selecting each record, right clicking on the checkbox and then selecting the Email option. We would like to find a way to automate this process. We do not want people to get individual emails, as sometimes there are a lot of individual items, so it is important that the records get combined and then sent. I looked into the SendGrid integration, but that would send individual emails. I feel like there would be a way to do this with Airtable automations or

Hi, I have two triggers = When a record is created When a record matches some condition I want same automation script to run whenever any one of the above points are triggered. Is there any way to do this? Ex: If “New record is created” OR “Record matches some condition” → Run the automation. PS= I don’t want to create two same automations for each trigger, I want this in single automation. Thank you