InfoPath Dev

I have a sharepoint list what I want to do is on top of the list I will add webpart that can call the infopath form then that infopath form will count the total number of entries in a column based on different criteria or column. Example Column Workgroup Closing Support Admin Status Closed Open Pending So what I ...

Tried to edit my message above but failed :-( I have attached here another form that pulled together to show the issue without all my other fields and lookups. In this form it has the same fields so RequiredAction, and ValidAction and I am using the following pattern "\p{L}+[ ]\p{L}+" to check before setting the value of ...

Hi Hilary, many thanks for responding so quickly and taking the time to help. I have attached the form as it is but please note it has a couple of SharePoint lookups so it may not work. When I test this I am clicking into another field rather tabbing which I would hope would do the same thing, indeed it does. These are the actions I ...

Thanks for replying. As I pondered this more and more, I began thinking about my Average column. Given the fact that the true "average"s included a heck of a lot more potential precision than 1 decimal point, I realized what was happening------sharepoint was making me think it was storing just one decimal point in my Numbers column ...

How many lists are involved here? I think we can just lookup to a single other list, and we can return additional column values, but I can't tell what kind of relationship you are trying to create here. Like - if this list item's Category is "Orange", go get a value from another list that also has a Category of "Orange"?

I haven't done this before, so don't know how much help this is - but what do you see in the dev tools console when this happens? Anything useful?

 The documentation says the syntax is: IF(logical_test,value_if_true,value_if_false) You might want to start smaller -  just with one of your values, like: IF(Average_1to3=1,"Low","Test") Then, when you know that is working, replace "Test" with your next IF and so on. 

Any chance I can see your form? You can attach it under the Options tab in a reply.... When you test this, are you tabbing out of the rich text field prior to looking to see if the rules have executed?

I have been staring at this screen: https://support.microsoft.com/en-us/office/create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632?ui=en-us&rs=en-us&ad=us for a long time, but I cannot quite see where the linkage between the columns is. I don't have Designer or Workflows and for this ...

I have a Sharepoint calculated column which I have created without using Infopath, just by creating a new column of type Calculated, and putting this formula: =IF(Average_1to3=1,"Low",IF(Average_1to3=2.3,"Low ...