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

Question

Question

Calculation of Single Line fields

Forms Version 10
Updated March 18, 2016
asked on March 16, 2016

I have a client that wants to do some simple calculations with Forms 10 without any scripting. They want to add two single line values to populate a third single line field.

 

I have tried =SUM(vacreq, vacbal)

vacreq and vacbal are field variables.

I continually end up with 0 in my third field. Is it not possible to add two single line field values?

 

Thanks

0 0

Answer

SELECTED ANSWER
replied on March 16, 2016

It is my understanding that you need to use number fields and not single line fields as they are string based.

0 0

Replies

replied on March 16, 2016

That's what I was thinking but hoping for a different answer. We would need to allow for half day requests and Number fields don't like the decimal.

0 0
replied on March 17, 2016

Hi Andrew

In Forms the Number Field will support Decimals, but it is default to 0 decimals when you drag it onto the page. Edit the Field, and near the bottom change the Decimals: Number of Decimals to 1 or 2, whatever you need and the field will then accepts decimals.

0 0
replied on March 18, 2016

Beauty. Thanks Steve.

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...