Lookup to populate Text Box or Dropdown

I was following this to pull Additional Fields to appear on the form using calculated field and it is worked perfectly. However, when I try changing the calculated field to text box, it won’t load in the SharePoint list when click New or clicking on the item. It worked in the preview tho.

For example, in my case, my list A has a People & Group field and a Department (text box) field, and my list B is “Staff List” with name of staffs, departments, titles, etc. So when I choose People & Group, it should match the DisplayName in People & Group with the name in list B with department.

What am I missing?

Request Failed Unexpected response from server. The status code of response is ‘500’. The status text of response is ‘internal server error’. null

I have created the “Business Intelligence Center Site” and I have to create dashboards.I have activated the required features at site level and site collection level also.Yet when I click on the ‘dashboard design’ in performancepoint tab of PerformancePoint Content list ribbon, it is showing me error as “Request Failed Unexpected response from server. The status code of response is ‘500’. The status text of response is ‘internal server error’. null “. It was working fine at starting. And I already downloaded the “Dashboard Designer” too. But later on that dashboard designer too is not connecting with the server. Why is it happening so. I did lot of finding and tried many solutions yet it is not working.

Highlighting text replacements

I am making an application where the user can perform multiple replacements after one another (eg. replace all “is” with “was”, all “will” to “would have”).

The problem I am facing UX-wise is how to signify the changes that will happen in the original text. I was thinking about highlighting the pending changes in the original text, as if highlighting text. Each replacement would get its own color.

What I am worried about is that the user would be able to replace all “to” with “an” and then all “anmato” with “pineapple”, then “tomato” would first become “anmato” and then “pineapple” (bad example, I know).

Changes would be able to overlap and thus highlighting would become problematic. I am able to figure out an algorithm that would highlight these both with the color of the first replacement, and the color of the second replacement, mixing the colors where they overlap.

I’m not sure if this is the best way to implement this, so I thought I’d ask you guys if you know of a better way.

SharePoint Online “Page Elements” style for Format Text missing

We are currently experiencing a really weird bug where the “Page Elements” is missing under the Font Styles under Format Text.

Here is a screenshot:

enter image description here

The weird thing is, it was working fine ever since we deployed it (5 months ago) and it just happened now.

All SharePoint portals inside our O365 (let’s call it O365 One) is affected.

Strangely, we have a different O365 (let’s call it O365 Two) account, and the “Page Elements” style is working there.

I even tried adding Custom Styles as defined here: https://knowledge.zomers.eu/SharePoint/Pages/How-to-add-custom-styles-to-the-ribbon-in-SharePoint-2013.aspx

But it also did not work for (O365 One). However, Custom Styles worked for (O365 Two).

Can anyone help / know what to do?

Thank you!


We found something strange; the javascripts on the problematic sites are being directed to:

<script type="text/javascript" src="https://static.sharepointonline.com/bld/_layouts/15/16.0.5131.1203/sp.js"></script> 

While the correct sites are:

<script type="text/javascript" src="https://cdn.sharepointonline.com/15815/_layouts/15/16.0.5117.1213/sp.init.js"></script> 

But the things is, we haven’t done anything to change it. Might it be Microsoft’s side?


Using responseheaders, found out that the SP Version of the Problematic Sites is :

While the correct sites are:

It seems that is problematic?

Prevent Word from automatically recognizing text before caption number as label

I’m using Word for Mac 16.24. I followed this excellent blog post to set up decent-looking equations in my Word docs, however I have an issue that it doesn’t address. If I surround the equation number in parentheses, Word automatically assumes the opening parenthesis is the label and so instead of e.g., ‘1’, I get ‘(1’ for my cross reference. It’s easy enough to delete this on a case-by-case basis, but when I update the references, all the cross-references are replaced with the versions with a leading parenthesis. For the time being, I’ve resorted to removing the parentheses from the captions, however I’d really like to have them there, as many (most?) publishers require them. The only alternative I can think of right now is to write a macro that updates references and then replaces all of the reference texts with the correct, parenthesis-less version.

Google Sheets text wrap no longer expands cell

All of a sudden I seem to be having trouble in my Google Sheets auto extending height of cell with text wrap, for certain cells.

Mac OS: 10.13.6 (17G65)

Chrome: Version 73.0.3683.103 (Official Build) (64-bit)

I select all cells via cmd + A and apply text-wrap:

enter image description here

I scroll to a cell on the bottom I’ve never formatted previously and type in a long string (Let’s say C1000):

enter image description here

The text wraps and expands the cell C1000 as expected:

enter image description here

I add text to a cell I had conditionally formatted (conditional format is simply to change it green on a certain value) and changed font of, and add long text, let’s say at C125:

enter image description here

The text doesn’t wrap in C125 even though wrapping is applied to it:

enter image description here

To reveal remaining text in C125, I had to manually drag the cell height:

enter image description here

I thought maybe one of the conditional formats was screwing with it, so I cleared formatting for all cells, and tried entering long text again in C125:

enter image description here

Again, it doesn’t wrap. The text continues on in the cell but doesn’t push the cell down and expose rest of text:

enter image description here

Lastly, I thought perhaps that text-wrap applies to correctly formatted cells as plain text, so I selected all cells again and set the formatting. No luck.

enter image description here

Can there be a bug with specific cells? Or does copying and pasting text from other sources, such as Mac Notes, cause bugs of this nature?

How can I restore to default such that text-wrap works for all cells?

View filter based in text not in number

I have a field in an entity that is an Entity Reference with widget Select list.

I have created a view and I want to be able to filter by that field in text format, but when I try to configure the filter I get the options to do it as if it were a number (is less than, is equal to…) and not as a text (contains, start with…).

Any idea of what I am doing wrong? Thanks!

words dictionary out of a text file

I’m python newbie please tell me what the weak spots of this code are (specially in terms of efficiency) and how I can improve it:

def get_word_frequencies(filename):   handle = open(filename,'rU')   text = handle.read()   handle.close()   MUST_STRIP_PUNCTUATION = ['\n','&','-','"','\'',':',',','.','?','!'\     ,';',')','(','[',']','{','}','*','#','@','~','`','\','|','/','_'\     ,'+','=','<','>','1','2','3','4','5','6','7','8','9','0']   text = text.lower()   for char in MUST_STRIP_PUNCTUATION:     if char in text:       text = text.replace(char,' ')   words_list = text.split(' ')   words_dict = {}   for word in words_list:     words_dict[word] = 0   for word in words_list:     words_dict[word] += 1   del words_dict['']   return words_dict 

Some steps sound repetitive to me and it seems that I’m looping on the text many times but I think I’m obliged to take each of those steps separately(unless I’m wrong), for instance, replacing invalid characters should be on multiple separate iterations, or lower casing the whole text must be a separate step, and so on.

Also for creating the dictionary I’m suspicious a way better than words_dict[word] = 0 must exist? Thanks in advance.

Reference dynamic text from another document within Google Docs

I want to create a document that has ten pages in it (ten pages, each page a new set of unique information). I want that document to pull from ten unique, single page documents that users can update. I want the updates in the unique documents to populate in the conglomerate document.

Is this possible with Google Docs?

I have seen that dynamic text can be linked between Google Sheets, or between Google Sheets and Google Docs but I want to do dynamic text from Google Doc to Google Doc.