Help

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

Re: Automatically copy a value to another record

901 0
cancel
Showing results for 
Search instead for 
Did you mean: 
philipp
4 - Data Explorer
4 - Data Explorer

 

Hello,I have been using Airtable for a long time - but am new to the community. Nice to be here! 🙂

I would like to copy a value in a cell to another record when a condition is met.

(The image as an example)

If a product (e.g. product 1 in group A) gets a value in attribute B (checkbox), the value in attribute A should be copied from product 1 to all other products in the group.

CleanShot 2023-01-26 at 16.01.31.png

Is this possible through automation?

Best regards
Philipp

 

1 Reply 1

Hi,

you can recursively update value and checkbox as conditional action when "Find records" (same group, field A is empty) array length > 0. To get a single ID from array, use this approach, for example.

Note it will cost one automation run for each updated value. If you need to do it in a single run, you should apply scripting step with filtering.