Solved

Can i make ANY field searchable? - Payment proposal - Details screen

  • 26 May 2020
  • 2 replies
  • 155 views

Userlevel 6
Badge +11

Hi

 

Wondering, we have a field available to us on screen for ‘Supplier Name’ - but when I look in the search box to configure so users can search by name its not available.

Is there anything I can do to make this field searchable??

Is there perhaps an SQL expression I can use that will put the sort by name into order?

 

 

icon

Best answer by JULIAN 26 May 2020, 18:20

View original

2 replies

Userlevel 4
Badge +9

If it is not there you can create a custom field which displays supplier name based on supplier id. There definetely a function which does that. Then that field will be searchable. 

Userlevel 6
Badge +11

Nice Julian thanks - that will do the trick. My only issue would be that we then have 2 Supplier name fields on the screen. It would of the job though, can easily hide the IFS Standard column.

Reply