Thanks @Mayank_TiwariI guess you mean I should not import data into a signed form,... but Acrobat let me so I can. And my problem is the form I have developed is to track issues and interactions about it and we have experienced some ill-intentioned people changing the data content before passing it ...

The initiate event seems to do the job.

... And I just realize another issue: if I import data into an already signed form, the signature was not removed,... so there is now a data mismatch between the date of signature and and the recorded dates in the log. I thought importing data would reset the form first, including signatures. Any th...

Would you like to share your form so we can try to figure it out?

actually, ppCurrent.getDay()== to 5 and 6 correspond to Friday and Saturday, but because I had the script for coloring the background after the line incrementing row number (rowNum++), if was coloring the row after the one I intended (therefore Sunday Monday (or an empty row if the last day of the P...

I meant: rowNum++

for the reset button, add the lines in blue:xfa.host.resetData();for(var i=1; i<=16; i++){resolveNode("form1.page1.Page1.Table1.Row" + i).fillColor = "255,255,255"; } regarding the background, my mistake, move the script above the row++ line.

just add the blue line below to the loop that clears the fields before assigning the dates and days //loop through pp//clears Day and Date columns to prevent extra rows is user changes monthfor(var i=1; i<=16; i++){Table1.resolveNode("Row" + i).Day.rawValue = "";Table1.resolveNode("Row" + i).Date.ra...

and for the required hours, if I understand correctly, it should count 8 hours for each day Mon-Fri.If so, the following code addresses both the background on weekends and the required hours calculation. var rowNum = 1;var nWorkDays = 0;for(var i=pp.getDate(); i<=ppEnd.getDate(); i++){pp.setDate(i);...

regarding the background for Saturdays and Sundays, you can add the following script to the final For loop in form1.page1.Page1.employeeScheduleInfo.PayPerDate::exit// Color backgrounf if Saturday or Sundayif (ppCurrent.getDay()==0 || ppCurrent.getDay()==6){Table1.resolveNode("Row" + rowNum).fillCol...