Challenge... need advice... - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Challenge... need advice...

Last post 08-10-2013 12:09 PM by Patrick Halstead. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 12-22-2009 04:37 AM

    Challenge... need advice...

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


    1. Product name ,
    2. Product code,
    3. quantity
    4. Gross unit price
    5. Value (unit price * quantity)

    Source: Access table with those fields

    My questions: What should be done to:

    1.  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]
    2. to count unit price * quantity in Value field
    3. 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.




  • 12-22-2009 06:26 AM In reply to

    Re: Challenge... need advice...

     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.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 01-04-2010 06:02 AM In reply to

    Re: Challenge... need advice...

    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)



  • 08-10-2013 12:09 PM In reply to

    Re: Challenge... need advice...

    yes, you can do that with rules and xpath functions

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.