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

Question

Displaying value from a general single line field in a dynamic table

Version 11 Classic Form Designer

Updated July 23

asked on July 23 • Show version history

I have a single line field where the user inserts a value.

Then I have a dynamic table, in which I need to show the value entered by user on the field above, in the first row only.

So far this function works.

But when I insert a value for the second row in the table, and click add, the value I entered for the 2nd row disappears.

It's because for each row populated, the else clause in this function =IF(ROW()=1,COT_neighborhood_park,"") makes the field empty.

Is there a way to overcome this, to add an else condition to the function so that it can keep the typed in value, on each append?

0 0

Replies

replied on July 23

You would have to do this with JavaScript or using some other method.

Calculations cannot be conditional in that way, so when you set a calculation on a field, that calculation will always overwrite user input; it is very much one or the other.

Even if you added an ELSE to the calculation, it would still overwrite what you entered manually.

2 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked July 23
Updated July 23
32 views