Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Oct 02, 2021 11:27 AM
hi
i need help counting a field with multiple values separated by a semi -colon. This column catches data from jotform, which is a multi-select field.
Oct 02, 2021 01:07 PM
Are you trying to count the number of items in the text field? And items are separated by a semi-colon?
Try this formula:
IF(
{fieldName},
LEN({fieldName}) - LEN(SUBSTITUTE({fieldName}, ";", "")) + 1
)
This formula uses the trick of replacing the semi-colons with nothing and then comparing the length of the text string with the original length to determine the number of semi-colons. Since semi-colons are only in between values, you have to add one to the number of semi-colons to find the number of items.
Oct 04, 2021 04:30 AM
The incredibly clever lengths we go to lacking a Split() function. I’m seriously impressed and dismayed at the same instant.