Hi 

I cannot figure out how to, if it is even possible, to update a specific field ( which is currently blank ), with specified text, which is appended on to the back of another fields data, within the same record, when a third field matches a certain condition. A bit of a tongue twister, apologies. 

For example :

I have 3 fields, namely status, name and surname.

First field :  Status 

Second field : surname 

Third field : left blank 

The first field ( status ) is populated with Awaiting order completion. The second field ( surname ), is populated with deer.  

Every time I change the status to order complete, I would like the third field ( which is blank ), to be auto populated with the second fields data ( surname ), deer in this instance, and have specified text appended. Therefore the third field should look like this : deer specified text. 

Can anyone offer any guidance on this please ? Hopefully this is not too confusing. Trying to use arbitrary values. 

Thanks