Share
Reporthi Expert
i have following UI where i enter the client id to bring the value from the two SQL db
get the value in client name using following code
If(ClientID2.Text<>"" ||ClientID2.Text=Blank(),
If( LookUp(CLIENT_INFO,Source_Client_ID= ClientID2.Text).Client_Name<>Blank() || LookUp('crna.tbl_client_policy_raw','Source Client ID'= ClientID2.Text &&'Source Country' <> "philippines" ).'Mask Client Name'<>Blank() ,Coalesce( LookUp(CLIENT_INFO,Source_Client_ID= ClientID2.Text).Client_Name,LookUp('crna.tbl_client_policy__raw','Source Client ID'=ClientID2.Text &&'Source Country' <> "philippines").'Mask Client Name'),
"No Record Found"))
over here i have to do the hard code for the client id
however i want to do the light search and display result in dropdown or the gallery.
the minimum character to enter in the search is 6 character, and display the list of list
the display list can be dropdown or the gallery item instead of textinput.
please help
Categories:
All responses (
Answers (
397
