Newbie Questions

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Tue, 20 Dec 2016 15:38:13 GMT

Hooray! :)

Re: Repeating Section in a SharePoint List

Soraie — Tue, 20 Dec 2016 14:34:25 GMT

Hilary,

I just wanted to reply to let you know that I was able to solve my problem! I was not setting my query fields properly. I went over and reread your posts and assigned my query username to the main data field username and it worked.

Thank you so much for your knowledge and time!!!

Re: Repeating Section in a SharePoint List

Soraie — Mon, 19 Dec 2016 18:45:20 GMT

Not to worry! You've already helped greatly, I will try and figure this last part alone :)

Happy Holidays!

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Mon, 19 Dec 2016 18:40:26 GMT

I'm not sure what else to suggest then, I'm sorry.

Re: Repeating Section in a SharePoint List

Soraie — Mon, 19 Dec 2016 18:21:56 GMT

I've done what was mentioned and also mimic'd the template that you just posted. Sadly this does not solve the problem. I've attached an image with the exact rules that was given in the template but it will still query the entire SharePoint List for all the computer types. So John will show all the computer types regardless of who the computer type belongs to. :(

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Mon, 19 Dec 2016 18:09:17 GMT

I'm attaching the list form I used for testing this prior to suggesting it to you. Save the form locally. Right click and select design. Take a look at the form load rules. You won't be able to preview, of course, since it is connected to my Office 365 site.

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Mon, 19 Dec 2016 18:06:02 GMT

So in your form load rule, you should set the main data source query user name field to the main data source data user name field, then run the query. When you open an item, the data fields will have the user name for the item.

Re: Repeating Section in a SharePoint List

Soraie — Mon, 19 Dec 2016 17:56:00 GMT

In the new Item view, it is a blank form which is correct.

In the Edit AND View item View, it is showing all the computer types regardless of username. This is most likely because on form load, I query the main data connection. It is not specific to the username that I view or edit the item from.

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Mon, 19 Dec 2016 17:47:39 GMT

Sorry, I'm still not understanding. I think you are saying in the Edit view the form loads correctly but in the regular View Item view it does not?

Re: Repeating Section in a SharePoint List

Soraie — Mon, 19 Dec 2016 16:58:07 GMT

Hilary,

I've attached screenshots with the details. As you can see from the list John does not have a value of 634, but it still shows up when I view an item. I'm assuming this is because when I query for data in the form load, it picks up all of this type of data and fills it in, i don't know how to make a condition where if the name field is not blank or is specific to the row I clicked on.

If there are any other specific screens you like to see, I'll do my best to post them! I'm really sorry for all of this inconvenience :(

Edit: Any way to have the form load query based on username and not just in general? This seems to be querying all the fields regardless of the Username/ID.

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Mon, 19 Dec 2016 16:46:04 GMT

Maybe attach some more screenshots that show your current rules & results.

Re: Repeating Section in a SharePoint List

Soraie — Mon, 19 Dec 2016 16:41:26 GMT

Thank you! :) Sadly, another issue came up where if I view items, it does not query based on username it'll group all the computers together.

For example, If I view a row where the username is John, it'll also populate all the other users computers but the username in the form load will be John. :(

And I thought I solved it.....

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Mon, 19 Dec 2016 16:35:22 GMT

I knew you could figure it out. :)

Re: Repeating Section in a SharePoint List

Soraie — Mon, 19 Dec 2016 16:29:22 GMT

I'm not setting the query fields to anything specific. I know I want to query the data but would I create a rule under the Username or the computer type (query for data)?

Re: Repeating Section in a SharePoint List

Hilary Stoupa — Mon, 19 Dec 2016 16:18:44 GMT

Are you setting the query field in the main data source? Then running the query?