Newbie Questions

Re: Use a lookup field's value, NOT its ID, in a math formula.

Hilary Stoupa — Fri, 03 Feb 2017 22:09:01 GMT

Well, the actual filter (stuff inside the square brackets) will vary, but generally, yes. I used current() instead of the full path to the main data source even though the SharePointListItem_RW node wasn't repeating, just because I wanted the sample to be relevant for you if you had been working w/ repeating data. :)

Re: Use a lookup field's value, NOT its ID, in a math formula.

Matt Leon — Fri, 03 Feb 2017 18:49:05 GMT

That worked perfectly. So, is the expression "../d:ID = current()/../my:SQF" a go to for this kind of issue? If so, and someone else needs to do the same thing, I have attached quick how to for where this expression goes.

Re: Use a lookup field's value, NOT its ID, in a math formula.

Hilary Stoupa — Fri, 03 Feb 2017 16:24:23 GMT

Give this one a try. You may want to add a condition to the rule to not run if SQF in the main data source is blank. :) EDITED TO ADD: save the file locally, right click & select design to open in design mode.

Re: Use a lookup field's value, NOT its ID, in a math formula.

Matt Leon — Fri, 03 Feb 2017 16:08:12 GMT

I did try to follow the steps from that link yesterday, but for some reason the math would return "NaN", "Infinity", "", or the "Total Cost"/ ID. After my failed attempts, I just figured that the link was only showing how to get the field to display the lookup value instead of displaying the lookup ID.

Re: Use a lookup field's value, NOT its ID, in a math formula.

Hilary Stoupa — Fri, 03 Feb 2017 15:55:27 GMT

Yes, you have to use the ID to get the value back from the secondary data source w/ the value. If you can attach your form under the Options tab in a reply, I'd be happy to give you a hand. This tutorial may also help you: https://www.premierpointsolutions.com/training/help-and-how-to-articles/get-infopath-to-display-lookup-column-value-not-id/

Use a lookup field's value, NOT its ID, in a math formula.

Matt Leon — Fri, 03 Feb 2017 15:48:37 GMT

I have a text control called "Total Cost". It's action rule has the condition: None - Run when field changes. It's action is: Set a field's value: "$/SQF" = "Total Cost" / "SQF". "$/SQF" is a text field. "SQF" is a lookup field. My issue is that instead of being divided by the value of "SQF", "Total Cost" is instead being divided by the ID of "SQF". Furthermore, I have another lookup field called "Campus". It's action rule has the condition: None - Run when field changes. It's action is: Set a field's value: "SQF" = "Campus". This rule works, because it uses their matching IDs; both "Campus" and "SQF" are on the same list. Is there a way to make it so that "Total Cost" is divided by the actual value of the square footage, not the ID, AND for "Campus" to set "SQF" equal to itself using their shared ID? Thank you,