Page 1 of 1

Adding label name and tab sequence to Eclipse table editor

PostPosted: Fri Feb 28, 2014 1:04 pm
by Bernd.N
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.

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.


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

PostPosted: Fri Feb 28, 2014 1:49 pm
by mboegem
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.

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

PostPosted: Fri Feb 28, 2014 3:40 pm
by Bernd.N
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" :)

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

PostPosted: 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.

Issue vs. Discussion

PostPosted: Fri Feb 28, 2014 6:51 pm
by Bernd.N
Hi Robert,

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

Issue = "TabSequenceInTableEditor"


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. :)


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

PostPosted: Sat Mar 01, 2014 5:03 pm
by mboegem
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.

Ordering of elements on form

PostPosted: Mon Mar 03, 2014 12:45 am
by Bernd.N
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.