Solved

Hi! A while ago I asked for help to concatenate several values together (kids’ ages) and the following was suggested by Justin_Barrett, which I am using now, thank you Justin. SUBSTITUTE( TRIM({K1 age} & IF({K2 age}, " " & {K2 age}) & IF({K3 age}, " " & {K3 age}) & IF({K4 age}, " " & {K4 age}) & IF({K5 age}, " " & {K5 age})) , " ", ", " ) However, it doesn’t seem to allow for a “0” value. Can someone advise why and/or how to modify this formula to allow for the “0” value?

Hi Novice Airtable user question - advice gratefully received. I want to create a master ‘to do list’ - which I will primarily view as Kanban - which I can both add new ‘tasks’ and also pull in items from other tables; using the status field in the other tables to then organise the master to do list. The Airtable is helping me with my professional development covering working on a new business idea, networking, job hunting, writing etc. What is the cleanest way to create a grid that has ‘new items’ and linked records? How can I pull records in from multiple other tables into my master plan and create a status field in the master document that pulls from the status fields in the separate tables? So I might have some networking activities to do, some writing to finish, a job to apply for etc - each of these are currently in separate tables? I hope that makes sense. As a note, the sub tables (job hunting, writing etc.) aren’t just about ‘tasks’ - as they serve as repositories of infor

Hello, I want to get daily summary of records from Airtable to Slack channel. I tried it by Append Entry and Schedule Digest, but it doesn’t work. I also tried instructions from your Airtable blog, but in the Record field I can’t see Use a Custom Value.

I have an attachement link that has a bunch of attachments but every now and then one of them looks like the below, but works when clicked. It seems to usually be .pdf’s. Any way to avoid this?

I want to be able to pick a value which and select some some other values which shows only values that contains values that includes values from first pick. I’ve been trying to play around with options.fields however I’m a little unsure what to put in as a fields value. I’ve tried ID’s and name values but I’m getting an error: ‘No field matching’ let filterArr = [] let filter = await input.recordAsync('Select Sender', base.getTable('Contacts').getView('Mills')) filterArr.push('rectBqFb8f8DtgRLW') let selectRecord = await input.recordAsync( 'Select a record', base.getTable(selectBase).getView(selectBaseView), { fields: filterArr, shouldAllowCreatingRecord: false } ) what do I need to pass as fields value?

I need some help editing my original formula which is: IF(IS_BEFORE({Actual Site Walk}, TODAY()), “ :white_check_mark: Done​:white_check_mark:”,IF(IS_BEFORE({Forecasted Site Walk}, TODAY()), “ :alarm_clock: OVERDUE​:alarm_clock:”,“ :running_man: In-progress​:running_man:”)) I’d like to add/change the formula to show “DUE SOON” for dates in the Forecasted Site Walk field that are within the next 14 days, but keep the rest as well. How do I do that? Thanks!

Hello everyone i am new to air table and i would like to know what is the best possible way to integrate lead routing into the system!

I am trying to adopt the summaries used in the Sales CRM Dashboard to get summaries in my Product database. I have a field that makes the category into a 3 digit number. I’ve tried linking this to a one row Summary table with no luck. It doesn’t seem to matter if I link the tables from the Cards table to the Summaries table, or vice versa. Either way, when I add the Rollup that refers to the NumAbbCalc field of the Cards table, I get nothing in the Summaries record. Somehow the connection between the tables is not correct.

Hi All, Basic question here - we have a lot of collaborators in our Account who all want to use filters concurrently. Whats the best way to manage this? Currently, I go into our table and if someone has a filter on I cannot use the system - definitely something im missing here Thanks all in advance!

Hola, tengo problemas con el login en el móvil, en la PC funciona el usuario y la contraseña y en el movil da error de sesión expirada Ya desinstale la aplicación y reinstale y el problema persiste.

All, I’m quickly learning the power of Airtable. As I am developing our base, we are creating views that group fields that are relevant to different users. When we do that, Airtable defaults to adding the summary bar with all numerical fields summed. I love the summary bar but it is rare we need those groups to be summed. So I find myself changing most fields back to “none” from “sum.” If I don’t, it provides misleading and/or nonsensical results. Is there a way to update the default summary bar option to “none?” Thanks, Matt

I am sure this is super easy, but how do you write a script to just trigger a webhook “https://hook.integromat.com/xxxxxxxxxxxxxxxxxxxxx”? Thanks for any help :slightly_smiling_face:

Hi everyone! I have been working on a general Airtable for a huge team that needs the same field to show a value called “what”. But every team calculates that value in a different way so I did a Nested IF formula that almost worked for every team but didn’t work for Content Demand Team :cry: Here is the formula I did: IF(Department="Illustration/Logos",{What}, IF(Department="Content Publishing", {What}, IF(Department="Mockups",{What}, IF(Department="Stock Photo", {What}, IF(Department="Content Operations", {What}, IF(Department="Mockups External Content",{What}, IF(Department="Logos External Content",{What}, IF(Department="Motion Graphics", IF({Motion To Publish}=1,({%Project}+{%Q&A}),(70+{%Q&A})), IF(Department="Graphic Design", IF(AND({Did SC}=1,{Did Assets}=1), AVERAGE({Assets Performance %}, {SC Performance %}), IF(AND({Did SC}=1,{Did Assets}=0),{SC Performance %}, IF(AND({Did SC}=0,{Did Assets}=1),{Assets Performance %}, IF(Department="Content Demand", IF(

I’m trying to send multi-line text through an airtable button via webhook to zapier. Zapier is picking up the text as a single line with no line breaks. How would I send multi line text? The text that is being sent across is of inconsistent length, so some records will longer and have more lines than others. Any help greatly appreciated!

Hi, I’m working on a button field that will allow one of our users to send emails to our customers. Within this table, I have a field containing customer specific URLs that we want to use within the email. My question is whether there is a way to map the hyperlink to text within the email I am formatting using the button field. I’d rather not send our customers the entire URL, it would be nice to show them something like a hyperlinked “Click Here” or something along those lines. Hopefully this is enough to go on. Thank you for all the help.

Hi, I’m using Airtable-js to build a website using my Airtable as a source. Because my table has 800 records, I’ve added a click event before fetching more pages of my table, but fetchNextPage is behaving strangely. Instead of fetching regular blocks (my page limit is 36), each request seems to be multiplied by two, thus first it works, then it returns a duplicate block, and eventually it bloats to the point of hanging. Check the code below. You can see eachPage renders more cards whenever I hit the bottom of the page. function updateTable () { table.select({ maxRecords: 800, pageSize: 36, view: "Grid view", filterByFormula: filterDefault, sort: sortDefault} ).eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { var rc = record.fields; var $dataContainer = $('#data-container'); var $cardAlign = $('<div class="d-flex align-items-stretch col-xs-12 col-sm-6 col-md-4 col-lg-2" data-toggle="modal

I.m new to Airtable. I’m trying to concatenate the nickname if the field isn’t empty or the first name if no nick name then a space then the last name. It puts NaN in the field. Here is my code in a formula field: CONCATENATE(IF(nickname="",First,nickname)+" "+Last)

Hello! I am hoping someone can help me create a formula that will calculate the date on which a child turns 7 years old. I have listed their birthday and have figured out how to calculate the child’s age today, but am unsure of how to figure this other data point I need. What follows is a screenshot of the columns. Thank you so very much for your help! ScreenshotforAirtableQuestion|448x142

Hello! I am a programming coordinator at a library, managing programming for 3 different branches with multiple different rooms. I’m trying to create a formula to pull from a “room” field into another that will formulate the “address” for the building the room is in. Example: Room X, Room Y, and Z should put Address 1 in the formula column, but Room A and B are at Address 2, Room C is at Address 3. I am able to use an IF formula to get it to work for 1 room, but anytime I try and add others I get errors. Here’s what I am working with so far: IF(Room = “HPL Program Room”, “Address 1”, “Address 2”) This will give me Address 1 for the “HPL Program Room” records, and address 2 for anything that is not “HPL Program Room.” If I try adding other conditions, I get errors. How do I add the other circumstances to the same string/formula field?

If I add a record to the table using the API, it is not displayed in the list (via the API). There are 5 records in the table. 3 out of 5 added manually, 2 out of 5 added via API. I am trying to get a list of records via the API - I only get 3 records that I added manually! Only gives 3 records via API There are 5 records in the table: Sorry for bad English

Our calendar table has a primary field of type datetime with the local format When using the API to update a link record in our bookings table with the recordId from the calendar, it is displayed in the US format A linked table shows the local format, it is just the lookup table that is wrongly presented In the picture above 3rd record we copied and pasted the date which is then the correct format Is this a bug?

I have two columns, one for USD price and EUR price. I want these prices to automatically be converted to DKK (Danish crowns), so: USD price*6.51 = DKK price or EUR price*7.44 = DKK price So, if there is a value in the USD price column, this value gets multiplied by 6.51 and the result is displayed in the DKK price column. If there is no value under USD, then it takes the EUR price instead. So far I have added this formula: IF(OR({Realized price (USD)}>0,{Realized price (EUR)}>0),{Realized price (USD)}*6.52,{Realized price (EUR)}*7.45) But this only takes into account USD price. If USD is empty it will return a value of 0 and disregard EUR price.

If there a way to write a formula that queries, basically, IF value X is in column C OR column D, then Y. I just want to be able to filter a base to show only the records where a Name appears in either one of two columns, if that makes sense. I wish the filter options weren’t by default AND, and could show all records that meet one of two filter conditions. Am I overlooking an easy way to do this? Javier

Hi, Here’s what I’d like to do. On my website, I’d like one form (Table 1) to have two fields. Twitter Handle Writing Prompt On my website, a user fills in both fields then the data gets added to Table 1 (in airtable). When Table 1 fields are filled, another table (Table 2) on the same web page will display the Twitter Handle and Writing Prompt. However, Table 2 will only show the LAST record (Twitter Handle and Writing Prompt) input from Table 1. I found this page that I thought would be helfpul: View last record only but I’m unable to make it work. P.S. I want to prevent users from adding duplicate data. I’ve added a picture to make things more clear, this is the kind of page I’d like to build. @Jacks data was input earliest. It vanishes once the next user (@elon) adds data. This would be TABLE 2. @You and “Go ahead…” would be the form where a new user would input their data. Once the user ads the data, it gets shown in Table 2.