# FR Notes personnelles et choix **URL:** \ **Category:** Ask for Help\ **Created:** [May 14, 2024, 9:44am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348 "2024-05-14T09:44:56Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 14, 2024, 9:44am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/1 "2024-05-14T09:44:56Z")
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 : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/21ff73dcd92ab3f6a8ce4e30f9d4df1fc4bdff1e.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e5d69b21adb6299c1f83698be3cd4b42bd5fd85d.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/79a827503394dcf96af671c20d02375e45f7ba9f.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/5462d0b006b9b3c18f56938587f91aecf4d253cd.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/483c7317f6a5c85a2716ca7b05b715914072b026.png) Merci d’avance pour votre aide, Je vous souhaite une très bonne journée, Lisa ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 14, 2024, 1:01pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/2 "2024-05-14T13:01:59Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/575bd613f0fd6f29e6ca3113c5220b4c58ff965a.png) pour les notes j’ai ceci et pour le contenu de l’application : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/4414308989db5bb8d8facb78f866d5a1119d5867.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9c6042f068883bcd73d30c949bcde3d1c6955ae3.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 15, 2024, 1:30am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/3 "2024-05-15T01:30:33Z")
It’s not immediately clear to me if each student and chapter combination has a unique row for it. Can you clarify this? ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 15, 2024, 7:15am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/4 "2024-05-15T07:15:08Z")
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. ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 15, 2024, 11:51am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/5 "2024-05-15T11:51:47Z")
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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b500b1066eebd78b5e1064e2aa565d7a599cbcc1.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e10299e753c2aa4e80197c7926c62dc42578cad3.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/524e133d1b4e5d53a6bcd8248ebf2a1bb9581244.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 15, 2024, 2:28pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/6 "2024-05-15T14:28:39Z")
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. ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 16, 2024, 7:28am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/7 "2024-05-16T07:28:15Z")
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 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 17, 2024, 12:10am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/8 "2024-05-17T00:10:48Z")
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. > [@Lisa\_M](#): > > 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. 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. ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 17, 2024, 8:16am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/9 "2024-05-17T08:16:32Z")
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… ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 17, 2024, 8:35am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/10 "2024-05-17T08:35:28Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/0628131587368f371bbaed7b47a8c8e11cf346f2.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac715a484523f3d6ead26fba8b4a9f6ecd008b33.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/48adf63c2d0845650b4da5affc20ee3b7f456f49.png) I did this but what is written still showing for others chapters. And it still not private ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 17, 2024, 12:53pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/11 "2024-05-17T12:53:55Z")
I did this : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7471115c4a1ef54426ca48e94f0cc8f7e661bad.png) 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… ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 17, 2024, 3:09pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/12 "2024-05-17T15:09:08Z")
I succeed to put the notes in privates !!! Now I have to do the selection by teacher and having different notes for each chapter… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 17, 2024, 11:44pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/13 "2024-05-17T23:44:19Z")
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? ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 21, 2024, 8:00am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/14 "2024-05-21T08:00:08Z")
Hello ! now, i have this : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/67c7358a1fd7b8a9496eb3f62c1c827b552ccc62.png) ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 21, 2024, 8:57am UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/15 "2024-05-21T08:57:25Z")
> [@ThinhDinh](#): > > Chapter ID \> RowID of the chapter the user is viewing. How to write this and where ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 21, 2024, 1:40pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/16 "2024-05-21T13:40:04Z")
What does the relation you show mean? Is it on the notes table or another table? > [@Lisa\_M](#): > > How to write this and where ? Inside the form to add a new note, or an action to add a new note, you can write the chapter’s rowID to that row, assuming you’re adding it in the Chapter details view. ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 21, 2024, 1:45pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/17 "2024-05-21T13:45:42Z")
> [@ThinhDinh](#): > > What does the relation you show mean? Is it on the notes table or another table? on another table ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/3/8342aca9938eadf7394f0cc9b41224afb1559ae2.png) Where for form ? What for actions ? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/24d068874e2c06c5c30ee32648b467bb00530312.png) I can’t find for row, i think I try everything ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 21, 2024, 1:46pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/18 "2024-05-21T13:46:30Z")
So can you describe how are you structuring your front end to allow users to add notes? ---
**Author:** ![Lisa\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lisa_m/32/74397_2.png) [@Lisa\_M](https://community.glideapps.com/u/Lisa_M)\ **Post date:** [May 21, 2024, 2:01pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/19 "2024-05-21T14:01:19Z")
yes, First, I have a database for all people connected. 1. I have two database, one for people who selected student and one for people who select teacher 2. I create 2 type of notes : - note for students with the component ‘notes’ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/323d9ddb77bfb110e445d7ff5f754b570c2364ae.png) - note for teacher with the component ‘form’ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1052d3e819b336ec7caa12a5c4da0b2a12d4926a.png) For the student layout, ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/319967047a7769e418ec4404b581f5ee3f8c2fec.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3c44f58015c41f18ae6444d39efaf5e455783a1.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/664a8ed4a713491433ec336723da38ae6f0453bd.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/406740c4272747489250d31b226396f258a6090b.png) And for teacher layout, ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/324df4d88909722d8668232aff93e3fb4ea90268.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39e60d7863c5d44b9f296b293d84079d94f0dc30.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ec6866c063631142de3086d06c5641035fb7551.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/07010874b9a230e9b9c2a7f07afed935a225bda5.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 21, 2024, 11:18pm UTC](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348/20 "2024-05-21T23:18:00Z")
Why do you have 2 tables for students and teachers, and another 2 tables for notes and forms? Shouldn’t you just have 1 for each purpose? [Next page](https://community.glideapps.com/t/fr-notes-personnelles-et-choix/73348.md?page=2)