Expand my Community achievements bar.

MHWinter
Offline
Type
• All
• Questions
• Discussions
• Ideas
• Blogs
Filter by user contributions
• 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);...

Type

Questions

Views

739

Like

1

Replies

8
• 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...

Type

Questions

Views

741

Like

1

Replies

0
• I recommend you check this tutorial by True Tech troubleshooting https://www.youtube.com/watch?v=8G7ORv0Sijw I have used a different script that I adapted from one found online,... can't find out where... to populate the State or Provinces for the US Australia, Canada, Brazil, Japan, or leave it ope...

Type

Questions

Views

1.7K

Like

1

Replies

0
• I guess you can combine both lines:this.rawValue = round(Avg(overall_score2, overall_score1)+.005,2)-.01Designer seems to only offer rounding to the closest decimal, whereas you needed to round down to the decimal below. So I don't think you can escape doing a little math!

Type

Questions

Views

846

Likes

2

Replies

1
• To round down, in FormCalc, you could use this formula:round(NumericField1.rawValue + .005,2)-.01

Type

Questions

Views

857

Likes

2

Replies

3
• Currently in your form, the checkbox shows or hides the Type dropdown field of the 1st instance of the table only. I see at least 3 options depending on what you are trying to achieve, which is still not clear to me:- the single check box shows or hides all instances of the type dropdown field, i.e....

Type

Questions

Views

468

Like

1

Replies

0
• See Designer Scripting Basics guide's chapter on Creating and Reusing JavaScript Functions

Type

Discussions

Views

1.7K

Likes

2

Replies

1
• try again

Type

Discussions

Views

1.7K

Likes

2

Replies

3
• Here is the form with the script in KPI 1 thru 3

Type

Discussions

Views

1.7K

Like

1

Replies

5
• Not sure it saves you a lot but here is an option. 1. create a script object to set the rating fields as required or optional based on 3 parameters:   - the page number   - the object number   - the status of KPI (empty or not)2 include a script in the exit event of each KPI field to test if KPI is ...

Type

Discussions

Views

1.7K

Like

1

Replies

6