GNOME Bugzilla – Bug 668815
Some suggestion for glom
Last modified: 2012-02-10 15:45:50 UTC
This are my suggestion for glom future releases, I would like my self to contribute in development, any explanation would be welcomed. - Agents - Agents to perform tasks like send notifications. A possible implementation would be that the agent would run on client computer. - Notification - Allow to change color on list row based on agent. This would alert for whatever the user associate the color. Typically it would be to user being notified if any field from a table is gets a specific value. I already started to investigate this one, got some info like pg_notify, psycopg2, here is some link http://divillo.com/. And I started to create the agent UI in glade. The Notification form would be like: | Field | operation+| value | Action+| ------------------------------------ | operation | => { ==; <=; >=; <; >; !=;} | Action | => { Change field Color; Alert; Email user;} (I think this can be complex) If action == 0 => Open Color picker form if action == 1 => Just pop up message or open an alert form (new form) if action == 2 => Send email to user (means that we will need to add email field when we add a user on database) - On the field creation form, add column "NOT NULL" with check box. This will allow to the user mark certain fields to filled before insert the new row on table. When user try to add with this field empty, message pops up. - User as Field - Another suggestion is to allow the user as field, this will allow for example to see who submitted the record. - In future, open glom project, would show a splash screen with company logo add to database preferences after login, and then would present a dashboard with all allowed table. this is not so important is just aesthetic thing, come from mine female part lol. Well those are some ideas that can be tuned
(In reply to comment #0) > This are my suggestion for glom future releases, I would like my self to > contribute in development, any explanation would be welcomed. Please put separate suggestions in separate bugzilla bugs. > - Agents - Agents to perform tasks like send notifications. A possible > implementation would be that the agent would run on client computer. You want action to happen in response to certain user events, such as entering certain values in certain fields? > - Notification - Allow to change color on list row based on agent. This would > alert for whatever the user associate the color. Typically it would be to user > being notified if any field from a table is gets a specific value. I already > started to investigate this one, got some info like pg_notify, psycopg2, here > is some link http://divillo.com/. And I started to create the agent UI in > glade. There should be no need to use PostgreSQL for this. We already have the developer choose an alternative color for negative values, so we can add something there: http://www.glom.org/wiki/index.php?title=Screenshots#Designing_the_Layout_-_Formatting For instance, we can just let the color be the result of a python calculation. <snip> > if action == 2 => Send email to user (means that we will need to add email > field when we add a user on database) I think this would be better handled by a general validation feature. For instance, we can just let the developer mark some fields as mandatory here: http://www.glom.org/wiki/index.php?title=Screenshots#Designing_Fields_in_detail > - On the field creation form, add column "NOT NULL" with check box. This will > allow to the user mark certain fields to filled before insert the new row on > table. When user try to add with this field empty, message pops up. Yes, though I would call it "mandatory" rather than "NOT NULL", because SQL is obscure, and we would want it to cover "" as well as NULL. > - User as Field - Another suggestion is to allow the user as field, this will > allow for example to see who submitted the record. Yes, I want to add creation user, creation date, creation time, modification user, modification date, and modification time to all tables, with the values being set automatically, I have not found time to do this yet. > - In future, open glom project, would show a splash screen with company logo There is already a Startup Script feature, so this can be implemented. However: > add to database preferences after login, and then would present a dashboard > with all allowed table. If there is no default table, Glom will already show the list of tables. Maybe we can make this more generally attractive, for instance by showing a larger window with the database name, organization details, and logo, which are already stored.
Reply by order :D 1 - Ok next time I will put it per suggestion 2 - Yes, imagine for invoice when the status of payment change to paid to notify. 3 - Agree 4 - Agree too :D 5 - Mandatory is the correct name, 6 - If you need well to develop tell me, the but i need a speed information to start to code 7 - It's not priority but later on i can investigate this. 8 - We could support image/icon to associated to tables that we would like to be visible on dashboard. Whatever I can start on just tell me.
(In reply to comment #2) > Reply by order :D > > 1 - Ok next time I will put it per suggestion It needs to be separate bugs this time, please. > 2 - Yes, imagine for invoice when the status of payment change to paid to > notify. OK. We could let the developer specify a python script that would run whenever a field value changes after user input. That script could check its value and decide to take some action. > 8 - We could support image/icon to associated to tables that we would like to > be visible on dashboard. You want each table to have an icon? I guess that would be possible. > Whatever I can start on just tell me. Please start by filing separate bugs for any new features from here. Then an improved table selection window should be fairly easy.
Please don't forget to file separate bugs.
I will, just give some time.
Closing now that you have filed bug #669468 , bug #669465 and bug #669464 .