After .onRowSelect, the record's id is 'undefined'

Ask the community
,
21

@karenmpiekarski
You get this CONSOLE-LOG, when clicking onto on of the table-rows…

1090×903 62.9 KB

I gave you already the code for this action, take a look 2-3 of my post ago.

Here the working CODE one more time (for the onRow-Select-Action)…

var myDATA 

export function table1_rowSelect(event) {
    console.log(event)
    $w('#BTNeditItem').enable()
    myDATA=event
}

export function BTNeditItem_click(event) {
    console.log("myDATA = ", myDATA.rowData)
    console.log("-------------------------")
    console.log("myDATA = ", myDATA.rowData._id)
    console.log("Salutation = ", myDATA.rowData.anrede)
    console.log("First-Name = ", myDATA.rowData.vorname)
    console.log("Last-Name = ", myDATA.rowData.name)
    console.log("Status = ", myDATA.rowData.status)
 //------------------------------------------------
    $w('#input1').value = myDATA.rowData.anrede
    $w('#input2').value = myDATA.rowData.vorname
    $w('#input3').value = myDATA.rowData.name
    $w('#input4').value = myDATA.rowData.status
 //------------------------------------------------
    $w('#columnStrip1').expand(), $w('#columnStrip1').show('fade')
}

You have 2-click-functions: 1) table1_rowSelect 2) BTNeditItem_click

  1. On first click → onto one of the many “table-rows” you get the console-log of the “click-event” (the big console-message on the beginning of this post).
    There you can get all the neccassary data of the event.
    Just take a closer look on it. You can recreate this console-log by your own, just run the example by yourself (while the console-window of google-chrome is opened —> F-12+CONSOLE).

in the first function a VARIABLE gets it’s VALUE after the first click was maden…

myDATA=event

The VARIABLE (“myDATA”) itself already was created right the beginning of the CODE.

Now (after the first click) “myDATA” holds the —> “event”-VALUE, a big bunch of data, which you can see in the console-log-pic.

  1. On second click the data of -->“myDATA”-variable is used to get all the saved row-data in this variable & pull these data into the shown INPUTS.
$w('#input1').value = myDATA.rowData.anrede
$w('#input2').value = myDATA.rowData.vorname
$w('#input3').value = myDATA.rowData.name
$w('#input4').value = myDATA.rowData.status


“anrede” —> “Frau”
“vorname” —> “Angela”
“name” —> “Merkel”
“status” —> “Inaktiv”

893×615 97.4 KB

You can also open much more columns in this example, when you go to the Settings…

887×651 83.8 KB

Which are your oppertunities/possibilities you will find here…

https://www.media-junkie.com/databases

There you will find the completed “Team”-DATABASE with all it’s data-fields.

To show more fields, just type in more existing column-data…

  1. nationalitat

  2. ausbildung

  3. verfugbarkeit

  4. and so on…
    Put these data into the INPUTS —> DropDown-Settings (in the middle).

  5. sprache & bundesland are special data-fields —> selection-tags.
    These ones you put into —> Check-Box-Settings (right-handed).

With these simple steps you will expand the given example.
Try it out.