On Etext template, is it possible to create LOV for reference within the template? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

On Etext template, is it possible to create LOV for reference within the template?

Hello,

We have a requirement to create a payment file format on Etext template. We have a field that needs to display a 3 character string that will serve as a code equivalent of a specific field.

For example:

Code Name

001 Sample1

002 Sample2

003 Sample3

So it will function like:

Select Code

from tableLOV

where Name = NameField (field from outbound payment)

I'm using sql syntax to illustrate how we want it to work, and I hope it was clear enough.

Is there a function for etext template that we can use to achieve this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!