Share ideas, ask questions, and get feedback about developing for ProcessMaker

Moderator: amosbatto

Forum rules: Please post new questions under "Developing processes & programming" for ProcessMaker 2 or 3.
By azalea45
#783910
I am a complete newbie with ProcessMaker, Java, HTML & XML.

I am using Processmaker 2.5.2

I have a simple form that uses a few cascading dropdown's, each dropdown runs a SQL query as they filter the information.

The value of the final dropdown is needed to be passed onto a grid. In the grid is another cascading dropdown.

EG In the main form the dropdowns are as follows
1. Type of establishment - Query SELECT * from EstablishmentType
2. Area of establishment - Query SELECT EstablishmentAreaID, EstablishmentAreaName from EstablishmentArea where EstablishmentType = @@EstablishmentType
3. Nearest town - Query SELECT TownID, TownName from Townz where EstablishmentArea = @@EstablishmentArea

The value of nearest town is then passed on to the Grid Activities. The user can then add the different activities that they took part in
The dropdown that needs to be be populated in the Grid uses the following Query SELECT ActivityID, Activity from Activity where NearestTown = @@NearestTown.
I am stuck as I cannot pass the NearestTown value across to the Grid

Please help
ProcessMaker external Editor

I configured every setting, I installed the 3 re[…]

Same problem here, I've installed Process Maker Co[…]

How can i make my own plugin

I am having a great time here on this website and […]

Hi Team Seeking assistance with this 2 issues am […]