1 Reply Latest reply: Aug 21, 2013 7:20 AM by Howard (... in Training) RSS

    Create a form with selective fields from a table.

    504021d3-18d3-4550-a4ab-cc96df004e83

      Hello everybody,

      I am trying to create a form on the table but I would like to show only a few fields depending upon what a user selects from a drop down list. Is it possible to do in the same page? If so, how can I accomplish this?

       

      Thank You for your help.

      Anu

        • 1. Re: Create a form with selective fields from a table.
          Howard (... in Training)

          I have done this sort of thing with a checkbox.  The report displays an initial set of columns and then the user can check (uncheck) the additional columns to be displayed.  [This checkbox sits just above the row of column headings.]  There is a Dynamic Action for the checkbox which immediately submits -- giving the new view of the report with the "new" set of columns displayed.  Each column has a condition such as  :F1201_ROLE = 'ADMIN' AND INSTR(:F1201_COLUMN_SELECTOR,'TID') > 0.

           

          In this case, only an ADMIN can see this column and it's only displayed when :F1201_COLUMN_SELECTOR contains "TID".  The checkbox places "TID" in the selector global variable when the Ticket ID column is checked.   You could use a multi-selector to do the same thing.

           

          Does that help?

          Howard