Checking and setting fields using automation

Andy Tran_xwzehx

I'm attempting to expand on an automation that I have where, when Field A = 123, it sets two other fields with similar values.  However, since this is a one way automation where you need to fill out Field A first in order for the automation to work,  I need to adjust it where, if any point, Fields B/C are populated first, and the other fields are populated in a similar way. 

Example:

Field A

Field B

Field C

Current automation - User adds value "123" to Field A and Field B and C get populated with "123" as well.

 

Attempting to do:  User adds "123" to any of the Fields A, B, or C, if those other fields do not already have "123" (including empty), then it gets filled in.  

 

Gaurav Arora_0be8uc

Hi @Andy Tran , Greetings!

To synchronize the values across all three fields, I recommend the following:

1. Include all three fields in both the automation trigger and the edit field action.
2. Implement a smart value condition to prevent accidental removal of values from other fields when a value is removed from one field. This condition can be adjusted or removed based on your specific requirements.

This setup ensures that any changes made to one field are automatically reflected in the other two fields, maintaining data consistency.

If you find this suggestion helpful, please accept the answer so that others can benefit as well!

Best regards,

Gaurav