You are viewing limited content. For full access, please sign in.

Question

Question

Look-ups - Show more info in auto-suggest/less info in field.

Forms
Updated May 24, 2017
asked on April 24, 2017

I have a GL Code field in a table that is required to designate what account in needed.  It is set up with look-up rules to auto-suggest the code numbers.  This is working well.

During testing, it was suggested that the auto-suggest listing show the code and the description, but it should only populate the code in the actual field. 

Here is the field when I get the autofill list.  Right now, it is set up only with the code.

I need to widen (hopefully without enlarging the actual field) the auto-suggest box and display the code and description.  The field value needs to be the code only.

Any ideas on how/if I can accomplish this?

0 0

Answer

SELECTED ANSWER
replied on April 25, 2017

You are only able to display the values that will be used to fill in the field. So if you only want the code, that is what will be displayed. If you want the code and description, that's what will populate in the field.

0 0
replied on April 25, 2017

Thanks, that's what I thought, but it never hurts to ask.

0 0
replied on May 24, 2017

I have combined my GL codes and description into one column so I can get the desired view.   If I focus on the selected input itself, is there a way to truncate the data to only the first 15 characters using formulas or regular expressions without effecting the list view for the look-up?

So the view would contain something like this...

12-123-12-12345 Description

I would like the actual input to read 12-123-12-12345.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...