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

Question

Question

Table in forms

asked on August 16, 2019

Hello,

 I am trying to create a table in Forms like attached. I want the total costs to sum up automatically. Is it possible to do? Thanks.

 

 

Table.png
Table.png (9.45 KB)
0 0

Replies

replied on August 16, 2019

Thanks to Laserfiche for beefing up Calculations in version 10.2. JavaScript is no longer needed to do this.

On the forms Layout Tab drag and drop Currency type fields onto the canvas for your 7 line items (Administration to Other). Key in a Variable name associated with each line under the Basic Tab, Variable field.

You won't find the following table in the designer but each field will have a Variable that is easy to recognize as shown here:

The Total line is also of type Currency but enter the following code on the Advanced tab under Calculation: =SUM(Value_1, Value_2, Value_3). Note that you just string the Variable names together with a comma between them.

Yours will likely look something like this: =SUM(Admin_1, Faculty_1, Clerical_1, PersonnelOther_1, Facilities_1, Library_1, Other_2)

When I preview my form, I enter the first 3 values and the Total is calculated for me automatically. You may want to make this Total field Read Only on the Basic Tab.

That should give you the idea. 

You may need some CSS formatting to get your text laid out exactly as shown in your table. 

This Calculation should work with v10.2 and newer. 

I would love to see how to right justify currency fields so it looks nicer, especially when entering numbers in the thousands of dollars. Good Luck.

 

0 0
replied on August 16, 2019

Thanks

0 0
replied on August 19, 2019

Can you please show me some examples of how to use css to indent?

 

Priya

0 0
replied on August 19, 2019 Show version history

Hi Priya!  Indenting is done using CSS with the key word "padding" and I have done it a few times, but have not had much success.  (I am certainly not an expert at this!) 

It would be best if you started a new Answers question on this one, because there are not very good examples when I do a search.  There are a few, but the examples are complicated and not just a simple one that a beginner could use.  It would be good for others to be able to see some simple examples, as well!

0 0
replied on August 22, 2019

Thanks

0 0
replied on August 19, 2019

Doug:  CSS that worked for me for right align of Currency fields:

0 0
replied on August 26, 2019

Thank you. This is helpful.

0 0
replied on August 16, 2019

Any update please?

 

Priya

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

Sign in to reply to this post.