Generating a Purchase Order

[Louwrens]

Good day,

I am creating a app whereby Employees request products or services to be done and when their management approves the expense a Unique PO is created and exported to a PDF.

Currently I am struggling to create a Unique PO that’s following in sequence with a Ref tables _Rownumber.

The PO I would like to create need to:

1. Get information from 2 different sheets. One being the the Branch and the other being the _rownumber.
2. I need the PO’s to follow a numerical order.
3. The action to create the PO can only take place once I have Approved the expense.

Table Structure
I have got a ORDER REQUEST FORM and a ORDER GENERATION.

Once the order is approved the Unique order No needs to be generated using.

1. A Column call Branch from the table ORDER REQUEST FORM
2. A Column for the ORDER GENERATION tablet called _Rownumber.

Is there someone able to assist?

[Steve]

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …