Regarding Value Prompt

[dipstm]

Hi,
I want to dynamically display the values for a value prompt based on the customer number.For different customers, the drop-down list has different values dynamically. Can anyone please provide a workaround for this.

Thanx,
Dipstm

[blom0344]

That should not be a workaround but a cascading prompt. The first one accepts the customernumber and a second one uses the selected value of the first. Check on how to build these cascades..

[dipstm]

Hi,
I will not be using cascading prompts. Actually there is one column in a table and the values populated for the drop-down of value prompt depends on the value of this column.For eg, if the col(value)=1 then display 1,2,3,4,5,10 in the drop-down and if col(value) =2 then display 1,2,3,4,5,10,30,60 and etc.
Is it possible to achieve this kind of functionality.

Regards,
dipstm

[almeids]

It sounds like this would best be done with cascading prompts as suggested.  Please describe specifically the functionality you want to achieve (step by step what you would want the user to see and do) and perhaps we can help.

[Suraj]

>>Hi,
>>I will not be using cascading prompts.
Why is that?
Your problem as suggested by almeids should be resolved by cascading prompts assuming that you use that properly.

[dipstm]

Hi,
As I said previously, there would be one column say for example 'exp' against each customer in the database table.Now,suppose customer A logs into the portal and for tht customer the value for 'exp' is 1 then the  value prompt of the prompt page should display only values like 1,2,3,4,5,30. Now ,if customer B logs in and if for tht customer the value of 'exp' is 2 then the value prompt of the prompt page should display only values like 1,2,3,4,5,30,60,90 and so on.For different customers, the value of 'exp' in the table is different and so as the values to be displayed in the value prompt drop-down.
Plz let me knw if you need for clarifications.

Thanx,
Dipstm

[blom0344]

One solution is to create a stationary table that you fill with a customer-dependant fill-script.
For each customer contents of the table will store their own set of data. This will work fine as long as the data does not need regular updates..

[Suraj]

Think about using prompt macros that can grab user or group id and depending upon that filter the prompt values.
If you have only few users, this will work fine, but if you have thousands of users then it'll be very cumbersome.

[almeids]

You should use a macro to identify the customer and retrieve the appropriate 'exp' value from the database.  You haven't mentioned though whether the prompt values you want to display also exist in the database.  If they do, then use the exp value in the filter for your prompt to populate it accordingly.  If not, you may have to create multiple static prompts and conditionally hide the ones that aren't appropriate for the user.  I'm not sure what this implies regarding your ability to make the prompt optional or not, and as Suraj suggests is potentially cumbersome to implement and maintain.  You'd be better off getting the customer/value associations into the database.