(data grid) is there a good workaround for obtaining other column values in FillInData for a Data Grid Table?

Josh Mellicker josh at dvcreators.net
Thu Aug 19 21:40:32 EDT 2010


Wow, I just looked at this, fabulous!!! Thanks!!!

On Aug 18, 2010, at 1:19 PM, zryip theSlug wrote:

> On Wed, Aug 18, 2010 at 4:15 AM, Josh Mellicker <josh at dvcreators.net> wrote:
>> Let's say you had a data grid table with three columns, and you wanted the first column to be the sum of the other two, like this:
>> 
>> 10      7       3
>> 5       2       3
>> 7       4       3
>> 
>> How would you calculate the first column while the table is filling in?
>> 
>> 
>> ---
>> 
>> Originally, we looped through the data and did the calculations, then put the data into the data grid. Now the data set is getting so large that this is too slow, looping through once to calc, then again for the grid. So we're thinking doing the calculation in FillInData would be more efficient. If possible.
>> 
>> It's easy to find any field value in a Data Grid form, since pData is an array with the row values, but we'd like to avoid switching to a form._______________________________________________
> 
> I have just upload an experiment stack in the Slug's website:
> http://www.aslugontheroad.co.cc/index.php?option=com_phocadownload&view=category&download=8:experiment-013-doing-sum-in-a-column-of-a-data-grid&id=7:data-grid&Itemid=63
> 
> The experiment shows how doing a sum of three columns in a column of a
> data grid:
> - when the dg is filling in
> - when you change a value in one of the three columns.
> 
> The stack using a custom column behavior. You can access to the script
> by clicking on the edit script button.
> 
> HTH
> 
> Regards,
> -- 
> -Zryip TheSlug- wish you the best! 8)
> http://www.aslugontheroad.co.cc
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the Use-livecode mailing list