You need to sign in to do that
Don't have an account?
Maria C.
QA Test Case Tracker Project
Hi all. I'm new to Salesforce but I'm picking it up very quickly and want to get started by building my first app. I want to use the challenge I have at work right now as a basis for my project. I could use your input as to what I'm going to need. I'd prefer to use Lightning builder only for start and leave Apex for later until I have a better grasp on what is and isn't possible with Lightning. This project will be for practice only and will not be used in real-world (my company doesn't even use Salesforce).
Here's the real-world issue I'm facing at work.
My company is going through a major system upgrade and my job is to test test test to ensure operations will be able to do their job after we go live. To keep track of my tests, I created a test plan in Excel and that's been my only tool. There are certain limitations I've found with Excel though which get on my nerves. Specifically,
1. I repeat tests. It's difficult to count how many tests are done and not done.
2. I skip tests. I don't do them all in the order they're written. This results in chaotic sheets.
3. It's extremely difficult to measure big picture results/performance. I thought to use formulas and VBA but once I understood the complexity it would involve, I decided it wasn't worth the time - it's easier to count it all manually (we're talking about 15 sheets, 50-200 rows each, not a simple task).
------
Here's what I have as a starting point to building an app that would replace my Excel test plan and allow tracking performance building reports, etc.
Objects needed:
CASE, TEST, ISSUE, TESTED ON (I'm unsure if I'll need this object or somehow make it part of TEST), maybe VERSION
CASE fields:
TESTED ON fields (not sure if object or part of TEST)
TEST fields:
Here's the real-world issue I'm facing at work.
My company is going through a major system upgrade and my job is to test test test to ensure operations will be able to do their job after we go live. To keep track of my tests, I created a test plan in Excel and that's been my only tool. There are certain limitations I've found with Excel though which get on my nerves. Specifically,
1. I repeat tests. It's difficult to count how many tests are done and not done.
2. I skip tests. I don't do them all in the order they're written. This results in chaotic sheets.
3. It's extremely difficult to measure big picture results/performance. I thought to use formulas and VBA but once I understood the complexity it would involve, I decided it wasn't worth the time - it's easier to count it all manually (we're talking about 15 sheets, 50-200 rows each, not a simple task).
------
Here's what I have as a starting point to building an app that would replace my Excel test plan and allow tracking performance building reports, etc.
Objects needed:
CASE, TEST, ISSUE, TESTED ON (I'm unsure if I'll need this object or somehow make it part of TEST), maybe VERSION
CASE fields:
- CaseName
- Category (picklist)
- CaseNumber
- Steps to reproduce (rich text area)
- Expected result (rich text area)
- CaseStatus (picklist)
- Existing issues: Related to ISSUE - link.
- Tests performed: Related to TEST - link.
TESTED ON fields (not sure if object or part of TEST)
- Version
- Environment
- Date (prefill to today’s date - ok to modify)
TEST fields:
- Inherit from CASE - all info - read only.
- Inherit from TESTED ON - all info - ok to modify.
- TestNumber
- Test Values (multiple fields - if I can build logic into CASE, it would be ideal)
- ActualResult (rich text area)
- TestResult (picklist)
- Notes (rich text area)
- IssueReported: related to ISSUE - link
- Name
- Priority (picklist)
- IssueStatus (picklist)
- IssueNumber
- ConfluenceNumber (text)
- Impact (rich text area)
- Notes (rich text area)
- Related to: CASE #s and TEST #s - links
- CaseName
- Category
- StepsToReproduce
- ExpectedResult
- ActualResult
- Version
- Date
- Maintaining Cases - add/edit and clone functionalities. Not allowed to delete if it’s related to an Issue.
- App for performing Tests - Make it easy to pick a case to test. Have some logic to suggest what case should be tested next. Also, need logic for starting tests over (when there's a new version out). Do I need a separate object for this? VERSION object? Need to think this over further - I could use your input. Basically, when a new version comes out, I have to start tests over. I need to track which cases are done and which are left to do and when there's a new version, I have to start with a clean slate.
- Reports and dashboards. Testing progress - % of cases tested, % of failure. Issue status tracking.
Test Tracker Professional By Merfantz Technologies Pvt. Ltd IT Management (Free)
Powerful Testing flow control for Releases and smart Defect/Bug tracking
Test Tracker Professional is to manage the core application testing, from requirements through deployment. It simplifies and organizes application testing management by providing you systematic control over the process.
https://appexchange.salesforce.com/appxListingDetail?listingId=a0N30000009wIQGEA2
It seems that you want to build you own little application with the « point-and-click » of Salesforce (like Access for Microsoft).
A free Salesforce org has just 5 mo of disk space.
With Excel, you can also develop little applications.