Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
6 months ago
Solved

Clear one username from all the User type fields challenge

How 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 a...
field
  • curevick's avatar
    curevick
    6 months ago

    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!

MikeTamoush's avatar
MikeTamoush
Qrew Elite
6 months ago

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.

  • JimHarrison's avatar
    JimHarrison
    Qrew Champion
    6 months ago

    Search & Replace is not available for User-List field types.