Lookup popup , using all column values

Radzen Studio Angular
1

Hi,

When using the Lookup popup on a Edit form I want to have access to all the included columns of the lookup popup grid.
This is posible if you leave the value property of the field empty so the event property includes all the values of the grid. The problem is that you can not initialize the popup with the id value from the database.
e.g.:
lookup popup shows 3 columns : ID, Name , Orgnr
I want to select a row and also use the Orgnr to patch to a form field value.

hope you can help . this will inprove data input quality a lot .

k.r.
Mehmet

2

You want to use the entire item in Change event of the DropDownDataGrid? Since you have the selected id you can easily find the item from the array bound to Data.

3

I'm struggling with the syntax : so instead of ${event.value}.Orgnr I have to use ${data.Orgnr} ? in the change event of the patch ?
And initiating the DropDownDataGrid on the edit form with the value retrieved from database on page load ? how is this done ?

4

I'm not sure what exactly is your setup however here is a standard edit CRUD page generated from Radzen with DropDownDataGrid:

Init from database:

image
image1920×1080 147 KB

Change will produce the entire item in ${event}

image
image1920×1080 125 KB

image
image1920×1080 130 KB

5

perhaps different when using the standard form , I'm not using the template form.
any pro's or con's on not to use the standard Forms ?

6

No cons, just pros. You have access to all form components, their properties and events. Converting normal Form to TemplateForm is a single click - both forms share equal features.

7

I see,
Perhaps it is best to start with using template forms with more complex projects.
Thank you for your support.