Hi all,
I've come across a bug within the system that I am working on that is caused by a discrepancy in Field Types.
On our Contact entity, we have a field called 'contactid' that has a Type of Whole Number. This is fine, and is not causing any problems.
On the Lead entity, we have a 'contactid' field as well, but the Type has been set to Single Line of Text. This field will be populated with data from an external system, and using the Form Assistant, we will use a workflow to populate the 'contactid' field on the Contact entity with the value of the Lead entity. The problem is that the Lead entity field should also have a Type of Whole Number. As this isn't the case, the workflow is currently not working, as the difference in Types does not allow for the Form Assistant to populate the field.
My question is this - is there a way to use a Web Resource to coerce the field on the Lead entity from being a Single Line of Text to a Whole Number? I can't create a new field, as this could cause massive data loss for the company, so my only option is to use code to edit this. Would it be better to create a C# plugin to edit this, or would some JS suffice?
Thank you for any help in advance,
Emily