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?