Need help with automating year end
I would like a way to automate a process we will do at year's end each year. We have over 100 Opportunities. [Opportunity] field is a Formula Text field made from taking the [Company Name]&" - "&[Se...
Forum Discussion
I suggest making a button to manually push to roll over the Opportunities.
The button would run a saved table to table import to import the table into itself, with the only field being updated would be the Status. There would be a filter to only copy records where the Status was open (I'm not sure of what your statuses are).
Then the button would continue and next copy the table into itself to create new records.
You will probably want to make a Copy of your app to practise making a saved import and then get those imports working when run manually.
Then I can help you build a button which runs those two saved Imports.
In theory, those could also be done with a scheduled Automaton, but it would be difficult to test. I think that pushing a manual button once a year is not too onerous.
The button would run a saved table to table import to import the table into itself, with the only field being updated would be the Status. There would be a filter to only copy records where the Status was open (I'm not sure of what your statuses are).
Then the button would continue and next copy the table into itself to create new records.
You will probably want to make a Copy of your app to practise making a saved import and then get those imports working when run manually.
Then I can help you build a button which runs those two saved Imports.
In theory, those could also be done with a scheduled Automaton, but it would be difficult to test. I think that pushing a manual button once a year is not too onerous.
When you go to Import / Export off the Main Home Page or from any Table Home page, you can choose Import and then there is a path to create a saved import.