-
Sorry, I'd help but most of those complex time formulas are beyond me.... is ElapsedTime being set by a rule or by a default value? I guess I'm wondering if you can't check the string after the ":" to see if it is anything other than "00" and then do something to increment the string before the ":"?
-
You bet - let me know if you have any questions on the filters for the data source for the multi-select. Dragging the secondary data sources onto the form so you can see the values returned is usually really helpful in figuring some of these things out. One thing that may also be helpful when you set up the filter (and is easy to overlook) ...
-
Great - see how the values for Application in the Group list are the IDs? So we either need to change your application drop down to store the ID, or handle for that in the filter. Attached with both options.
-
Can you preview this one and send a screenshot so I can see the values from the lists?
-
So, you want the title to show in the Groups multiselect, just filtered on the selected application? I think the attached form will do what you want - save locally, right click and select Design, & preview.
-
I'm confused still. :)
You want to filter the allowable selections in the multi select? If so, you add a filter in the multi select's properties.
-
Can you attach a sample form? It would make the issue easier to understand. Under the Options tab is a place to attach a template.
-
I replied in the other thread - since you were using a default value in GL code, the formula changes a bit - current always refers to the node you are on, thus the XPath is relative.
-
I didn't realize you were using a default value on GL Code instead of a rule on Expense Type. Try this for your default value:
xdXDocument:GetDOM("Expense GLs")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:GL[../d:Company = xdXDocument:get-DOM()/my:myFields/my:Company and ../d:Title =current()/../my:Expense_type]
-
The current() function still works. I'd guess that @Title is incorrect - I think a SharePoint list connection no longer returns attributes, but elements instead. Attach your form under the options tab if you need a hand.