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 Nameusertrue hasattanedHas attended text isattendAttendtruefalsecheckbox _now:>[date20181210]Training registration is closed.Validation rule dataset
trueisattend=trueSet valueisattend !_user:[empty] AND nominateby:[empty]nominateby=[entry._user]truenominateby=[entry._user]Set valuenominateby coursecategory:[entry.competence]Apply Filter on a fieldcompetencecourselist:21234088
NominatetwhrtrainingalltrueINLINEtruecompetencetruetrue coursetruetrue test nomineetruetrue ccidtruetrue isattendtruetrueUsers lookup is not possible by anonymous users - so, you cannot really submit this particular form... The idea of this demo is to show how to implement dependent fields and apply filter rule isattendtruetrue
|