Want to update lookup field value as null or blank based on picklist value when selected as ‘No’
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…
Have you checked out this post: http://community.skuid.com/skuid/topics/best-way-to-set-value-of-field-to-null-blank?
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’)
Hi Karen, it’s not working for the lookupfield which is dependent on picklist value.
Leave the lookup field value as blank in the builder.