When I a dropdown is selected in loop screen, a predefined webhook, could then be used to populate a prepopulate grid. The data pushed needs to be in a predefined form and have columns set up in the predefined grid. The case scenario considered here is large datasets: if we have a purchase order which has a large number of materials associated with it then we could select the purchase order, fire the webhook, retrieve the data and populate the grid with the columns predefined by dummy reference data.
1
Comments
Please sign in to leave a comment.
If I'm interpreting this correctly, what you're looking for is basically a way to use reference data to determine what fields need to exist in a prepopulated grid. So if I choose option A, show these fields; if I choose option B, show these fields. But all of those fields are completely specific to those options (that is, option A might have fields 1, 2, 3, 4 and option B might have fields 2, 3, 5, 6). Does that sound roughly correct? Trying to wrap my head around this one to see if there's a possible workaround. Thanks!
Sara,
That is not quite correct. What I am trying to do is increase the user experience. If we have largely sized reference data where it contains a variable that has multiple dependence then this control would allow us to first select the first level variable, which in turn would trigger the webhook to retrieve the extra information. Lets say we have purchase order P1, under which there are multiple materials (m1, m2, etc...):
P1
- M1
- M2
- M3
- M4 etc....
A prepopulated grid would be set up initially for the material items M1, M2 ....etc... properties, these have to be predetermined in the designer. Selecting the Purchase order P1, P2 etc...., would trigger a call to a determined URL which would return JSON string array of variables defined by the designer's predefined columns for the selected purchase order. I understand that this control would be unique in that it is not unique, but it does offer a way of giving access to large datasets.
Use two fields and have them nest.