Adding label name and tab sequence to Eclipse table editor

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Adding label name and tab sequence to Eclipse table editor

Postby Bernd.N » Fri Feb 28, 2014 1:04 pm

In the Eclipse table editor, a new table can be defined on the fly.

It would be a nice help to add a column "label text" to the right of the "Name" column,
which could be automatically preallocated with what you put in the name column,
minus a possibly prefix regarding the table name, and with "neat" capital letters.

Example:
name column = e_first_name (Employee First Name)
label text column = First Name (automatically generated)

That way, the generated detail or list form could already come up with nice fitting labels.

And if there would be an additional tab sequence column where you could fill in ordering numbers like 10, 20, ..., n,
also the tab sequence editing could be done quite fast directly in the table editor.

One could also think of a "column number" column, where you could already define if a field goes to the first, second or third column in a large detail form layout.

Bernd
Attachments
Eclipse_table_editor_addition.png
Eclipse_table_editor_addition.png (31.76 KiB) Viewed 7832 times
User avatar
Bernd.N
 
Posts: 544
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Adding label name and tab sequence to Eclipse table edit

Postby mboegem » Fri Feb 28, 2014 1:49 pm

Hi Bernd,

the 'label' option actually does exist, however not in the implementation you suggest.
if you open a table, select a column, you will see 4 tab panels with properties.
On the 'details' tab panel you will find a field 'Title'
Here you can use i18n based label text as well as 'hardcoded' text.

The default tab sequence is useless in my opinion.
It depends on the form you are creating and since you can have multiple forms based on the same table it'll never be correct.
Besides what if you use table columns and foreign table columns in 1 layout?

Hope the 'title' option will get you started.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Adding label name and tab sequence to Eclipse table edit

Postby Bernd.N » Fri Feb 28, 2014 3:40 pm

Hi Marc,

thanks for the Title hint, that's certainly similar.
An option "[ ] Put field name automatically to title" would be nice then, as especially when using i18n-labels, the Title could be the same as the Field Name in many cases. It would spare a lot of typing.

Regarding the "tab sequence order number", I think it depends a lot on the type of application you build.
The application I have in mind will have detail forms for about 50% of the tables, and some of them are quite large regarding the numbers of fields. Most involved tables go with their field majority to one "main" detail form.

Therefore, it would be a help when I could put the tab sequence already in the table, as it would spare a lot of work: in the resulting detail form, all basic fields from the main data source would be already in place.
The filling in of fields from other tables still needs to be done, sure, but as you can move entire groups of fields, that should not be a problem.

Below the line, I think it would be nice as an option, for cases where your form has the majority of fields from one table.
Something like the current option "[ ] Display DataProvider ID" below the table: [ ] Display tab sequence column
When creating a new form, there could be an additional option "[ ] Use table tab sequence" :)
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 544
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Adding label name and tab sequence to Eclipse table edit

Postby ROCLASI » Fri Feb 28, 2014 5:15 pm

Hi Bernd,

You can file a feature request for this in Servoy's support system.
If you only post them on the forum they might get lost and Servoy can't track them like they can in their Jira system.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Issue vs. Discussion

Postby Bernd.N » Fri Feb 28, 2014 6:51 pm

Hi Robert,

yes I know, I just wanted to discuss it here first. I wanted the workflow to be kind of

Issue = "TabSequenceInTableEditor"

ServoyTalk.DiscussIdea(Issue)

IF ServoyCommunity.LikesTheIdea(Issue)
THEN ServoySupportSystem.CreateIssue(Issue)

That way, maybe others have some more ideas or hints regarding the topic, and we could create a common optimized feature request. :)

Greetings
Bernd
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 544
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Adding label name and tab sequence to Eclipse table edit

Postby mboegem » Sat Mar 01, 2014 5:03 pm

Hi Bernd,

another solution concerning the tab sequence that came to mind:
at startup of solution you can loop through your forms and set the desired tab-sequence based on the x/y position of your fields.
This can be done using the solutionModel.

Another option is to do this at onLoad of the form, but then you'll need to call 'controller.recreateUI()' on order to prevent the error message 'stale forms detected'
keep in mind that a recreateUI will set your form including form-variables to their defaults.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Ordering of elements on form

Postby Bernd.N » Mon Mar 03, 2014 12:45 am

Hi Marc,
thanks for the tips!

I actually was not exact in my terms, I did not mean "tab sequence" but more precisely "field order".
With a predefined "field order" in a data-dictionary-table defining my main form table, I would like a one-click-button to generate a prototype form for my customer, without manually setting one single lable or text field.

I got the tip that after fields are set on a form by a program, one can make the new form persistent.
Then I could continue the form design already with that prototype.
Therefore I suggested a new ordering column in the table definition table in Eclipse.
Bernd
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 544
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 13 guests