InfoPath Dev

The solution was actually very easy. I changed the secondary data connection to sort on the item I wanted to sort. Easy peasy :-)

I'm still on the topic with the repeating table. I have a lookup to a list that once selected it shows all entries from that list with that Job Number. The entries in the list has different Item Types. When the item types are displayed, I want them to appear sorted alphabetically. How can I accomplish that?

I found a solution! You create 2 buttons. One will submit and reopen a blank form. The other will submit and close. :-) My help came from the following post: https://wonderlaura.com/2013/05/01/infopath-save-and-new-button/

Hi Hilary, I get the following message: An error occurred while using the form. For more information, contact the site administrator. An entry has been added to the Windows event log of the server. Log ID:5567 It gives an correlation id, but since this is SP online, I don't know how to troubleshoot / view the correlation it. Can ...

Sharepoint Online environment: I saw a video tutorial from Jen Lindsay here: https://www.youtube.com/watch?v=H09KGvd3vZw&app=desktop It does exactly what I need, but the 'Insert new' button in her demo gives me an error message. When I open the form and click on Insert - it works only once. When I want to insert another item, it ...

Awesome - it works perfectly!! Thank you so much Hilary

Thank you Hillary, it seems we're on the track to the solution. But it only shows the sum of the current 'Resources' field you're in, it does not show the sum of all Totals where all Item Types = Resources. (I use Job No 3 for testing, it has 3 resources.)

Hi Hillary, here's my form. You're right, it should change to the ID, and the ID for 'Resources' is 5. You'll see on the form next to 'Resources' a calculated field, that is where I'm trying to add the totals where Item Type = Resources. I need to repeat that for all the Reimbursables and sub consultants as well. ...

Thanks Hillary, but my problem is, the list is a repeating table and the Item Type is a lookup field. When I enter the fx function, it returns '0' although there are items in the Item Type column/field. This is how my fx looks like: sum(Total[Item = "Resources"])

I have an infopath form developed on a list with a repeating table. The form have 2 data connections to the same list. (one is secondary) It is build for a budget. You select the project number, and the different expenses for that project is displayed. Then you can add another expense. The expenses (Item column) is in different groups, ...