Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 23, 2022 02:03 PM
Hello,
I've looked everywhere and can't find a simple solution that works for me. I have a table where I link records and I want to take the linked records field and split it by comma and input those items into it's own field.
Can someone please give me a formula to input into the columns?
Dec 25, 2022 08:00 PM
Record 1 =
Record 2 =
MID({Record ID from record ids}, FIND(",",{Record ID from record ids} ,1)+1,99)
Note the 99 character count in the 2nd formula could be replaced by another calc to get the exact length of the string but using 99 works just as well!
Dec 26, 2022 07:01 AM
Hi John_B2 I don't think this worked properly. Here's what I've inputted.
https://komododecks.com/recordings/NNvWuEBLCQPhULqzextt
The formula throws out an error and the second formula just throws out the last number instead of the second record ID
Dec 26, 2022 11:51 AM
Hi TIna
sorry my formula was for comma delimited strings but on looking again I see your field is a lookup that returns a single long string with no commas - it's a case of Airtable's "what you see is not what you get". In some ways this will make it easier to retrieve to data. It's displayed with commas but when used in a formula the commas are not there. The first comlumn will just be