InfoPath Dev

[quote user="Hilary Stoupa"]Could I see a copy of your form? You can attach it under the Options tab in a reply.[/quote]  Sorry we are not allowed to upload anything but this is the default value of the field  sum(Quantity2[Items = Item2]) + sum(Quantity1[Items = Item1]) + sum(Quantity3[Items = Items3]) + ...

[quote user="Hilary Stoupa"]I need more info. I don't know what "not working" means here - the number isn't what you expect? The formula returns an error? You can't get the formula editor to accept the formula? etc....[/quote] the correct total is not showing and it only compute the first field but the other ...

 I have 5 fields that are coming from secondary data. They are all in numeric format. What I need to do is once the user select the items in the list it will check how many quantity of that items from field1 to field5 and add them together. I tried 1 field and it's working fine but when I sum all 5 fields like ...

[quote user="Hilary Stoupa"]This is not possible out of the box. You may want to try using SharePoint Designer workflow for this, or Power Automate if you are on SharePoint Online.[/quote]    Problem is I don't have access in SharePoint Designer so no other way for this one? 

Hi Hillary hope you can help.me with this one thank you

Just a quick question how can I update the other sharepoint list from my current infopath form once I update the field in my current list it should be also updated on the other list. I know how to get data from other list but updating it to other sharepoint is I dont have any idea hope anyone can help me about this thank you in advance

Hi I notice if I create a form in custom list all the other options in infopath are gone like repeating table etc. How can I add repeating table on this custom list? I never tried creating form library I only master how to create forms in custom list

[quote user="Hilary Stoupa"]Use the addSeconds function - but I'd probably add that first, then use substring-after to get the time. See attached - save the file locally, right click & select Design. Formula is: addSeconds(now(), 43200)[/quote] is 43200 equivalent to 12 hrs? so for example the date now and time is Sept 7 11PM ...

Hi is it possible to add like 12 hours once you extract the time from now() function?