FR Notes personnelles et choix

Bonjour,

J’ai besoin d’aide pour la création de mon application, ce qui me permettrait de la finir.

4 difficultés :

  1. Pour les professeurs, je voudrais qu’ils puissent choisir l’élève qui l’aura précédemment choisi lors de l’inscription. Cette sélection permettra au professeur d’ouvrir les chapitres de l’enseignement que pour cet élève (A).
  2. Pour la suite, pour le professeur, pour chaque notion, il pourra rentrer des notes écrites privées que seul lui pourra visionner. Il ne peut pas les partager. De plus, quand le professeur retourne au début et choisi un autre l’élève (B), quand il va sur les notions, il ne voit pas ses notes écrites précédemment pour l’élève (A).
  3. Pour les élèves, ils voient différents noms des notions, car ce sont des questions. Et pour chaque question, il peut remplir des notes personnelles et privées. Il ne pourra jamais partager ses notes.
  4. Pour tous les cas, quand la personne écrit ses notes privées dans une notion, ces mêmes notes ne se voient pas dans l’autre notion. Elles restent uniques.

À savoir, que ce soit pour l’élève ou le professeur, il y a plus de 50 notions.

Voici quelques images :





Merci d’avance pour votre aide,

Je vous souhaite une très bonne journée,

Lisa


pour les notes j’ai ceci

et pour le contenu de l’application :


It’s not immediately clear to me if each student and chapter combination has a unique row for it. Can you clarify this?

Hi @ThinhDinh !

For all students, they all have the same chapters tittles, and inside the same notions/questions too. The only thing which change is the personals and privates notes for each as they write them themselves.

And for teacher it’s the same, but they don’t have the same name for chapters and notions.

Bonjour,

J’ai réussi la création de la note.
Mais je n’arrive toujours pas à la privatiser et à la dissocier des autres notions…


image

I think you’re making it harder than it should be here.

If I understand you right, you want a teacher to have private notes for a combination of student and chapter.

Each student can also have private notes for a chapter.

If that’s the case, you can have a notes table which contains the columns for:

  • User ID
  • Chapter ID
  • Student ID
  • Notes

If the teacher is logging a note from a form, you show a component to choose the student from their list of students, plus the note itself either in a text entry or a note entry.

If a student is logging, then do the same thing, except the component to choose the student.

Create relations as needed to show the logged in user only notes they have logged for each chapter. I don’t think you need to add the step for teachers to choose a student.

Thanks !
What do you think I have to put as type for each column ?
For User ID → Row ID ?
For chapter ID → relationChapterID with chapter ID and the table where write chapter/notions ?

For Student ID → relation with the table “student’s name” ? This column is only for the notes of teacher ?

For the layout, do you think it’s easier to use notes or collection ? I prefer the visual of notes, but I know it’s possible to create a collection.

Thanks for helping me :slight_smile:

User ID > RowID of the user who is logged in.
Chapter ID > RowID of the chapter the user is viewing.
Student ID > Choice component for the teacher only, to show which student the note is tied to.

I’m not sure what you mean here? Do you mean how to show those notes on the layout? I would create a custom collection and use the notes component on each item.

1 Like

Thanks !
What I need to create action, for where people write notes ?

Probably add a new row on table notes ? But I try, and it’s still showing for every one…



image

I did this but what is written still showing for others chapters.
And it still not private

I did this :


but when I want to make USER - Make a row owner, on the layout it removes the note. Or I have to do something in the actions, but I don’t know what…

I succeed to put the notes in privates !!!

Now I have to do the selection by teacher and having different notes for each chapter…

Do you absolutely need to have the row owner in place? If yes, write a user email instead of the user ID and put the row owner on that column.

Can you show us what you have on the front end now?

Hello !

now, i have this :

How to write this and where ?