Solved

Hi – I may be in the wrong place, but if this is possible, am guessing it will be a script. I have a single multi-select field with 450 options like: United States, Automotive, P&L, Canada, Manufacturing My team has gone through and categorized these into 3 new fields which would be: United States, Canada Automotive, Manufacturing 3 P&L We have about 1500 records tagged in the first way. Is there a script I could run, that would redistribute those tags from the single field to the three fields, without creating new options? Please let me know if this should be elsewhere. I searched for similar requests and didn’t find this. Thank you!

I’m looking for some help in how to set this up properly. My main table has the 1st column that is an App. Table 1: App1 App2 App3 I’d like to to have another table where the main 1st column is directly linked and the same as on Table 1. App1 App2 App3 without just copying and pasting them over. I have another Table that is “Company” that has all the data on the company that created the App1 which is simple to link via relational because the column 1.

Hello Everyone, I could use some help. Ideally I would like to create a form that can easily be emailed. I have Client orders in one table, each order is linked to a customer and the products they will be shipped. On the Product table there is a Retail price and product description. I am trying to get the specific products for a customers order, price and descriptions in a long text form that can be easily copied. Thanks in advance, BH

Is there a way to count the number of times a duplicate name appears in one table and display that number in another table? For example, Minnie Mouse’s name appears 3 times in the “Billing” table and I want to output the number 3 under a column for Minnie Mouse in the “Child” table. The way my data is set up is I have 2 tables, one for “Child” and another for “Billing”. The “Billing” table keeps track of all the client with the months we billed them for, their name will appear multiple times corresponding to the month he/she was billed. This duplication is how our biller kept track of the data, by having a Jan, Feb, Mar, etc tabs in excel and the client’s name being inputted in the corresponding month tab. The “Child” table has a different set of data that can’t be combined with “Billing” I’ve been trying to understand other answered inquiries that was posted here, but my knowledge of setting up the logic statements for formulas is very elementary

View the latest field Hi, I’m totally new to Airtable and so far I’ve been fascinated by it. :smiling_face_with_sunglasses: I started doing is something that allows me to keep the daily balance of different accounts, see image, So I capture daily transactions and therefore the actual balance is the last recorded . How can you make a query or a summary, which brings me only the data of the most recent registration of the different accounts? Thank you very much for your help

Why do I get this error message when trying to link Fields both to other tables and within the same table? Are you sure you want to convert to this field type? Converting to this field type may clear some cell data from every record in the table. If the conversion causes a problem, you can press CTRL Z to undo. Thanks!

I have tables set up with Autonumber as the primary key. It’s basically my version of a CRM. I have the Contacts linked to the Company records, but it displays the AutoNum instead of the Contact name. Is there a way to choose what displays when you link records? I saw a previous topic that the recommendation was to have the AutoNum NOT be the primary key. Since there can be a number of Joe Smiths or JaneMillers in a given set of names (examples only), I’d prefer to keep the autonum to get a unique key. It would definitely be helpful to see ‘Jane Miller’ in the company record instead of ‘1’…

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)