Upvote 1

Populate Select list with DataMaster Field names

Need Answer Mhopdyke ● ago

I want to create a Select List that shows the fields in the Datamaster. Let's say I have a Datamaster with records that has fields 'firstname', 'lastname', 'phone', 'address','country', What I want to achieve is a user can select which fields to display when the Datamaster is searched. For example, the first dropdown lists all the fields available and they select 'firstname', another dropdown lists all the fields and they select 'lastname', another dropdown lists all the fields and they select 'address'. then they can select a dropdown to enter criteria for a field: 'lastname = jones' and click 'Search'. When the results return, only the 'firstname','lastname','address' fields display for all records with lastname of 'jones'.

Replies (5)

Ria Arias ●

Hello, I am attaching an example, could you confirm if it is what you need?

Regards.

Files:

Mhopdyke ●

Hi Ria,

Thanks. This is almost exactly what I'm looking for. One question: I don't want any results to show until I click 'Search'. What do I need to adjust?

Ria Arias ●

Hello, in this case I could add an event on the screen, on page load, set the value to an element, select the data list and in the calculated value, add a constant text empty in the expression.

let me know how it went.

Regards.

Files:

Mhopdyke ●

How do I mark this as answered?

Ria Arias ●

Hello, it is not possible to mark the answer, let us know if we can help you with something else.

Greetings.