Hi there dear bubblers
I am building an attendance tracking app but have issues enabling editing the data created from a repeating group.
→ on this screenshot the saved lessons are just showing to clarify the context
My use case and data types used are:
After selecting the course name in the filter dropdown, the Course List with course names and attendee names is displayed from the Course data type.
Then, after the user selects the status (icon), the attendance records are created on the Lesson data type with attendee name, course name and status.
(The field For Course on the Lesson looks up to the Course - so there is a relationship between the two data types.)
The scenario is:
Dropdown filter for data type COURSE > Name → works
RG displays attendee names from Course data type. → works
After clicking any status icon, a lesson record is created on the Lesson data type with the relevant data> works
User can click between icons and color of those icons changes → works
Here I am stuck:
When the user clicks on any icon, every time a new lesson thing is created.
I would like to accomplish that, when the user clicks a status icon, to look up for any existing lesson record first (with the selected course name, full name and date selected) and if none exists, create one.
Does anyone know how to accomplish this?
I have the following idea:
Access the status entry on the lesson from the course data type so I can say:
when current cell’s course’s lesson status is empty - create it
or when lesson data entry with course name, attendee name and date selected does not exist, create it?
I tried adding a new Lesson field on the Course data type which is a list of lessons and
tried the “only when” condition on the workflow create a thing:
Not sure why this is not working. Any help is appreciated.