how to modify values in list tables before display

Ask the community
,
1

Hi
All Im trying to do is concatenate firstName,LastName when displaying, as well show data creation date with time. It should be very simple fix, but Im just not able to crack it :frowning:
here is the code and the table Im trying to show:

Do let me know how to add pagination too ,from coding .

1503×855 55.3 KB

// For full API documentation, including code examples, visit https://wix.to/94BuAAs

$w.onReady(function () {
});

export function dataset1_ready_1() {
 // Add your code for this event here: 
$w("#dataset1").getItems(0, 20) //gets 20 items
  .then( (result) => {
 let items = result.items;
    console.log(result.items);
    items.map(item => { //loops for each item
 
 if (item.newField) { //makes sure the field is not empty
 //item.newField = item.newField.toLocaleTimeString(); //changes the format to only show the time            
            item.newField = item.newField.toLocaleString('en-GB', { timeZone: 'UTC' });
 //
        }
    })
 
    $w("#table1").rows = items; //populates the table
  } )
  .catch( (err) => {
 let errMsg = err.message;
 let errCode = err.code;
  } );
}
2

Hi
I changed the code, but dont know how to modify date column before display.
I as well read: https://www.wix.com/corvid/reference/$w/table/rows
it doesn’t show how to modify the data returned from the query before using it to set the table’s row data.
My key objective is to show date with time in list table.
ps:pls provide me syntax for : row._createdDate = date; (I know this is wrong)

import wixData from "wix-data";

$w.onReady(function () {
  wixData.query('customForm') 
    .find()
    .then(res => {
 let tableRows = res.items;
 
       tableRows.forEach( (row) => {
         console.log(row);
 let date=res._createdDate;         
         row._createdDate = date;
      } );
 //  $w('#table1').rows = res.items;
     $w('#table1').rows = tableRows;


    });
});