Forum Discussion
There are different ways of doing this with varying complexity. If you're starting with a brand new database where you are able to start with no Tasks, then what you can do is make a summary field on the relationship where one initiative has many tasks to count up the number of Tasks. Then you look up that summary field down into the Task and then create a Snapshot Field. The snapshot field will freeze in the value at the time the Task is created. If you use this method you have to be sure that nobody, not even the admin, can delete records, otherwise you won't get duplicate task numbers.
Another level of complexity might be to have an override field on the Task sequence number so you're able to assign tasks numbers manually if you have existing Tasks or somehow the sequence gets messed up.
It would create a formula field which would use the override if present else it would use the snapshot field. The snapshot field would be made by first doing a summary maximum of that formula field and then looking up the maximum sequence number down to the children Tasks and then making snapshot of that look up field.
- HomeTownHero10 months agoQrew Trainee
Thanks Mark, The override field on the Task sequence number solution would be the route I need to take. Would you be able to provide the steps I would need to take? Thank you again.
- MarkShnier__You10 months ago
Qrew Legend
OK, the setup is a bit circular so let try the steps.
- Create a formula numeric field called [Task Sequence]. Leave the formula Blank.
- On the Relationship where 1 Initiative has many Tasks, between Create a Summary (Maximum) of [Task Sequence]. Call it [Current Max Task Sequence]
- Lookup the value of [Current Max Task Sequence] down to Tasks, but call it [Current Max Task Sequence (lookup)]
- Create a new Numeric (not a formula field, just numeric) field called [Max Task Sequence Snapshot] and at the bottom of the Field Properties set it to be a snapshot of the field [Current Max Task Sequence (lookup)]. Do not "Initialize".
- Create a New field in Tasks called [Task Sequence Override]. Set the checkbox in field properties to not treat blank as zeros.
- Go back to the formula field for [Task Sequence] and make the formula: IF(not IsNull([Task Sequence Override]), [Task Sequence Override], [Max Task Sequence Snapshot] + 1)
Try setting that all up and then we can touch base again. :)
- HomeTownHero10 months agoQrew Trainee
Hi Mark, It totally works! Your steps/guide allowed me to complete my assigned task and now I have a better understanding of QuickBase logic as well. Many many thanks Mark.