-
You can find more info here: https://support.office.com/en-us/article/Add-an-index-to-a-SharePoint-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0?ui=en-US&rs=en-US&ad=US
Basically, if you index the columns most often used for filters / queries you can improve performance. So, let's say you have a Project Number column and ...
-
Okay, I'll give it a try later today & let you know what I learn. :)
-
Is this a SharePoint List? Is the form customized in InfoPath or is the validation just on the list column? I ask because your formula looks like it might be for a SharePoint column, not InfoPath. :)
-
I have a form where people will enter the department they are working in. This is a single choice item. Then they will select the departments that they would like to obtain training in. This is a multi choice item. I need some validation to make sure that they don't select the department they are currently working in as an option that they ...
-
Thank you Hilary, I made two form load rules:which sets the Title filed value equal to Title value of the dataFields, when the Title field is not blank;which queries for data from the main connection, when the Title field is not blank.These rules work well in the display form (I'm able to the see all the items with the ...
-
Hi, Thanks for extending your help on this
I haven't worked with Indexes before
I've got many columns and not sure how to approach this, would appreciate if you can point me in the right direction otherwise im worried ill end up with a new problem to deal with :)
-
I have three forms similar to the attached. Each takes about 1 minute to open. Can you recommended any changes to the form data connections, rules or queries that will allow the form to open more quickly?
I have tried to 'uncheck' the automatically retrieve data checkbox, and then create rules/queries that will trigger repeating tables to ...
-
Yuck. I wonder if adding indexes to the list (under the list settings) would help?
-
Here's a modified copy of my default data form where I've changed the formula to set the serial number to handle for any number of digits after the dash. Instead of the "4" in the formula, you use the string-length of the substring after the "-".
-
Ok, I was wondering about that. I think that is doable with a workflow. ok sounds good.