List of my English courses

Help
1

Hello Guys,
I’m French. I would like to make a list of my English lessons.
I have several teachers and therefore several dates and times.
I would like to have in order :

  • Year:
  • Course date :
  • Time of class:
  • Name of teacher:
  • Subject:
  • Number of participants:

Who could help me with the dataview and METAdata?

Thank you in advance.
JPR_Project

1 Like
2

No one to help me do that? I’m new to Obsidian.

3

Someone will help sooner or later. I’m not a Dataview user.
As on all forums, it’s good practice to…

  1. Search the internet/forums for related information;
  2. Show prospective helpers you tried to solve your problem in some way (even if your code is completely wrong).
1 Like
4

I’d add that maybe adding some context regarding where the problem is/might be exactly could help too (:innocent:) …

I mean, where do you need help precisely:

  • to know how to create the underlying metadata ?
  • to determine how to link things to each other ?
  • dataview query ?
1 Like
5

I mean, I need help creating the Dataview and the METADONNEES:

TABLE WITHOUT ID
Année AS Année,
Date_du_cours AS Date,
Heure_du_cours AS Heure,
file.name AS "Nom du cours",
Nom_du_professeur AS "Professeur",
Sujet_du_cours AS Sujet
FROM #Cours WHERE !contains(file.name,"Template_cours")
6

Template Cours

Année:
Date_du_cours:
Heure_du_cours:
Nom_du_professeur:
Sujet_du_cours:

#Cours

7

Note Cours anglais

Année: 2023
Date_du_cours:
Heure_du_cours:
Nom_du_professeur:
Sujet_du_cours:

#Cours

8

Yes, I need the data view query. Thanks.

9

Thanks for your Help :

image
image1411×544 37 KB

1 Like