I have a calculated column that is made to be a link that links to the items own custom forms. The ID that is used to link to that item is done by a custom number field that is set by a workflow after an ID has been assigned.
99.99% of the time it works perfectly fine. Some times the ID is missing when the user clicks on the button. The link is still valid so the user is taken to the first item in the list (not the item they click on).
Not sure why or how to fix this. Any pointers are welcome as this problem seems to happen on other lists as well.
Example of the calculated column button code:
="<button class=""button"" onclick=""window.location" &CONCATENATE("='/Departments/Sales/Lists/Sales Activity Tracker/UpdateCustomer.aspx?ID=" ,backend_ID ,"' ") &";"" style=""height:35px;"">Update Customer</button>"