Add new data to a previous list of things - how to

Need help Database
1

Hei guys the situation is this

Objective
I want to add to a previous list of answers of a survey other new answers that the user have made in a second time (if not clear the example hope will clarify)

First Survey
First Survey1509×59 11.5 KB

Survey 2
Survey 21509×59 13.9 KB

Database
I have created in my DataBase:
Answers

  • Answers first round (text) (List of things) → field 1
  • Answer second round (text) (list of things) → field 2
  • User (User) → field 3 → it’s linked to the User data type

User

  • name → field 1
  • surname - > field 2
  • Answer (answer) → field 3 → it’s linked to the previous data type

Example
1 step:
Let’s have the example that one user is doing the survey for the first time answering the only two questions in the survey. In the db there will be the
Data type: Answers
Data field: Answer first round → there will be the two different answers separeted by a comme (example - fish, elephant)

2 step:
Let’s have the example that the same user is doing the survey for the second time answering the same two questions in the survey.

I would love to have such end output:
Data type: Answers
Data field: Answer first round → there will be the two different answers separeted by a commea (example - fish, elephant, dog, cat)

Question
Is it possible to add to a previous list other new information?

P.s. I don’t want to modify the old answers with the new ones but I just want to add the new answers to the old answers.

2

Sure, just Make Changes To A Thing, select the relevant List field and use ‘Add’ to add a new thing to the list.

1 Like
3

Yup, magic! Thank you