InfoPath Dev

I thought about using designer, but as I have little control over the server and designer has a hard time scheduling flows, it can only run on the weekend (complex situation) I actually managed to figure a way to do this, my formula is way overly complicated, but I think it's going to work. Thanks so much for your reply, you got me on the ...

thanks so much Hilary, I'll take a look at this right away. although I have an added wrinkle and I'm not sure if it will make things easier or impossible. I tried to edit my post but I don't think it worked. What I am trying to do is to present this information in a form from another list, so I am using a query to grab dates from my ...

I'm trying to create a formula that is today - "assigned date" to return the number of days from assigned to today. from my understanding I should be able to use the formula "translate(now(), "-", "") - translate(AssignedDate, "-", "")" but I keep getting a "nan" error. what ...

Hi, I have a form webpart with a selector list next to it on a SharePoint Page. When I have the two connected the selector list sends the first row of data to the form on load (expected behavior), when I change the setting for the list to not send the first row of data to the infopath form webpart the form doesn't load at all and has a ...

That's what I thought, but it hides everything. which in turn causes the sum to not work properly (i think?). just to confirm, the preceding-sibling rule goes on the repeating table and the sum formula would be used 4 times, one for each quarter? what about category in the repeating table? I was just using d:category, but does that need a ...

I can't seem to get something else to work, I've got a new page with a similar repeating table on it, but am having issues getting it to display the way I want it. This table needs to be a sum of years per category. I am fairly certain I need to use preceding:sibling and/or the current() function to get it to hide unwanted rows. right now ...

thank you so much! I know I was doing something wrong, I just couldn't put my finger on it. I have such issues with repeating tables, the rule that you used to hide the empty rows I ALWAYS forget, then I just try and fudge my way to the end. thanks again!

I’m having an issue with my dropdown, once I make a selection, I can’t make another selection until I select “blank”. I’ve run into this many times and am always able to figure it out, but this time it’s got me stymied. I even tried adding another DC to just pull the contract numbers, but that’s not working (probably a poor way of doing it too) ...

Thanks Hilary, That's one of the hides that I was looking for, I also just realized that the filter I was using for the repeating table was not on the query field (LOL) You're a lifesaver!!

Hi, It's been awhile since I did this and I feel like I'm missing something super simple. I have a SharePoint list that I am tracking commitments for contracts. I felt the simplest way to to this is to create a list item for each category and Year, I'm trying to view the accumulated information in a repeating table on a second page. ...