Data Table Validator Data Type

Hi All,

I have an "import" button set up on my data table so that values can get pasted in directly from a spreadsheet. Is there a way to prevent submission if one of the values for one of the fields is empty or of wrong data type (e.g. can I set a restriction for a field to be numbers only)?

Here is the javascript I'm using below:

fd.rendered(function() {
var grid = fd.control('CarrierUpdates').widget;

grid.setOptions({toolbar: [
		name: 'import',
		text: 'Import'

    // get the grid position
    var offset = $(this).offset();
    // crete a textarea element which will act as a clipboard
    var textarea = $('<textarea placeholder="Paste your text here..."></textarea>');
    // position the textarea on top of the grid and make it transparent
    	position: 'absolute',
		left: offset.left,
		border: '1px solid grey',
		width: 200,
		height: 100
    .on('paste', function() {
		// handle the paste event
		setTimeout(function() {
			// the the pasted content
			var value = $.trim(textarea.val());
			// get the pasted rows - split the text by new line
			var rows = value.split('\n');

			var data = [];

			for (var i = 0; i < rows.length; i++) {
				var cells = rows[i].split('\t');
						Carrier: cells[0],
						DeliveryNote: cells[1],
						PlannedPickupDate: cells[2],
						OTMPUAppointment: cells[3],
						CustomerMaster: cells[4],
						PlantShortName: cells[5],
						Destination: cells[6],
						OTMNumber: cells[7],
						RisktoMakePUAppointment: cells[8],
						IssueReason: cells[9],
						NewETADatePickUp: cells[10],
						NewETATimePickUp: cells[11],
						Comments: cells[12]
	.on('focusout', function() {
	setTimeout(function() {


I appreciate any help in advance! Thank you!

Hello @markymark,

Welcome to Plumsail Community!

You can convert value to number and check if it is valid before creating the record. For instance, value in Column 2 should be a number:

for (var i = 0; i < rows.length; i++) {
					var cells = rows[i].split('\t');
                    var numberValue = Number(cells[1]);
							Column1: cells[0],
							Column2: cells[1]
                    else {
                        alert('value in line ' + i + ' Column 2 is invalid');