Apex Code Development You need to sign in to do that
Don't have an account?
jenny jade Copy Text Value to a Lookup Field
How should I copy a text field to a lookup field
I tried doing it with workflow field update but its in vain as workflows dont update lookup field
and my next approach was process builder ,but this too is failing because since I am updating a lookup field its should update the ID not the name .
This is the error for Process builder:Error Occurred: The flow tried to update these records: null. This error occurred: MALFORMED_ID: Previous: id value of incorrect type: Mike Dan. For details, see API Exceptions.
My two fields are Previous Manager which is a text field
Previous is a lookup field
I tried doing it with workflow field update but its in vain as workflows dont update lookup field
and my next approach was process builder ,but this too is failing because since I am updating a lookup field its should update the ID not the name .
This is the error for Process builder:Error Occurred: The flow tried to update these records: null. This error occurred: MALFORMED_ID: Previous: id value of incorrect type: Mike Dan. For details, see API Exceptions.
My two fields are Previous Manager which is a text field
Previous is a lookup field
You might be thinking that by the appreance it is text filed but in the back end the reference fields are always bind with ID of a record, view layer renders the name on Page. So grab the ID of the record and update in the lookup field.
Hope it make sense to you.