With "dbpGetActiveField" I only get the name of the column, but not in which row I clicked the column (for example: I clicked to the third entry in the column "filmtitle" - row 3 - than the variable online says "filmtitle", but I have to know the exact field I clicked to display information exactly to the film I clicked on - on a separate page.
For your needs, you don't need to know the actual column that the user double clicked.
However, when a user double clicks a row, that row becomes the "current record" .. meaning that the NeoBook special variable of the form [dbDatabaseName.dbTableName.dbFieldName] contains the value of the field (column) in the row that the user double clicked.
So, when you double click in row 3, the value of the cell at the intersection of Row 3 and Column headed FilmTitel can be found in [FilmDB.Filminfos.Filmtitel] ... you can verify this by placing an AlertBox
command that shows the value of this special variable in the subroutine that responds to the double click n the grid.
This value keeps changing as you navigate up and down the rows ... so you can use SetVar
to copy the needed value to another NeoBook variable.
Note that the little black triangle in the left most column of the grid (pointing towards the right) always tells the user which row is the "current row".
And I don´t really know how to resort the list alphabetically by genre or filmtitle with a button and how to search the list for titels I type in an input field.
To view records in a specific sort
order, take a look at the commands dbpSort
in the Help
, take a look at dbpQuery
By the way, the Action Command Reference
section of the Help
contains all the available commands for this plugin ... you might want to read up on this list first ... will save you a lot of wait time on this forum.