This topic is locked

dropdown box based on another field content

4/28/2009 7:07:15 AM
PHPRunner General questions
P
pjacastro author

i wonder to know if its possible have a dependent dropdown box that will be populated based on another field in the add form.
for example:

i have a field name payment that is a dropdown with the values: "Payed" and "Not Payed"

and have another field dropdown for store percentage dependent on the store field, and in that dropdown field percentage store i want to filter the positive percentages if the field payment is "payed" and the negative percentages if field payment is "not payed".
as i am newbie in php and i am trying this PHPRUNNER, if this is possible, please tell me where and what code do i need to do something like this
thanks

J
Jane 4/28/2009

Paolo,
I suppose you want to set up dependend dropdowns.

Check How to setup dependent dropdown boxes on Edit/Add pages tutorials here:

http://www.xlinesoft.com/phprunner/php-database.htm

P
pjacastro author 4/28/2009

Paolo,

I suppose you want to set up dependend dropdowns.

Check How to setup dependent dropdown boxes on Edit/Add pages tutorials here:

http://www.xlinesoft.com/phprunner/php-database.htm


hi Jane,

thank you for your answer but,
i already set up the dependend dropdown for this case on my example,
I have a dropdown field called "Payment" that as 2 values: "Payed" and "Not Payed"
In the same form i have a dropdown field called "Store" from Stores Table and another one called "Store Percentages" from Store Percentages Table dependend on the "Store" dropdown field,
in that Store Percentages Table i have positive and negative percentages for the stores
What i want is that de dropdown "Store Percentages" the negative percentage values if the dropdown field "Payment" is equal to "Payed" and the positive values if the dropdown field "payment" above is set to "Not Payed"
Thanks

J
Jane 4/28/2009

Paulo,
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this issue.

P
pjacastro author 4/28/2009

Paulo,

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this issue.


Table x
fields:

Payment - values in the payment field are only Payed or Not Payed

Store - values from stores table

Storepercentages - values form storepercentages table dependend on stores
that is allready done
is possible in the storepercentages dropdown field list the storepercentages<=0 if the payment=Payed and

list the storepercentages>0 if the payment=Not Payed
thats it

thanks in advance jane

J
Jane 4/29/2009

Hi,
I see what you're saying.

Unfortunately PHPRunner do not support dependent dropdown based on two field values.

We plan to add this feature in the next version.