I believe this is an automation question, but would be happy to learn any solutions!We use Airtable for a CRM that has 4 tables: City, Account, People, and Activity. (Cities have Account linked to them; Accounts have People linked to them; and People...
Hello - we use a formula field to create unique & automated "Activity Titles" for records.Our current formula pulls from various fields:Program (multi select)City (linked field)Type (single select)Date (date)Current formula is: Program & " - " & City...
Thanks for taking a shot! I had a similar experience and couldn't quite crack it. I've never dove into scripts, so not sure if I'll be able to solve it that way...
thanks, Sho!Based on your suggestion, I found an even simpler solution - added a Count field (which we needed anyway) to count how many linked fields there were - ie how many Cities participated in each record. Then took your formula (thank you) and ...
