|
|
|
|
|
|
|
|
|
|
 To create new posts or to reply to existing ones, you must be registered and logged in! |
Started: 1/8/2010 9:21 AM | |
|  | Calculation based on day of the week Good day everyone,
I have a calculation field for an overtime claim form I designed. Everything works well but the only thing is I need to add up hours based on day of the week ie if it is a sunday then it should be added in a box called ratex2 and if it is any other day it is a box called ratex1.5
I want to use rules as far as possible. Any help will be appreciated.
Regards,
Chester  |  |
Posted: 2/22/2010 3:49 PM | |
|  | Hi Chester,
How did you create your form? InfoPath, customized page or web part?  |  |
|  |
its in infopath. I got it right thanks. I used rules. I converted all my days of the week to numbers and Sunday is 0.  |  |
|  | Good work. Glad you came right.
 |  |
|
| Edit in Browser | /_layouts/images/icxddoc.gif | /forums/_layouts/formserver.aspx?XsnLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | FileType | xsn | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /forums/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /forums/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document.2 | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /forums/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document.3 | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /forums/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document.4 | 255 | | View in Web Browser | /_layouts/images/ichtmxls.gif | /forums/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1 | 0x0 | 0x1 | FileType | xlsx | 255 | | View in Web Browser | /_layouts/images/ichtmxls.gif | /forums/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1 | 0x0 | 0x1 | FileType | xlsb | 255 | | Snapshot in Excel | /_layouts/images/ewr134.gif | /forums/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&Snapshot=1 | 0x0 | 0x1 | FileType | xlsx | 256 | | Snapshot in Excel | /_layouts/images/ewr134.gif | /forums/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&Snapshot=1 | 0x0 | 0x1 | FileType | xlsb | 256 |
|
|
|
|
|
|