InfoPath Dev

Hello, Due to InfoPath not being able to add/subtract time out of the box, I spent multiple hours figuring out how to subtract start and end time. So now I have a result formatted as string, but I want to ROUND UP to the nearest hour. So for 00:25 I want it rounded to 01:00, and 01:40 to 02:00, etc. Then I need the sum of this result (they ...

Hi Hilary, I take it that my confusion over your reply is due to the fact that I had no idea InfoPath can't subtract two times and return an integer value. So I tried following the method at http://www.bizsupportonline.net/infopath2003/time-calculations-infopath-using-rules.htm, which is EXACTLY what I need to accomplish. However, ...

Hello, Really stupid question, but I just can't remember the right mechanism for this. I have 3 fields as part of a repeating table; START_TIME, END_TIME, TOTAL_TIME. Where can I set the rule to run the formula to calculate the total_time? If it's the default value for total_time, it creates an error as soon as the start_time is ...

Hello, I have a form library for a form which is NOT browser-enabled, and SP is set to open in the client. With a workflow email using the "[%Current Item:Encoded Absolute URL%]" hyperlink, the form tries to open in the browser and fails with the error "The form cannot be opened in a web browser". Do i have to use ...

 Hello, I have a list which has a people picker, and shows the "Name with Presence".  I want to populate two other sharepoint columns using a workflow....email, and username.  I'm still new to workflows like this, so I am struggling... I've attached a screenshot of where I am so far, and am wondering ...

Hello,  I'm working on the Qdabra leave request template, and have a hard time knowing what setting are required in the workflow to update the SharePoint list.  Anyone familiar with this? I just don't know how to set the "Update List" action.  I attached a screenshot.  

Totally makes sense! Thanks!

Thank you Hilary. for explaining that. If you don't mind a follow-up, as I am trying to learn a few things. How does that condition determine if I am Admin or not? I don't see it passing any criteria or anything, just simply "Number or Occurrences". How does it know what to look for in the list?

Hi all, I recently purchased a "Leave Request" template from Qdabra, which includes qRules finishedloading in the data connection. One of the rules includes the following 2 conditions: Number of occurrences of SharePointListItem_RW is equal to 0 and Number of occurrences of SharePointListItem_RW is greater than ...

Hello, I built a simple form based on a SharePoint List, and since then I added a new column to the list. I now want to pull data from this new column, and submit data to it from the form. Is it possible to somehow add this column to the main data connection?