Change position of Title field in list, in Site Design script

When I create a list in a site design script (via createSPList -> Add-SPOSiteScript -> Add-SPOSiteDesign), the Title field is automatically added. I’ve found out how to remove the Title field by using the Hidden property, e.g.:

{ "verb": "addSPFieldXml", "schemaXml": "<Field Type=\"Text\" Name=\"Title\" DisplayName=\"Title\" Required=\"FALSE\" Hidden=\"TRUE\"></Field>", "addToDefaultView": false }, 

However, what I want to do for this list is include the Title field, but have it displayed at the end of the table and the bottom of the New / Edit form (i.e. last field in the list). There doesn’t appear to be any way to do this with the createSPList command, as the Title field that I specify in my script is overwritten by the Title field which is automatically added, and it is positioned in the first column of the view and the first field in the form.

I’m aware I can change the order after the site design has been applied, but I’d prefer to set the order programmatically in my script. Is there a way to do this? An example script is below, which will add two fields to the view, but the Title field will always be put first when the design is applied, despite being listed last in the script, and not included in the view:

{ "$  schema": "schema.json", "actions": [     {         "verb": "createSPList",         "listName": "List positioning Title field",         "templateType": 100,         "subactions": [             {                 "verb": "addSPFieldXml",                 "schemaXml": "<Field Type=\"Text\" Name=\"Field1\" DisplayName=\"Field 1\" Required=\"TRUE\" MaxLength=\"255\"></Field>",                 "addToDefaultView": true             },             {                 "verb": "addSPFieldXml",                 "schemaXml": "<Field Type=\"Text\" Name=\"Title\" DisplayName=\"Title\" Required=\"FALSE\" MaxLength=\"255\" ShowInViewForms=\"FALSE\" Overwrite=\"TRUE\" Viewable=\"FALSE\"></Field>",                 "addToDefaultView": false             },             {                 "verb": "addSPView",                 "name": "All Items",                 "viewFields": [                     "Field1"                 ],                 "query": "",                 "rowLimit": 30,                 "isPaged": true,                 "makeDefault": true             }         ]     } ], "bindata": { }, "version": 1 } 

Library Title showing as “Error” when user doesn’t have permissions

I have a customer site where, if the user doesn’t have permissions to view the library, the title shows “Error” rather than the name of the library but denying permissions when clicked.

Any guidance on how to resolve this display as the customer wants either the library name displayed (but when clicked an “access denied” error comes up) or they want the library not to display at all.

Check If an Item by same title exists in sharepoint list then display that info in the Infopath form

I have a requirement like this.

I have a SharePoint list named ‘Examdate’ which stores different CoursNumber, Semester and ExamDate. It uses an InfoPath form for entering the CoursNumber in the list.

Now they need to have a mechanism to find out if the user is adding a New ExamDate whose CoursNumber is already present. They don’t want the users to stop the adding process, but instead, want to display the ExamDate for this already existing CoursNumber in the form. This should not happen on the save button.

So, I was thinking of customizing the NewItem form by adding a button near the CoursNumber field, say “Check Existence”, and check if the CoursNumber and Semester exists by that number entered by the user. But I dont know how I can implement this.

What’s the best and simplest way I can do that?

Check If an Item by same title exists in sharepoint list then display that info in the Infopath form

I have a requirement like this.

I have a SharePoint list named ‘Examdate’ which stores different CoursNumber, Semester and ExamDate. It uses an InfoPath form for entering the CoursNumber in the list.

Now they need to have a mechanism to find out if the user is adding a New ExamDate whose CoursNumber is already present. They don’t want the users to stop the adding process, but instead, want to display the ExamDate for this already existing CoursNumber in the form. This should not happen on the save button.

So, I was thinking of customizing the NewItem form by adding a button near the CoursNumber field, say “Check Existence”, and check if the CoursNumber and Semester exists by that number entered by the user. But I dont know how I can implement this.

What’s the best and simplest way I can do that?

Modifying Page Title To Be Separate From Browser Title

I have a module that contains multiple forms, each form in its own file. I need to modify the page title such that it is different from the browser title for several of these pages. The name of the module is member_login. This is what I have so far:

function member_login_preprocess_page(&$  variables) {   if (\Drupal::routeMatch()->getRouteName() == 'member_login.login') {     $  variables['content']['#title'] = t("The new HTML title.");   } } 

I add this function to the .module file. Do I need to call it, or does Drupal call it automatically for it to come into effect? Currently, I do not see it into effect.

Is there a way or widget to display a specific window title in KDE? (non-focused)

I managed to install a couple of different window title widgets, but they all seem to be locked to focused. Ideally I’d like to be able to have a specific programs window title displayed whenever it is running and be able to customize the appearance.

Kernel: 4.18.0-21-generic

OS: Ubuntu 18.10

batch adding posts to a category based on matching regex for title with SQL

I am adding location categories to posts based on keywords in title, I got it working once, so code is fine if first time, but now get SQL Error (1062) Duplicate entry ‘4419-268’

so I assume its because some fields already are filled…what is the correct code, when updating categories even some might already have same one?

here is my current code

 INSERT INTO wp_term_relationships (term_taxonomy_id, object_id) SELECT '268',  ID FROM  `wp_posts` WHERE (post_title REGEXP '€|E\.U\.|Euro|Europe|Germany|Deutschland|Berlin|Munich|München'  OR post_content REGEXP '€|E\.U\.|Euro|Europe|Germany|Deutschland|Berlin|Munich|München') AND post_type = 'post' 

cheers

Ben