You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Forms - Quote characters being removed from selected values before passing to lookup

Updated May 10, 2018
posted on May 9, 2018

Forms 10.3.1 appears to be secretly stripping quote (") characters from the values set in the form before passing the data to lookup rules. We verified this by writing a stored procedure that simply returned "hello world" as output and stored the value passed from forms into a table. The value was sure enough missing the " character.

The modification of data causes the lookup rules to return nothing, since the modified value will never exist.

Any way to disable this?

0 0
replied on May 10, 2018

Hi @████████

I tried to test this out on my 10.3.1 Forms. I added quotation marks to a field, submitted it (which writes to a SQL table. No problems though? It wrote the quotes in.

Any more information on the column data type in the SQL table?

 

0 0
replied on May 10, 2018

Did you use the data with the quotes in it to perform a real-time lookup on the form?

All column data types are nvarchar(max) but the issue is with the data being sent over by Forms, not with anything on the SQL side.

We created a Stored Procedure to capture the data coming over so that we could look at it directly.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...