JS Link Conditional Formatting Paging Not Working

I’ve added a list view webpart onto a SharePoint 2013 online page, this webpart has a JS Link to a file containing JavaScript which applies different CSS to the CurrentRiskImpactLikelihood column depending on it’s value.

The JavaScript i’ve used is below:

    (function () { var condFieldCtx = {}; condFieldCtx.Templates = {};   condFieldCtx.Templates.Fields = { "CurrentRiskImpactLikelihood": {"View": PriorityFormat1}, }; condFieldCtx.OnPostRender = [PriorityFormat1]; SPClientTemplates.TemplateManager.RegisterTemplateOverrides(condFieldCtx); })();   function PriorityFormat1(ctx){      var priorityValue = ctx.CurrentItem.CurrentRiskImpactLikelihood;      if(priorityValue == 'Very Low'){         return "<span><font style='padding:5px;color:black;background-color:yellow;display:block;'>"+ctx.CurrentItem.CurrentRiskImpactLikelihood+"</font></span>";         }     else if(priorityValue == 'Low'){         return "<span><font style='padding:5px;color:black;background-color:yellow;display:block;'>"+ctx.CurrentItem.CurrentRiskImpactLikelihood+"</font></span>";         }     else if(priorityValue == 'Medium'){         return "<span><font style='padding:5px;color:white;background-color:orange;display:block;'>"+ctx.CurrentItem.CurrentRiskImpactLikelihood+"</font></span>";         }     else if(priorityValue == 'High'){         return "<span><font style='padding:5px;color:white;background-color:red;display:block;'>"+ctx.CurrentItem.CurrentRiskImpactLikelihood+"</font></span>";         }     else if(priorityValue == 'Very High'){         return "<span><font style='padding:5px;color:white;background-color:red;display:block;'>"+ctx.CurrentItem.CurrentRiskImpactLikelihood+"</font></span>";         }     else{         return ctx.CurrentItem.CurrentRiskImpactLikelihood;         } } 

This works fine on page 1 of the values I return, it doesn’t matter what the item limit of the pages in the view are, as soon as I go to the next page I get the following error:

TypeError: Cannot read property 'CurrentRiskImpactLikelihood' of null 

Does anyone have any ideas on a fix for this? I’ve tried googling it but had no luck so far!

Conditional formatting rules not applying the same in all ranges w/same rules

Excel 2016. I have the same six rules applied to seven separate columns. The formula and range is EXACTLY the same for each column (column letters changed, of course). The conditional formatting rules are: (Column D example) Top 1 =$ d7=LARGE($ d:$ d,2) =$ d7=LARGE($ d:$ d,3) =$ d7=SMALL($ d:$ d,3) =$ d7=SMALL($ d:$ d,2) Bottom 1

All cell data are non-formulaic numbers save last column (rules apply correctly there). Some columns have all rules applied correctly, some do not have the “Small or Large 2” rule applied. I have 11 rows of exclusive data now, so there should not be an issue with insufficient variables. What could I be missing? THANK YOU.

Python 3 TypeError: not all arguments converted during string formatting , lists issue

This program made in python 3.72 is supposed to recieve a number list from the user and then print four different lists with the numbers that are multiples of 2, 3, 5 and 7.

num_input = "" num_list = [] while num_input != "ESC":     if num_input.isdigit():         print("Number added")        num_list.append(num_input)     num_input = input("Enter a number list [Type ESC to end list]: ")  num_list_2 = [] num_list_3 = [] num_list_5 = [] num_list_7 = []  for item in num_list:     if item % 2 == 0:         num_list_2.append(item)     if item % 3 == 0:         num_list_3.append(item)     if item % 5 == 0:         num_list_5.append(item)     if item % 7 == 0:         num_list_7.append(item)  print(num_list_2) print(num_list_3) print(num_list_5) print(num_list_7) 

when I ran the code it did well until I wrote “ESC” to end the list and it showed this:

Traceback (most recent call last):   File "test.py", line 17, in  <module>     if item % 2 == 0: TypeError: not all arguments converted during string formatting 

Any help appreciated

Can I use conditional formatting to highlight a cell for dates less than 30 days away?

I have a large spreadsheet where I need to keep track of coming expiration dates and I would like dates which are within 30 days from today’s date OR which have already passed to be highlighted in red. However, all of the stuff I have found online so far results in the entire column getting highlighted or not no matter what I do.

What would the formula be for it to highlight both dates which have passed already AND dates within the next 30 days?

Google Sheets: Conditional Formatting – Custom Formula – Text Contains

Okay, so I have dates in column B that include weekdays in the following format: DDD, MMM DD, YYY (For example, Sat, Jan 19, 2019).

I want each row to auto format to a specific background colour based on the weekday in column B.

So, if B1 contains “Sat” I want row 1 to turn blue. If B100 contains “Sat” I want row 100 to turn blue.

I have tried using suggestions from these threads like regexmatch: Conditional formatting based on portion of text

or countif: https://stackoverflow.com/questions/27723102/finding-partial-texts-in-conditional-formatting-custom-formula-is

But neither of these seem to work for me.

I am at a loss. Any help is appreciated.

Formatting Paragraphs in json in my drupal powered REST API

I’m using Paragraphs to organise my content. A Project has many paragraphs. Each paragraph can be of type Text or Image (thanks to the paragraph type feature).

I want to expose my content to a REST API. So I created a view with a REST Export, listing projects.

Here’s an example of the data i’m retrieving. This project has 3 paragraphs (called slides):

[ { "title": "My Project title", "field_slides": "<div class=\"item-list\"><ul><li>  <div data-quickedit-entity-id=\"paragraph/1\" class=\"paragraph paragraph--type--image paragraph--view-mode--default\">\n          \n  <div data-quickedit-field-id=\"paragraph/1/field_image/en/default\" class=\"field field--name-field-image field--type-image field--label-above\">\n    <div class=\"field__label\">Image</div>\n              <div class=\"field__item\">  <img src=\"/drupal-8.6.5/sites/default/files/2019-01/photo-1547213529-98a94130a2f3_0.jpeg\" width=\"1050\" height=\"700\" alt=\"\" typeof=\"foaf:Image\" />\n\n</div>\n          </div>\n\n      </div>\n</li><li>  <div data-quickedit-entity-id=\"paragraph/2\" class=\"paragraph paragraph--type--text paragraph--view-mode--default\">\n          \n  <div data-quickedit-field-id=\"paragraph/2/field_text/en/default\" class=\"clearfix text-formatted field field--name-field-text field--type-text-long field--label-above\">\n    <div class=\"field__label\">Text</div>\n              <div class=\"field__item\"><p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p></div>\n          </div>\n\n      </div>\n</li><li>  <div data-quickedit-entity-id=\"paragraph/3\" class=\"paragraph paragraph--type--image paragraph--view-mode--default\">\n          \n  <div data-quickedit-field-id=\"paragraph/3/field_image/en/default\" class=\"field field--name-field-image field--type-image field--label-above\">\n    <div class=\"field__label\">Image</div>\n              <div class=\"field__item\">  <img src=\"/drupal-8.6.5/sites/default/files/2019-01/photo-1547253291-1337138b39e0.jpeg\" width=\"675\" height=\"901\" alt=\"\" typeof=\"foaf:Image\" />\n\n</div>\n          </div>\n\n      </div>\n</li></ul></div>" } ] 

All the slides are in a string. It also shows the edit links and some other html markup, and I can’t use this format with my api client. Ideally, I’d need the slides to be separated (3 slides here so an array of 3 objects) and just show slide content (raw text or image url). That way I could consume my Api.

Any Idea how I can achieve this?

App storage location change button gone after formatting SD card?

I’m on Oreo, and previously had a “change” button under the storage section of most apps that would move a few kb of the app to the SD card. I just formatted the SD card to internal storage, and that button is gone now, can I just not move apps to the SD card now or is there some way to do that still? Why is the button gone? (Apps still default to the phone’s own storage not SD; I installed a new app to test that)

How to display a value in cents as dollars (without fraction) by using only cell formatting, not formulas

The question is same as this one, but 950 cents should be displayed as 9, while keeping original 950 as cell value.

Let’s say I have an integer value of 950 (representing 950 cents) in cell A1 in an Excel 2010 spreadsheet. Is there a way to make Excel display this value as 9 (representing 9 dollars) in that same cell (A1) while still keeping the original integer value as 950, maybe by using a custom number format code?