App reference with quantity

Follow
Luís Eterovick

My example is very simple... i have an app PRODUCTS which has all my problems (obviously) and the app SALES for the sales i do.
The thing is.... each sale may contain 5x of product A and 8x of product B so just referencing the product from the first app will not really help. I'd have to input all the information about the sale by regular text?

Wouldn't it be usefull to add the same reference more than once, or add a quantity to them? Is that possible?

7

Comments

15 comments

Date Votes
  • Official comment
    Sara Høeg Højlund-Rasmussen

    Hey guys,

    This is possible if you use an app for sales and an app for products -
    - Make sure to have a relationship field from your sales app to products to select product A
    - Also have a quantity field for number of products A
    - Then use the calculation field to make a sum of the total sale

    Use the same format for product B,C etc. A relationship field, a number field to quantify number of products and a calculation field to calculate the sum.

    Then you need a final calculation field to take the sum of revenue for A;B and C.

    Hope this helps?

    Here is some help on the calculation field: https://help.podio.com/hc/en-us/articles/201019358-Calculations

    You can use this to calculation numbers from related apps.

    //Sara - Podio

    Comment actions Permalink
  • Anoop Haridasan

    I would also like to know if this is possible

    0
    Comment actions Permalink
  • Alex

    bump!, i need the answer as well!

    0
    Comment actions Permalink
  • Rémi Ciron

    To solve this I made 3 apps, one for products, an other for projects and a third for the order.
    The product is the base stuff with the price / unit, the project reference the product and adds a number of products, and finally the order references the projects.

    But I agree I would need a reference quantity because I want to calculate the raw material used to make a product and if I need 3 apps to do this it'll be a kludge... I also want to track raw material usage to maintain an inventory and know when to restock.

    0
    Comment actions Permalink
  • Vikram Bhatnagar

    I have the exact same issue. I'm creating a orderplan and would like to add muliple products to one order. this can be done via Relation to my Product App. The issue i'm facing is: How can i add a quantity and price to every product which i've added to on single order.

    0
    Comment actions Permalink
  • Brian Good

    I also have this exact same problem. I need to be able to either lister the "product" several times to indicate the quantity. Separating the product into several app relations is not an efficient method.

    0
    Comment actions Permalink
  • Fabien Widehem

    Same here, it would be really useful to add quantity sold for a product.

    0
    Comment actions Permalink
  • Marcin Hinz

    Did anyone find solution for this problem?

    0
    Comment actions Permalink
  • Владимир Калитеня

    And same for me (

    Can somebody from Podio stuff help us solving this problem?

    because right now i just cannot implement this simple sales tracking crm system ...

    maybe there is some additional applications that makes possible to enter quantity of related items separately?

    0
    Comment actions Permalink
  • John Trickett

    Sara,

    This assumes that you know the number of products in a sale. In our case this can be anything from 1 to 500. What would be useful is a repeat group function.

    A selection of fields that are grouped, can be repeated and can utilise collect sum functions to calculate totals.

    John.

    0
    Comment actions Permalink
  • Brian Good

    Just checking in again.

    Will we ever just have the functionality to add the same "product" multiple times within a single relationship field?

    0
    Comment actions Permalink
  • Matthew

    Would love to see this built in as well. The products app mentioned by Sara is a useful workaround, but it definitely feels clunky and non integrated. A secondary 'quantity' field which is associated with an original text field would be great.

    0
    Comment actions Permalink
  • Lorenzo Rotteglia

    hello, 

    Is there any update on this? 

    I would need multiple times to prepare worklist, bill of materials, workfolw lists, offers etc and i imagine this as apps with reference to related products and a field with quantity (eventually calculation for prices but this is not my main point). 

    The main problem is that i need to be able to add products to the list dinamically as the number of items in the list can vary from 1 to hundreds! 

    Moreover i would need to group them in sessions and subsessions with subtotal etc.

     

    What would be a good implementation with podio?

     

    Thank you very much and keep up with this good solution!

    Lorenzo

    0
    Comment actions Permalink
  • Nick Rondle

    I'm also trying to do this now, 7 years later and no response?

    0
    Comment actions Permalink
  • Pete Cuff (BUSY)

    As per good relational database design, you are referring to a link table function. To achieve this in Podio you would need 3 apps: products, sales, and sales lines (or similar). Your sales item would reference your sales lines app, your sales lines app would reference your products app. In your sales lines app you select product and quantity.

    You could then use a calculation field in the sales app to then easily create a summary markdown table of the related sales lines app items.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post
Powered by Zendesk