How can I mass delete info from a field in multiple constituent records?

Robert Thibault

I need to delete a mistake that was made in a field, during an import, in multiple records.

Andy G.

you can update, but you cannot (by yourself) blank out any field. you will need to ask support to do that for you. I know, i've been there.

Andy

Ryan Hagg

Can you pass it a space " "? If it needs to be null or empty then support will have to help you

Andy G.

Ryan Hagg:

Can you pass it a space " "? If it needs to be null or empty then support will have to help you

hmmm, I never tried to use space " ", as the fields I wanted to blank out were date-type. i am sure you can, though. just do a test on 1 record and you'll find out

I personally dont like " " as it will change the query logic. a space would be considered a value so you couldnt do clause "where field is blank", instead you would have to do "where field is equal to " "". it wont be easy to maintain for the long run.

Andy