[edit: since posting, I’ve made an updated version, scroll down]
I shared this app elsewhere in the Fibery community, but I figured I could leave a link to it here as well, so that it might be easier to find.
Here are the type relations:
The idea is that a Test Case can be defined with a collection of named Steps (each with an Action and an Expected Result).
When the ‘Execute Test Case’ button is pressed, a linked Test Execution is created (automatically assigned to the current user and named with the day’s date). The Test Execution is created with a collection of Step Results - one for each named Step in the Test Case.
Using auto-linking to connect the Step Results to the correct Steps (based on matching the Test Case and entity names) the Step Results inherit (read-only) fields for the Action and Expected result.
Each Step Result has an editable Actual Result field, which to be filled in by the tester when the test is run, together with a Pass/Fail/TBD single-select field.
By doing all this, it’s possible to have a table view for all the Step Results of each Test Execution showing Action, Expected result, Actual result and Outcome.
I also added a bit of logic so that the overall outcome of the Test Execution (pass or fail) can be determined based on the outcomes of the Step Results, and some date comparison logic so that it’s easy to see whether a Test Execution is the latest one for that Test Case.
I designed a Vizydrop report to summarise the results, but it seems that this does not get included in the shared app, sorry :-/
Anyway, hope it might be useful or inspirational for someone. There’s obviously lots of room for improvement/enhancement, so please add your own tweaks and re-share