I'm drafting a form to have an excel style table do some simple
budgeting calculations but in adobe. I'm about to tear out my hair
because I can't figure out why it isn't functioning properly. I'm a
completely self-taught designer so it could be something very basic that
I'm missing.I have a subform that mimics a table so that it can expand
by columns instead of rows. Each subform/column has a drop down (shown
in red) that is meant to control a set of checkboxes (in red). There is
a switch state...
Hi MinusZero,Sadly, I didn't find anything that translates to the column
instance creation. It does give me some solutions for future things I
want to do with this form. Just doesn't cause the sum calculation work
for created columns. Thanks though!
I've got the row subtotal to work$.rawValue =
Sum(Sum(Row3[*].ColX[*].Cell4[*]) + Row3.Cell3)Still need a formula that
totals the column when it is one of the dynamically created ones.I tried
this:$.rawValue =
Sum(Row3[*].ColX[*].Cell4[*]...Row19[*].ColX[*].Cell4[*])and $.rawValue
= Sum(Row3.ColX[*].Cell4[*]...Row19.ColX[*].Cell4[*])They don't work.
Hi All,I have a form that I'm building where the table expands by
columns and not rows. I have the instances set up and the columns are
added or removed by the user with no problems. What I want to do is have
a column that subtitles each row. I know how to do subtotals when I'm
working with tables that expand by rows, but the FormCalc doesn't
translate to the column. I used this as a reference to build the
expanding columns:
http://forms.stefcameron.com/2006/10/28/scripting-table-columns/ All th...
Dove into FormCalc and answered my own question.var pDate =
Date2Num(Date A.formattedValue,"MM/DD/YYYY")var mDate = Date2Num(Date
B.formattedValue,"MM/DD/YYYY")var kDays = mDate - pDateif (kDays >= 90)
then Num2Date(mDate - 15)elseif ((kDays >= 30) & (kDays<= 89)) then
Num2Date(mDate - 10) else Num2Date(mDate - 5) endifI'm managing the
pop-up in a secondary way.
Hi Everyone!I have a complicated form situation. I'm trying to have it
calculate when a person can start working on a report (Date C) based on
the day a project ends (Date A) and the day the report is due (Date B).
We have a set scale for when the Date C should be based on the
difference between The form has 2 dates that are entered by the user
(Date A and Date B). I managed to calculate the difference between Date
A and B that gives you a numeric value ( x days ). I need the form to
calculate a...
Hi,I'm creating a contracting template form where I a cover page that
holds all the user entered fields. Names, dates, amounts, applicable
contract terms etc. Once completed it a click event makes the contract
visible with all the data populated from the cover page.The issue is I
have a dynamically expanding table for the payment schedule (see below).
Row 1 is fixed as they'd always have 1 payment that is due when the
contract is signed, but row 2 lets them schedule installment payments.
The foo...
