-
I didn't realize you had attached a template. Yes that works. Now that I understand the solution, I added some additional rules that update the rest of the fields when Role is updated. It works great.
Hilary, I appreciate all of your patience and support on this forum. We're incredibly lucky to have you.
Thank you so ...
-
Did you try the template I attached to my last post?
-
I would like it so if an end user changes the value of the Role dropdown box to a value in the list, the rule should run and populate Model user with the associated value.
Role: Radiology Resident (chosen by user)
Model User: RISRES (populates automatically)
Again, all the data is in one table. And for the ...
-
Sorry, I should have paid more attention to your filter - you actually want to filter on Role, right?
-
Right! Sorry! :)
Well matching Secondary to Main isn't triggering the update to the Model User dropdown box. Any other ideas?
Does it matter if I compare ID(Main) to ID(Secondary) or ID(Secondary) to ID(Main) ? I tried doing that but no change. Also tried matching ID under the queryFields folder versus dataFields. Still not ...
-
I can't preview your form - I don't have access to your SharePoint site :)
-
You were right. I was comparing secondary to secondary. Your attachment didn't work for me though. When I change Role via the dropdown, Model User doesn't change. It remains blank. It works for you in Preview mode?
-
Your screenshot looks right to me - what are you trying to calculate that isn't working? You can also attach a form under the options tab.
-
My guess would be that you aren't able to access the lists web service from your browser form - check the SharePoint ULS logs after submit. You may have to disable loopback check. Since you said SharePoint 2013, I was assuming you are using an on-prem server?
-
Hi Hilary
I've created several forms and published to SharePoint and they have all had the same issue. They were fine on the old MOSS system. Now we are using SharePoint online it seems to be playing up and the only difference is that I have had to convert the form to work on SharePoint. SO all the submit buttons and data ...