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

Question

Quick fields and Real time lookup

Quick Fields Version 10 Capture Pattern Matching and Regular Expressions

Updated September 12, 2016

asked on September 9, 2016

I have a customer that is using real time lookup to get a check amount using the check number. the example of a returned value would be 1210.000000 . Is there a way to drop off the extra 0's using pattern matching or something else in conjunction with real time lookup

0 0

Replies

replied on September 9, 2016

You could likely do pattern matching on the field with something like \d+\.\d{2}, but my recommendation would be to edit it at the query level so it comes back from SQL already in correct form.

Assuming MSSQL is being used, the following would adjust the output on that query. You would need to also switch it to use a custom query, or create a view that has the field as you want it.

SELECT CONVERT(DECIMAL(10,2),YOURCOLUMN)

1 0

replied on September 12, 2016

Tried the query and it doesn't give me a result in quickfields but it works in sql

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked September 9, 2016
Updated September 12, 2016
173 views