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 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?

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!

Clear one username from all the User type fields challenge

4 Replies

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.
MikeTamoush
Qrew Elite
7 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
  Qrew Champion
  7 months ago
  Search & Replace is not available for User-List field types.
curevick
Qrew Cadet
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!

Forum Discussion

Clear one username from all the User type fields challenge

4 Replies

Related Content

Coping with EntraID username change

Qrew Tip: Table From Field

Snapshot Fields

Username to text field

Authentication using username/email and password