Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 08, 2024 07:54 AM
Hello,
How is this happening when there is no comma in the Lookup field? I now have to add values in my "VM Email" table for both "John Smith" and "John Smith," which is an unexpected nuisance.
Can someone help me understand how this is happening and how to remedy?
Mar 09, 2024 04:20 AM
Hm, I attempted to replicate this but everything seemed to work as expected and there was no extra comma
Could you provide a screenshot of your automation that pastes the unique values in the Rollup field into the Linked field's "Update Record" step where the data that's being updated into the Linked field is visible?
Mar 10, 2024 12:15 PM
It does work on probably 95% of my records, as you have in your test screenshot, but I'm not sure what's wrong with the other 5%.
The Rollup field formula is the simple ARRAYUNIQUE(values).
The Update Record automation step is what you'd likely expect it to be:
This procedure of copying and pasting values from one column to another via automation is something I'm well-acquainted with at this point in my Airtable journey, but this is might be the first time I'm updating a Link field with the contents of a Rollup field. I haven't seen this behavior when trying to copy any other field type into a Link field.
Mar 11, 2024 03:14 AM
That's so interesting and I'd love to poke around your base to see what was happening! If you could duplicate your base and leave only the records with the problems and DM me an invite that'd be great
No worries if that's not possible and if you ever figure out why this his happening I'd really like to know why as well!
Mar 11, 2024 06:22 AM
Unfortunately I'm unable to duplicate the workspace/base due to data privacy requirements, but what I can at least say is that the Rollup/Link fields are the only ones that think a comma exists (and the Link field is the only one that displays a comma).
Some other things I've noticed:
Mar 13, 2024 08:06 AM - edited Mar 13, 2024 12:47 PM
I can't duplicate the error:
https://airtable.com/appvR6hY4ZgTSWVVS/shriIIqar0FGP7sb1
However, you can correct it by using using the following formula in your Rollup field:
REGEX_REPLACE(ARRAYUNIQUE(values)&"", ",$", "")
&"" converts the array to a string, ",$" looks for a comma at the end of the string, and "" replaces it with nothing.
Alternatively, you can try the ARRAYCOMPACT function, which will remove empty/null values in the rollup:
ARRAYCOMPACT(ARRAYUNIQUE(values))
This behaviour has been around for a while and I'm not sure if it was identified as bug, nor what exactly triggers it. I believe it was related to empty data, but the forum search function is failing me at the moment.