Form with courses: categories and sub categories
ConfiForms Form Definition |
---|
formName | courselist |
---|
registrationFormTitle | Course list |
---|
|
categorycategoryfalse[d1=Personal Effectiveness|d2=Leadership on Task/Project|d3=People Management Effectiveness|d4=Language Proficiency|]selecttrue
subcategorySub categorytext courselist
|
ConfiForms TableView |
---|
|
category subcategory |
This form uses the "courseslist" from in course field and this field gets filtered based on the "competence" selected. Competence field filters source form dataset by "category" field
LIke this
Image Added
ConfiForms Form Definition |
---|
formName | twhrtrainingall |
---|
registrationFormTitle | Nominate Training Course |
---|
|
competenceCompetencefalse[d1=Personal Effectiveness|d2=Leadership on Task/Project|d3=People Management Effectiveness|d4=Language Proficiency|]selecttrue courseCourse[21234088|courselist|subcategory|true|false|]smartselect nominatebyNominate byuser ccidCharged Cost Centerselect code as code , CostCenterDesc as costcenter from [Jarvis_portal].[dbo].[FA_CostCenter] where Code like 'TWT.%'fd0bf8518ed28044710ad678de258c1fdbdynamicselecttrue nomineeNominee Nameuser hasattanedHas attended text isattendAttendtruefalsecheckbox _now:>[date20181210]Training registration is closed.Validation rule dataset isattend=trueSet valueisattend nominateby=[entry._user]nominateby=[entry._user]Set valuenominateby coursecategory:[entry.competence]Apply Filter on a fieldcompetencecourselist:21234088
Nominatetwhrtrainingalltruetruecompetencetruetrue coursetruetrue test nomineetruetrue ccidtruetrue isattendtruetrue |