InfoPath Dev

On further investigation the root cause of the problem is that function username() in the preview just contains a person's username whereas the published form contains i:0#.w|domain\username. Unfortunately using a substring-after function also doesn't solve the problem. I have added a new text box called current user and I need to make ...

I have two forms that relate to each other. On the first form there is an ID and a repeating table. On the second form I have a text box for the ID and then a drop down. I want the drop down to pull the one field from the repeating table so a user can select one. When I try I am only able to pull the very first entry of the repeating ...

 OK so it looks like my screen shots haven't worked - they were mainly used as proof of what I'm describing

 I am using SharePoint 2013 (on-premises) and InfoPath 2013 to customise a list form.  First I need to explain the configuration of my various SharePoint lists that I'm using for lookups. On my parent site I have a list called "Teams" (a custom list with 1 column entitled "Title" which is single text). ...

Hi Hilary. Thank you for the warm welcome. This is for Office 365.

1. I have a Regional Compliance List that tracks 'Total Systems' and 'Total Systems Inspected' 2. Both totals are currently updated by me, manually 3. There are several forms that the user can use to upload various system inspection forms to various libraries 4. I have created workflows that push the above ...

 Hello Hilary, Apologies for the late response. Essentially what I am after is a form that can submit a repeating table that can have a varying amount of entries, as well as non repeating fields outside the table to be submitted to a database. But I need the non repeating fields that are only entered once, to match up ...

 Okay, a few things - you have a rule on "Mrate" to set a query field and run a query based on the date? That rule should probably go on the date itself. Second - how many rows do you think you'll end up having in your list? Probably not a lot, right? I'd just query all the data on load, and then set the rate when the date ...

I have attached the test form that I am using. Thanks

 Hi,  I found an error in my form and had also unchecked the 'Refresh value when formula is recalculated'.  I also had a description field that would not publish to the list if it exceeded about 250 characters.  Everything seems to be working fine now.