Double Select / Ajax Control

Applications Forms
#1

Hi! I have a situation where I have 4 fields that need to auto load depending on the criteria that is selected. The data for these fields are stored in their own tables and all have auto id’s assigned. The problem comes when there are one to many relationships that need to be displayed.

Example:

Field 1 - single select, can only select 1 item from the list. No problem.

Field 2 - double select, depending on what was selected from Field 1, using ajax I can auto load the records that are available for what was chosen in Field 1. In Field 2, however, I need to be able to choose multiple records. No problem.

Field 3 - double select, I need to be able to only show the values coordinating with what was chosen in Field 2. This creates a problem for me. There could have been multiple choices selected in Field 2. I also need to be able to choose multiple records for this field.

Field 4 - double select, I need to be able to only show the values coordinating with what was chosen in Field 3. Again, this creates a problem for me. There could have been multiple choices selected in Field 3. I also need to be able to choose multiple records for this field.

I have never successfully used the contains code in scriptcase so I’m not sure how to process this function. Any suggestions would be helpful!
Thanks!
Lisa

#2

Hello Lisa.
Basically you should hide whatever you don’t want to display when you select options on field 1, 2 or 3.

Javascript codes can do the job and scriptcase already loads jquery library, so it should be easy if you know what to do.
You can code it inside the application, you can use for example, events to code.

I hope this simple information may enlight you, sorry if I was too vague.

#3

Thanks Cavadinha for your response. I have never written Javascript codes so I’m not sure how to do this. I’ll try Google-ing it to see if I can get some sample code. Thanks.

#4

But Cavandinha, this is a great sample for Scriptcase where the advanced questions are. If Scriptcase is searching for subjects for Webinars then using javascript, tcpdf, JQuery within your Scriptcase PHP environment are great subjects for this.

#5

Hey Lisa, I thought you used to sc already, it seems not.
You should take a look at the samples project. Every most common base things in systems are displayed there.

Take a look at form49, form50 inside our samples project, there are a lot of potential learning there.

And if you have any doubts please contact our support.

You’re right Albert.
I’m not in charge of the webinars and we are still maturing them.

This idea will be discussed around here.