LinkedIn
Twitter
Since I am using Google translate to try to understand your question and I know that EQUIPOS could mean both Teams and Equipment, I am not sure of your actual data structure.
But, my basic understanding is that you want to know how to update a column value in one table based on a change in value in another table.
There are a few ways:
-
If your tables are setup with a Parent/Child relationship (see more below), you can reference the Parent from the Child OR reference the Child from the Parent using “dot” notation. In this way, the column that needs updated based on changes can implement a formula to determine the resulting value using the other table’s values.
-
When saving the changed row, you could attach a “Form Saved” action that can transition to an action to your target table (where the column to be updated lives). This also requires some link between the two tables such as a Ref column. You will find the “Form Saved” property in the Form definition itself at the bottom under the Behavior section.
- Similar to 2), you could implement an Automation process that detects when the source row changes and then transitions to the target table to apply an update.
To find more on Parent/Child relationships, refer to this article and scroll down to the section “Expressing Ownership Between Tables”:
Please post if you still have questions.
