Question

Fields in Forms automatically show up populated with data

Forms Version 10

Updated April 18, 2017

asked on April 17, 2017

Hello,

I have a user who is on Forms 10.1.0.619 and they have built a form that uses fields with look up rules and also concantanates data for each row dependent on the values of each field they select.

The issue they are having at hand seems more along the lines of how the rows are set up as opposed to the concantanate formula.

What happens is that they have a row with values that they select (Category and Type) and then the last field (Exp_GL_Code) populates a string of information based on the values of the previous fields they selected. ( I have provided a screenshot call Field Issue 1 showing this)

Then the problem starts, when they click "Add New Row", the next row has empty field values EXCEPT for the Exp_Gl_Code field which has the same value as the field above it (I have provided a screenshot named Field Issue 2 showing this)

Not only does the data pre populate, but when they select a new option for Category and Type, the Exp_GL_Code field changes both in the first row and the second row. The same applies when you add other rows or make a change to the Category and Type field of ANY of the rows.

Has anyone seen this before?

Field Issue 1.jpg (25.15 KB)

| Download

Field Issue 2.jpg (82.43 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on April 18, 2017

A case had been opened with Laserfiche Support. The form is working as designed. The flaw was in the formula being used operating on the entire columns, instead of other cells in the row. The formulas in question were of the form:

=CONCATENATE(Table.Column1,Table.Column2)

when they should have been of the form:

=CONCATENATE(INDEX(Table.Column1,ROW()),INDEX(Table.Column2,ROW()))

As written, the field was already populated when adding a new row because the columns did already contain data, even if there was no data in the columns for the new row. Similarly, this was why the fields would update together and include data for every row in the table.

Note that this syntax and usage was introduced in Forms 10.1 and is not supported in previous versions.

1 0

Replies

replied on April 18, 2017

We didn't see this issue before, did you have any custom JavaScript for the table columns? Can you open a support case by providing the process xml as well as the screenshots for the lookup rules configuration so that we can do further trouble shooting with your process?

0 0

replied on April 18, 2017

Xiaoxiao,

Yes I will go ahead and open up a ticket here shortly.

Thanks

0 0

SELECTED ANSWER

replied on April 18, 2017

=CONCATENATE(Table.Column1,Table.Column2)

when they should have been of the form:

=CONCATENATE(INDEX(Table.Column1,ROW()),INDEX(Table.Column2,ROW()))

Note that this syntax and usage was introduced in Forms 10.1 and is not supported in previous versions.

1 0

You are not allowed to follow up in this post.

Question

Question

Fields in Forms automatically show up populated with data

Answer

Replies

Sign in to reply to this post.