SharePoint Integration

Re: Dynamic Stock list, cascading field help

Hilary Stoupa — Mon, 24 Apr 2017 14:26:37 GMT

Hooray! glad you got it. This is one of those things that can be really tough when you first start but once you have it figured out one time, gets easier the next. :)

Re: Dynamic Stock list, cascading field help

Brainman — Mon, 24 Apr 2017 12:59:12 GMT

I found it. I was using the wrong table. Instead of the table with the lookup column (stock) I needed to use the primary table (locations).

Re: Dynamic Stock list, cascading field help

Brainman — Mon, 24 Apr 2017 10:37:14 GMT

Well, Infopath didn't found it out on it's own, neither did I. I'm also not understanding how it works, I have tried many possible ways. I couldnt find a good blog/article/forupost that explains to me why it returns a ID instead of the 'location'.

In the picture I showed the connection between my tables and the formula, as you explained (Productnumber (from secundaire dataconnection: "Stock") is equal to "Product" (from main connection).

Re: Dynamic Stock list, cascading field help

Hilary Stoupa — Thu, 20 Apr 2017 17:54:30 GMT

Okay, I think you need in your filter to select the secondary data source productnummer first, then in in the third dropdown, select the main data source product. We want to see InfoPath using "current()" in the filter, and it will probably figure that out on its own.

Re: Dynamic Stock list, cascading field help

Brainman — Thu, 20 Apr 2017 06:25:01 GMT

Hello Hilary, It's a pleasure to get a response from you. Most of my knowledge of Infopath I got from your responses on this forum.

I don't really have a formula, it only says d:productnummer (this is the productnumber from the Stocklist). I would like to understand what I'm missing.

With regards,

Ramon

Re: Dynamic Stock list, cascading field help

Hilary Stoupa — Wed, 19 Apr 2017 14:20:01 GMT

Hi - in your formula editor dialog, can you click the Edit XPath checkbox and paste the XPath into a reply? Or attach your form to a reply under Options & I'll see if I can give you a hand. :)

Re: Dynamic Stock list, cascading field help

Brainman — Wed, 19 Apr 2017 08:34:34 GMT

I'm sorry, I am using Infopath 2013 and I think it should have been in the sharepoint forum instead of Infopath 2010. Could this be removed to the right forum?

Dynamic Stock list, cascading field help

Brainman — Tue, 18 Apr 2017 06:57:20 GMT

Hello,

I'm working on an dynamic stock system on sharepoint with Infopath, but I cannot figure out the cascading fields in Infopath. ( i tought cascading fields was also possible within sharepoint but this area is grey, i cannot select tables?). Anyway,

I created 5 tables on sharepoint:
- locations
- products
- users (there is a lookup column with departments)
- departments
- stock (here is product (lookup) and location (lookup) and Amount

I created a form where a user can request an item. When selecting the item there should be a choice of the locations. The same goes with the user, some users can request for multiple departments.
So far I have this in the field 'location':

Data source: stock (product - location - amount - ID). On entries I have the following: Filter data on 'Product (from main) = Productnumber (from stock). What I get is that the ID is shown in the location field, after selecting a product but I cannot get the name of the location.

Do I need to add another filter level? I think i'm on the right track, because it is filtering the right locations, but it shows the ID from the locations.

Help is much appreciated,

With regards,

Ramon