The edited value of a Field Reference is not saved in the database

Issue

• When you create a form and add, for example, a Text field and in its advanced settings you change the Field Reference field, after publising the form, you will expect to find that the new value of the reference field is changed in the dabatase.
  
  
• Also if you publish the form and inspect the source code, you will find the original value of the Field Reference (Option12345678)

 

Environment

• DXP 7.4

 

Resolution

• When we add a field in a form there are 3 values related to it:
  • The Label.
  • The Field Reference, that originally is the same as the Value.
  • The Value.
• The label and the field reference can be changed, but the value is a constant.
• The reason behind is that the the database is modeled after DXP’s needs. If we added the field reference there, we would need to, every time a field reference changes, update the rows of this table so the data wouldn’t be obsolete.
• The field name is immutable and it was created for this kind of use cases where we needed a constant identifier.