Help

Automations - appending a field automatically

Topic Labels: Automations
Solved
Jump to Solution
675 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Kyle_Eastwood
5 - Automation Enthusiast
5 - Automation Enthusiast

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

 

2 Solutions

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi, @Kyle_Eastwood 

How about a third formula field like this?

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

 

See Solution in Thread

Sho
11 - Venus
11 - Venus

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?

See Solution in Thread

4 Replies 4
Sho
11 - Venus
11 - Venus

Hi, @Kyle_Eastwood 

How about a third formula field like this?

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

 

Kyle_Eastwood
5 - Automation Enthusiast
5 - Automation Enthusiast

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
11 - Venus
11 - Venus

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
5 - Automation Enthusiast
5 - Automation Enthusiast

@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