kitty | UI Components i 've built and used over the years | User Interface library

I have a table in the following format :

owner_id question response created_at 1 dog_name Rex 2021-05-31 1 cat_name Old Kitty 2021-05-01 1 cat_name New Kitty 2021-05-30 2 cat_name Bella 2021-05-28 3 bird_name Birdy 2021-05-28

And I would like to be able have the list of owner with each pet's name :

owner_id dog_name cat_name bird_name 1 Rex New Kitty NULL 2 NULL Bella NULL 3 NULL NULL Birdy

I have manage to list all the data that I need with the following query :

...

I am a total script kitty at best and am trying to use google apps scripts to automate a process for me. Here a sample table like the one I am working with(data is in google sheets spreadsheet):

Variety Category Peter Courtney DP HBC 0.00 4.5 DP MNG 2.00 0 UB THN 7.00 0 471H THN 5.00 0 471H THN 0.00 5 GRH FST 4.00 0 GRH THN 8.00 0 GRH THN 0.00 8 GRH THN 0.00 8 HM HBC 6.50 0 HM HBC 0.00 6.5 HM MNG 2.00 0 HM MNG 0.00 2 CL HBC 8.50 0 CL HBC 7.00 0 PSV HBC 2.50 0 PSV HBC 7.00 0 PSV HBC 0.00 2.5

The table shows the employees reported hours broken down by Variety and category. My goal is to compile this data so if the employees work at the same category and same variety I want all hours expressed in a single line. For instance if you look at the last two rows of the data you'll notice that the Variety and Category columns are matching which means the data should be compiled. So instead of:

Variety Category Peter Courtney PSV HBC 7.00 0 PSV HBC 0.00 2.5

I want to compile the data like this:

Variety Category Peter Courtney PSV HBC 7.00 2.5

I am trying to do this from the bottom up because I heard going from the top down can cause issues but I am open to any suggestions. I think I need to write a for loop that compares the variety box of the active row to the variety box of the above row AND compares if the category box of the active row is equal to the category box of the above row and if both are true add the hours of both the "Peter" column and "Courtney" column.

I know there is more to do on top of that but this for loop is what I really need help on, unless you can suggest a better way?

Thanks for looking at my work, JP

Stackoverflow member Ruben has asked me to elaborate more, here is where I am at:

I found a stackoverflow answer that pushed me in the direction of how to parse the data with the for loop. Here is the for loop skeleton I am working with:

...

I'm new to Rust and a frequent user of MongoDB. I usually use node.js + Mongoose ODM.

Is there any MongoDB ODM in RUST that implements a custom schema and business logic hooks like Mongoose ODM ? Or do I need to implement it myself inside the Rust's type system?

This is an example from Mongoose

...

I have a simple struct in a custom pallet:

...

I have a data like this below,

...

My text disappears when I hover over it. I tried removing the hidden and putting the visibility: visible and I changed the opacity to 1 but I still keep getting the same - the text still disappears when I hover. I am trying to make the text stay the same and do nothing when I hover. The weird thing is I have a box border around it and when I hover the whole lower part disappears with it so half the box and the text disappear too. Am I missing something else?

...

Found a few postings on this, but none with a solution which solves what I am looking for. I am trying to import an excel file and save it as JSON, but group up some columns under others in the JSON file.

Here is my excel data:

Here is my python code:

...

I have this text that I want to read the first column from in my project named Data.txt.

...

I have created two apps and both has the same content.
App 1 is created with Flexbile Column Layout:

App 2 without:

As you recognized, UI components on App 2 are bigger than on App 1.

I am using the same controls on both:

...