populate select box from glide record

techies · ‎01-16-2017

Hello all,

So I am creating a UI page that requires a select box to become populated with values that are stored inside a custom table. The custom table

has a column that contains a 'choices field' with several different choices. I am wondering if there is a way to get an array of these values into the

jelly script and use it in the select box. An example would be lovely too.

Thank you for any help.

Abhinay Erra · ‎01-17-2017

Here you go

<g:evaluate var="jvar_test" object="true" jelly="true">

var obj=[];

var gr= new GlideRecord('u_sales_order_ui');

gr.query();

while(gr.next()){

obj.push(gr.u_subcategory.toString());

}

obj;

</g:evaluate>

<j:forEach var="jvar_item" items="${jvar_test}">

</j:forEach>

</select>

View solution in original post

techies · ‎01-17-2017

Thanks so much for the help. The dropbox only has the option "demo" and not my choices for some odd reason.

techies · ‎01-17-2017

Well it only has one choice not all choices. Is it because I only have one record?

Abhinay Erra · ‎01-17-2017

Yes, it is because you only have one record in the table

techies · ‎01-17-2017

Sorry for the confusion. Thank's for your help!

techies · ‎01-17-2017

What I am trying to create is a select box with those choices so that when a user selects a certain choice I can create a record of it. Thanks for your help.