DanielReam
Qrew Member
Joined 4 years ago
User Profile
User Widgets
Contributions
Track Task within certain hours
Looking for some direction for a task timer being built. Only want it to track within a certain time frame (6AM - 230PM) and deduct time for lunch and break. I have the basic time tracking up and running just not the exclusions mentioned above. Any guidance would be appreciated. Daniel ------------------------------ Daniel Ream ------------------------------3Views0likes0CommentsRe: Using IF to compare values in two form fields
I have the same concern. [Amount 1] is a manual input amount [Amount 2] is a formula field using Query & Sum. Thinking it's something past the second decimal place. Have gone out as far as 10 decimal places but I'm not seeing anything obvious. ------------------------------ Daniel Ream ------------------------------57Views0likes2CommentsUsing IF to compare values in two form fields
I'm using a rich text - formula field to compare currency amounts in two form fields within the same form. So far this is what I have: IF([Amount 1]=[Amount 2], "<font color=green><b>Values Match</font></b>", "<font color=red><b>Values Do Not Match</font></b>") Currently even if the values match I'm getting the "Values Do Not Match" response. What am I missing or what have I done wrong? ------------------------------ Daniel Ream Builder ------------------------------85Views0likes4CommentsFormula: Generating child record & pushing values from parent into that record.
Hello, I'm wanting to create a button with an embedded formula to generate child records while pulling field values from parent into child. I have most of it figured out except the pulling and pushing of values. URLRoot() & "db/" & [_DBID_TRACKING_PARTICIPANTS] & "?a=API_GenAddRecordForm&_fid_57=" & URLEncode ([Record ID#])& "&z=" & Rurl() Want to drag employee ID from parent into child and place in correct field in addition to the above. ------------------------------ Daniel R ------------------------------26Views0likes1CommentFormula: Generating child record & pushing values from parent into that record.
Hello, I'm wanting to create a button with an embedded formula to generate child records while pulling field values from parent into child. I have most of it figured out except the pulling and pushing of values. URLRoot() & "db/" & [_DBID_TRACKING_PARTICIPANTS] & "?a=API_GenAddRecordForm&_fid_57=" & URLEncode ([Record ID#])& "&z=" & Rurl() Want to drag employee ID from parent into child and place in correct field in addition to the above. ------------------------------ Daniel R ------------------------------12Views0likes1Comment