Hello, I am trying to create an app to control trainings in my company. This will be the structure. Employee Table: This table will contain the following columns: Employee ID, Employee Name, Employee Function… Training Table: Training ID, Training Name, Training Description and some other column…

Here is the way: check the first checkbox of the range you want to select; hold SHIFT and click on the last cell of the range; press Ctrl+D (on Windows / Linux), which means “Fill selected range with the value of the first cell”. Other shortcuts here . [Capture vidéo du 2023-01-25 23-54-28(1)]

Hello, that would be easy to accomplish with the ActionButton (custom widget). There is some help about that in this forum. See this post, for example: [image] Action Button Info Ask for Help I couldn’t find a public example, so created one here: Student Grades - Grist . …

While this ALMOST go as far as I need, and it’s a very similar example, the number of records that can be added is always the same: Total Number of Students - Number of Students already selected. So for an exam with 0 students in the Exam Grades Table, the buttom will read 5. If I manually add two …

That sounds like an interesting function, but I think it is not posible yet. Another solution, would be to filter the employees by funtion, but you have to change the Structure a litlle and ActionButton code for that. If you keep reading the posts after the one I sent you, there will be a solution …

Actually, I was able to do just that. Just added a SELECTED column to the Students table… and changed the Action Button Code actions = [] existing_grades_students = set(Exam_Grades.lookupRecords(Exam=$id).Student) for s in Students.all: if s not in existing_grades_students and s.selected: act…

The only part I am still missing for this to work like I want, is to CLEAR the select buttons after I click to add the students (employees in my app) After all, I want to add two bricklayers out of 10. I select those two and add. Then I select another Exam (Training). Like Excel. I want the secret…

Yeah, my whole problem is in how to update the existing records to unselect them. UpdateRecord, Update… nothing works and more than that, they make the whole button not work. actions = [] existing_grades_students = set(Exam_Grades.lookupRecords(Exam=$id).Student) count = 0 for s in Students.all: …

For such cases, a bit complicated, would you please have a public sample on docs.getgrist.com ? It would make it easier to investigate.

Of course. How should I proceed?

If your document is already on docs.getgrist.com and doesn’t contain sensitive data, you may add Public Access (by clicking on the share button); otherwise, you could duplicate it (share button also), checking the option to include structure without data, then share the link to the copy.

It’s already public, because it is another public document that I started messing around https://public.getgrist.com/kS2cFNKm2JpF~kPhHquBRWGiDNFLnYkJ67D~24732/Student-Grades/p/1

"Training Control" app: help with table structure

Ask for Help

Paul_G_Janzen January 25, 2023, 11:58am 2

Hello, that would be easy to accomplish with the ActionButton (custom widget). There is some help about that in this forum.
See this post, for example: