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.
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.
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.
Thanks
Can you please show me some examples of how to use css to indent?
Priya
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!
Thanks
Any update please?
Priya