Desktop productivity for business analysts and programmers

Prompt user more than one time

Reply
Occasional Contributor
Posts: 18

Prompt user more than one time

[ Edited ]

Hello,

 

I need some help. I created a project wihere in the first part the user enter a date range and a code, the result of this, update a table with credit card numbers, this table is use to populate a dynamic prompt where the users have the possibility to select the credit cards they want and another date range to bring the info of those credit cards.

 

My problem is that when I run the project, the program prompt the user to enter all the information when the correct function of the project is firstly to prompt the user, for date range and a code and then with that result, prompt the user again with another date range and a list of credit cards generated from the previous result.

 

I tried define a cascading prompt at the stored process steps, but it doesn't work.

 

Any idea?

 

prompt2.png

Super User
Posts: 23,224

Re: Prompt user more than one time

Posted in reply to rodrichiez

Does the second prompt somehow depend on the first? That's not really clear from your post.

Occasional Contributor
Posts: 18

Re: Prompt user more than one time

Hi @Reeza

 

The second prompt don't depend on the first. But, the result is use to populate the second prompt with credit cards numbers.

Super User
Posts: 13,283

Re: Prompt user more than one time

Posted in reply to rodrichiez

@rodrichiez wrote:

Hi @Reeza

 

The second prompt don't depend on the first. But, the result is use to populate the second prompt with credit cards numbers.


 

Pretty much the definition of "depends on the first prompt".

Super Contributor
Posts: 368

Re: Prompt user more than one time

Posted in reply to rodrichiez

Maybe you can create a selection prompt and in your project check for which step is active.

Call the first selection "First step...." and the second "Second step..." or similar.

The first selection contains the prompts needed for the first step (!) and the second the prompts needed for the second (!) step.

 

You then need to check the macro variables to see which step is actually executed....

 

Could work?

Smiley Happy

//Fredrik

Occasional Contributor
Posts: 18

Re: Prompt user more than one time

@FredrikEI'm not familiarize with that: " check for which step is active." How could I know which step is active?

Super Contributor
Posts: 368

Re: Prompt user more than one time

Posted in reply to rodrichiez

I think it works like this, you need to test it Smiley Happy

When you run the first step the macro variables (prompts) in the second step are missing (or you can set a default value).

I also think that the selection prompt is a macro variable that you can chech for.

 

I think you might have some trouble to get it working exatly as you like, but you sohuld get closxe Smiley Happy

//Fredrik

Occasional Contributor
Posts: 18

Re: Prompt user more than one time

@FredrikE I've tried selection group and it doesn't work. 

Super User
Posts: 23,224

Re: Prompt user more than one time

Posted in reply to rodrichiez

I don't have EG installed at the moment, but I believe cascading prompts need a table registered in the metadata library. So you would have to register your main data.

I think this paper covers what you're trying to accomplish:

https://www.lexjansen.com/sesug/2015/172_Final_PDF.pdf

Occasional Contributor
Posts: 18

Re: Prompt user more than one time

@ReezaThis is not the same because in my case, the project need to run one time to obtain the credit cards numbers to populate the dynamic prompt from wich the user can choose in another prompt the cards he wants and after that selection the project should continue running.

Super User
Posts: 23,224

Re: Prompt user more than one time

[ Edited ]
Posted in reply to rodrichiez

@rodrichiez wrote:

@ReezaThis is not the same because in my case, the project need to run one time to obtain the credit cards numbers to populate the dynamic prompt from wich the user can choose in another prompt the cards he wants and after that selection the project should continue running.


Think about it differently. The first two prompts build the second prompt which makes it a cascaded prompt. 

The first two filters can be applied to the third one, from what i understand. 

 

EDIT: you want pages 7+ to build the prompt, the situation is not exactly yours but the problem is the same underlying issue, building a prompt off a table which has to be first registered. 

Occasional Contributor
Posts: 18

Re: Prompt user more than one time

Posted in reply to rodrichiez

I've tried all the recommedations but did not work. So I divided the project on two stored process, one for populate the dynamic prompt and another one to select from the list of cards and enter the date range. Thanks all of you the suggestions and your time.

 

 

Ask a Question
Discussion stats
  • 11 replies
  • 224 views
  • 4 likes
  • 4 in conversation