User Interface - How to manage FMPro repeating fields?

Hello Forum, hello Servoy Team, :D

This is my first post here. So let me first introduce myself: As developpers, we are working with FMPro since its debut, as other Servoy developpers, we are looking for a replacement for FMPro for some (not all) of our solutions. Three years ago, we didn’t found such a replacement, but at beginning of april we gave Servoy a try…

Using a demo version, we managed to migrate a part of our +50 FMPro solution. At that point, it appears that mostly all features will be easely transferred to Servoy except for one: our use of FMPro repeating fields.

Most of the “infamous” :wink: FMPro Repeating Fields can be replaced, by a portal on a related table. But one feature is not doable at this time in Servoy: the ability to display these fields horizontally or vertically, including calculated fields.

To transpose this feature to servoy, we will need either to display a “rotated” table in a portal, with fields (columns) as rows and records (rows) as culumns, quite a disturbing feature idea hmm? :oops:

So, before requesting such a feature, I prefer to ask the community if you already come to that point, and how you managed it.

We already found some beginning of a trail: :idea:

a/ For simple Repeating fields, only needed for the ability to find in any occurence by searching into only one, we wrote a global method.
b/ For complex arrays of datas & calculated repeating fields, we think to use a bean, for instance jTable or any other mean to transpose rows and columns to user interface.

So, to make it short, does anybody have THE solution? Does anybody have an example of an implementation of jTable bean in Servoy (using it as a spreadsheet)?

Or may be do you need a more precise example?

Anyway, congratulations to Servoy team and cheers to Forum users.

Can you give an example of what kind of data you would like to display and why you need it to be oriented differently? Using html tables might be an option but we need to know more in detail what you want to do exactly, perhaps you have a screenshot with explanation on what you want to accomplish?

Can you give an example of what kind of data you would like to display and why you need it to be oriented differently?

Sure here is our explanation:

In this case we have 3 tables like:

  • Products
    ProductID
    Name
    Specific Gravity (S.G.)

  • Recipes
    RecipID
    Name

  • Parts
    PartID
    Part
    Weight = Part * Specific Gravity

We need to be able to input in a table manner and then compute all information to process the recipes and display it back in a table:

  • Get the sum of the weight for each products to draw from stock
  • Get the weight for each products for each recipes to prepare the work
  • Get the weight for each products for each recipes
  • Get the sum of Specific Gravity for each recipes

We are not limited in the number of products.
We limit to 50 the number of recipes

Here is how it looks like in FMPro: