Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
7 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
    7 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!

Denin's avatar
Denin
Qrew Captain
7 months ago

Depends 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.