InfoPath Dev

[quote user="Hilary Stoupa"]Oh, I see - so you do need to do something like what is in the sample I attached. You have a data connection to the Projects list? Drag the data fields onto the form, so you have a repeating table, then add a formatting rule to hide any rows if the preceding sibling has a matching name. Then you can use ...

Oh, I see - so you do need to do something like what is in the sample I attached. You have a data connection to the Projects list? Drag the data fields onto the form, so you have a repeating table, then add a formatting rule to hide any rows if the preceding sibling has a matching name. Then you can use calculated values with formulas similar to ...

 [quote user="Hilary Stoupa"]Yes, I meant the calculation would be in InfoPath - just use a calculated value? So - you put the table from the secondary data source on the form, and in one column use a calculated value to show the result?[/quote]  yes I could do this for that column. Would I have to recreate the calculated ...

[quote user="Hilary Stoupa"]Not to be slow - but the Planned Total Number is from the list, and is per project? So is the number of completed? Wouldn't you just put a calculated value in the column for Number Of Uncompleted that is the Total Number minus the Number Completed?[/quote]    to clarify none of the columns with ...

Yes, I meant the calculation would be in InfoPath - just use a calculated value? So - you put the table from the secondary data source on the form, and in one column use a calculated value to show the result?

 Hi Hilary, Yes i could do that for that column however that column doesn't actually live in the list yet. I was hoping to be able to do that calculation in infopath verses doing it in SP 

Not to be slow - but the Planned Total Number is from the list, and is per project? So is the number of completed? Wouldn't you just put a calculated value in the column for Number Of Uncompleted that is the Total Number minus the Number Completed?

Hi Hilary,   thank you for responding. I took a look at your file and actually saw this on another post. Unfortunately in my instance the user is not entering information. I'll try to explain better.   - I have a list that holds a list of projects with other meta data like planned number of tests, ...

I have an ID number in a SharePoint list that currently is manually assigned when a user creates a new entry. I am creating a form in InfoPath 2016 that is just a pretty front end window for data entry. I have some cascading Listboxes that I am using. What I would like to be able to do, if possible, is get the ID box to look at the last value in ...

Just emailed you via the forum - you can reply to my email w/ the form attached & I'll take a quick look later today. :)