InfoPath Dev

I'm expanding my work so far from a single entry on a repeating table to a more standard table layout. Each row contains data for one day so I know I can get the difference between two entries and shift it to decimal number in ActualTime and then work the rule magic to get totals. But I need to now expand this to cover up to 4 in/out entries ...

That is a huge help in understanding the logic. Now I just need to figure how to get time to calc across multiple entries. New post coming soon I think.

Glad you got it working! One thing that I found hard to remember when I started with InfoPath was where rules go - you want your rules on the field that will be changing. Action rules fire when a field changes, so if you want to set fieldB when fieldA has a certain value, the rule goes on fieldA. :-)

In the past, I've seen people use SharePoint designer workflow for this - removing permissions on submit and adding back permissions only for those who should be able to see a given form - you'd need to promote a field w/ the user's name, so you had the info available for your workflow.

Nope - Under File > Form Options, find promoted properties. Add your new column. Republish & it will be in your library. You may or may not need to add it to the view - can't remember if it is added to the default view or not. :-)

I got it! I just had to play with where the rules were placed and where they were pointing to! Thank you!

Good morning. We are having an issue with the email data connections in our forms using the username [function] where the alias has special characters like $ and #. Now the aliases have a underscore instead of these special characters, and the emails will no longer send because the username is based on an individuals log in id which still ...

I tried this application but was not successful. Your field1 for me would be a calc field called ActualTime that displays the difference in time in decimal format for total hours entered that day (punch in/out). That field should show the total time regardless, then it should be populating a RegTime field with up to 8 hours and anything over 8 ...

 I know there's a way to do this cause I've done it before. Published the form to a SharePoint 2016 form library and now added a field on the form, I can't remember how to add the field so it's reflected in the SP library. I don't have to set up a new Data Connection do I?

hi, I have 1 datepicker control, i need to add months(value from textbox eg.6 months) to the date and show result in another datepicker control. Thanks