well if you want the second person to be able to see what the first person has entered it will need to be the same document. You could do it so the first 5 pages are visible and then the rest can become visible only when a password is entered or something like that. That way the first person can fil...

In a table you will need to reference each row - so your calculation would be something like (in formcalc):$ = Row1.price1 + Row2.price2 + Row3.price3 or however you have named them. The easiest thing to do is to call each row the same thing (eg. Row1) and each cell in the column the same thing (eg....

Your calculation in formcalc should be something like:if (TtlHrs.isNull == 0 and HrlyRate.isNull == 0) then$ = TtlHrs * HrlyRate + (TtlHrs * HrlyRate * VacRate)else $ = ""endif

Here is some code in Formcalc which will work for what you want. Put it in the exit event for the textfield.In this example the page is called myPage and the textField is called TextField1. Rename them as you need.var indexCount = 0var thisIndex = $.parent.indexwhile (indexCount < thisIndex) doif (m...

also to change the colour of the text just add to your if statement:Cell1.font.fill.color.value = "13,254,123"changing the numbers to the colour you want.

You could do something like (in formcalc in the exit event of Cell2):if ($.isNull) thenCell1 =  ""else  Cell1 = "2"endifthat way you don't have to have a default value and have it hidden originally, just leave it blank at the beginning.

so are the numbers already in the first column or do they need to be put there dynamically?

You have the script in the wrong event because cell1 is not actually changing until you run the script. Try putting a script into the exit event of Cell2 and you could just put something like this (in formcalc):if ($.isNull) thenCell1.presence = "hidden"else Cell1.presence = "visible"endif

you only need to put the code in once,  in the exit event of To_Date. You will need to name all the other fields Date01 for the loop to work.

OK so to start I have 2 date fields called start and end. These are where you enter the start and end dates for your pay period. For my example I have set the date format to DD/MM/YYYY so if you change this you will need to alter the code below accordingly.Then to fill the actual dates I have made a...