Neotable get row data on click on it

#1 · March 10, 2022, 9:35 am

Hello,I have a neotable object and load data from mysql. For example 3 columns id, name, city how is it possible when click on a row on this table to get this row data on 3 variables id, name, city.

#2 · March 10, 2022, 11:06 am

Hi @ecotip,

in neoTableInitTable you can define a subroutine, at last parameter, that react to the events on neotable table.
for example
neoTableInitTable "YourContainer" "" 17 "Table" true true true true false "onTableClick"

and then in "onTableClick" subroutine get the clicked row. If id, name, city are the fields of your data loaded in the table use

If [neoTableEvent] == "click"
SetVar [currID] [neoTableRow('id')]
SetVar [currName] [neoTableRow('name')]
SetVar [currCity] [neoTableRow('city')]

.alert with values in clicked row
jsalert "[currID]\n[currName]\n[currCity]"

endif

regards

Rocco

luishp and Gaev have reacted to this post.

#3 · March 10, 2022, 3:32 pm

Thank you very much Rocco,

everything working perfect!!!

Best regards,

George

roccocogliano has reacted to this post.

#4 · December 14, 2022, 11:27 am

Hi..

There is any documentation with those events and variables are used in NeoTable ?

Is frustrating to look left and right for information in posts and examples that normally it should be in a documentation.

I can't find in samples directory this example https://visualneo.com/tutorials/neotable/ so i can examine it.

Here https://webhelp.visualneo.com/neoTable.html there isn't any reference to returning variables or events.

We are not all users advanced or we are new users, so a proper documentation is a useful guide to minimize the effort.

Sorry but the last few days spend my time trying to find information on how things working.

Thanks

#5 · December 14, 2022, 12:41 pm

I can't find in samples directory this example https://visualneo.com/tutorials/neotable/ so i can examine it.

@smartmedia please check on My Documents/VisualNeoWeb/Sample Apps/tutorials
Also check each command description. VisualNEO Web has evolved very quickly and, although we are doing our best to keep documentation updated it's not allways possible.
Thank you for your understanding.

Regards.

smartmedia has reacted to this post.

#6 · December 14, 2022, 1:39 pm

@luishp

I understand how difficult is for one person to manage and keep running such a business, on the other hand a lack of appropriate information on how things working discourage new and novice users like me to continue keep a pace and rhythm of trying and learning.

My proposal is:

Create On VisualNEO Web: Plugins VisualNEO Web page an appropriate folder for every plugin is running so all relative info for every plugin will go right there.
Make a proposal to mature programmers who are respective members of this community like @gaev - @rcohen - @hpw if they want to contribute in updating vital information about how plugins working in help file and on forum.

That my opinion and excuse me if the way i express it hurts someone, this is not my attention.

suyonob has reacted to this post.

Neotable get row data on click on it - Forum

Neotable get row data on click on it