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

Question

Question

Laserfiche forms Lookup cell formatting

asked on June 10, 2015

I have many forms that look up to a SQl database. the info is imported from an excel spreadsheet. is there a way to format the cells to veiw properly, from the lookup. 

 

EX. my spreadsheet has thier phone number as 9135555555 i would like it to pull and email out as (913) 555-5555

Ex2. I have a field that pulls in a dollar amount 500. the dollar fields in my form pulls in 500.0000

0 0

Replies

replied on June 11, 2015

Hi there,

Lookup retrieve the value, doesn't format the value. You can either format it in sql within a view or add custom javascript to format it.

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

Sign in to reply to this post.