I'm creating test data for search function in a mobile app. But the search function is little bit tricky.
Let me give an example. We have mobile app which we can buy dogs. in this mobile app we have categories of dogs.
- Guard dogs
- Senior dogs
- Service dogs
Each dog category has different search fields.
Assume I want to buy a service dog and I tap search function. then there will be a different screen with search fields. Breed, Age, Sex , Weight, Service etc. under breed we have 14 different species with check boxes. For Age we have radio buttons.
If I buy a Domestic doc it will have fields like breed,age and sex only.
So I want to create test data in an excel sheet.
How can I manage the data in a excel sheet for each category?