It is not technically configurable as it is based on the length of the data type set in the Cityworks database. Even if you do change that value in the column there are other items such as the stored procedure that is used to conduct the update on a submit. The best option is requesting Trimble to update schema to have a longer data type length which they seem to have done in the past for quite a few columns. This also has been a problem with us as well for certain columns.

@samuel white? It's not configurable and an enhancement request would be needed to increase it. Have you considered using Comments instead as those are nvarchar(Max) per comment and include a user and datetime stamp.

Thanks for the answer.

Since this is the integration from See Click Fix into Cityworks, they would need to update their code to do such a thing.

Anyway, we have to work around it by having the people who handle these look in the See Click Fix CRM for the additional details. Of course one of the the points of such an integration is that people don't need to work in another system, but there we are.

Really, this is their issue to work around and admittedly, not a lot of these sorts of reports come in. Most reports ae very (too) short on details.

/Samuel

@samuel white? You're correct - CivicPlus would need to adjust their code to switch from using Details to Comments if you can't get everything into the details you want based on our field limit of 500 characters. I manage our partnership with them and have included @Zack Beatty? for awareness and to see what he can tell us.

I ran into this limit as well when I use the API to pull in an external form to create a Service Request. I modified all my forms to ensure the text going into Details is capped in order to stay below the limit.

I found that Custom fields also have a 250 character limit.

Likwise, work order Instructions field.