Question

LOOKUP on non-primary column


Badge +6

Hi Team,

Do we have an option FSM web/Smart in show lookup on non-primary column and on clock on “OK”, primary Id need to be stamped automatically .

 

Ex:  in Task Screen  ,  UI should show only “Address name” . Lookup should on  “Address name” , if user pick one address , “ADDRESS_ID” should stamp in backend . ADDRESS_ID are generated in sequence and nothing relevant to FSM user


3 replies

Userlevel 6
Badge +26

Hi @seeda 

You can search on whatever field you want. You can create a custom lookup screen to show the relevant fields only.

For example team lookup field

Right click the lookup filed

Click lookup Seeting

 

I am not sure I understand what is “ADDRESS_ID” should stamp in backend. Can you please elaborate?

Cheers!

Badge +6

@

  • Shneor Cheshin ,  in TASK table , “ADDRESS_ID” column is there . in Task UI screen, i wanted to show only address name(using relation) . using custom lookup on address name , i can show address table, if he clicks on “OK” button, “ADDRESS_ID” column should populate . 

 

 

Userlevel 6
Badge +26

@seeda 

OK. Any questions?

Reply