Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Copy values from one field to another field without using formula or rollup

Topic Labels: Automations Data Extensions
405 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Thanveer
4 - Data Explorer
4 - Data Explorer

Greetings Everyone,

I would like to know if I can copy values from field to another field automatically without using formula or rollup.

I have attached the screenshot of my table for your ref. I need to copy the values from the original fields to the helper fields automatically.

Please advise.

Regard,

Thanveer

1 Reply 1
DisraeliGears01
6 - Interface Innovator
6 - Interface Innovator

Why won't formulas or rollups work? Are the helper fields in a different table or base from the originals? 

Regardless, you could build an automation for this... Assuming it's the same table, make a view only showing records where volume, revenue, and cost aren't empty. That's your automation trigger. When a record enters that view it updates to fill in those other fields with the original field information. Same thing would basically work for a different table in the same base, if it's different bases then you need a different approach. 

EDIT: You could cut out the view middle man and use "When record matches condition" too as the trigger