Hi everyone,
I’m building an application where users need to create dynamic forms.
To address this, I developed a plugin that generates fields based on the user’s selection at registration. I use the same APEX classes, and it works quite well.
The only remaining challenge is creating a "Select" type field. Currently, I provide some pre-defined queries for the administrator to choose the data source for that field.
My question is: is it possible to create an item similar to a Popup LOV or Select One using pure HTML with a dynamic query?
In my research, I found an old package called APEX_ITEM and tried two functions, but they didn’t fully meet my needs:
APEX_ITEM.SELECT_LIST_FROM_QUERY_XL: This works, but it generates a "plain" select field. With larger queries, it triggers a small string buffer error when using SYS.htp.p.APEX_ITEM.POPUPKEY_FROM_QUERY: This also works, but it generates a field type that looks very different from the rest of my application. Moreover, I’d like to have more control over the HTML tags it generates, which this function doesn’t easily allow.
Maybe what I’m trying to do is not recommended, but I would really like to know if there’s a way to achieve this.
Thanks in advance!