Hi Kirk, What version are you using? If it's v16 or less think of the tasks you trying to accomplish in terms of the selection in the listbox instead of the cells. For the fill down example from the listbox you determine what field (column) you are working with then apply the changes to that field of the selection. To select a record within the selection you use GOTO SELECTED RECORD. https://doc.4d.com/4Dv18/4D/18/GOTO-SELECTED-RECORD.301-4504918.en.html To make some change to a subset of the selection you use the set named in the listbox config, make the edit and then restore the selection. And so on.
If you are using v17+ I would strongly encourage you to start a brand new form and use Form and an entity selection for the listbox instead. From your question I can tell you are working with an unfamiliar mode of listbox use. If you haven't started learning ORDA and its accompanying new capabilities this sounds like an excellent application for them. The time you spend learning to use ORDA will pay dividends moving forward. Learning about selection based listboxes is only useful if you are working on an old project that requires them. On Tue, Nov 12, 2019 at 12:22 AM rooftop99--- via 4D_Tech < [email protected]> wrote: > Hi All > > I feel like a rookie, but here is the deal... > > I have used array Listboxes many times with success. A current project > requires the use of a Selection based listbox. How do I execute Cell level > logic? For example: Let’s say I want to create a simple “fill down" > function. The user highlights several rows and right-clicks a one of the > cells on the top row, then chooses “Fill down” from the menu presented > using the command “Pop Up Menu”. "ListBox Get Cell Position” command gives > me the row and column plus a pointer to the field clicked on. With all > that information how do I get the value of the clicked on Cell (field) so I > can stuff it in a variable and how do I walk down every row (record) in the > highlighted selection and apply this value. In an array Listbox it would > be simple. I am missing something in a Selection based Listbox... > > I am sure I will slap my forehead and mutter the words, “that is so > simple, why didn’t I think of it!!” when I hear the answer, but how do I > reference a single cell (record/field) in a selection based listbox to > either read values or to write values? > > Thanks in advance for your help. > > Kirk > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- Kirk Brooks San Francisco, CA ======================= What can be said, can be said clearly, and what you can’t say, you should shut up about *Wittgenstein and the Computer * ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
