Order Quantities and prices of same customer one record

[aminsaleh]

Hi everybody!

Again in my app which I am developing for my salespeople to use.

When a salesperson wants to get an order info as illustrated below: 

►►►

In order section he can fill multiple items like for instant (Chair, table) as in the below image.

Now here is the problem, how can he fill the quantity record based on the order record.

for example maybe 

chair 2 unit

Desk 1 unit

---------

Same question for Unit price record

For example 

chair unit price $70

Desk unit price $95  (Knowing that unit price is not fixed for all customers)

----

Total record will sum the total amount

Thanks indeed 

[Ceke]

You can't do it in this way.

1) make a new table called sales with 5 columns: Orderid,order,quantity,unit price,total order. 

2) make the ordering ref to the table nagham and select the checkbook "is a part od".

3)go in the Nagham_Form and the referenced column for the sales table.

4) Set the Sales View Inline Column Order without Orderid

5) in Nagmah table Remove columns quantity and unit price

6) in the total apply this formula :

Sum(select(Sales[Total Order],contains(sales[orderid],[_thisrow].[orderid])))

Then you'll have wat you are asking.

The result should be a inline visualisation like a table inside the form to add as many orders you wish.

[aminsaleh]

@Ceke  Taank you for your kind help

To omit any ambiguity please clear this point

2) make the ordering ref to the table nagham and select the checkbook "is a part od".

► what did you by (ordering) - no column is called ordering. did you mean order or orderid

3)go in the Nagham_Form and the referenced column for the sales table.

Did you mean the Nagahm table.

4) Set the Sales View Inline Column Order without Orderid

Please explain this.

6) in the total apply this formula :

Total of Nagham table.

[Ceke]

Sorry my smartphone has changed the text.. to do this process tou should create another table called sales.. there is a video on you tube explaining it from @MultyTech Vision

1) make a new table called sales with 5 columns: Orderid,order(set it as a enum withe the values of the enumlist ),quantity,unit price,total order. 

2) make the order id  ref to the table nagham and select the checkbox "is a part of".

3)go in the Nagham_Form and add the referenced column for the sales table.

4) Set the Sales View Inline Column Order without Orderid

5) in Nagmah table Remove columns quantity and unit price

6) in the total apply this formula :

Sum(select(Sales[Total Order],contains(sales[orderid],[_thisrow].[orderid])))

[aminsaleh]

@Ceke 

I did not get this point

3)go in the Nagham_Form and add the referenced column for the sales table.

I went to nagham table and the ref column of sales table is already here:

[Ceke]

Search un the views a view called like that table adding _form, if you don't see it go to de bottom and click show sistem visualisations and then make as I told you above  

[aminsaleh]

Hi @Ceke 
I went to Nagham_Form

from where I should add the referenced column for the sales table.

sorry for bothering you 

[Ceke]

In the column order, set the order of your form with that column