Skip to main content
Question

LOOKUP on non-primary column

  • May 2, 2023
  • 3 replies
  • 64 views

Forum|alt.badge.img+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

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • May 2, 2023

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!


Forum|alt.badge.img+6
  • Author
  • Do Gooder
  • May 8, 2023

@

  • 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 . 

 

 


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • May 8, 2023

@seeda 

OK. Any questions?