InfoPath Dev

Yes give them an inch and they want a mile! Its all good though because I didn't think most of this would even be possible, so learning lots I'm not familiar with the username() function so can you control views based on users with this method too?, would be most useful to be able to load only specific views for particular groups of ...

Hi Hilary That works now perfectly, I just added one condition, the expression as per above and all is fine! I'm not going to pretend I know why so I'll have to look up differences between relative and absolute paths Since I;ve been trying to get this to work they have asked me to limit some path movements by user, now I believe ...

No I wasn't doing that , I set it as "Stage 1" and now only Stage 1 shows in the field My list will be simple as per attached and as outlined above, 2 columns, one with Stage and one with Path If something else is needed to make it work I'm fine with that but can' t seem to get your xml method to work either in my form ...

See attached, I just did up a quick one for the field in question as the full form is rather large with lots of data in it

Also when I use the xml approach with the 2 files I get blank so must be doing something wrong? Here is your Data source entry /Statuses/Status[. = xdXDocument:get-DOM()/my:myFields/my:field1 or . = xdXDocument:GetDOM("StagePaths")/StagePaths/StagePath/Path[../Stage = xdXDocument:get-DOM()/my:myFields/my:field1]] and here is ...

Hi Hilary I never used the xml resource files before but might have to go that way as I can't get the one SharePoint list with two columns Stage and Path to work?! The field is just blank, I assume I don't need the expressions and just need your 4th filter condition => field1 is equal to Path[Stage = field1] I assume it's ...

Hi Hilary This is it exactly, thanks. Just so I'm clear, i would create a list with 2 columns as use as the data source, then replicate the expressions and filters as per your example and should be good to go? Stage Path Stage1 Stage2 Stage1 Stage4 Stage2 Stage3 Stage2 Stage5 Thanks again

Yeah if it can be managed with a list and needs an extra field that would work either, I'm just not getting it to work all within one field but if that's possible then great!

Awesome Hilary this helps alright, thanks! So it's a one column SharePoint list to hold the stages 1-> 12 for example. Then in the form Stages field entries set the filter exactly as you have, selecting the correct field that holds the values form the external list, preceding-sibling::Status[1] = ...

Hi Hilary Yes thinking further the read only view is easier to implement and achieves the same goal Thanks!