Solved

Hi, I am trying to construct a daily email to summarise data. I have all the data I need, but I cannot get the email to structure correctly. I have used HTML to make a table for the data, but when the email sends the formatting is awful. I’m looking for a way to get the table to display correctly, does anyone have any ideas? Ideally I want the table to sit in the white space with the other text I have attached a copy images to show the issue and what the raw form looks like

Hello :wave:t3: I get concatenated values from a roll-up. The result is: CotisationsONIRCP I want this: Cotisations ONI RCP (with black in between each value) I tried using this formula but it does not change anything: CONCATENATE(values)&SUBSTITUTE(“”," ") Any advice? Thanks!

I’m not sure if this is an irrational question or not, but is there a way to set up some kind of button (one) that will issue a command to run an entire base/all it’s rows ‘at the same time’? The reason I am asking this is in relation to connecting to automation software like n8n, zapier etc and reducing the number of api calls (they’re not an issue now but could be in the future). In my usage case, I have a table that sends and receives sms via n8n and Twilio. I only want to send messages in bulk on a manual basis. At the moment, I have a Checkbox Table that when checked sends the message to the user, and if I need to send to a 1000+ people I would copy and paste down the whole Checkbox select. The issue in my mind with this is that - particularly as the row count increases with more people in the future - there will become milliseconds delays between the first select and the last select, thereby firing off automations (which activate on select) at different times. Therefore - and com

Within the last hour all of the automations just stopped processing through and now have a “In Progress” for the run history. I checked the automations as there was no field values changed and the trigger never changed. Additionally, I ran a few test automations and they went through and updated the fields correctly. However, when a form is submitted the automations doesn’t process and gets stuck at “In Progress”. I can’t find anything to show it is broken on my end. Is there an announcements portion or something that maybe AirTable can state if this is more then a local issue and effecting others?

I am tracking companies, investors, and founders. It just so happens that some founders are also investors. For example: Company X - Founder A - Investor M, Investor N (also Founder C), Investor O Company Y - Founder B - Investor Q (also Founder A), Investor R, Investor C Company Z - Founder C - Investor E, Investor F, Investor G (also Founder B) I want to setup a view where people can see both (a) the Company that the Founder founded (straightforward lookup/linked record), (b) the Companies that the Founder has invested in (if any). How do I achieve this?

Hi I have a very basic base with a list of locations and their details. I would like to know if there is a way once the address is ‘clicked’ in a record it can take me to a maps product such as Google maps, etc. that will allow directions/location information? Thanks

I just connected a base to slack and I’d like to automatically message a specific employee when a customer’s credit card expires. I have a field with expiration date, another field with a formula “IF({Expiration Date}<TODAY(),“Expired”,“Valid”)”. Is there a way I can trigger a slack message when this field is “Expired”? Would I use “updates to watched record” to configure slack message? If so, how do I make my formula field a “watched record”?

Hi forum! Can anyone from the community let me know if their Airtable integration was reviewed after submitting it? We’re getting radio silence recently – just want to understand the timelines so we can plan our developer resources for this quarter. Our timeline so far: April 17: Submitted an app May 9: emailed marketplace-submissions@airtable.com asking for an update May 12: got an email from Albrey asking for changes to the integration May 16: made the changes, resubmitted, emailed to confirm changes were made June 6: emailed asking if there was an update June 16: emailed asking if there was an update June 27: emailed asking if there was an update Airtable Blocks SDK talks about a 2 week turnaround time, but it’s now been almost two months since we last heard from Airtable. Once an integration is approved, is there a similarly long turnaround time for any changes to the integration? I’d hate to be telling a customer that it’ll take 2+ months to respond to bug reports. :frowning:

Hello, I am trying to build a simple automation using Make.com (Integromat) when a form is submitted to Webflow I need to create, search and update a record. This is the workflow: I have 2 forms on my webflow website: Form 1 gets email address and IP address → Create a new record Form 2 gets a few checkboxes and IP address → Search for records that matches the IP address and update the record with the checkboxes I tried different formulas but the issue I am having is that when Form 2 is submitted all the records on my table are updated. I hope somebody can help me. Thank you. Here some screenshots from my automation.

Hi mates, I’m using a field button to open a gmail mailto URL. Everything is working well (I’m adding fields, subject, email and body) except the fact that gmail doesn’t add my signature by default as always. Is anyone facing the same problem? Thanks in advance,

I have a pretty complex string of nested IF statements that appear as bulleted items. If the string returns anything at all, I need it to display with a title at the top “Pending Items:”. If it returns nothing at all, the title should also not appear. There is no way to add the current field title into it’s own formula, so I’m not quite sure how to approach this.

Hi. I’d like to write a script where I change the formula of a formula field when a record is updated. Is this possible? I need this because I need all my values in a column to be the same date, so I configured this field to be: DATETIME_PARSE(“01/07/2022”, “DD/MM/YYYY”). But I need this date to be changed by my user through the dashboard (by editing a specific record). So I’d like to run an script that changes this formula, replacing the date part (“01/07/2022”) for the new one, picked by my user, so my entire column will get the new date value. Anyone can help with this?

Hi So I have a formula: SET_TIMEZONE(NOW(),‘Europe/London’) This should return the current time in London. However it is out by 1 hour. Currently it is 15:28 but the formula returns 14:28. Is this because airtable is not aware of British Summer Time? Can this be fixed?

Hi there! Still learning how to make full use of formulas and write more useful IF() statements. In this case, I’d like to flag tasks that should have been started but haven’t been or that haven’t been marked finished after their deadline is either today or has already passed as “Delayed” (and otherwise are “On Schedule”) Of note is that my Status field is a single-select field, so not sure if that “=” is what’s throwing this off or if it’s just fundamentally way off-base. Any help is appreciated! IF( IS_BEFORE({Task Start Date}, TODAY()) AND( Status = 'Not Started') OR( IS_BEFORE({Task Due}, TODAY()) OR( IS_SAME({Task Due}, TODAY()) AND( Status != 'Done' ) ) ) ,"Delayed", "On Schedule" )

I’m trying to write a formula that says. If {Inspection Date} is not blank and the number is greater than 730, then “No” or If {Inspection Date} is not blank and less than 730 then “Yes”. I keep getting hung up with the blank fields. This is my current formula: IF({Inspection Date Formula}!= BLANK(),AND({Inspection Date Formula}>730,“No”,“Yes”)). The output is now a 1 for NO and a 0 for Yes. Blank fields are still blank which is what I want. How do I get the 1 and 0 to say No and Yes?

Hello ! I’m looking for a solution to find the different strings in one fret and erase them in another. For the moment it looks like this: REGEX_REPLACE(Concat, Del,"")) But it doesn’t work if in “Del” I put: 8hKitchen 9hRoom And in Concat 9hRoom 10hDiner 8hKitchen 11hBathroom I would like to delete: “8hKitchen” and “9hRoom” (but it can also be of other occurrence, more or less.) Someone would have any idea ? Thanks in advance

I’ve made this datetimediff formula with two lookup values that are both formatted in the way of date with the same time zones. Lots of the values are accurate, but some values are very off… I’ve attached screenshots here for reference. The most_recent_sold_date is a lookup from a rollup value, but I would think it would still work in the formula.

Howdy, I have a database that deals with inventory for serialized items. For each item, I need to know when they have been found to be in-stock. Here’s what my setup looks like today: Records are items uniquely identified by a serial number One link-to field is Inv_Seen In which collects values each month that that item has been present for. As an example, one record will have been “Seen In: 2022-06” which means it was seen in June 2022. I manually type “2022-06” for each item. This setup is working fine, but requires a lot of typing the same exact thing over and over again Here’s my “dream” setup that I’d like help writing a script to achieve: Records are uniquely identified by a serial number One link-to field is Inv_Seen In and collects values… BUT… …There is ALSO a button field called Inv_In Stock? whose action is “Run Script”. That script will populate Inv_Seen In with “2022-06” (or whatever the month currently is. I am a-okay hardcoding the month value in the script.) for jus

Good morning! Does anyone have any idea what will happen to interfaces created for free accounts once they (the interfaces) are no longer in beta? I have a client with the Legacy Free plan and I don’t want to set them up with a bunch of interfaces unless they’re going to be able to keep having access to them. Thanks so much and rock on, Michele

I am new to Airtable. I am on free tier now. I have an extension to run a script - essentially for lookup. I am using a script for lookup as my base needs two conditions for reference and I cannot use the native Lookup functionality. My issue is that the script works perfectly for the first 15 records. The script stops working from record 16 onwards (I have total 29 records currently). To check whether there was anything wrong in records 16-29 that was causing trouble, I copied the base, deleted the first 15 records and ran the script. The script worked perfectly in the copied base on the remaining records (erstwhile record no. 15-29). I am quite perplexed. Can anyone guide me why is this happening. I checked if I had exceed the record limit. The total records across tables in my base adds up to ~600. Thanks in advance for helping

Is there a way to quickly see all of the different values in a field, similar to how you can click to filter on a column in Excel and see all of the possible options (similar to screenshot from Excel below)? As an example, I have a field that is mostly blank but has a few records with varied single line text data. I want to quickly see what those different single line text lines are to see if I want to filter on any of them, but they’re not consistent enough to make it a single select field. For another example, I have a field of various dates and would like to filter by certain dates, but don’t know all of the choices off the top of my head. Is there a way to quickly see the list of choices without creating a separate view or using a pivot table? Again, I could choose a type of ‘single select field’ but it doesn’t organize the dates nicely to see by year/month/day like you can see when clicking to filter values in Excel. Thanks!

Hi all Here is the challenge I need to solve - I track some small time investments for an investor club in companies. i.e. records are the company names (Apple, Netflix, etc.) Fields are James $ Invested and Adam $ Invested James invested $100 in Apple Adam invested $50 in Apple and Adam also invested $50 in Netflix I have a formula field that sums up the total amount invested in each company (e.g. Apple is $150 ($100+$50) and Netflix is just $50. What I would also like to do is link this to another table and have James and Adam as the Records and then show the total amount they each invested in aggregate (i.e. fields would be Total Invested, and for James it would be $100 and for Adam it would be $100) I saw this link below but it does not work for me since I have more than one field (James and Adam) linked to the same record (Apple) Airtable Support Find the sum of an entire field A core difference between Airtable and a traditional spreadsheet is tha

I got a notice from airtable. my records are over 1200. and I counted all records in each table in 1 base. (1 includes sync table from another base). my detailed questions are below. Is airtable import all records when I sync records from another base even if I filtered some records? Is there any other hidden things I need to know when I count records. I counted all current records and all synced records, but still 100 records difference between my count and airtable count.

I have 2 date columns that are only completed on some projects. I need this rolled up to show the MIN of each of these dates on another table. Arrayunique shows the value, but its not a date, its text. Any other formula like if value then min will only show 0. Essentially any time I add Min to the formula it is showing 0 because of the blank cells.

Good afternoon I am currently doing a personal nutrition project and I want to solve the following question: There is a table of products, and I want to check for a duplicate when a new record is entered, maybe such a product was already in the database I tried to do it through automation, and mark a duplicate, but automation does not work drive.google.com Untitled: Jul 28, 2022 1:10 PM.webm Google Drive file. Maybe someone else knows how to deal with entering duplicates in one table?