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

Question

How do I copy a field value from a table to a single line field on the same form?

Forms

Updated June 20, 2017

asked on June 20, 2017 • Show version history

The attached example shows what I am trying to accomplish. I would like the Part Number value in my table row to populate the Part Number single line field on the same form.

Any suggestions?

copy example.jpg (37.6 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on June 20, 2017

In that case, let's go with this formula instead using the Index function:

=INDEX(TableName.Variable,1)

If using the same variable as I did in my last reply, this would look like this:

1 0

Replies

replied on June 20, 2017

Hi Jason,

To clarify, would this include multiple part numbers depending on how many rows are added to your table? If so, you can accomplish this with a pretty straightforward calculation.

In the Calculation section of the Advanced tab of your Part Number single line field, you can insert the Part Number table variable from the token picker, and that should list out all part numbers with a comma in between. See example below:

0 0

replied on June 20, 2017

Most of the time there would only be one row and hence one Part Number. If there are additional rows, the part number value would be identical to the first. Is there a way we can configure the single line field to only show the first part number from the table?

0 0

You are not allowed to follow up in this post.

Question

Question

How do I copy a field value from a table to a single line field on the same form?

Answer

Replies

Sign in to reply to this post.