SPO list view formating - json beginner
Hi, When i'm doing conventional row format - change the row color of items modified today - it does that and creates the json of this view. Nice. There's a simple Hover on Title json code that when i try just this code it works very nice. I am trying to combine the 2, row conditional format and hover. can someone assist? https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting scroll down to Default cards on hover via formatting. I copied the code here: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "children": [ { "elmType": "img", "style": { "width": "32px", "height": "32px", "overflow": "hidden", "border-radius": "50%", "margin": "2px" }, "attributes": { "src": "='/_layouts/15/userphoto.aspx?size=S&accountname=' + [$Editor.email]", "title": "[$Editor.title]" } }, { "elmType": "span", "style": { "vertical-align": "middle", "margin-left": "2px" }, "txtContent": "[$Editor.title]" } ], "defaultHoverField": "[$Editor]" } thanksLookup values invisible on QuickEdit (JSON formatted)
Hi there, I hope you can help. Values on a Choice column appear colour formatted on QuickEdit view. However values in a Lookup column (values taken from a lookup list) are invisible on QuickEdit. The values are there, but are only visible when you click into the cell. Both Choice & Lookup columns have the same formatting. The screenshot below shows how the columns display in regular list view versus QuickEdit view. Attached is the JSON formatting code I have. Can anyone help please? Thanks.
Engineering Notation Formatting Excel
Enhancement Suggestion Engineering Notation Formatting is one of the most useful yet least documented options. This is at least true for electrical or any other field with calculations requiring unit conversions and consolidation. ##0.0E+0 This should be in a more convenient category under beside or under Scientific Category vs 2 mouse clicks and a big scroll deeper as almost undocumented option under "Custom". How does ## make you intuitively guess this means Engineering notation? Ideally would also have option to fix the exponent . i.e so you could stay in the same units nanoseconds or millivolts even if move more than 1000 units.. A suggestion for one of my favorite tools.
