+2Hello,
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?
+9Record 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!
+2Record 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!
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
+9Hi 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
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
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.