Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
7 subscribers
Views
1913 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I have to fields: "Time Spent" and "Total Time". Here is my
mikec
over 10 years ago
I have to fields: "Time Spent" and "Total Time". Here is my scenario. A user wishes to have a simple time tracking system setup for tasks. He opens a record (form) and enters 3 in Time Spent and upon Closing the 3 also appears in Total Time. The next day he enters Time Spent 4 and Total Time is now 7. As you can see I want to add the Time Spent to the Total Time so they can track how much time they spend on a given task. Any thoughts? Thanks!...
OriginalPostID-75987
OriginalPostID-75987
Discussion posts and replies are publicly visible
Parents
0
Jorge Sanchez
Appian Employee
over 10 years ago
Another idea: If the form where you capture the time spent and display the "Total Time" could be a Quick Task (so it would show under "retaled actions" in the Record view) then the setup could be much easier.
As Colton said, design the form so that you have an editable "Time Spent" field and a read only "Total Time". Total time should be pre-populated from a PV storing the total time. "Time Spent" should be mapped to an ACP.
In the Output tab of the node create a custom output and set it up to:
=ac!timeSpent + pv!totalTime
and store that into the totalTime pv.
That's it! Next time the Quick task is accessed via the related actions, you will see the latest value.
Side notes: Be sure to play around with the Other tab memory options such as "Delete Previously Complete instances" to save memory.
Also, if the time spent is based on the time spent working on certain Appian Tasks, this could also be calculated automatically using the task start and completion times.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Jorge Sanchez
Appian Employee
over 10 years ago
Another idea: If the form where you capture the time spent and display the "Total Time" could be a Quick Task (so it would show under "retaled actions" in the Record view) then the setup could be much easier.
As Colton said, design the form so that you have an editable "Time Spent" field and a read only "Total Time". Total time should be pre-populated from a PV storing the total time. "Time Spent" should be mapped to an ACP.
In the Output tab of the node create a custom output and set it up to:
=ac!timeSpent + pv!totalTime
and store that into the totalTime pv.
That's it! Next time the Quick task is accessed via the related actions, you will see the latest value.
Side notes: Be sure to play around with the Other tab memory options such as "Delete Previously Complete instances" to save memory.
Also, if the time spent is based on the time spent working on certain Appian Tasks, this could also be calculated automatically using the task start and completion times.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data