I have a hyperlink field in an Infopath form which is set to populate a file Hyperlink to a shared drive based on entries to other fields in the form, using below formula for default value:
concat("file://\\file\nmig1\Compswap\C Welsh\Database files\Business Excellence\Evidence\", Contract, "\", Area of Excellence, "\", Measure, "\", Level)
This works fine when an item is first submitted to the associated Sharepoint list - however if you try and edit an item using the form, the hyperlink entry in the Sharepoint list does not get updated.
For clarity - the Hyperlink field updates correctly to a new string within the form, it just doesn't overwrite the old hyperlink value in the Sharepoint list when the edit form is submitted.
I've searched extensively for anyone having or solving the same issue, no joy.
Anyone come across this, or have any idea why this could be happening?
It seems bizarre that it submits fine for a new item but fails to edit.
EDIT: Should add that this is on Sharepoint 2010.