Community
Select to view content in your preferred language

String or binary data would be truncated Error

46
2
2 hours ago
PlANNADMIN
by
Emerging Contributor
2 hours ago

I am getting an error when trying to submit a survey via Survey123. The error reads " String or binary data would be truncated in table." It is a hidden text field in the survey that is populated by a calculation. The field length should be more than adequate so I can't figure out what is causing the error. I have attached a screenshot of the error and the xlsx file. Any assistance would be greatly appreciated!

Preview file
65 KB
Preview file
322 KB
0 Kudos
2 Replies
Neal_t_k
by
Frequent Contributor
2 hours ago

Thats a giant calculation!   But it appears to have some syntax errors,  I threw your xlsx in Connect, unhid all the fields and received this, which looks bigger than your field length:

Neal_t_k_0-1763584944358.png

 

0 Kudos
Neal_t_k
by
Frequent Contributor
an hour ago

@PlANNADMIN  You need to add some parenthesis to to separate/group your and "and" and "or" statements. Separating them out helps keep track of where you are when you get that complicated of an if statement.  

if(((${service_required} = 'Water' and string-length(${service_installation}) > 0) or(${service_required} = 'E and W' and string-length(${service_installation}) > 0 and string-length(${connection_date}) > 0)),'Completed',
  
if(((${service_required} = 'Water' and string-length(${installation_complete}) > 0 and string-length(${service_installation}) = 0) or(${service_required} = 'E and W' and string-length(${installation_complete}) > 0 and string-length(${service_installation}) = 0 and string-length(${job_end}) > 0)),'Completed_TD',

if(((${service_required} = 'E and W' and string-length(${scheduled_start}) > 0 and string-length(${installation_complete}) = 0 and string-length(${inspection}) = 0) or (${service_required} = 'E and W' and string-length(${installation_complete}) > 0 and string-length(${inspection}) = 0) or (${service_required} = 'E and W' and string-length(${scheduled_start}) > 0 and string-length(${installation_complete}) = 0 and ${inspection} = 'Failed' and ${estimate_required} = 'No') or (${service_required} = 'E and W' and string-length(${installation_complete}) > 0 and ${inspection} = 'Failed' and ${estimate_required} = 'No') or (${service_required} = 'E and W' and string-length(${service_installation}) > 0 and string-length(${inspection}) = 0) or (${service_required} = 'E and W' and string-length(${service_installation}) > 0 and ${inspection} = 'Failed' and ${estimate_required} = 'No')),'In_Progress',

if(((${service_required} = 'E and W' and string-length(${scheduled_start}) > 0 and string-length(${installation_complete}) = 0 and string-length(${inspection}) > 0 and ${estimate_required} = 'Yes' and string-length(${estimate_cs}) = 0) or (${service_required} = 'E and W' and string-length(${installation_complete}) > 0 and string-length(${inspection}) > 0 and ${estimate_required} = 'Yes' and string-length(${estimate_cs}) = 0) or (${service_required} = 'E and W' and string-length(${service_installation}) > 0 and string-length(${inspection}) > 0 and ${estimate_required} = 'Yes' and string-length(${estimate_cs}) = 0)),'In_Progress_Planning',

if(((${service_required} = 'E and W' and string-length(${scheduled_start}) > 0 and string-length(${installation_complete}) = 0 and ${estimate_required} = 'Yes' and string-length(${estimate_cs}) > 0 and string-length(${payment_date}) = 0) or (${service_required} = 'E and W' and string-length(${installation_complete}) > 0 and ${estimate_required} = 'Yes' and string-length(${estimate_cs}) > 0 and string-length(${payment_date}) = 0) or (${service_required} = 'E and W' and string-length(${service_installation}) > 0 and ${estimate_required} = 'Yes' and string-length(${estimate_cs}) > 0 and string-length(${payment_date}) = 0)),'In_Progress_CS','In_Progress_TD')))))

 

0 Kudos