Automations - appending a field automatically

[Kyle_Eastwood]

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

[Sho · Accepted solution]

Hi, @Kyle_Eastwood 

How about a third formula field like this?

IF({Status}="Order Complete",{surname} & " specified text")

[Kyle_Eastwood]

Hey @Sho 

Thanks for the help, although I'm no expert at code, so please excuse my ignorance here. As an action, do I choose run a script and literally copy and paste the above code into line 1 ? I am probably doing it completely wrong! 

I tried the above and the following error occurs : ERROR
ReferenceError: IF is not defined
at main on line 1

Thanks

Kyle 

[Sho · Accepted solution]

You just set the third field to Formula field and input this formula
Specified text also seems to be dynamic text, how is the Specified text input?

[Kyle_Eastwood]

@Sho Apologies for the slow response.

The specified text is always the same. The dynamic field is the surname field. The "Order Completed" field is selected from a dropdown. 

I have just tested the formula and it has worked a treat. A huge thank you for your help. This is really useful.

Thanks 
Kyle