I have created an action that copies information from a row into another table. I want this action to be hidden once it has been executed to prevent it from overwriting the row after the fact. Is there a way to do this by setting a condition that checks if the other table has the same information?
In the action's behavior settings you can add the following formula (with modifications) to the Only if this condition is true field:
NOT(IN([UniqueValue],OtherTable[UniqueValue]))
Here the [UniqueValue] is a column that is unique to the specific row. It also needs to be a value that is being copied to the second table. You might have one, such as your key column, or you might need to create one.
User | Count |
---|---|
35 | |
34 | |
27 | |
23 | |
18 |