Grid

• Data is required.
• Data must be a 3-digit number.
• Data must be less than or equal to 500.

<fine-grid id='myGrid1'>
</fine-grid>

<script type="text/javascript">
  var info = {
    element: 'grid',
    example: 'validations'
  };
  
  function customerNumberCheck(number) {
    return /^\d{3}$/.test(''+number);
  }
  
  fine.ready(function(e) {
    var el = document.getElementById('myGrid1');
    el.set('theme', 'flat');
    el.setConfig({
      height: '400px',
      showToolbar: true,
      columns: [{
        field: "orderNumber",
        title: "Order Number",
        width: '100px',
        filtering: false,
        displayFormat: '0,0',
        editable: false,
      }, {
        field: "orderDate",
        title: "Order Date", 
        width: '40%',
        dataFormat: 'Y-MM-DD HH:mm:ss',
        displayFormat: 'dddd, MMMM Do YYYY',
        editFormat: 'MM-DD-Y',
        saveFormat: 'Y-MM-DD',
      }, {
        field: "status",
        title: "Status",
        width: '150px',
      }, {
        field: "customerNumber",
        title: "CustomerNumber",
        validation: {
          validations: [{
            function: 'require',
            message: 'Customer number is required'
          }, {
            function: 'customerNumberCheck',
            message: 'Customer number must be a 3-digit number'
          }, {
            function: 'max',
            arguments: [500],
            message: 'Customer number can not be greater than 500'
          }]
        }
      }, {
        commands: ["Edit", "Delete"],
        editingCommands: ["Save", "Cancel"],
        width: '120px',
        filtering: false,
      }],
      dataSource: {
        schema: {
          model: {
            idField: 'customerNumber',
            fields: {
              orderNumber: {
                type: 'number'
              },
              orderDate: {
                type: 'date'
              },
              status: {
                type: 'string'
              },
              customerNumber: {
                type: 'number'
              }
            }
          }
        },
        transport: {
          read: {
            url: "gridDataService.php",
            dataType: "text"
          },
          update: {
            url: "gridDataService.php",
            dataType: "text"
          },
          create: {
            url: "gridDataService.php",
            dataType: "text"
          },
          destroy: {
            url: "gridDataService.php",
            dataType: "text"
          }
        },
        serverPaging: false,
        serverFiltering: false,
        serverSorting: false,
        serverGrouping: false,
      },
      paging: {
        pageSize: 10
      },
      sorting: {
        type: 'multiple',
      },
      filtering: {
      },
      editing: 'batch',
    });
  });
  
</script>