+18How would you go about removing one Username from all the records in a table where the User-list contains that Username and still leave any other username selection untouched?
Manually, one record at a time?
Grid Edit and unselect the one Username, oh and any of the deactivated users or you can't save the record?
Export, find and replace, upsert?
Best answer by curevick
I would download a CSV with the record ID and that field and then do the search&replace through excel. Then I'd re-upload using the record ID as the merger field. Hope that helps!
+11Depends how many records it is, but if it's any more than a handful I would just export the data, change it in Excel, and import it again.
If I had a concern about having a bunch of records with the same last modified by/time, I would add a note while changing it in Excel and include that if I had a notes field.
I've never tried, but can you use Search and Replace in this records, then search for the email and replace with ""? My gut says it won't work, so my instinct says export to excel and re-import, but even that might be harder said than done, as I believe the export has the ID in <>, and it doesn't reimport nicely.
I'm thinking you make a temp formula field, UserListToEmails([Your User List Field]). Export that, find and replace the email with a blank, then reimport.
+5I would download a CSV with the record ID and that field and then do the search&replace through excel. Then I'd re-upload using the record ID as the merger field. Hope that helps!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
