¿How can I count the total # of lessons?

Vaughtton · 2024-07-30T13:22:59.208+00:00

Trying to create a LMS in toddle, using Xano as a Backend. I need to get the total number of lessons in a course to show it to the user and track progress.I can't figure how to do that natively using Formulas in Toddle.My JSON is like this:id: 1,created_at: 1722335594204,Title: Introducción al No-code,Description: Descubre el mundo del no-code a través de este curso de Introducción.,Portada: {access, path, name, type, size, mime, meta, url},_secciones_cursos: [{id: 1,created_at: 1722335578035,Nombre: Introducción al Curso,Posicion: 1,cursos_id: 1,_lecciones_secciones: [2],_contar_lecciones: 2},{id: 2,created_at: 1722335587176,Nombre: Primer módulo,Posicion: 2,cursos_id: 1,_lecciones_secciones: [2],_contar_lecciones: 2}]}

Vaughtton
1 year ago
Trying to create a LMS in toddle, using Xano as a Backend. I need to get the total number of lessons in a course to show it to the user and track progress.

I can't figure how to do that natively using Formulas in Toddle.

My JSON is like this:

id: 1,
created_at: 1722335594204,
Title: Introducción al No-code,
Description: Descubre el mundo del no-code a través de este curso de Introducción.,
Portada: {access, path, name, type, size, mime, meta, url},
_secciones_cursos: [
{
id: 1,
created_at: 1722335578035,
Nombre: Introducción al Curso,
Posicion: 1,
cursos_id: 1,
_lecciones_secciones: [2],
_contar_lecciones: 2},
{
id: 2,
created_at: 1722335587176,
Nombre: Primer módulo,
Posicion: 2,
cursos_id: 1,
_lecciones_secciones: [2],
_contar_lecciones: 2}]}
Jacob Kofoed
1 year ago
If it is just an array, you can use the size formula, otherwise, if an object you can use the entries formual to turn it into an array and then use size
Vaughtton
1 year ago
Yep, secciones_cursos is an Array, and inside that array I have the _contar_lecciones that returns me the number of lessons in that section.

What I would need to to is to go through each section (can be more than two) and sum the values of the _contar_lecciones to get that total # of lessons.

How can I create that Loop?
Jacob Kofoed
1 year ago
There are a few ways you could do this. You could use a map together with flatten to create a single array with all lessons and then could the size. However, the cleanest and faster solution is to use the bit more difficult reduce formula. It accumulates a value, so in your example we start at 0 and then add the size of each lessons list to get the full lenght in the end. I've set up an example for you here https://editor.nordcraft.com/projects/mznpjead0hee/branches/start/components/HomePage?leftpanel=design&canvas-width=800&canvas-height=800&rightpanel=style&selection=formulas.sHkyKr3VUO92FOYccQeiH.formula
👍1
Vaughtton
1 year ago
That works great! Thank you 😄
Tod
1 year ago
Great energy @Vaughtton! Your continuous contribution to the toddle Community just made you advance to Community Level 1!
@Jacob Kofoed
There are a few ways you could do this. You could use a map together with flatten to create a single array with all lessons and then could the size. However, the cleanest and faster solution is to use the bit more difficult reduce formula. It accumulates a value, so in your example we start at 0 and then add the size of each lessons list to get the full lenght in the end. I've set up an example for you here https://editor.nordcraft.com/projects/mznpjead0hee/branches/start/components/HomePage?leftpanel=design&canvas-width=800&canvas-height=800&rightpanel=style&selection=formulas.sHkyKr3VUO92FOYccQeiH.formula
Pascal
1 year ago
have you more formula workflow examples? this is very helpful!

¿How can I count the total # of lessons?

Vaughtton

Jacob Kofoed

Vaughtton

Jacob Kofoed

Vaughtton

Tod

Pascal