You are viewing limited content. For full access, please sign in.

Question

auto fill new line from previous form data

Forms

Updated August 24, 2017

asked on August 24, 2017

I have a purchase order form that when submitted auto populates a receivables form during the next step of the process, however, any time the purchase order has more than one line of information, the receivable form puts all the info on one line instead of creating a new line to mirror the line from the previous PO, is there a way to tell Forms to mirror the table from one form to the next?

Purchase Order.png (50.22 KB)

| Download

Receive Form.png (22.12 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on August 24, 2017 • Show version history

Hi Mike,

You can do this by using the variable of the purchase order table.

So in this example, my purchase order table has variable "Item_Description". I put this variable into my new, "Items Received" form:

Then I edited the table to the format you showed. I kept the first three columns from the previous table (Project Name, Product Description, Quantity) and just renamed Quantity to "Quantity Ordered", deleted the currency field columns and added another field for "Quantity Received"

This is the result:

Let me if this doesn't work for you.

1 0

Question

Question

auto fill new line from previous form data

Answer

Replies

Sign in to reply to this post.