Does it not work if you put a list column field on the form twice? The New Item form is not saving my input from this field to the list.
In the attached image, the fields with matching colors are both connected to the same list column:
I really don't want to have to have two sets of Product Number list columns. Any suggestions as to why the form is not saving the Part Number values?
Solved! Go to Solution.
this is not supported.
how could form know which of the values actually write to the list field?
you could workaround with a validation rule based on replace() runtime function which supports regular expression as well.
general validation formula might look llike
ProductControl == "Product1" && replace(ProductNumberControl,"regex_to_validate","SOME_VALUE_TO_CHECK") != "SOME_VALUE_TO_CHECK"
ie. you replace a (regex) pattern you want to validate with a whatever value/string and check whether replace() output equals to that same 'whatever value'. if it doesn't you are sure input value doesn't match validation pattern.
I thought by disabling the unused fields along with hiding them, it would know use the enabled fields. Could you please tell me what the disable option on a formatting rule actually does? Thanks!
formatting rules control just visual behaviour of affected controls.
apart from some styling (color, font, ...) you can
hide control - it visually disapers
disable control - control is visible, but grayed out and you are not allowed to change it's content
my suggestion is to not have these fields directly connected to the columns but just named and have somewhere in the form three hidden calculated values that, depending on the selection get the value from the proper field and each of this calculated field is connected with your SharePoint column..in this way you should be able to have a single set of columns in SharePoint and two fields in your form..