Controls

Re: Challenge... need advice...

Patrick Halstead — Sat, 10 Aug 2013 19:09:20 GMT

yes, you can do that with rules and xpath functions

Re: Challenge... need advice...

Tesoro — Mon, 04 Jan 2010 14:02:36 GMT

Thanks for propmt answer.

I managed to do most things. But i still have some questions.

1. I have a table with fields

Product: this field has two rules for fields code and Price - which fill up automatically (yupi :) )
Category:
Code: filled in automatically
Quantity
Price: filled in automatically
Value: cunts: Quantity*Price

I would like to have a filter box category, which when I select a field "category" for example PEN show me all the pens in the box product.

And next question: is there a way not to do a few items I mean not to establish that the position will be 10 only, but if user want to do " next field" and all rule of doubling and then at the end of the order value of the count of selected items (something like repeating table - but i dont know how to use it)

Re: Challenge... need advice...

Jimmy — Tue, 22 Dec 2009 14:26:53 GMT

You should provide a dropdown box that displays the product names but actually stores a product code. Then display the actual value of that field in an expression box next to the dropdown.

That takes care of 1 and 2. 3 a textbox for the user to edit. 4 should be a field with the default value referencing the unit price in your DB data source and filtered using the product code in 1 & 2. Then use a simple multiplication expression (my:quantity * my:unitPrice) as the default value for the value field.

You can use the sum() function to get the sum of all of the instances of a single field across repeating sections.

Challenge... need advice...

Tesoro — Tue, 22 Dec 2009 12:37:44 GMT

Description: I need to create a form to order office supplies.

Fields:

Product name ,
Product code,
quantity
Gross unit price
Value (unit price * quantity)

Source: Access table with those fields

My questions: What should be done to:

After selecting the field PRODUCT uploaded other info to other fields (such as unit price, product code, etc.). [Should I use filters and if so how to do it]
to count unit price * quantity in Value field
To counted 10 items, and gave the sum of the final contract (with the few fields of Value field)

Thank you in advance for helping.