We have a CRM system that generates unique customer IDs. Now we added a field "customer match code" to our Fogbugz cases, using the Custom Fields Plugin.
In the CRM we have a button "Add case to customer" that launches a VB script to open a URL, ie. Fogbugz.
Obviously, it would be nice to pre-fill the custom field "customer match code" with the ID. Normal fields are easy to pre-fill:
Since the field is a custom field, I found it not in the table "Bug", but in "Plugin_6_CustomBugData", where it is called "customerxmatchxcodeX62".
Neither accessing "customerxmatchxcodeX62", nor "customer match code", nor "Customer Match Code" worked.
Does anyone know of a way to access custom fields like this?
Note: I am aware of the XML API. I'm trying to avoid it in this case, because all I want to do is open a browser with Fogbugz "new case" page and fill this one field.
Thank you for any helpful responses!
See also the various values you can set in the URL of the case edit page.
In this thread I found that setting custom fields via XML API seems to work. However, using the same syntax does not work, in this specific case: