TC-43-002 - FORMS implementation and connection
| Test Case ID | TC-43-002 |
| Author | Alena Galysheva |
| Date of creation | 13.06.2023 |
| Class | Functional |
| Type | --- |
Update history
- version 0.1 - 13.06.2023 - Alena Galysheva - test case created
- version 0.2 - 05.07.2023 - Alena Galysheva - test name fixed
Test case description
This test case verifies the functionality of the FEA-43-power-automate-emailing. The goal of this test is to verify that FORMS collects appropriate data and verifies input and that data received is handled appropriately.
Source for the test
This test is based on the following feature requirement:
- Use case: Use Case # 1 Creation of Hashes, Automated Email Generation and Delivery
- Feature: FEA-43-power-automate-emailing
Prerequisites and test steps
Prerequisites
- Ensure that the Excel sheet with the required structure for the Power Automate emailing feature is implemented.
- Prepare test data that covers various scenarios and includes entries with different first names, last names, companies, and email addresses.
- Microsoft Forms has been implemented and integrated with the Excel sheet.
- The feature implementation has passed the TC-43-001 test.
- Grant the test engineer access to the Excel sheet and Forms, allowing them to view and modify the data as needed during testing.
Test steps
| # | Action | Expected result |
|---|---|---|
| 1 | Access to the Forms is denied, preventing unauthorized users from opening it. | The Excel sheet is successfully opened, allowing authorized access to the data. |
| 2 | Attempt to open the Forms as an unauthorized user. | Access to the Forms is denied, preventing unauthorized users from opening it. |
| 3 | Review the fields in the Forms. | The Forms display the required fields as specified in the user requirements. |
| 4 | Enter valid test data into the Forms, ensuring all fields are filled and have the correct input types. The entered name should not exist in the database. | The valid test data is accepted, and all fields are successfully populated with the entered information. |
| 5 | Submit the valid data in the Forms. | The submitted data is processed successfully without any errors or issues. |
| 6 | Input test data with one or more empty fields. | The test data is accepted, and all fields are successfully populated with the entered information. |
| 7 | Submit the incomplete form. | The Forms prevent the submission of incomplete data, displaying an error or warning message to the user. |
| 8 | Enter test data with the same first and last name as an existing respondent in the Excel sheet. | The Forms accept the data, allowing the submission of entries with duplicate names. |
| 9 | Check the main table in the Excel sheet. | The main table in the Excel book contains the valid test data, with the name, email, and company data written to the appropriate columns. Entries with missing fields or incomplete data are not present, and duplicate entries are excluded. The hash value is empty. |
| 10 | Check the email account of the process owner. | There should be 1 notification of a new entry to the main table. |
End state
The Forms accurately collect and validate user data, preventing unauthorized access and ensuring the correct storage of information in the Excel sheet.
To be taken into account during test
N/A
PASS/FAIL Criteria
- PASS: All test steps are completed successfully, and the output matches the expected results.
- FAIL: Any of the test steps fail, or the output does not match the expected results.