I have a situation where I would like to display a grid widget associated with a particular type of data but I don't know what that type is until the user selects a particular row in an existing grid. Once they select a row, I want to show and filter a widgets based on the value of a field in the source row.
For instance, if the row has a field named MYTYPE and the value is 'A', I want to open and filter GridA based on the values of the other fields in the source record.
Now the user selects a different row where the MYTYPE field has a value of 'B'. I then want to open and filter GridB also based on the values of other fields in this new source record.
The data in GridA and GridB come from two separate data sources and are not something I could easily combine into a single SQL union query. I figure there has to be a way to do this using Execute Scripts but I have a hard time tracking down the specific calls I'd need to make in the Javascript setting.
For instance, if the row has a field named MYTYPE and the value is 'A', I want to open and filter GridA based on the values of the other fields in the source record.
Now the user selects a different row where the MYTYPE field has a value of 'B'. I then want to open and filter GridB also based on the values of other fields in this new source record.
The data in GridA and GridB come from two separate data sources and are not something I could easily combine into a single SQL union query. I figure there has to be a way to do this using Execute Scripts but I have a hard time tracking down the specific calls I'd need to make in the Javascript setting.
Comment