1. Database structure

    1. Data types

      Untitled

Data Type Fields Field Type
User Name text
Email text
Partner user
Role Role (option of admin or standard)
Question Creator user
Date date
Answers List of Answers
Categories List of Categories
Question Body text
Visible? yes/no (defaulting to ‘yes’)
Number of answers number
Approved? yes/no (defaulting to ‘no’)
Answer Creator user
Question Question
Edited? yes/no (defaulting to ‘no’
picture Image
File File
Visible? yes/no (defaulting to ‘yes’)
Answer Body text
Comments List of Comments
Liked by List of users
Modification date date
Category Display text
Visible? yes/no
Comment Comment body text
Answer Answer
  1. Date type interactions
    1. A standard user can
      • invite someone by email to join them as a partner / accept an invite
      • create an ‘Answer’ to respond to a ‘Question’ to which only they and their assigned partner can view
      • Submit a ‘Question’ for admin’s approval
      • edit & remove an ‘Answer’ they created
      • ‘like’ and add a ‘comment’ an answer
      • View & answer past questions
    2. An app admin can
      • Create (and approve), edit/delete, search for, and download questions
      • Create/ delete categories
      • Add/ edit users
      • Track analytics
  2. Pages
    1. Index
      1. Basic landing page
      2. Explains what it does & how it works
    2. Home
      1. Display’s current date & today’s question
        • data source = search for questions: filtered (date = current date; visible = ‘yes’
        • Includes repeating group displaying categories
          • data source = this question’s categories: filtered (visible? = ‘yes’)
      2. Answer section for a user to create an answer
      3. Unanswered past questions Section
        • Header sections
          • Clicking ‘Unanswered Past Questions’ title directs user to ‘past questions’ page
          • Includes count of questions unanswered by current user between sign-up date and yesterday’s date
        • Horizontal scroll repeating group showing past unanswered questions
          • Each question block includes
            • Question body
            • Question date
            • Question’s categories**:** filtered (visible? = ‘yes’)
          • Clicking on a question block leads user to the answer page
            • Data to send = current cell’s question
      4. Button to submit a question
      5. Submit a question pop up
        • Triggered by clicking ‘Submit a question’ button
    3. Answer Page
      1. Displays current page’s question’s date and question body
        • Only questions with their ‘visible?’ set to ‘yes’ can be seen
        • Includes repeating group displaying categories
          • data source = this question’s categories: filtered (visible? = ‘yes’)
        • Includes count of answers
          • data source = Repeating group’s List of Answers: count is 1: formatted as text
            • Yes: 1 results
            • No: [Repeating group’s List of Answers: count] results
      2. Display’s current page’s question’s answers created by current user or their partner
        • data source = this question’s answers: filtered (advanced: this answer’s creator is current user or this answer’s creator is current user’s partner; visible? = ‘yes’)
        • Each answer block includes
          • ‘edit/save’ icon
            • When this answer block’s ‘edit mode?’ is ‘no’
              • the feather icon type = ‘edit’
            • When this answer block’s ‘edit mode?’ is ‘yes’
          • [Answer’s creator’s first]’s answer
          • Answer date/time
          • [Answer body]
        • Under each answer block, there is a floating section for comments and likes
      3. Answer submission pop-up
    4. Past questions
    5. Account
    6. Admin portal