Change column position using JSON sharepoint online

Is it possible to change the positions of the columns in a JSON template? I have ordered them within the JSON file, but once the template runs the default sharepoint columns still show in the original position.

Example

I would like Version column to appear first, Name column to appear second, and Program column to appear third.

Correct column order of comparison data table

I need to design a table where the user will need to approve new values. The table will show him two old values and the gap between the old ones and the new one (The percentage represent the gap from the old value to the new value), if he’ll see a suspicious percentage gap he will check the amounts.

Do you have an idea of how to sort the columns for efficient scanning and so it will be clear what the percentage represents?

Table design example

sharepoint online – Calculated Column – Days Difference – Syntax Error

I have a SharePoint List and I’d like to have a column to calculate the days it take to solve a ticket (Solution date – Submission Date).

I tried to create a calculated column, by using a formula = DATEDIF((Submission Date),(Solution Date),"D"), and return data with “Number”. It didn’t allow me to create this as it says Syntax error.

I researched and tried to replaced “,” with “;” = DATEDIF((Submission Date);(Solution Date);"D") , still didn’t work.

Both Solution date & Submission Date columns are formatted as “Date and Time” Type.

Displaying Column Description on Hover without SharePoint Desinger

Is there a way to show the description of a column of a SharePoint online list when the mouse is hovered on in the modern experience without SharePoint Desinger?

Maybe similar to this one (https://stackoverflow.com/questions/48230765/displaying-column-description-on-hover) but in the modern experience.

Add a seach box to an integer column in SP online list

Stack Exchange Network


Stack Exchange network consists of 177 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

query – MySQL Dynamic Result view with column when values are on same column

I want to create a dynamic value based on election result. I’ve three table.

  1. vote table
  2. Candidate table
  3. Candidate position table.

Here the candidate table and position table is dynamic. its means I haven’t any control on it.

I want to make a view like this:
enter image description here

Here Ballton num come from vote table, president, general secretary and treasurer is come from candidate position table and against each ballot no all column will be populate.

Here are the rest of the table structure:

Vote:
enter image description here

Candidate:
enter image description here

Candidate position:
enter image description here

Filter on Multiple values for same column using Rest api

Is it possible to filter using rest api in sharepoint to Filter on Multiple values for same column ?

query performance – Indexing a date column in MySQL doesn’t work if a date function is used

I have a table with the following schema

table_name

id int
task_id int
completed_date datetime (INDEX IX_TBL_NAME_COMPLETED_DATE)

I run EXPLAIN on this query

EXPLAIN 
    SELECT
        *
    FROM table_name TBL
    WHERE
        TBL.completed_date BETWEEN date1 AND date2

This query runs and fetches records using the index on completed_date

However,
While running the same query with a date function

EXPLAIN 
    SELECT
        *
    FROM table_name TBL
    WHERE
        CONVERT_TZ(TBL.completed_date, timezone1, timezone2) BETWEEN date1 AND date2

The index isn’t made use of resulting in a slow query.

Can someone explain the reason behind this behavior and solution to optimize queries like this?

sales order – How to add new column in sales_order_grid.xml dynamically or direct from class?

enter image description here

I have created a configuration for selecting fields from sales_order table to join with sales_order_grid table. I need to show these selected extra fields on the sales order listing page. like the screenshot below.

enter image description here

When enabling the fields from configuration it will be shown in the order listing page. Could you please help me to sort out this issue.

I have tried below code in app/code/Vendor/OrderGrid/view/adminhtml/ui_component/sales_order_grid.xmlsales_order_grid.xml

<columns name="sales_order_columns">
    <column name="customer_id" class="VenorOrderGridComponentFields">
        <argument name="data" xsi:type="array">
            <item name="config" xsi:type="array">
                <item name="component" xsi:type="string">Magento_Ui/js/grid/columns/column</item>
                <item name="label" xsi:type="string" translate="true">Customer id</item>
                <item name="sortOrder" xsi:type="number">60</item>
                <item name="align" xsi:type="string">left</item>
                <item name="dataType" xsi:type="string">text</item>
                <item name="visible" xsi:type="boolean">false</item>
                <item name="filter" xsi:type="string">text</item>
            </item>
        </argument>
    </column>
</columns>

And extend Column class by Fields VendorOrderGridComponentFields.

    public function prepareDataSource(array $dataSource)
    {
        if (isset($dataSource('data')('items'))) {
            foreach ($dataSource('data')('items') as & $item) {
               $item('componentDisabled') = 1;
               $item('visible') = 0;
            }
        }
    return $dataSource;
    }

Google Sheet Column Tick box validation

Complete newbie here, sorry if this sounds silly.

I have 3 columns and 60 rows of tick boxes, I have the tick boxes adding up at the bottom of the sheet.

Question is I do not want a user to tick more than the available ticks per column each column has a maximum amount of tick boxes available.

For example column, A max ticks allowed is 12, B max ticks allowed 7 and C Max 25.