InfoPath Dev

The form will be used several times everyday by different people in different locations. Has you understood I need each form to have a unique number for business reason and having a user number won't unfortunately solve my problem but I will have a look at the list of database idea. Thanks again Hilary

Hi Hilary, thank you for this solution. I was hoping you'd reply. I don't want at all that two forms get the same number. What other options would you recommend? What I really need is for each form to have a unique and consecutive number starting from the first form (example: 0001). And if possible that the field Reference number in the ...

Hi, I have created a form that is published on Sharepoint Online 2013. In that form I have a Reference Number and a Site field, what I'm trying to achieve here is when a user click new to fill up a new form that my Reference Number field is automatically populated with the first 3 letter of the Site field +001 and so forth. For example: ...

Exactly what I did works perfectly, I thought maybe there was another way. Thank you very much for being so active on this forum :)

Hi all, I have created a form with a drop down list box name "Client" that retrieve it's information from a Sharepoint list. From that drop down I autopopulate (set a field's value) 4 other fields in the form. Until that point everything is working fine. This drop down field "Client" is promoted (property promotion) ...

Thank you but I have found the solution right after publishing my post and I couldn't delete it. I didn't need the 1st repeating table nor the optional section. I simplified the form and now the sum are working in the repeating table.

Hi All, I designed an Infopath form which has a repeating table followed by another repeating table in an optional section in a repeating section. At the end of each repeating table I have the sum of a column. I also have further down (outside the repeating section) a Total of all the sum fields . In the Total field I have the error ...

I realized I had put an extra quotation mark in the condition that's why it was not working. Thank you so much for your help Hilary and for sharing your knowledge, it's exactly what I needed and it's working !! :D

Thanks very much for the new file I just had to change the formula for the step 2, the rest was right. My question is how did you insert the fields MonthHelper and YearHelper on your Fields Task Pane without they appear on your form ?

Thank you, I have applied the same rules to duration and duration type but when I fill out duration, duration type and set a Start Date the End Field is blank. It's working on your file but not mine, I'm thinking that I might have insert the MonthHelper and YearHelper the wrong way. Could you tell me how you did? Thanks