Wordings with SharePoint Words

Column Formatting for SharePoint Online

End User Steps

Select Column=>Column Settings=>Format this column=>Change the code=>Preview=>Save. For more information, visit here


Comic Words on SP Column CSS
Lets enter another beautiful coding in SharePoint CSOM with CSS. Style plays a major role. Each of us are born with a unique style. A part of finding yourself is to find your style.It is very personal.Its never about brand, but your style.Fashion says "me too". Style says "only me". Lets start with a very nice color "pink". As I type this I hope my friend gets her pink dress for her next birthday. Lets start applying a pink background to a SharePoint Column.
Imagine a green world with more greenery and crystal clear water.Now,we have more salty water/ocean and less clean drinking water. The green trees are a treat to the eyes and even soothes the soul and Spirit.I was astounded with the clean vast green grass I saw in US during the first visit.A garden and waterfall nearby would make life very colorful.You can pick fruits/vegetables from garden instead of using supermarkets.Lets try to make the text color green in SPColumn.
Never Compare is a very good motto to follow. The only person to compare is yourself. Color helps to find the data you need faster. If there are thousands of black text, you would focus on one Green text.In the SharePoint world, lets see a scenario where we want to give a different color to different values.How?
Bold is beautiful. Fear is the strongest prison and courage is the way out.Courage is needed in the world. I never faced any bullying till school/college days and faced them first time in office.I always tried to keep away from any group calling me for no reason to come and start making fun of me. Few years back, I understood that some wait and plot to just pounce on me when alone.I loved her and she used to smile.Others used to complain about her to me and I used to stay quiet.I was a tenant of her. She tried to hire me for her kids subject which I hate. I denied and she started harassing. I called the police related many confusions and the robber visit to another girls room. She ran away from police for no reason.Two girls came and they talked in a local language.She was quiet after a police warning. When the girls were leaving home and I was alone, she tried to attack me.I was calm and watching her break and throw all my things.It was a like swimming pool with my drinking water on the ground.Then, when she took my shoes and threw inside my room, I got angry fearing my little teddy will be hit.I hit her with my shoes on the face.She tried to suffocate me to death.I screamed for God and I knew God helped and my self defence comes from no training and she,her family and her servants stopped attacking ran away after I bit her. Thankfully, I am away from such evil places and much better. I definitely prefer peace than stay inside a war zone called Paying Guests in India which are manmade hells to crush many in a small space and get huge money by owners.I trust humans no more and knew many are hidden devils with fake smiles.
Space is mysterious and wonderful.I love vast space. I am still stuck in a tiny dot of darkness. When I close my eyes, I cannot imagine vast space like the stars studded in various galaxies. I heard another NDE experience and understood that this world is a problem and on waking up to a new Reality, the world itself changes. Fear vanishes. The trees and lakes are shining themselves without a Sun. I think we are moving from one Life to another eternally and have no death. What to do in each life?Maybe, Admire the creations and beauty of God, continue to learn, grow and love. Coming back this world, I think of India as Hell and USA as Heaven.When you drive, people almost are so close to you. In USA, the people keep a 1 car distance. There is more Space in USA and lesser people. Lets give more space in #sharepoint SharePoint column using word spacing.
I found a new nice change in SharePoint Look. The Site Contents were hidden. More space now! I had to walk alone long back when back from office.There was a friend in front of me with my shape. Guess? Shadow. Lets give Shadow effect in SharePoint Field.I used to wonder at the mystery behind Light and Shadow. It was a miracle to me.The brighter the Light, darker the shadow. I just changed the lights in my rooms and even tried the shadows of different Lights. One person met God just by thinking about source of consciousness. That is one of the best encounters with the Supreme Being so far in silence without any religion where DJ Jones could see the whole Universe as you see your hand and did not die. Jones came out of the body for no reason went through Time itself and saw real himself as a shadow. He moved on beyond and found God.The Love,Bliss was wonderful. He could not fight Power to stay there.Many times, we understand what we want when we lose.When I lost consciousness recently, I realised I want to be conscious and not lose consciousness. But, what is consciousness? I do not know. I hope that my conscience is intact even after reading so many religions.
What is the best location for a text many times.Center.Lets center the content in a SPField.The location plays a major in our life. Many of us want a safe neighbourhood. Some are good in any kind of environment.Most are affected easily by the circle of friends or the environment.Many are very good in heart and cheated easily by the world.Many of us are in the center of our life and wondering what to do. It is like crossing the road with 2 lanes with vehicles going to your left and right.You have decided to cross the road. You are in the middle of the road. Its time to cross the road and not decide what to do in the middle of the road.We are in the crossroads of our life and mostly in the middle of our life.We have a bunch of experiences and have come to the present.Sometimes, life is as terrible like standing in the middle of traffic.With the help of God, there will be no vehicles on the road when you cross and you can live your life happily and peacefully ever after.
I saw nice words. A boss tells an employee to have a nice day. The employee goes home to have a nice day.A house is made a home after much decoration and cleanliness. An important text can be emphasised by using text-decoration in CSS. The same can be applied in SharePoint Field CSS.
The first and last lines in a story makes an impact. While reading story books/movies, I always used to read the climax/last part.Most of the fairy tales are usually 'Once upon a time, ...[something happened]..and lived happily ever after'.After analysing the common features of those going to a far away realm and coming back for a special mission, I believe that each of our story is to live happily ever after in that Beautiful Light filled with Love, Peace,Bliss, Joy.Any story begins with few gap in the first line.How do we do such an effect in SharePoint field?Using text-indent.
Going higher is always better. Upper berth in sleeper coaches in train is always better. I enjoyed the first floor in trains in New Jersey Transit.While going Higher, we can get a better picture.The view from a mountain top is much better than a view from the ground.Uppercase text can be useful sometimes.How to make the words in a SharePoint column speak louder?Using Uppercase.
I had worked on edge detection during college days on images. The colors are amazing and the edges also add beauty. I have heard that a kid sees a black and white world before the colors are manifested to the eyes. While coloring , I love to use the black sketch after the coloring is done.How to give border to a field in SharePoint?
Many times, we are lost and not knowing what to do. In that case, its better to start with an outline on what all one can do. You can write down all your skills, hobbies, interests. You can develop new skills in your new interests like rock climbing, travelling etc. After noting down everything, you can sort them and spend time with each of them. After few months, that which gives you peace of mind, health, joy to you and others will mostly be the right choice. If you are a programmer, you can start with an outline of what codes you can do to make life simpler and easier. In SharePoint Field, an outline or a nice dotted border can be given to make the content more special like a nice card.
SharePoint Lists contain data. Can put the data for a Field in a nice container shaped as "U"."U" or "You" cannot be contained in a small body and are definitely much more than this body with the capacity to tap into the whole Universe and get what you want. You can think, thank, forgive, achieve etc. Lets fill the SharePoint data inside a cup, just like filling a cup with water/tea/juice with your friends. May your cup overflow with peace, love, joy, happiness and awesomeness too.
VIBGYOR. Here is a beautiful quote by Kyle:"A rainbow is a product of physics working for your appreciation of beauty".Colors add beauty to life. Many who travelled different dimensions report of seeing vibrant color more fantastic than the colors in this physical world.Lets add colorful borders to a list column.
We might sometimes overflow with too much words and the listener might run away. It is nice cut short the words and show only the needed content. How? Using overflow. You can hide extra content using hidden property. Lets not use overflow in certain cases. Overflow in your life with peace, love, awesomeness.Time is precious and no one has time for another. I have cherished the presence of many loved ones and not the conversations many times. A kid grows happily in a family getting love and affection. I feel we are here to love only family, friends or selected few and not everyone. Many times, jobs snatch away the time with family/loved ones and one is busy doing something after one has to live in the world created by monkey minds. Even a bird can learn to fly,get food and live. Humans have to think and select from many careers and the world steals the time. HR has no heart and I was pained to hear that one girl I spoke to was not allowed to cry for her fathers demise.Many parents want to spend time with kids and the jobs/education steals too much time away. 9-5 routine may have to be reduced to let the humans sleep earlier.
Images play a major role in our life. Many evil people go after fame/image/brand/counting money created by hidden unknown workers and forget about the normal beautiful images to be seen in day to day life. I still know many companies/religions who have big big teams just to work on social image on facebook or many sites rather than the product/work/well being of others. They have a team to shut the Voice of Truth coming from what happened by trying to bribe/threatening those who tell the truth.Sadly, many developers leave the product they developed and someone else takes ownership and tries to get profit. If developers sell, the better. Many sales people are forced to lie unnecessarily. One of the biggest gifts we have is our eyesight and its nice to see the beautiful creations on Earth. Image processing has improved to a great extent and many softwares can change the image to stunning imaginations. #SharePoint also allows you to give nice effect on images. We can add an image to a field in a column. I still could not get the background image working in a SharePoint field. This opacity effect gave a background like effect.Lets add an existing SharePoint cute image to a column in SharePoint.
We are in a global village. The most confusing aspect of globalisation is Time.Time itself changes in different places. When the sun is setting for one, the sun is rising for another. You might be working with someone from far away.Mere looking at the watch now is not enough. I need to use an app /tool to convert a time of someone located far away to my local time. What is the value of Time? Priceless. Cost? It is free though. Time spent wisely is a great art. Suppose, in SharePoint, we have all the values in DataTime format and want to see the data in Local string.How?Using toLocaleString().For example,a value of Fri Oct 12 2018 23:58:43,changes to 10/12/2018 11:58:43
I feel many pain in life comes from unwanted waiting. Though many say that we should be patient, I feel we become patients after waiting due to unnecessary anxiety. Even patients are expected to be patient in a queue in a hospital. From my experience, body heals naturally and the body might heal itself during the waiting time without a doctor.Many make forced appointment at a time with one person deciding the time. It is better not to plan any meeting without mutually agreeing at a time which suits both/all. It creates anxiety and most of the thoughts are spent on Time and not enjoying the moments of the day as per your choice and life is manipulated by another who steals your time. Many good things happen without planning at the right time. Better to stay away from any system making us wait. Waiting for a call is pain after interviews. Waiting for a call from a liar who promises to call at a time is waste.Such systems which make us wait unnecessarily are evil. Life without queues is much better. Imagine each waiting for a car to be manufactured one by one. Parallel processing helps.Slowly, even the SharePoint Lists are showing updated data without me refreshing.How to show wait cursor for any column?
Computer has entered the drawing area and it is nice to watch the computer draw nice images based on codes. Computer drawings are way better than my paper drawings with the right algorithms. Most of the animations create stunning graphics much better than many minds can imagine. Drawing/ Coloring is a common enjoyable activity for most kids. I was trying to get that yellow mark on a text in SharePoint column using clip and not working yet. Lets try the height,width,border and also get a cross effect on hovering.
The Virtual Reality is very nice where you are at the center and getting a 360 degree view of the movie. This is almost close to the actual experience without going through the physical pains involved. For example, stunning view of underwater oceans, climbing Mount Everest, Roller Coaster ride etc. Imagine going to a nice huge lake surrounded by mountains. Where is the best view? You would row to the center to get the 360 degree view. Similarly, content in center is better than regular content shown on the left. How to center the content in the center of the box for a SharePoint column? Using padding.
Many times, I hate money. Because money is used to hire and not help others. Those who help are forced to beg for money from those who hire. For what? For helping the clients. Thanks to technology ,things are improving and many can get paid directly from clients and also get a Thank You from those whom they help instead of waiting for Promotion for years from unwanted systems. A friend in need is a friend in deed. Have you got any friend who has helped you in times of need? Friends do help in times of need for free and get a place in your heart. I was touched by the story of a lady Crystal who had to walk out of the no gas/electricity house with her kids on the road in cold winter due to non payment of bills by her drunk husband. While she was walking, a cab driver stopped and dropped her in her mothers house for free. How to add a help icon on hovering over a SharePoint Title Field?
Its better walk alone in the right way than to walk in the wrong way with the crowd. The inner compass always guides you much better than outer signs from relations, places, external world. We all need to go in the right direction. The right choices help us to lead an independent, righteous life filled with peace, joy, laughter and good health. Lets try to put the text also from Right direction. As a kid, I had learnt the Arabic language where the text starts from right to left. Lets try to put the text of Title column from Right to Left.
Emails have changed the world to a safer place. Email is much better than chat, giving enough time to think and freedom to respond/not respond. You can also store the documents in email.Long ago, time was wasted in physical meetings with tiring travels to share the thoughts or have a discussion. Physical meetings might go ahead to physical abuses and it is funny to see certain countries throwing chairs in the political debates. In SharePoint list, how can we see the current Email of the logged in User ID?
Long ago, displaying the current day was not straighforward in SharePoint.Create a dummy column with formula Today and then many strange steps.Now, with the help of @now and formatting column, sharepoint allows you to view current date and time with ease.The power of Now is immense.Now is always the right time to make the right choices and go ahead to fulfill the cherished dreams and get back the Joy,Peace and Love you deserve.
End User Steps

Select Column=>Column Settings=>Format this column=>Change the code=>Preview=>Save. For more information, visit here

CSOM Code($CSSDisp1Field.CustomFormatter=$CSSCode;)
#Download Sharepoint online client components
#Specify tenant admin and site URL
$User = "admin@xxx.onmicrosoft.com"
$SiteURL = "https://xxx.sharepoint.com/sites/dev"
#Add references to SharePoint client assemblies 
$spPath="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\"
Add-Type -Path ($spPath+"Microsoft.SharePoint.Client.dll")
Add-Type -Path ($spPath+"Microsoft.SharePoint.Client.Runtime.dll")
Add-Type -Path ($spPath+"Microsoft.SharePoint.Client.Search.dll")
Add-Type -Path ($spPath+"Microsoft.SharePoint.Client.Taxonomy.dll")
Add-Type -Path ($spPath+"Microsoft.SharePoint.Client.Publishing.dll")
Add-Type -Path ($spPath+"Microsoft.SharePoint.Client.UserProfiles.dll")
$Password = Read-Host -Prompt "Please enter your password" -AsSecureString
$Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($User,$Password)
#Bind to site collection
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
$Context.Credentials = $Creds
 
#Create a new list
$listInfo = New-Object Microsoft.SharePoint.Client.ListCreationInformation
$listInfo.Title="PSJSON"
$listInfo.TemplateType=[Microsoft.SharePoint.Client.ListTemplateType]::GenericList
$psListJSON=$context.Web.Lists.Add($listInfo)
$psListJSON.Description = "JSON List through code"
$psListJSON.Update()
$Context.ExecuteQuery()
 
$psListJSON = $context.Web.Lists.GetByTitle("PSJSON")
$context.Load($psListJSON)
$Context.ExecuteQuery()
 
$fieldType="Text"
$fieldName="CSS1"
$fieldXml="";
$CSS1Field=$psListJSON.Fields.AddFieldAsXml($fieldXml, $true, [Microsoft.SharePoint.Client.AddFieldOptions]::AddFieldInternalNameHint);
$Context.ExecuteQuery()
 
$CSS1Field=$psListJSON.Fields.GetByInternalNameOrTitle("CSS1")
$Context.Load($CSS1Field)
$Context.ExecuteQuery()
 
$CSS1Field.Title
$CSS1Field.CustomFormatter=;
$CSS1Field.Update()
$Context.ExecuteQuery()