Help

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

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

340 0
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