Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

4

0
João Ferro
Ligar 16/04/20, 11:36

As Rodrigo said, is not easy to handle dinamic interface. If instead of a table, your genders were arrays then you would have more control over that.
If you still want to do it dinamically you could try a multiform as Rodrigo said.
1) Create a form for Genre with a Table List of books of that Genre 
2) Create a multiform over the genre tables. Fore each Genre it will replicate the form created in 1) with the information you want.
No need for SR, extra fields or conditional logic with this solution.



0
Álvaro Damas
Ligar 16/04/20, 11:33

There is a pattern in the menu lists that is largely ignored, can it help?  In the example below, equipments (EQUIP) only appears in this menu list if there are repairs (REPAR)





0
Rodrigo Serafim
Ligar 16/04/20, 11:06

I think you are making things complicated for yourself going with that interface. Forms and tables are much more complex when they need to react dynamically, and the way you are describing you would need a dynamic number of table lists in your form.

You should be using either a tree control of some sort of extended form linked to the GENRE or THEME table list (an inline form that repositions as the user clicks on rows of the table list). Even a multiform, with its limitations, is likely simpler than managing by hand what can possibly grow to dozens of table lists.

You will need to have a count of the number of books in order to do the filtering out of 0 book categories, it should be much simpler than creating sql views.



0
Rui Rita
Ligar 16/04/20, 09:59

In this case, the SR (Linked sum) should be in the gender table, and not the book table, due to the gender being inserted dynamically, you can´t attach SR in the book because you can´t tell how many there will be.

By doing this you will have the information on the gender table of how many books there are for that gender. You should also complement the SR with a + (arithmetic) formula which will represent if that gender has or not any book.


This being said, you should have something like this in you gender Table:

Field: NUMBOOKS -> SR formula: [BOOK->1]

Field: HASBOOKS -> + formula: IIF([GENDR->NUMBOOKS]>0,1,0)


In you form, for each table list, apply the show when condition to each table list [GENDR->HASBOOKS]==1

  • Flag

I understand you solution but that would make create a number of fileds... I would need a logic field for every genre in my BKTHE table, and on the theme tabel a sum for every genre

Maria Guedes
ativo 16/04/20, 10:14

0
Maria Guedes
Ligar 16/04/20, 09:39

Thanks! The goal is that i have multiple tables lists, imagine a form for subjects with multiple table lists to the books, separated by genres in different table lists. But I only want to show the genres / table lista that have books. (so hide the empty table lists)


 


Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

18 follower(s)

Stats

Asked: 31/03/20, 14:58
Seen: 2079 times
Last updated: 17/04/20, 08:21