Is there a way I can produce an error message in an app when fields have been truncated?
Hi @PeterAP, this might be possible, but it depends on the specific use case you have/what you're trying to do/where fields are bing truncated. Could you provide a bit more detail please?
Hi @PeterAP
Can you provide specific details about how the fields might be truncated? There are a couple of ways that I can think of such as changing the field length with a select tool, or adding to text to a field in a formula tool. Both of these also give warnings as opposed to errors, so you need to planned for and handled with good error management in your workflow. You can of course set the workflow to stop after any conversion error in the Runtime settings. But this is messy. and doesn't give the user any valuable info
A better option is to plan for these types of errors. Use a combination of the Field Info tools and a series of message tools to check field lengths and types on input. When adding text to a column ensure that the field length is set to a large enough value at the start of the workflow.
Dan