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?
Question
Question
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.