2

Is there a way to suppress field prompt table validation for a particular value using peoplecode.

For example: On the page, for field A I enter value as "NEXT" (this value doesnot exist in the prompt table attached). When I save the page, if the value entered is "NEXT" I want the page to be saved.

Thanks in advance.

user7194270
  • 117
  • 2
  • 16
  • Note: I want to use the prompt with edit but only when the field value is "NEXT" it should not validate. – user7194270 Jan 31 '18 at 16:35
  • You could make the prompt table be a view which does a `union` of your actual prompt table combined with the value "NEXT" – Ben Rubin Jan 31 '18 at 23:02
  • Thanks Ben! Is it possible to do the same using peoplecode? – user7194270 Feb 01 '18 at 04:41
  • As far as I know, there's no way to do precisely what you're asking for. Once you assign a prompt table to a field, I don't think you can remove the prompt table validation. The closest thing I know of is using a dynamic prompt table, like this https://peoplesoftconcept.blogspot.com/2014/01/creating-dynamic-prompt-using-dynamic-view-in-peoplesoft.html – Ben Rubin Feb 01 '18 at 14:35
  • You can add a button that will SET the NEXT value through peoplecode.... if you do that, I think this will bypass the TableEdit – Walucas Feb 09 '18 at 16:52

1 Answers1

0

Remove the prompt table from the field on the record. Write a function that checks the value of field A and checks the table you were using as a prompt only if the value is not NEXT and add it to the fieldedit event.

Equistatic
  • 416
  • 1
  • 3
  • 8