HTML functionality to pre-populate forms

Jeff_ARC

I am working on a solution that requires 30 fields (see illustration #1) to be pre-populated with information. The information that is being populated in the fields is also pretty lengthy. I am running into what looks like a character limitation with the final fields (see illustration #2). I have checked the character lengths of both the information populating the fields and also the characters used to create the formula. Neither of them are approaching the 4000 character limit, even if they are combined.

Is there another limit that I am encountering. If there is any suggestions to work around it. I have tried truncating the information populating the fields and I have abbreviated field names from what I originally had but I am still encountering the same situation.

Illustration #1 - Formula used to pre-populate form fields.

Illustration #2 - Information being displayed in the final two fields of the form (all other fields are appropriately populated)

prime_nathaniel

@Jeff_ARC can't totally help you without seeing your formula output. Have you validated your code for all 30 fields individually?

Jeff_ARC

The fields all use the same formula:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Business Resources: Software Systems Interruption]@row, "%", "%25"), " ", "%20"), "#", "%23"), "$", "%24"), "&", "%26"), "||", "&"), "=", "%3D"), "|^", "="), ":", "%3A"), "<", "%3C"), ">", "%3E"), "[", "%5B"), "]", "%5D"), "{", "%7B"), "}", "%7D"), "+", "%2B"), "@", "%40"), "/", "%2F"), ";", "%3B"), "?", "%3F"), "|", "%7C"), "~", "%7E"), "'", "%27"), ",", "%2C"), CHAR(10), "")

Which references a field that is populated with text from a dropdown list (See: [Business Resources: Software Systems Interruption]@row above)