I need to set a reference field to a null value and I'd like to do it with the "Update All" functionality in a filtered list.

HugoFirst
Kilo Sage

‎09-17-2018 02:41 PM

 I need to set a reference field to a null value and I'd like to do it with the "Update All" functionality in a filtered list.  When I make the attempt, I get an error "Invalid Reference".  So, is this possible?  I can do it one record at a time in the form.

0 Helpfuls
  • 1,197 Views
2 REPLIES 2

Mark Stanger
Giga Sage

‎09-17-2018 02:51 PM

Unfortunately, you can't empty values using 'Update All' from a list.  The simplest way available is to write a quick background script if you've got a lot of records.  You could use the current list you're on and copy the query from the breadcrumb, then use '.addEncodedQuery' to grab those records and clear out the reference field values with an empty string.

0 Helpfuls

Mark Stanger
Giga Sage

‎09-21-2018 10:16 AM

Just checking on on this one.  Has this question been answered or is there more information I can help you with?  If it's been answered, please mark the answer above as the correct one so people know this has been taken care of.  Thanks!

0 Helpfuls