You are viewing limited content. For full access, please sign in.

Question

Question

I am looking to use Formula to achieve a decision process

asked on March 4, 2016 Show version history

Table below us summery of the days work for a given employee.  I am using Forms 10 Calculation functionality to gather the totals for "Total Machine Hours" and "Indirect Hours".  All the employee needs to do is enter his actual hours he worked in the "Total Pay Hours" field.  The Submit remains hidden.

Here is the decision:

1) If the Total Pay Hours is LESS than Total Machine hours, then the Submit should display.  And a prompt should appear prompting user to change all "Indirect Hours" listed in the table to a '0' value.

2) If the Total Pay Hours is MORE than the Total Machine hours, then the employee needs to be prompted to add additional "Indirect hours" to the table to make up the difference.

I tried accomplishing this with the new Forms 10 calculations ability, but have only gotten one or the other mostly successful.  Any suggestions?

0 0

Replies

replied on March 7, 2016

You can achieve through this

1. have a hidden field with formula = Total_Machine_Hours - Total_Pay_Hours

2. use CustomHTML fields to put the error message, use field rule to show the proper error message they want when that hidden field is greater than 0

To hide the submit button, you'd have to use javascript

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.