How can I solve it?

Need help Database
1

I do survey feature. I want to let User(user_role: designer) create his own questions and send to User(user_role:client) to fill it.

  1. To add new thing(e.g Open Question) I simply use: Create a new thing: Question

DT: Question

  • body(text)
  1. Creating a new survey:
  • Title(text)
  • from RG (data source: Questions) I choose few Questions - I set a state: state type Questions(list). Value: index’state;plus item current cells Question
  • I Create a survey

DT: Survey

  • title(text)
  • questions(list of questions)
  1. Creating an order:
  • Title (text)
  • I choose the survey from List
  • Client’s email (text) - user won’t have an account yet. Im sending to him an invitation to email. When he signs up then I display to him orders(contain current user email)

DT: Order

  • title(text)
  • survey(Survey)
  • clients email(text)

My question is: How to add answers to this questions?

I can display the questions in repeating group and under this text I add input.

What’s next…?

Zrzut ekranu 2024-02-6 o 19.19.21
Zrzut ekranu 2024-02-6 o 19.19.211920×1315 76.4 KB

Zrzut ekranu 2024-02-6 o 19.19.58
Zrzut ekranu 2024-02-6 o 19.19.581460×1232 50.5 KB

2

You will create a new datatype called Answer which has the answer text and a link to the original question.
And the survey will have a list of these answers.

You can do the same for question alternatively. Question might have a list of Answers. This way you may not need link to the original question.

1 Like
3

I do this for Sport event app

Used in Soccer club,
each forms is based on Date, User, Venue,Sport Area i had to answer only 1 question to avoid duplicate.
Answers are Text, Number or Picture.

Good Job