Re: Click Table (Jim Ault)
The key here is > But a table field would (if it worked) be much better. It is a question of field management, or cells within a table. The Rev table object is very difficult to manipulate and get a decent user experience. You mentioned column resizing, which would mean tab stop management in a table object, or padding with spaces in a single field and you said > (did it in hypercard all the time by aligning the report and getting > the clickword, then checking for a sign). In my opinion, this would be better than trying to use the current table object. My attempts to use it have been far from what I would want to use, let alone put in front of a user. Data in cells can appear partially hidden, over the top of other cells, etc. Perhaps you should give it a go and see what you think. You might find that you like the table object and it does what you want. Someone else may have a different answer and perhaps an example stack of the code loops they use to control the table object. Jim Ault Las Vegas On 2/23/07 7:47 AM, "John Runde" <[EMAIL PROTECTED]> wrote: > Thanks for your reply, Jim. > > I also may not have explained what I need very well. > > All i want to do is have a table where i can click on an item > and identify the line & item# that was clicked on, and can drill down > for the user for the details on that item. > > For example, a monthly financial report: > > Column 1 (item 1) would hav categories (of revenue...say) > Row 1 (line 1) would have the months of the year, starting with > column 2... 12 months (Jan, FebDec) > > (you can see that line 1, item 1 would not be used) > > I would then fill that grid with the summary of revenue data for the > monthly report > User wants to see why category "Misc Revenue" was so high in July, > Misc Revenue is line 10, July is column 8 (item 8) > He/she clicks on that number. > click populates cell 1,1 with "10,8" > I then have code that goes puts the category (item 1 of line 10) into > "theCategory" > and the month (item 8 of line 1) into "theMonth" > code then goes to the source document and finds all the entries for > theCategory that originated in month theMonth > I then pop up a stub stack and populate it with those transactions. > > Real simple. I can't believe it is as hard as it is, unless I am > missing something. > (did it in hypercard all the time by aligning the report and getting > the clickword, then checking for a sign). > But a table field would (if it worked) be much better. > > > Thanks, > john > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Click Table (Jim Ault)
Thanks for your reply, Jim. I also may not have explained what I need very well. All i want to do is have a table where i can click on an item and identify the line & item# that was clicked on, and can drill down for the user for the details on that item. For example, a monthly financial report: Column 1 (item 1) would hav categories (of revenue...say) Row 1 (line 1) would have the months of the year, starting with column 2... 12 months (Jan, FebDec) (you can see that line 1, item 1 would not be used) I would then fill that grid with the summary of revenue data for the monthly report User wants to see why category "Misc Revenue" was so high in July, Misc Revenue is line 10, July is column 8 (item 8) He/she clicks on that number. click populates cell 1,1 with "10,8" I then have code that goes puts the category (item 1 of line 10) into "theCategory" and the month (item 8 of line 1) into "theMonth" code then goes to the source document and finds all the entries for theCategory that originated in month theMonth I then pop up a stub stack and populate it with those transactions. Real simple. I can't believe it is as hard as it is, unless I am missing something. (did it in hypercard all the time by aligning the report and getting the clickword, then checking for a sign). But a table field would (if it worked) be much better. Thanks, john ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Click Table
Jim's suggestion is excellent but you might also check the Runrev forum under feature requests. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Click Table
On 2/22/07 8:38 AM, "John Runde" <[EMAIL PROTECTED]> wrote: > I am doing some financial programming. Of prime importance, is a a > Spreadsheet like field... I will call a "click field". It is a > crucial piece of my project, and I have not been able to get it to > work. Note that I am an accountant, not a programmer (but an old > hand at hypercard). > > Here are the criteria I need: > > 1. a table field > 2. the field is locked > 3. when you click on a cell, the row, column (item,line), should be > placed in the top, leftmost cell (i.e. "1,1"). This cell will be > reserved for this purpose. > 4. the table should scroll both H and V > 5. I should be able to resize the table as needed (for various cards). > 6. I will use code to populate the click field, it would be nice if > the field would auto adjust for column width. > > This seems so simple, yet I cannot get it to work. It has to have > something to do with properties, but danged if I can figure out > what. I tried about every property setting in combination, but to no > avail. > > Can someone program the above and either email it to me, or give me > the details. In Rev, it is not simple. There is no real table object, yet. There are plans to do this, but not likely in the near future. I understand you want the user experience to be very much like using a spreadsheet. Most of us are familiar with the Excel spreadsheet which is optimized, operates with tons of code behind it, and is far more versatile than a Rev field will ever be. You might take the approach of putting your calculated values into a substack that is the size of the screen, remains invisible to the user, contains the actual 'table field', then you 'import snapshot' of the rect of that table field into the main stack, put that image into a group (setting the H & V scrollbars to true). Now the user can see the numbers, scroll, click, and you can adjust the size of the rect of the group. The user click location could retrieve the actual number from the substack field and put it into a 'display field' at 1,1 as in get item 6 of line 5 of fld numberGrid For the column width adjust, you would need to get the formattedwidth of the number in each cell, then adjust the max/min tab stop values for each column, then import the snapshot of the filled rows and columns. As you can see, this is not really simple. I avoid using the table object, but in your case, you are trying to make a clean user interface. Key components import snapshot click location on an image => cell clicked substack holding the formatted field, invisible --there are other ways of doing invis fld Hope this gets you started Jim Ault Las Vegas ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Click Table
I am doing some financial programming. Of prime importance, is a a Spreadsheet like field... I will call a "click field". It is a crucial piece of my project, and I have not been able to get it to work. Note that I am an accountant, not a programmer (but an old hand at hypercard). Here are the criteria I need: 1. a table field 2. the field is locked 3. when you click on a cell, the row, column (item,line), should be placed in the top, leftmost cell (i.e. "1,1"). This cell will be reserved for this purpose. 4. the table should scroll both H and V 5. I should be able to resize the table as needed (for various cards). 6. I will use code to populate the click field, it would be nice if the field would auto adjust for column width. This seems so simple, yet I cannot get it to work. It has to have something to do with properties, but danged if I can figure out what. I tried about every property setting in combination, but to no avail. Can someone program the above and either email it to me, or give me the details. email "[EMAIL PROTECTED]" Many Thanks to any who will help, jwr ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution