Both values come from the same database（Sample_Employee）. Among them, Enter a value (name) in [ Input_SelectedEmployee ] and want to retrieve another value (phone) from the database (Sample_Employee).
I know how to do the form of List, but I don't know how to do the form of input. Could you please teach me?
Hi @Ren Xiaorong ,
I have updated your oml, you need to add input onchange event and some filter on GetEmployeeDeatail.
Hope this will help you.
Thank you for your reply. I understand. Thank you very much.
What should I do if I want to save the values in the selected list to the database?
Without adding any save buttons, directly select the data in the list, and then save the data directly to the database.
Hi @Ren Xiaorong
I didn't opened you OML but If you mean by selected list is Dropdown then in OnChange event handler of your dropdown use UpdateSample_Employee entity action and pass the form data as a source.
I hope it'll help you.
ThanksDeep
I want to put the data selected in the list into a new SaveData table instead of directly updating the Sample_ Employee
Okay, but your SaveData entity has only 3 columns Id, FirstName and Phone, In this case if you want to update record here then you must be known its Primary Key Id, then you can update it else you can insert new record,
Also if you want to update split record then click on + icon before source and it'll open a prompt like this -
If you have these all data available set the values here.