Code

Re: Filter formula for Current Record

Metron4 — Fri, 22 Feb 2013 19:39:04 GMT

I was able to accomplish what I wanted by creating a hidden control that stored the ID value. My lookup values now call the ID value of the hidden control saving several steps in the formula. The form loads much faster now.

Re: Filter formula for Current Record

Metron4 — Mon, 28 Jan 2013 16:42:33 GMT

Thanks for the reply. Do you have an example of this? I have never set up another view before.

Re: Filter formula for Current Record

Patrick Halstead — Fri, 25 Jan 2013 22:22:24 GMT

Hi Metron4,

I would try breaking it apart into two calculations. Do the inner one in the default value of a field which does not appear in your view. Then, the view element can reference that hidden field to do the top filter. See if that's faster.

Just an idea,

Patrick

Filter formula for Current Record

Metron4 — Fri, 25 Jan 2013 19:45:09 GMT

Hello,

I am trying to write a formula that will filter values for text box controls that match the current Project ID. This example uses the Cost Code associated with the project.

xdXDocument:GetDOM("Charge Codes")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:CostCode[../d:ProjectID = xdXDocument:GetDOM("Projects")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:ProjectID = xdXDocument:get-DOM()/my:myFields/my:ProjectID]]

It actually works, but now the preview takes way too long to load, and when I enter a different project ID, it takes a long time to switch the cost code. I assume it is because my formula is too convoluted, but this was the only way I could get it to work.

Can someone tell me if there is a more efficient formula? Please see attached image. Thanks.