How to make lookup value as null or blank based picklist value

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Want to update lookup field value as null or blank based on picklist value when selected as  'No'
Photo of Kailas

Kailas

  • 330 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
I'm not certain, but I think if you use update field on rows and set the look up field to any value that is not an actual look up value, it should blank out the field. For example, update the field to "blank" should work if I remember correctly...
Photo of Kailas

Kailas

  • 330 Points 250 badge 2x thumb
Hi Raymond, as u said field value is updating to 'blank' and the same reflecting in email notification as "Client = blank" (In email notification 'Client' value should not consider when user selects pick list value as 'No')
Photo of Karen Waldschmitt

Karen Waldschmitt, Official Rep

  • 8,240 Points 5k badge 2x thumb
Photo of Kailas

Kailas

  • 330 Points 250 badge 2x thumb
Hi Karen, it's not working for the lookupfield which is dependent on picklist value.

thanks
Photo of Sneha

Sneha

  • 624 Points 500 badge 2x thumb
Leave the lookup field value as blank in the builder.