InfoPath Dev

Thanks Patrick The goal is to minus minutes from the "Hours field" based on the text input from the "Break taken field" The trick part is the "Hours" field is a sum created from the "time from" and "time to" fields. Hope this makes a bit more sense? Thanks again for your reply.

Hi all I am looking for a way to subtract the total of a column using a formula. The formula for which I need to subtract the time from is as follows using another text input field. translate(addSeconds(timetoRT, -1 * (substring(timeFromRT, 1, 2) * 3600 + substring(timeFromRT, 4, 2) * 60 + substring(timeFromRT, 7, 2))), "ER?", ...

Dear all I have created a Data source connection on SharePoint which points toward and Empty table which users will enter information in 2 columns. After configuring BCS correctly and some other stuff it all works fine and I can see the data populating the SQL database. What I cannot do however is add a Data source "SQL View ...

Dear all I am having a problem with a form that populates names from a SQL data source. The problem is the names in the list are sorted totally randomly, this would not be a problem if they were also not jumbled up every time the form is reloaded.  Please see the pictures below for clarity     The names do match ...