How to automate copy/paste from one column to another, and determine appropriate trigger?
Basically we have two workspaces. One is for project management. The other is for accounting. Once the project has been completed, we change it's status to "ready for accounting" which then automatically syncs with the accounting workspace. So no new records are being created in the accounting workspace.
We then generate a "price code" based on the company name and the product. The price code reference a price list which is a different table in the accounting workspace. I have nearly all the mechanics of this worked out, but currently have to manually copy/paste from "price code" column to "price" column (see screenshots). I'd like to automate this, but I've had trouble with the tutorials I've seen, and I also don't know what an appropriate trigger would be.
Thanks in advance for any help!
Accepted Solutions
If I were you I'd set up the trigger to be:
If "Price" is empty and "Price Code" is not empty
And the action would just be an "Update Record" where I paste the value from the "Price Code" field into "Price"
Here's an example automation:
If I were you I'd set up the trigger to be:
If "Price" is empty and "Price Code" is not empty
And the action would just be an "Update Record" where I paste the value from the "Price Code" field into "Price"
Here's an example automation:
