InfoPath Dev

Add another helper field to your repeating table - and then you can use logic on it to act on each row individually. So - you have a helper field called "set" for example in your repeating table. You can have an action that sets that field to 1, outside of the repeating table. Then the rules on the "set" field can set the ...

Hello Hillary, Thank you very much for this work around it did work. But how to set initial values to the field using rules in case of manual split, considering these fields are in repeated control and initial values are various for all rows. I though 'set field' in a repeated table can achievable only using default ...

Okay that is true but seemed very strange to me that 'what is the exact purpose of InfoPath form designing if they cant be published to sharepoint'!! Neverthless, i am just starting with Power Apps option... could you give me some 1-2 liners how to go about it. I have a heads-up =Power Apps has a Form Designer but need to check ...

 Hi Hilary,  Thank you for that its becoming a bit more clearer now. Against each question there will be 3 check boxes of which only 1 can be answered. The questions and check boxes will be added to an existing form that I have designed that as other criteria boxes at the top of the form which is taken from the main SharePoint ...

The issue is that the default in the case of manual assigns all the amount to the first month selected in the case of the current year. As long as you use a default, you are going to face the same issue of the value being updated when the user re-opens a saved form. Again, I'd recommend using a rules based approach. What if you had two ...

Ah, OK. You should be able to use to local-name as a filter. See attached sample - save it locally, right click and select design, then you can preview or take a look at the logic.

It's not possible as we are not setting values back to Excel WB in SP. There is no data connection and we use Excel REST service to just use the Chart model and the model graphs on the value we pass in the URL. So it could gets lengthy, but the linked Image only read upto 255 chars. The simplified sample is representative of actual. I have ...

Yes all your assumptions on the scenario is right. And I know it is complicated, might be my less knowledge in InfoPath leads to this complexity. Do you have any suggestions? We cant do the wizard because the design cant be changed. Just repeating the problem we faced: once user done manual splitting, when user reopen the form to edit, ...

 Hi Hilary,  That's the bit I am struggling with, im not even sure if my XML is correct This is how my Secondary looks at the moment   Regards Jim 

Yick. Okay - so I understand the temptation to use substring formulas for conditional values, and sometimes they can be useful, but this seems awfully complicated. It appears that the split is based on the month to start as well as the option button, and then also depends on the year, right? If for "this" year, we pay attention to the ...