# How to create an app for taking Sales Orders

**URL:** <https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048>\
**Category:** Ask for Help\
**Created:** [April 14, 2020, 2:55pm UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048 "2020-04-14T14:55:07Z")\
**Posts on this page:** 1\
**Showing post:** 18

<div class="post-metadata">

**Author:** ![Mariano\_Betta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariano_betta/32/17895_2.png) [@Mariano\_Betta](https://community.glideapps.com/u/Mariano_Betta)\
**Post date:** [April 26, 2020, 12:22am UTC](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048/18 "2020-04-26T00:22:52Z")

</div>

I managed to get an id to send each product.  
Your recommendation helped me, I’m not sure if I did as you tell me, but it was based on your idea.  
In the products table I already had the trade in each row, so I only had to add the mail, concatenate it to control with the confirmed table. While I succeeded, I had to make multiple columns in the editor. Surely there is a simpler way, but I’ll show you to see.

1. In the spreadsheet I entered the word name to all the products, to relate it to the user.  
Already in the editor
2. A relation column to get the mail.
3. A vlookup column to get the mail again, otherwise I can’t find a way to concatenate it.
4. A template column to link commerce and mail.
5. A relation column to join with confirmed orders
6. A vlookup column to find the number of times that mail and trade are in the confirmed orders table.
7. A template column to join Commerce & mail & count

I show you the link:

> **[25-4-2020.mp4 (video)](https://drive.google.com/file/d/12nnv7ZOLfy_W9dguHWi-77DI2cc9K21G/view?usp=sharing)**
>
> Google Drive file.

It works, it takes a while for the order to arrive and at this moment the internet works slowly, I would have to use a total in the data editor and also make several changes to optimize the application and reduce formulas. But I wanted to test that logic and it works. I am missing many things, but it is the basis for taking off.

---

_[View the full topic](https://community.glideapps.com/t/how-to-create-an-app-for-taking-sales-orders/7048)._