The only way to pass a URL parameter to a SharePoint Online (modern design) form’s field is to use PowerApps (at least, if you cannot add any JS on your website!). Important warning: when you use PowerApps to manage your form, all edits to the list settings won’t reflect to the PowerApps form. For example, […]
Tag: Niveau expert
Transfer an Alexa AWS Lambda function from the online editor to the ASK CLI
When we follow the guide to build a new smarthome skill, it gives the steps to create a function in the online code editor. But if you prefer to use the ASK CLI, there is some steps to follow… I first create a fake skill with ask new (using the “hello world” and “AWS Lambda” […]
Debug a third party Android APK
(inspired by this blog post) 1) Install smalidea plugin Download the smalidea plugin (see also the related Github Repository). Open up Android Studio and you should see the welcome screen like the one on screenshot below (if not, close your current project by selecting File -> Close project), go to the Plugins section, and from […]
Capacitor Plugin for HTTP requests with self-signed SSL certificates
I’m using CapacitorJS for easy development with Android. I needed a way to do an HTTPS request to a box that uses self-signed SSL certificate. To accomplish it, I created my own capacitor plugin. See this wiki page for details: https://github.com/Aymkdn/assistant-freebox-cloud/wiki/Capacitor-Plugin-for-HTTP-requests-with-self-signed-SSL-certificates
Let’s Encrypt Certificate: how to remove a domain from a certname that contains several domains
My server manages several websites with different domains using Apache. The first time I used Let’s Encrypt I followed the default command which has created one certname for ALL my domains. Now I want to remove just one domain from this certificate, and it becomes complicated to understand how to do it. The best solution […]
Upgrade from MySQL (5.6.40 – Debian 9.12) to MariaDB
(Source) A few steps: sudo apt-get install software-properties-common dirmngr wget -qO – https://mariadb.org/mariadb_release_signing_key.asc | sudo apt-key add – nano /etc/apt/sources.list.d/mariadb.list In mariadb.list we add the two below lines: deb [arch=amd64,i386,ppc64el] http://mirror.23media.de/mariadb/repo/10.4/debian stretch main deb-src http://mirror.23media.de/mariadb/repo/10.4/debian stretch main Then: apt-get update apt-get install mariadb-server
Sharepoint REST API to index a column or delete a column and more…
Due to the 5,000 items threshold limitation it can become very frustrating to administrate Sharepoint. For example, if your list has more than 5,000 items, you cannot add an index, delete a lookup/people column, delete the list or the website, and more ! Hopefully some of the operations can be done with REST API, and […]
Create a self-signed certificate for localhost testing with IE11 and Webpack
Sources: https://stackoverflow.com/questions/44988163/create-self-signed-certificate-for-testing-localhost-and-have-it-accepted-by-the http://woshub.com/how-to-create-self-signed-certificate-with-powershell/ https://stackoverflow.com/questions/4691699/how-to-convert-crt-to-pem/4691749#4691749 https://webpack.js.org/configuration/dev-server/#devserver-https If you develop with Webpack under Windows and you want to open your localhost server in HTTPS with IE11 you may receive a message like : “Content was blocked because it was not signed by a valid security certificate.” Below I explain the steps to make it work with IE11: […]
Remove custom properties/metadata for an Office document [javascript]
I have this document library on Sharepoint where I have one custom column called Metadata and that is a lookup to another list on my Sharepoint. When the users download an Office document from this library and then re-upload it we could have the below error message: There is at least one lookup column that […]
How to delete a document locked by another user in Sharepoint using JavaScript
When you open a file from Sharepoint, it will receive a short term lock that will prevent others to change some properties on the file. This protection can be useful, but also very annoying, for example when the file is not closed properly, then the lock could stay “forever”. There are many posts on the […]