Question

Why my Table result is different?

Forms

Updated May 15, 2017

asked on May 11, 2017

Hi All,

I created a Form using the object Table.

The user can add 1 or more products.

In my exemple, the user add Articles "AE011117", "AE030054" and "test".

Then, this list is sent to another user (called user2). This user2 should approve or not this list.

In the approbation, the user2 dont have the same view than the first user and idk why and how to do.

We can also see in the "Réf F." the value "test" is hide because the field's length. In my mind the value "test" was delete but I was wrong.

It could be nice if we could put "..." when the value is bigger than the field.

Thank you for your help.

Regards

0 0

Answer

SELECTED ANSWER

replied on May 14, 2017

I mean add the two tables in this way:

1. In form 1, add a table with 5 columns

2. In forms 2, instead of drag the "Table" from the fields palette on the left, switch to Variables tab, and drag the variable of the table to the form to create a new table but will use same variable as table in form 1, and remove the columns you don't need on form 2.

In this way, the two tables can have different number of columns and the column with same name can share data.

See this video for demo: https://www.screencast.com/t/q5TxP59v6O

1 0

Replies

replied on May 11, 2017

Are these two tables using different variables? Is there formula on the second table field variable?

If they are sharing the same variable then they should look the same and the second table should have 3 rows instead of one.

0 0

replied on May 12, 2017

It looks like you use two separate tables on different form with separate variables but use variables value from first table as default value of the second table

You should add the table in the second form by dragging the table variable from the variables tab so that two tables on two from sharing the same variable and they variable value can be passed from form 1 to form 2.

0 0

replied on May 12, 2017

Thank you all,

You right Xiuhong! I have 2 tables on different form and I need to take back the values of the first to fill in the second.

In my first table, I have 5 fields, but in my second table, I have only 3 fields.

When you said "dragging the table" ; you means pick value from table 1?

Because this is what I did.

This is my form 2

0 0

replied on May 15, 2017

Hi Xiuhong, thanks a lot.

Regards

0 0

You are not allowed to follow up in this post.

Question

Question

Why my Table result is different?

Answer

Replies

Sign in to reply to this post.