I’m trying to update a multiple select field based on info from an api. There’s 30 some values that will either be Yes or blank. If it’s yes, its works fine and puts the correct value, but gives an error if it tries to add nothing to the multi select...

How could I use a script that does this to update two fields in my table? IF(FIND(",",{Name}),TRIM(MID({Name},SEARCH(",",{Name})+1,500))) I know it works fine as a formula but I don’t want a formula field since I want to link the email to another tab...