Recored orders in Excel sheet from original Excel data file

[Eng_Ivan]

I would like to Create simple app that record all the orders i make it from Excel file to another Excel sheet file so i can see the output orders in excel sheet ,i did Behavior to copy the rows from first table and put in second table which is the output, i miss the orders number and how re order same product multiples times and see that in my second excel sheet .please advice

[Steve]

Eng_Ivan:

i miss the orders number and how re order same product multiples times and see that in my second excel sheet

What does this mean?

[Eng_Ivan]

i mean i don’t put order number yet,any idea how i put random numbers automatically,

[Steve]

I’m afraid I’m still not clear.

You can generate a random number with RANDBETWEEN():

help.appsheet.com

RANDBETWEEN()

Random integer from range

You can generate a random identifier (for a row key, e.g.) with UNIQUEID():

help.appsheet.com

UNIQUEID()

Pseudo-unique ID

[Eng_Ivan]

Thanks Steve, did i need to put order number in first table ?and any time i order that product ,i can see the hole raw in second table ,

[Steve]

Eng_Ivan:

did i need to put order number in first table ?

I have no idea. You haven’t provided nearly enough information for me to know.

Eng_Ivan:

i can see the hole raw in second table ,

What does “hole raw” mean?

You might want to consider engaging an AppSheet partner for help. I suspect your needs are greater than what i’m prepared to help with here in the community.