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

Question

Question

Using Default Value vs. Formula

Forms
Updated July 3, 2020
asked on July 1, 2020

Is there a better option to make fields equal other fields? I can either set the default value of a field to be that of another field, or I can use a formula of =Former_field, for example. Are there any pros or cons to either? I've noticed that using the default value doesn't always work in some scenarios, but I can't figure out why, and am wondering if using a formula would be more reliable. Any tips on this matter?

0 0

Replies

replied on July 1, 2020

Default value only applies once, the first time there is no value in the variable. So ideally you want to use a calculation to keep the fields matching at all times.

0 0
replied on July 1, 2020

Do default values work in tables as well? I'm using the exact same default value to pull a single line field value into another single line field with no issue, but when I have a single line in a table, it doesn't pull in for some reason.

0 0
replied on July 3, 2020

When both fields are inside table, you should use formula such as =Index(Table.Single_Line1, Row()) to pull the value.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...